To reveal these additional attributes, just click the little stock icon to the left of the company name and you’ll see a pop-up card that contains related data. So, what is so special about the stock data type? It retrieves a rich collection of market data-including current price, volume, high, low, company name, company description, number of employees and much more. The little icons indicate Excel has successfully found the ticker symbols and converted them into stocks. When you do, Excel attempts to convert those static text values into stocks (Figure 2). You can select the tickers, then click the Data > Stocks command in the Data Types group. (Note: converting your ticker list into a Table isn’t required, it just makes this feature easier to use). Perhaps your list is stored in a table (Insert > Table) and looks like Figure 1. Let’s say you have a handful of tickers and you want to view their current prices or related information. Note: This article is presented with Excel O365 for Windows not all versions of Excel include the features discussed. Specifically, we’ll talk about how the Stock data type retrieves current quotes and related information, and how Power Query can retrieve historical stock quotes from the web. If you’re typing closing prices into Excel manually, this article may be able to help you get it done faster.
Microsoft recently updated the built-in tools for retrieving stock quotes into Excel.
