Guide‎ > ‎

Guide for excel 2003

This page will explain how to use Historical Data Downloader.xls to download historical data from yahoo finance. It uses the power of Microsoft Excel macros to get LIVE up to date historical stock data.

Step 1: Open Historical Data Downloader.xls. You will need Microsoft Excel 2003 or higher. The examples below are done using Excel 2003. Go to the MS excel 2007 example.

Step 2: Enable Macros

When opening up the spreadsheet, you may see a security warning.

Click on enable macros.

Step 3: Paste your list of symbols in the symbols tab. Non american stocks will require a suffix from yahoo finance.

Symbols Tab

Step 4: Select the historical data date ranges, and where you want to save the csv files.

Step 5: Press the 'Download' button.

You will see excel start getting the historical data from yahoo finance. This process can take some time depending on your internet connection, and computer power. Press ESC a few times to stop processing.

You will need to restart excel if you want to continue processing.

As each symbol is completed, a csv (comma separated value) file will be created in your chosen location.

Sample output file:

If you have any problems or queries, see our FAQ or feel free to contact me.