Export data from Yahoo Finance into Excel Spreadsheet

This project was successfully completed by ZeusMan for $100 CAD in 2 days.

Get free quotes for a project like this
Project Budget
$30 - $250 CAD
Completed In
2 days
Total Bids
Project Description


Export one year of data from YAHOO FINANCE CANADA into one EXCEL spreadsheet per list of companies.

Approximately 2000 companies on my list.

Automate the process above so it can be run on a daily basis.


Automate the process so that any updates to the company list will be included when the routine is run.

Include variable start and stop dates to determine the data range.

These start and stop dates will be entered into the relevant YAHOO FINANCE CANADA webpage.

Webpage data exported into a temporary EXCEL spreadsheet and sorted in chronological order (oldest to newest).

Once sorted the data is copied into the correct columns of the appropriate company EXCEL spreadsheet.


Not sure how many spreadsheets can be safely contained within one EXCEL workbook (computer capability dependent I assume).

Therefore multiple EXCEL workbooks may be required to accommodate approximately 2000 companies.

Completed by:
Skills Required

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