To insert a stock price into Excel, you first create a linked record. Then you can use another column to extract the stock price from the linked record itself.
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.
4. Linked records appear
If Excel finds a match between the text in the cells, and our online sources, it will convert the text to linked records. You'll know they're linked records if they have this icon: .
4. Click the Add Column button
Click the Add Column button , and then click Price.
5. Price appears
Excel will extract a value from the linked record's Price field. 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 linked records.
If you see instead of an icon, then Excel's having a hard time matching your text with a record in our online sources. Correct any spelling mistakes and when you press Enter, Excel will do its best to find a matching record. Or, click and the Record Selector pane will appear. Search for a record using a keyword or two, and then click Select.