If you’re trying to import stock prices in Excel from Yahoo Finance, this tutorial can help you. You may need it for many reasons. For example, your trading platform doesn’t have the stock you need to analyze. Many traders use Excel for seasonality and statistical research.

In this tutorial, you will learn how to import stock prices in Excel.

Let’s start!

Go to yahoo finance and search your stock. In this tutorial, we’ll use the SPY ETF.

searching spy on yahoo finance

Click on “Historical Data”

extract historical data spy on yahoo finance

Select your preferred TimeFrame; we chose Daily. Click on “Download Data” and save the file named “SPY.csv” in your Hard Disk.

extract daily historical data spy on yahoo finance

Data processing before importing

This is optional; we do this to avoid the problem with the system separators. Our decimal separator is the “comma” and the Thousands separator is the “dot”.

The file that you downloaded from Yahoo Finance uses the “comma” to separate the single data and use the “dot” as a decimal separator.

Open the file SPY.csv in Excel and click on “Find & Select”

Excel Find and Replace stock Chart data

Now you write a “comma” in “Find What” and a “semicolon” in “Replace with” and click on “Replace All”

Excel Find and Replace stock Chart data 2

Repeat this process and write a “dot” in “Find What” and a “comma” in “Replace with” and click on “Replace All”

Excel Find and Replace stock Chart data 3

That’s all. Save the file and close it.

Import the file CSV in Excel

Now open Excel, select the “Data” tab and click on “Get Data from Text/CSV” and select the file that you have downloaded from yahoo finance.

Excel Import stock data from file CSV

Now choose the delimiter “semicolon” and click Load

Excel Import the stock data from file CSV

Excel will create a new table with Date, Open, High, Low, Close, Adjusted Close, Close and Volume columns.

Yahoo finance data of spy in excel

We have successfully imported data from Yahoo Finance to Excel. Now you can analyze all-world stocks without a trading platform. The data is free, and Excel is a potent tool for statistical research.

Your next step:

Download the Excel file of this tutorial from this LINK.

 

Editors’ Recommendations:

Leave a Reply