If you need stock market data for your spreadsheet, you can save time and get up-to-date information with the built-in Stocks data type in Microsoft Excel. Here’s how to populate your sheet with details like ticker symbols, market caps, previous close, and more.
Add Stock Data to Your Excel Sheet
To use the Stocks data type in Microsoft Excel, you only need an internet connection and a bit of your own data to start.
Open your spreadsheet and type a piece of information, like a company name or stock symbol. With the cell still selected, open the “Data” tab, and then click “Stocks” in the “Data Types” section of the ribbon.
After a few seconds (depending on your internet connection), you might see the “Data Selector” sidebar open on the right. This happens when your item can’t be found or more than one stock with that name is available.
Click “Select” under any of the available options in the sidebar.
If you click away from the cell that contains your initial data, just select it again, and then click the small Insert Data icon that appears next to it. A long, scrollable list containing all the stock market details you could possibly need will appear.
Choose the information you want to include and it will pop into the cell at the right. You can continue adding details for the stock in this same way. Any additional details you choose will populate in the subsequent cells to the right.
You can also add column headers to identify the data you include. At any time, though, you can just click the cell containing an item to see what it is in the Formula Bar.
View the Data Type Card
The scrollable list of details for a stock is helpful, but you can also view this same data in a card format. Just right-click the cell containing the company or stock you first typed, and then select “Show Data Type Card” from the menu that appears.
You can then see those same details in an easy-to-read snapshot. You can also drag the bottom-right corner to enlarge the card if necessary. To add move information from the card to your sheet, just hover your cursor over that piece of data, and then click the Extract to Grid icon.
Refresh the Stocks Data
Like the Geography data type in Microsoft Excel, the Stocks data type retrieves information from an online source. This means you can update it without opening a web browser.
To do so, just right-click the cell that contains the company name or stock symbol, and then select Data Type > Refresh from the menu that appears.
Don’t See the Stocks Feature?
If you don’t see the Stocks data type in Microsoft Excel, make sure your system meets the following requirements:
- You’re using Excel for Microsoft 365: Microsoft might add this feature to additional versions in the future, but for now, you’ll have to use this one.
- You’ve updated to the latest version of Office: Microsoft is rolling out this feature gradually, so you might have to wait a bit. Just keep checking for new versions of Office.
- English is set as the editing language in Office: Excel’s data types are only available if you’ve done this. You can learn how to change it in Microsoft Word here, and this will also change it in Excel.
- › How to Use the Automatic Data Type Tool in Microsoft Excel
- › How to Create Your Own Data Type in Microsoft Excel
- › How to Use Templates for Data Types in Microsoft Excel
- › How to Calculate CAGR in Microsoft Excel
- › How to Calculate a Moving Average in Microsoft Excel
- › How to Use Goal Seek in Microsoft Excel
- › How to Get Currency Exchange Rates in Microsoft Excel
- › Windows 10 Really Wants You to Upgrade Already