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
Employer working
Project Budget
Total Bids
Project Description

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.

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online