Closed

excel macro to pull from yahoo finance

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...?

## Deliverables

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.

Skills: Engineering, Excel, Microsoft Access, Microsoft Exchange, MySQL, PHP, Powerpoint, Project Management, Software Architecture, Software Testing, Word

See more: yahoo-finance, project management scenarios, programming symbol, programming in excel 2010, programming excel spreadsheets, macro programming in excel, excel macro how to, give me yahoo, pull data, go to market, finance in excel, finance excel, finance excel data, excel model, Excel Formulas, excel finance, email pull from database, project finance excel model, excel macro download file, excel macro yahoo stock prices, excel project use database, populate excel spreadsheet spreadsheet, finance data excel, stock excel model, excel macro yahoo download historical data

About the Employer:
( 0 reviews ) United States

Project ID: #3225331

4 freelancers are bidding on average $90 for this job

danielferry

See private message.

$170 USD in 14 days
(57 Reviews)
6.7
matsolvw

See private message.

$42.5 USD in 14 days
(72 Reviews)
5.4
shawnvw

See private message.

$63.75 USD in 14 days
(1 Review)
2.5
Gallus

See private message.

$85 USD in 14 days
(3 Reviews)
1.4