Fix Excel STOCKHISTORY Missing Data and #VALUE! Errors
Question details
The user needs to restore current market data or resolve missing results and #VALUE! errors from Excel STOCKHISTORY.

- 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.
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.
Check the security identifier and trading dates
Use this check to rule out an incorrect ticker or a date with no available trading data.
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.
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.
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 Microsoft 365 updates and report a service issue
Use this approach when valid formulas fail for multiple dates or securities.
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.

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.




