Excel 2007 Simple Spreadsheet Lookup and Download - Repost - open to bidding

Lezárva Kiadva: 6 évvel ezelőtt Kiszállításkor fizetve
Lezárva Kiszállításkor fizetve

Overview: Metastock Explorer Spreadsheet.

The attached Excel spreadsheet (Excel 2007) is the second stage in a Stock selection system designed to determine stocks that have reached their Buy Price. The spreadsheet is made up from results of an Exploration using Metastock (an equities charting package) from EOD (End of Day) data downloaded during March. These results are then copied and pasted from Metastock into this spreadsheet. The process is occurs daily after trading is closed. No knowledge of Metastock is required; its’ part in the process is finished at this point.

(For this reason the spreadsheet format must remain as it is with the same column headings and in the same sequence as shown. Any change to the format would require reformatting of the original Metastock results before pasting to the spreadsheet.)

The system relies on any stock breaching the preset Buy Price; ie at some time during the trading day the stock has fallen below the Buy Price. In order to know this the Low for the current day must be downloaded from Yahoo Finance and compared to the Buy Price for that particular stock. The stock suffix for the Australian Stock Exchange by Yahoo is .AX, so BHP must be rendered as [login to view URL] in order that it is managed correctly by the Yahoo Finance download. Only ASX stocks are ever used; there is no necessity to cater for other exchanges.

In the event that the Low has been breached conditional formatting is required to indicate that the breach has occurred. The stock in question will then be deleted from the system. Only about 1 in 7 stocks actually do fall to reach their Buy Price. In the current worksheet two have been highlighted to clarify the requirements but these figures are false and placed there by way of illustration. When you run a test you will see that they have been fudged.

The benefit rendered by spreadsheet is that the system is automatic. The alternative is to download each ‘Low’ at EOD separately or to examine each of 30 something charts and both are tedious. Once a week the spreadsheet is tidied up and those stocks that no longer meet the criteria are removed.

Specific requirements:

1. Insert the suffix .AX to each stock symbol when downloading data from Yahoo.

2. Write an Excel Look-up macro suitable for use with Yahoo Finance EOD data and include a download button on the spreadsheet.

3. Download the day’s Low for each stock and Update the Low Value.

4. Where the Low for the day has fallen below the BuyPrice highlight the cell.

I shall be happy to answer any queries.

Charles Brodley.

Powerpoint Közösségi Média Marketing Twitter Webes adatgyűjtés WordPress

Projektazonosító: #13598669

A projektről

22 ajánlat Távolról teljesíthető projekt Utoljára aktív: 6 évvel ezelőtt

22 szabadúszó tett átlagosan 179£ összegű árajánlatot erre a munkára

sapotacorp

Hi hamedezat. I have read 4 requires in your project. I have finish them quickly. Let's contact me to discuss further details.. Q

£225 GBP 6 napon belül
(916 vélemény)
8.7
mantislin

Hi sir, This is kimi and I am scraping expert, I have did too many scraping projects, please check my profile page then you will know. https://www.freelancer.com/u/mantislin.html Can you tell me Továbbiak

£178 GBP 5 napon belül
(295 vélemény)
7.6
shinemonkey212

I Will Give You Successful Sites and Many Helps!!! Hello, how are you? I'm glad to tell you about your project. As you can see at my profile, i am a WordPress Expert and have great skills and solid experiences for y Továbbiak

£150 GBP 3 napon belül
(94 vélemény)
7.2
schoudhary1553

Bid Summmary Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve.

£250 GBP 3 napon belül
(26 vélemény)
6.1
XpertSolNet

Hi Dear, I have gone through the complete job description. Please share further details so I can start working on it. I have great expertise in Powerpoint, Social Media Marketing, Twitter, Web Scraping, WordPress. Továbbiak

£250 GBP 3 napon belül
(1 Visszajelzés)
0.8
vl16vaidya

A proposal has not yet been provided

£222 GBP 10 napon belül
(2 vélemény)
0.9
znawaz97

Hello I am expert in writing i will help you in your work I assure you for the quality work, I am new here but doing work on many other platform I assure you for the good

£111 GBP 3 napon belül
(0 vélemény)
0.0
SilentStarMagic

Hi, I am a serious developer who aims to provide high quality services. If you contact me, we can discuss more things detail and will be achieved with each other's purpose. Good luck for your business…

£150 GBP 2 napon belül
(0 vélemény)
0.0
aangelo01

I know to use excel, word and some editing. I will do whatever it takes to get the job well done on the quickest time. My clients satisfaction is always important.

£150 GBP 3 napon belül
(0 vélemény)
0.0
iyapraji

A proposal has not yet been provided

£250 GBP 7 napon belül
(0 vélemény)
0.0
Shopify

Hello, I want to show you all relevant Demo and Designs which is similar to your project completed previously. To make sure about the requirement set and customizations, I want to discuss this project with you further Továbbiak

£257 GBP 3 napon belül
(0 vélemény)
3.4
RubyOnRail

Hello, It's a pleasure to let you know that I've Completed and Delivered similar project before. All I need to work on customization part if we can proceed towards more discussion. I have gone through your project Továbbiak

£277 GBP 3 napon belül
(0 vélemény)
0.0
vw7571960vw

I have the experience to start contributing from day one and I am truly excited about the prospect of getting started

£150 GBP 3 napon belül
(0 vélemény)
0.0
rakeshwadhwani

Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and Továbbiak

£150 GBP 3 napon belül
(0 vélemény)
2.0
anupgtm

I am interested with this project as i study about stocks in Nepal and I have created an excel sheet for calculating values for my stocks traded in Nepal stock exchange(NEPSE). Hope you can send me your excel sheet for Továbbiak

£144 GBP 4 napon belül
(0 vélemény)
0.0