Data Import & Export

Fix Excel STOCKHISTORY Missing Data and #VALUE! Errors

Tauseeq MagsiTauseeq Magsi Nov 18, 2026 869 views

Question details

The user needs to restore current market data or resolve missing results and #VALUE! errors from Excel STOCKHISTORY.

Fix Excel STOCKHISTORY Missing Data and #VALUE! Errors
Product
Microsoft Excel for Microsoft 365
Device & OS
not provided
Scenario
A workbook uses STOCKHISTORY to retrieve historical prices for a security.
Observed behavior
Recent market data is missing or the formula returns a #VALUE! error, potentially because the financial-data service is unavailable or delayed.
Before you start

Note the security identifier and date range in the affected formula. Check the relevant exchange's trading calendar, including holidays, and allow for any market-data reporting delay.

Solution 1Recommended

Check the security identifier and trading dates

Use this check to rule out an incorrect ticker or a date with no available trading data.

1
Inspect the formula

Select the cell showing missing data or #VALUE! and check the STOCKHISTORY arguments in the formula bar. Verify the ticker, exchange, start date, and end date.

2
Test a known trading date

In an empty cell, enter =STOCKHISTORY("MSFT",DATE(2023,2,13),DATE(2023,2,13)) to test a known historical trading day. If it works, compare its arguments with the affected formula.

3
Check the affected dates

Compare the requested dates with the security's exchange calendar. Adjust the date range in the formula to include trading days, and allow time for recent data to become available.

Check the security identifier and trading dates
Data availability varies: A weekend or exchange holiday may have no market data. If a valid ticker and trading date still fail, the connected data service may be delayed or unavailable.
Free Microsoft Office alternative

Work with market-data spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and move existing worksheets into WPS Office for everyday editing.

Open and edit compatible Microsoft Excel XLSX and XLS filesReview and organize imported market-data tables in WPS SpreadsheetUse a familiar interface for a smoother move from Microsoft OfficeAccess free spreadsheet tools in a lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does STOCKHISTORY return #VALUE! for a recent date?

The date may not be a trading day, the security identifier may be incorrect, or market data may be delayed or unavailable. Check the formula arguments and the exchange calendar, then retry later.

How can I tell whether my STOCKHISTORY formula is the problem?

Test a known ticker and historical trading date in an empty cell, such as =STOCKHISTORY("MSFT",DATE(2023,2,13),DATE(2023,2,13)). Compare the result and arguments with your original formula.

Where can I check for Excel updates?

In Excel for Windows, select File > Account > Update Options > Update Now. On a Mac, select Help > Check for Updates.

Who should I contact if valid STOCKHISTORY formulas still fail?

Use Help > Feedback in Excel or contact Microsoft Support. Include the formula, security identifier, affected dates, and error message so the issue can be investigated.

Can WPS Office restore Microsoft's STOCKHISTORY data service?

No. WPS Office is an alternative for working with compatible Excel files, but it cannot restore Microsoft's external data service. Check STOCKHISTORY formula compatibility before using the workbook in WPS Spreadsheet.