Historical Stock Prices in Excel

Simple spreadsheet with form to download historical stock prices right into Excel.

Supported versions: Excel 2007, Excel 2010, and Excel 2013. Last Tested: 5/14/2015

Description

This nifty little spreadsheet can download historical daily adjusted closing prices for a list of stock symbols within a specified date range. With a click of a button, your pristine data is neatly organized in a new worksheet, waiting to be analyzed.

How to Use the Spreadsheet

The form is very intuitive to use. Just enter a list of stock symbols, enter the start and end dates, select a frequency, and click download. Your data will be downloaded into a new worksheet within the same file.

A Note About the Data Source

The historical stock price data is downloaded from Quandl.com, a free search engine for numerical data, through its API. As of 1/15/2015, Quandl limits anonymous data downloading to 50 API calls per day, which is equivalent to downloading data for 50 stocks per day. If you sign up for a free Quandl account, Quandl provides you with an authentication token under your account settings which lifts your download limits to 2,000 API calls per 10 minutes and 50,000 API calls per day. Limits are subject to change. Please refer to Quandl's API page for the current limits.

Further Customization

Quandl.com offers not only historical stock price data but also a slew of key financial data on publicly traded companies such as dividends, net income, PE ratio, and much more. Custom Excel templates, forms, or add-ins can be built to take advantage of the open data source, helping you streamline your financial analysis.

Feedback

I really enjoy putting together simple yet practical spreadsheet tools - from coding the core functionalities to designing an intuitive template - that people would actually use regularly. Any feedback or suggestion to help improve this spreadsheet is sincerely appreciated.

5 Responses to “Historical Stock Prices in Excel”

  1. hi,

    I would like to thank you for your useful excel spreadsheet to get historical stock prices. However, it would be much appreciated if you can develop this in Mac version since I could not use it in the excel in my mac.

    Best Regards,
    Nikki

    • Hi Nikki,

      You’re very welcome! Unfortunately, the VBA library I used to develop the historical stock price tool is only available on Windows. But I’m not giving up on Mac yet. If I’m able to find a reliable workaround for Mac versions of Excel, I will definitely let you know.

  2. Mark Sendelbach says:

    Yi,

    I tried to use your Historical Stock Price spreadsheet, but Excel gave me the following warning message:

    “Compile Error in Hidden Module. Controlsheet.”

    What version of Excel do I need to run this spreadsheet?

  3. Kendel Charles says:

    Thanks alot for all the downlaods that you have provided. Your like the Mavis beacon for excel :).


Leave a Comment

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

* required