Last Updated on August 13, 2021 by Mark Ursell
In this article and video, I show you how to download price data from Yahoo Finance into Excel.
Yahoo Finance is the best source of free historical price data on the internet. If you regularly use Yahoo price data in Excel, this article will save you time and help you download the data quickly and easily.
What is the Free Spreadsheet?
I have created a spreadsheet to automate the download process.
This spreadsheet uses VBA to automate the downloading process. Making it quicker and easier for you to get the data you need for your analysis.
How to Use the Spreadsheet
When you open the spreadsheet you will see options to select the market, date range and frequency (period).
You then click the button, and the data is imported in your spreadsheet.
The spreadsheet was designed in Excel for Windows but should also work in Excel for Mac.
Watch The Video
In this YouTube video, I demonstrate the formulas and how to use the spreadsheet.
Get the Free Spreadsheet
You can download the spreadsheet for free by signing up to my mailing list:
If you want to create your own spreadsheet you can see the formulas that I used to create it.
URL Information Needed to Download the Data
Every time you download data from Yahoo Finance it generates a URL that corresponds to your query.
The URL format looks like this:
The market code is the information used by Yahoo to identify the stock, ETF or currency. These codes are not always the same as the codes you will find used elsewhere.
If you don’t know the code, you can get it by going to the Yahoo Finance page for the market you are
You need to specify the date range of the price data.
The dates are expressed in UNIX format. The formula to calculate the Unix Code is:
Yahoo Finance Data is available for daily, weekly and monthly periods. In the URL it is 1d, 1wk and 1mo.
The Next Step: Backtest Your Strategy
“The goal of a successful trader is to make the best trades. Money is secondary.”Dr Alexander Elder
I do all my backtesting in Excel. Over many years I have developed a backtesting system that is easy to use for anyone familiar with Excel.
You can use it to test everything from simple investment ideas to complex quantitative strategies.
Tradinformed Backtest Models help you test your strategies, develop new strategies, and find the best settings.
Tradinformed Members get:
- A new backtest model including my results and analysis every month.
- Direct access to me through the Members Webinars.
- Exclusive tutorials so that you can quickly understand and use the models.