Get a stock quote

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

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.

Note: June 12, 2018: This data type is currently a beta feature, and only available to a portion of Office Insiders at this time. We'll continue to optimize it over the next several months. When it's ready, we'll release it to all Office Insiders, and Office 365 subscribers.

  1. Type some text in cells. For example, type a ticker symbol, company name, or fund name into each cell.

  2. Then select the cells.

  3. 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.

  4. With the cells still selected, go to the Data tab, and then click either Stocks or Geography.

  5. 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: Linked record icon for Stock .

  6. Select one or more cells with the data type, and the Add Column button 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.

  7. 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.

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+F5.

  • If you see Question mark icon instead of an icon, then Excel is 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 matching information. Or, click Question mark icon and a selector pane will appear. Search for data using a keyword or two, choose the data you want, and then click Select.

  • You can also write formulas that reference data types.

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

See also

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.

×