Fix Missing Stocks and STOCKHISTORY Features in Excel LTSC
Question details
Users are unable to locate or use the Stocks data type and the STOCKHISTORY function to retrieve financial market data in their spreadsheets.
- Product
- Microsoft Excel LTSC / Office 2021
- Device & OS
- not provided
- Scenario
- Attempting to track financial market data, retrieve historical stock prices, or convert text into dynamic financial data entities.
- Observed behavior
- The Stocks option is missing from the Data tab, and typing the STOCKHISTORY function results in a #NAME? error because the feature is not included in the software.
Verify your exact Office version by navigating to File > Account in Excel. This confirms whether you are using a perpetual license like Office 2021 or LTSC, which determines your feature access.
Use Excel for the Web to Access Stocks Data Types
Since the Stocks feature requires a cloud-connected Microsoft 365 environment, you can access it for free by migrating your file to Excel for the web.
The Stocks data type and STOCKHISTORY functions are powered by cloud services. Because Office LTSC and Office 2021 are designed as disconnected, perpetual licenses, they do not include these internet-dependent premium features.
You can bypass this limitation by using the free, web-based version of Excel which supports these dynamic data types.
Sign in to your Microsoft account and upload the Excel workbook you want to edit into your OneDrive storage.
Navigate to office.com/launch/excel in your web browser and open the uploaded workbook.
Select the cells containing company names or ticker symbols, go to the Data tab on the ribbon, and click 'Stocks' in the Data Types group.
Try WPS Office for Your Spreadsheet Needs
If your current Excel version limits your access to modern features, consider switching to WPS Office. It is a highly compatible, free, and lightweight alternative that excels at financial tracking, data analysis, and managing complex workbooks seamlessly.
- 1. Download and Install WPS Office: Visit the official WPS website to download the free installation package and follow the on-screen instructions.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing financial tracking documents directly with perfect formatting retention.
- 3. Explore Financial Templates: Browse the WPS Template library to find ready-to-use stock tracking and portfolio management spreadsheets.
Frequently Asked Questions
Why is the Stocks data type missing in Office 2021?
The Stocks data type is a premium, cloud-linked feature exclusive to Microsoft 365 subscription plans. Perpetual licenses like Office 2021 and LTSC are locked-in-time releases and do not receive these internet-dependent feature updates.
Will Office LTSC ever get the STOCKHISTORY function?
No, Office LTSC is specifically designed for disconnected environments and does not receive new feature updates or connected cloud features like STOCKHISTORY after its initial release.
How can I pull stock prices without the Stocks data type in desktop Excel?
You can install third-party financial add-ins from the Office Store, or use Power Query (Get & Transform Data) to connect to free financial web APIs and pull real-time stock data into your LTSC spreadsheet.
