Yahoo Historical Data Download

Please note: Yahoo Finance currently limits historical data downloads depending on the resolution of data required:

  • Minute Data: 7 days
  • 2 Minute Data: 60 days
  • 5 Minute Data: 60 days
  • 15 Minute Data: 60 days
  • 30 Minute Data: 60 days
  • Hourly Data: 730 days
  • Daily/Weekly/Monthly: No limit

The Add-in enables on-demand downloading of historical data from Yahoo Finance into Excel.

To get started, launch the Configuration Pane and search for the instrument in the Search box on the Yahoo Finance tab. Select the instrument, for example here Apple Inc. (AAPL) is selected:

Yahoo Finance Historical Data Download to Excel Screen

Next, you need to specify the type of data you wish to download:

  • Resolution: Select a resolution for the data you require, for example "1 Minute", "5 Minute", "30 Minute", "1 Hour", "Weekly" etc.
  • Range: You need to specify a date range. There are limits to how much data is available for each resolution (see above).
  • Fields: Select which fields you would like to download, out of High, Low, Open, Close and Volume. The symbol itself can also be returned.

Ensure the cell where you would like the data to be downloaded to is selected in your spreadsheet.

Press the "Download Data" button and the requested historical data will be downloaded from Yahoo Finance into your spreadsheet:

Yahoo Fianance Historical AAPL data in an Excel spreadsheet