'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel STOCKHISTORY Not Displaying Exchange and Symbol
Question details
The user needs to resolve an issue where the Excel STOCKHISTORY function intermittently fails to output exchange and symbol information for specific stocks.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Using the STOCKHISTORY formula to pull and display historical financial data and stock properties in a spreadsheet.
- Observed behavior
- The function's second argument fails to return Exchange:Symbol information (such as XNAS:NVDA) for certain securities intermittently, while working correctly for other ticker symbols.
Ensure you have a stable internet connection, as the STOCKHISTORY function relies entirely on continuous communication with external market-data servers.
Restart Excel and Refresh the Data Connection
Since this is often caused by a temporary server-side issue or interrupted data stream, restarting the application can force a fresh connection to the financial data provider.
Intermittent data omissions usually indicate a temporary hiccup in the background data service rather than a persistent formula error. A full restart clears the caching of the data types.
Save all your current progress in the workbook and completely exit the Microsoft Excel application.
Relaunch Excel, open your workbook, and click on the cell containing your STOCKHISTORY formula.
Navigate to the 'Data' tab on the ribbon and click 'Refresh All', or simply press the F9 key on your keyboard to force Excel to fetch the latest server data.
Verify Security Symbol and Formula Arguments
Confirm that the stock symbol is fully supported and that your formula arguments are correctly formatted to request exchange data.
Report Persistent Intermittent Issues to Microsoft
If the problem only affects specific stocks and persists across multiple sessions, it is likely a backend data source bug that requires Microsoft's intervention.
Try WPS Office for Seamless Spreadsheet Management
If you are frustrated by recurring server-side data issues or expensive subscription models in Microsoft Excel, consider WPS Office. It provides a lightweight, highly compatible, and free alternative with a familiar user interface for reliable spreadsheet analysis.
- 1. Download the software: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install and launch: Run the installer, follow the on-screen instructions, and open WPS Spreadsheets.
- 3. Open your files directly: Drag and drop your existing .xlsx workbooks into WPS Office to instantly resume your financial data analysis without formatting loss.
Frequently Asked Questions
Why does STOCKHISTORY show #BUSY! or #CONNECT! errors?
These errors typically indicate that Excel is currently retrieving data from the external server or that there is a temporary network connection issue preventing the data download. Waiting a moment or refreshing the data usually resolves it.
Is the STOCKHISTORY function available in all versions of Excel?
No, the STOCKHISTORY function is a dynamic array function available only to Microsoft 365 subscribers and Excel for the Web users. Older perpetual versions like Excel 2019 or 2016 do not support it.
How do I correctly specify the exchange in the STOCKHISTORY formula?
You can prefix the stock ticker with the specific exchange identifier followed by a colon, such as 'XNAS:NVDA' for the NASDAQ exchange, to ensure the function pulls data from the correct financial market.
Can I refresh STOCKHISTORY data manually if it gets stuck?
Yes, you can manually refresh the data by navigating to the 'Data' tab on the Excel ribbon and clicking 'Refresh All', or simply by pressing the F9 key to force a workbook recalculation.
