Excel Error Codes

Fix Excel STOCKHISTORY Returns #N/A Error for Stocks and ETFs

John Wilson Oct 9, 2026 869 views

Question details

The user wants to understand why the STOCKHISTORY function in Excel 365 is returning an #N/A error for certain stock symbols, ETFs, or market indexes, and how to resolve or report the issue.

Why Excel STOCKHISTORY Returns #N/A for Stocks and ETFs

Product: Excel 365
Device & OS: not provided
Scenario: Attempting to retrieve historical financial data for specific stocks, ETFs, or indexes using the STOCKHISTORY formula in Excel.
Observed behavior: The STOCKHISTORY function fails to output the historical data and instead returns an #N/A error in the cell.

Before you start

Ensure you have an active Microsoft 365 subscription and a stable internet connection, as the STOCKHISTORY function relies on continuous cloud access to fetch third-party financial data.

Solution 1Recommended

Verify Ticker Formatting and Data Availability

Check if the requested stock symbol is properly formatted and supported by Excel's third-party market data provider.

The #N/A error frequently occurs because Excel's data provider (Refinitiv) may not cover certain niche ETFs, newly listed stocks, or specific regional indexes. Incorrect ticker formatting can also cause the function to fail.

Use the Stocks Data Type first

Type the company name or ticker into a blank cell. Go to the 'Data' tab on the ribbon and click 'Stocks'. If Excel cannot convert it into a Stock data type, STOCKHISTORY will not work for that symbol.

Include the Exchange Prefix

To avoid ambiguity, prefix the ticker symbol with the exchange abbreviation. For example, instead of just using "MSFT", update your formula to use "XNAS:MSFT" for the NASDAQ listing.

Check for Supported Indexes

If you are trying to pull index data like the S&P 500, ensure you are using the correct recognized ticker format, which is often "^GSPC" or "INDEXSP:INX" depending on current data provider integrations.

Data Provider Limitations: Excel occasionally experiences temporary backend connection issues with its data provider. If a previously working formula suddenly shows #N/A, wait a few hours and manually refresh the workbook by pressing F9.

Solution 2

Seek Specialized Microsoft Community Assistance

If standard troubleshooting fails, you may need to escalate the issue to Microsoft's specialized community forums regarding missing data.

Free Microsoft Office alternative

Seamlessly Analyze Financial Data with WPS Office

If you are frustrated by subscription-only functions or complex data errors in Microsoft 365, try WPS Office. It is a highly compatible, free, and lightweight alternative that handles complex data analysis, financial models, and large spreadsheets with ease.

1. Download and Install WPS Office: Visit the official WPS Office website to download the lightweight installer for your Windows, Mac, or Linux device.
2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx or .csv financial documents directly.
3. Perform Your Analysis: Utilize WPS Spreadsheet's rich library of financial, statistical, and mathematical functions to continue your data analysis without subscription barriers.

Highly compatible with Microsoft Excel formats (.xlsx, .xls, .csv) ensuring your financial models open flawlessly.Completely free to use with a familiar, intuitive user interface that requires no learning curve.Fast, lightweight performance perfect for managing heavy datasets and complex financial charts.Built-in advanced formulas and robust analytical tools to replace your everyday spreadsheet tasks seamlessly.

microsoft office alternative - wps office

Frequently Asked Questions

Why does STOCKHISTORY show #N/A for newly listed ETFs?

Newly listed stocks or ETFs take time to be added to Excel's third-party data provider (Refinitiv). If the provider hasn't updated their database to include the new listing, Excel will return an #N/A error until the data is populated.

Is the STOCKHISTORY function available without a Microsoft 365 subscription?

No, STOCKHISTORY is a dynamic array function exclusive to Microsoft 365 subscribers. If you open a workbook containing this function in Excel 2019, 2016, or older, it will return an error.

How can I fix the #BUSY! error in STOCKHISTORY?

A #BUSY! error means Excel is currently communicating with the cloud servers to download the historical data. Simply wait a few moments. If it persists, check your internet connection or press F9 to force the workbook to recalculate.

Does STOCKHISTORY support cryptocurrency data?

Yes, STOCKHISTORY supports major cryptocurrencies, but the exact ticker formats can vary. Use the 'Stocks' data type feature first to search for the cryptocurrency pair (like BTC/USD) to ensure Excel recognizes it before using the formula.

Microsoft Office Error Codes