Download historical stock prices into Excel
with the HistoricalPrices Add-in
If you want to download historical stock prices into Excel, there's a lot to like about the Yahoo Finance data. (see "How useful is STOCKHISTORY?"). For one thing it covers all major stock exchanges. It includes many different types of security--stocks, ETFs, mutual funds, indices, commodity futures, currencies and cryptocurrencies. Also, there are no subscriptions to pay, at least for now. Our latest add-in HistoricalPrices combines our legacy CSV download product and the more versatile JSON based download into one convenient utility. which is highly adaptable to your needs. Also included is the PriceOnDate user defined function (UDF) which allows you to access the price of any security on any given date.
Watch the video below to see HistoricalPrices in action!
Data from all major exchanges
Yahoo provides historical price data from over 80 international stock exchanges covering all major sites. Many give real time data including the USA, Canada, India, Russia and Currency markets.
A range of financial instruments
You can import price, dividend and split history for-
- Stocks and shares
- Commodity Futures
- Bond Rates
- Mutual Funds
No VBA skills required
You won't need to know any VBA to get historical data onto your spreadsheets. It is so easy to use. Just enter the destination of the data and the ticker, what range and interval you need and away you go. You can even specify what columns you need and make many other fine adjustments.
If you prefer to use VBA, of course, we have you covered. The core data-fetch functions from the previous HistoricalPrices releases are still available. See here.
For decades Yahoo! has been providing historical data to low bandwidth users at no charge. This may change, of course, but as of now there is no fee for requesting the data and there is no recurring subscription for the HistoricalPrices Add-in.
One minute to 3 month candlesticks
You can set the candlestick period (data interval) to
- 1, 2, 5 or 15 minutes
- 1 hour
- 1 day
- 1 week
- 1 or 3 months
50 years of data
Depending on the security and the data interval selected, you will be able to import up to 50 years of history. For more details see here.
Simple ribbon interface
The uncluttered HistoricalPrices ribbon menu has a button to bring up the interactive userform, and several refresh options, including the ability to add a refresh button to any of your worksheets
Or you can have any of the HistoricalPrices data regions refresh automatically, every candle interval.
The easy-to-grasp interactive userform gives you complete control over formatting the data when creating or editing a HistoricalPrices data region. For many fields the defaults will be fine, but you have the ability to set:-
- The destination placement of the data
- The ticker symbol
- The type of data (prices, dividends or splits)
- The time range of the data
- The data interval (candlestick width)
- Ascending or descending date order
- Do you wish to display market time or offset the time somehow?
- Interpolate prices into null (inactive) periods
- Filter out dates before a fixed date, or after another fixed date
- Which fields (Open, AdjClose etc.) do you require and in what order?
- Do you want headers?
- Do you want automatic refreshes in addition to manual?
All these settings can be on the form or referred to the spreadsheet. Just click on the form titles to bring up a help page on how to use the form.
Simple yet versatile, you can use this function when you just need a single price.
- Give it a date and a ticker and this simple function will give you the Adjusted Close price for that day.
- Give it just a ticker symbol and it will give you a recent price (very recent for real-time exchanges)
- You can also specify "High", "Low", "Open", "Close", "Volume" or "AdjClose" as a third parameter.
Ordering is through PayPal, we don't have access to any of your personal or credit card information, except for your email address so that we can send a link to the download. Algorithm Science is authenticated by Thawte and the program itself is code signed with a Thawte/DigiCert certificate to prevent tampering.
The program does not gather any information from your computer. There are links to this website for help, and occasional connections to Yahoo! to import data, that's all.
Our money back guarantee
If you can't load the add-in, or it doesn't work the way we describe, we will refund your money--just email us at email@example.com . If something should break and the data becomes unavailable within a period of 60 days of your purchase, we will either fix the problem or we will refund your money.
"...the add-in is perfectly usable."
"This new Add-in is really awesome.
- I really love the PriceOnDate() feature which is essentially like the Office 365 stock price feature which is not available on my standalone version of excel.
- Drawing Historical Data for a Single Stock Is much more flexible compared to the earlier emulator. "
"Wanted to drop you a note to applaud your new Add-in. It works great. Working on recoding my existing sheets to use the add-in, rather than VBA code. I think when I’m done with conversion it will work great. I will send you a copy of my sheet."
The plugin has been working perfectly!
Thank you! yeah this plugin is killer, it's helped me automate a lot of things. thanks again!
Need macros instead?
The Add-in is password protected and obfuscated, If you would prefer a macro version with full access to well commented VBA code, then GetHistoricalPrices may work better for you. It is a macro enabled workbook (not an add-in) and it has most of the functionality of the add-in, with some extra capability. Click here for details.