How to Download Price Data From Yahoo Finance into Excel

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.

Anyone who is interested in Market Analysis, Technical Indicators, and Backtesting will benefit from this article.

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.

Download Price Data From Yahoo - Excel Downloader Screenshot

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:

Excel Formulas

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

Sample URL

Every time you download data from Yahoo Finance it generates a URL that corresponds to your query.

The URL format looks like this:

https://query1.finance.yahoo.com/v7/finance/download/%5EGSPC?period1=1530489600&period2=1593561600&interval=1wk&events=history

Market Code

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

Date Range

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:

=(Current Date-DATE(1970,1,1))*86400

Interval (Period)

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.

2 thoughts on “How to Download Price Data From Yahoo Finance into Excel

    • Mark Ursell says:

      Thank you Prateek, that is a good question. Yahoo Finance only offers daily, weekly and monthly historical data. So you can’t use this exact process to get intraday. If you have an online source of intraday data you can use the Excel data import function to get it directly into your spreadsheet. One suggestion is to try MT4, lots of brokers offer it, and you can download historical data directly from the platform.

Comments are closed.

Powered By MemberPress WooCommerce Plus Integration