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.
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
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
Now select the cells that contain ticker symbols, company names, or fund names.
3. Click Data > Stocks
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
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: .
4. Add a column
Click the Add Column button , and then click Price.
5. Price appears
Excel will extract the Price field from the cells with the Stocks data type. Click the Add Column button again 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.
To see all of the fields available for a company or fund, click the stock icon ( ) or select the cell and press Ctrl+Shift+F2.
You can also write formulas that reference data types.
If you see 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 and a selector pane will appear. Search for the data you need using a keyword or two, and then click Select.