How to get stock prices in Excel

Reading time: 3 minutes

How to get stock prices in Excel

Let’s learn how to get stock prices in excel. You can get stock data in Excel. It’s as easy as typing text into a cell, and converting it to the Stocks data type. This data type is considered linked data types because they have a connection to an online data source. That connection allows you to bring back rich, interesting information that you can work with and refresh.

When we are starting out in stock investing, we are looking at the options that we have on the market in order to understand what all numbers and graphic areas are telling us.

So today I am going to explain how you can obtain the prices of stocks in Excel, which is a nice and easy way in my opinion to begin to analyze stocks of various companies around the world.

It is quite usual at first we would need some real help of professionals, or that would really hard to understand what all numbers are saying to us, so we started looking the best ways of learning it, looking at videos on Youtube, blogs, or even tutorials or courses which come to us right after starting a google search about the topic.

But actually, the indicators which are most important to do a fundamental analysis or analytical analysis are easier than we are making out. If we actually grasp the 4 or 5 basic indicators, then we have a great picture of every company on the market.

So let’s see step by step how to insert our stock data into your spreadsheet.

how to get stock prices in excel

To insert a stock price into Excel, first convert text into the Stocks data type. Then you can use another column to extract certain details relative to that data type, like the stock price, change in price, and so on.

Note: The Stocks data type is only available to Microsoft 365 accounts or those with a free Microsoft Account. You must also have the English, French, German, Italian, Spanish, or Portuguese editing language added to Office Language Preferences.

Type some text in cells. For example, type a ticker symbol, company name, or fund name into each cell.
Then select the cells.
Although it’s not required, we recommend creating an Excel table. Later on, this will make extracting online information easier. To create a table, go to Insert > Table.
With the cells still selected, go to the Data tab, and then click Stocks.
If Excel finds a match between the text in the cells, and our online sources, it will convert your text to the Stocks data type. You’ll know they’re converted if they have this icon for stocks: .
Select one or more cells with the data type, and the Add Column button will appear. Click that button, and then click a field name to extract more information. For example, for stocks you might pick Price.
Click the Add Column button again to add more fields. If you’re using a table, here’s a tip: Type a field name in the header row. For example, type Change in the header row for stocks, and the change in price column will appear. Or type other field names like Last Trade Time, Previous Close, and Exchange.