excel macro to pull from yahoo finance
This project received 4 bids from talented freelancers with an average bid price of $90 USD.Get free quotes for a project like this
I have an existing spreadsheet that I run market scenarios on.? I would like a macro to pull historical data off of yahoo finance, populate a certain section of the spreadsheet, while allowing my existing formulas to draw that data as the input in the model.? If I could enter the ticker into? a black cell in the spreadsheet and have the macro pull data after hitting enter that would be great.? ? Yahoo already keeps a database of historical data on each stock that can be downloaded to a spreadsheet, I just need the process to be faster and easier to use so I can do it all within excel.? If I liked how this turns out, the project could definetly grow and give opportunity for more in depth programming...?
I would email you the spreadsheet? file.? That way I can show you exactly where the data should populate.? Many of the formulas will already be in place to pull from the data coming from yahoo.? Basicly I want to be able to enter a ticker symbol into a blank space at the top and have the software go to yahoo and gather data for me so I do not have to download multiple spreadsheets to analyze multiple stocks.? This way I can etner ticker after ticker and monitor historical prices (and current) very quickly.? Example below.
Browse Related Skills
Other things people do on Freelancer
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online