StockHistory Function is not fetching data beyond 7th Sep 2026

STOCKHISTORY generally updates only after a trading day completes, so it cannot return today’s trading details until the market has closed or the day has completed for that market.

If data is stopping at 7 Sep 2026 for all symbols, the practical alternatives in Excel are:

1. Use the Stocks data type for current values and summary fields
   • Enter the ticker or company name in a cell.
   • Go to Data > Stocks.
   • Use the inserted fields to pull values such as Price, 52 week high, and 52 week low.
   • This is the recommended alternative when the goal is current market data or common summary metrics.
2. Use STOCKHISTORY with valid historical dates only
   • STOCKHISTORY is for historical data.
   • If a workbook uses automatic calculation and a date formula such as TODAY(), the function refreshes when the workbook opens.
   • For date reliability across regional settings, use DATE(...) instead of text dates. Example: =STOCKHISTORY("IBM",DATE(2025,1,1),TODAY(),1,2)
3. Use Power Query for external financial web/API data
   • Go to Data > Get Data > From Web.
   • Enter the URL of a financial data provider.
   • Transform and load the data with Power Query.
   • This is the documented alternative for advanced users when built-in stock data is insufficient.

If this is a service-side issue rather than a formula issue, there is no documented self-service fix or published recovery timeline in the available guidance. Report it through Help > Feedback in Excel. In organizational environments, an admin can also report it through the Microsoft 365 Admin Center.

References:

• STOCKHISTORY function
• Fixing broken formulas in the Migrated Files
• STOCK DATA TYPE FUNCTIONALITY UPGRADES - Microsoft Q&A
• I'm trying to access stock pricing in excel. I keep getting a message that "Our Server is temporarily having problems." Is there a fix underway? - Microsoft Q&A
• When is Microsoft Excel STOCK_HISTORY servers projected to be back on-line? - Microsoft Q&A