Multiple Stock Quote Downloader for Excel

This Excel spreadsheet downloads multiple historical stock quotes into Excel. Just enter a series of ticker symbols, two dates, and click a button.

Update on 11th July 2017: You can now sort the historical data in ascending or descending date order

Update on 6th July 2017: I’ve uploaded a new version of the Yahoo spreadsheet that now works again.  Download the new version at the bottom of this article. Comments welcome.

Update on 20th May 2017: Yahoo Finance have discontinued their free historical data API. As a workaround, I’ve posted a new version of the spreadsheet that uses Google Finance.

This data can be used for correlation analysis, technical analysis with RSI and ATR, historical back-testing, portfolio optimization and much more.

A previous spreadsheet let you download data for a single ticker symbol. Sometimes, however, data for just one company isn’t enough – you need to compare the relative performance of several companies. That’s when you need this free, user-friendly spreadsheet for bulk data download.

The spreadsheet is simple to use. Start by entering a start and end date, your desired quote frequency (d for daily, m for monthly, y for yearly), and your desired sorting (oldest data first or newest data first).

Excel spreadsheet to download multiple stock quotes from Yahoo Finance

You can also specify if you want the data for each ticker written to separate CSV files. If so, specify an export folder for the files.

Then enter a list of ticker symbols in cell A11 and below (one tick per cell). After you click “Get Bulk Quotes”, the spreadsheet downloads the historical stock quotes into individual sheets. The sheet name is the ticker symbol.

Yahoo Finance in Excel

The spreadsheet downloads the date, open price, high price, low price, closing price, volume and adjusted close price.

AAPL Yahoo Finance

If you add or remove tickers , or refresh the data, the spreadsheet deletes the existing quote sheets, and inserts new sheets with the new data.

If you asked the spreadsheet to export the data, you’ll find a CSV file for each ticker in the folder you specified.

Yahoo Finance Stock Quotes Exported to CSV Files

The file name is constructed from the ticker, start date, end date, and the download frequency.

If you misspell a ticker or leave a blank, the VBA is clever enough to skip over or ignore the error. You won’t get any nasty error messages.

Yahoo Finance VBA

You’ll also get a list of tickers for which no data was found. This list is dynamically updated by the VBA.

I’ve tested the spreadsheet by downloading historical quotes for 180 ticker symbols. Everything worked perfectly, with 180 new sheets added to the workbook, each filled with historical data.

You can also collate the open, high, low, close, adjusted close and volumes for every ticker on the same sheet. That is, you can collect all the open prices on one sheet (named “Open”) together with the corresponding dates, all the high prices on one sheet (named “High”) together with the corresponding dates etc. Simply check the “Collate” button.

stock quotes for multiple tickers collected onto one Excel spreadsheet

The collate feature correctly reconciles tickers that return data with differing time series – dates and values are correctly associated.

The VBA is not protected; you can view and modify the code. Please let me know if you have any suggestions for improvements or additions to the functionality.

Get Excel Spreadsheet to Download Bulk Historical Stock Data from Yahoo

Get Excel Spreadsheet to Download Bulk Historical Stock Data from Google Finance

546 thoughts on “Multiple Stock Quote Downloader for Excel

  1. Samir,

    I’m loving your Multiple Stock Quote Downloader, for Yahoo, and am finding new uses for it all the time. I noticed that on the last sheet “Trading Volume”, the first ticker doesn’t come up for me.
    It could be that I’m doing something wrong.

    I love it though,

  2. Yahoo download doesn’t work any more (2017/11/02).
    “It has come to our attention that this service is being used in violation of the Yahoo Terms of Service. As such, the service is being discontinued. For all future markets and equities data research, please refer to”

  3. For the Google File, how do I get history of the S&P 500? On google the ticker is “.IXN” but when I input it into excel, the ticker fails. Please help

  4. I am new to program. I am looking to have closing prices collated to one sheet(I understand that part). I want the list to have tickers list vertical on A column and dates horizontal across the 1 row listed from farthest(A1) to end date(A30)

  5. Hi Samir,

    Firstly, let me say that your bulk stock quote downloader is a terrific function.

    I use much of the data for my position as an economist in Australia.

    I have two questions for you.

    1. I noticed that the downloader will only download a certain amount of stock codes (yahoo data). I have about 30 plus codes inputted and after about that amount the open, close, high, low, etc Tabs will not display (there will be run time error in the VBA code). Is it possible for you to change the VBA code so that it can accept lets say 100 stocks with all the other information per above still able to be displayed.
    2. On your website, you mention that Yahoo have discontinued providing free historical data. However, for all my stocks I still receive the historical data (when I update the downloader). Can you clarify what is meant by that yahoo has discontinued this free service?
    3. Finally, the downloader using google data will not display Australian data. For example: ASX: CBA will not be found and ASX: NAB shows the wrong time series.

    I realise you provide this free and I appreciate your time.

    Regards L

  6. Your spreadsheet has great appeal to me. Unfortunately, when I ran it, I received an error message saying: Run time error ‘429’: ActiveX component can’t create object

    I am using Excel 2017 for Mac. I have successfully run other VBA macros.

    Any suggestions on how to debug the error? Much thanks.

  7. I have been using your old bulk symbol down loader as a core component for my stock look up until Yahoo stopped supporting it. A feature I liked was the company name lookup from the stock ticker. Is it possible to lookup up a name with the new Yahoo API function?

  8. Hello,

    Thank you for this awesome tool. I was wondering if there was a way to get index funds to show up, like the DOW and NASDAQ for example? I tried using all the ticker names I could think of but they would not show up.


Leave a Reply to Tuan Cancel reply

Your email address will not be published. Required fields are marked *

What is 15 + 3 ?
Please leave these two fields as-is:
IMPORTANT! To be able to proceed, you need to solve the following simple math (so we know that you are a human) :-)