Get a stock quote

To insert a stock price into Excel, you 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.

Office Insider

To see this feature, you must be an Office Insider   

This feature will be gradually released to Insiders over the next several weeks. Insiders are Office 365 subscribers who get an early look at the new features and help the Office team evaluate them. Become an Insider.

1. Type data, create a table

Cells with stock ticker symbols

Type some ticker symbols, company names, or fund names into some cells. Then select those cells and create an Excel table by clicking Insert > Table. If your data has column headers, select the My table has headers checkbox.

2. Select cells

Cells with stock ticker symbols selected

Now select the cells that contain ticker symbols, company names, or fund names.

3. Click Data > Stocks

Data tab, Stocks and Geography buttons

On the Data tab, click Stocks. Please note: This feature will be gradually released to Insiders over the next several weeks. Insiders are Office 365 subscribers who get an early look at the new features and help the Office team evaluate them. Become an Insider

4. Stock data types appear

Cells converted into linked records showing stock icons

If Excel finds a match between the text in the cells, and our online sources, it will convert the text to the Stocks data type. You'll know they're converted if they have this icon: Linked record icon for Stock .

4. Add a column

Cursor clicking Add Column and selecting Price from field list

Click the Add Column button Add Column button , and then click Price.

5. Price appears

Stock prices appear in new column

Excel will extract the Price field from the cells with the Stocks data type. Click the Add Column button again Add Column button to add other helpful fields like Last Trade Time, Previous Close, Exchange and so on.

Important: Stock information is delayed, provided "as-is", and is not for trading purposes or advice. See About our data sources for more information.

Tips: 

  • To see all of the fields available for a company or fund, click the stock icon ( Linked record icon for Stock ) or select the cell and press Ctrl+Shift+F2.

  • You can also write formulas that reference data types.

  • If you see Question mark icon instead of an icon, then Excel's having a hard time matching your text with data in our online sources. Correct any spelling mistakes and when you press Enter, Excel will do its best to find a match. Or, click Question mark icon and a selector pane will appear. Search for the data you need using a keyword or two, and then click Select.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×