STOCKHISTORY Function Returning #VALUE! for Dates After September 7, 2026 (Refinitiv/MSN Sync Latency)

Question

The =STOCKHISTORY() function returns a #VALUE! error when requesting End-of-Day (EOD) market closing data for any date after September 7, 2026.

Historical queries targeting sessions up to and including September 7, 2026, successfully resolve and return accurate closing prices. However, querying valid market sessions from September 8, 2026 onward fails across multiple tickers. This indicates an upstream data pipeline stoppage or sync failure between the market data provider (Refinitiv/MSN Money) and Microsoft’s backend servers for Indian equity feeds.

Query the closing price of an Indian stock (NSE or BSE) for September 7, 2026.

Result: The price appears normally.

Query the closing price for the same stock for September 8, 2026, or any subsequent trading date.

Result: The cell displays #VALUE!.

Expected vs. Observed Behavior:

Expected: The function returns the end-of-day closing price for completed trading sessions after September 7.

Observed: Excel returns #VALUE!, indicating that backend data for Indian exchanges has not synced or updated after September 7, 2026.

Request:

Microsoft Support previously indicated this is a server-side ingestion issue. Please escalate this to the market data engineering team to refresh and backfill the daily NSE and BSE price feeds from September 8, 2026 onwards.

Answer 1

There is no problem with your Office installation or Windows, this is a widely reported problem with StockHistory not working in may locales since the 7th of September, there is currently no workaround available, this forum is jsut a user to user forum, the best option is to report this in Excel - Help - Feedback - Report a Problem.

Microsoft have indicated they are aware of the problem, we just need to wait for them to resolve the problem on their servers and StockHistory will then work again.