A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Dear @Clover Keth
I understand the interruption is affecting your work. To help distinguish a connection failure from missing market data, could you confirm:
- Are you using the Stocks data type or the STOCKHISTORY function?
- Do you receive an error, or do prices remain unchanged?
- Are all tickers affected, or only particular stocks or exchanges?
I recommend testing one affected ticker in a new blank workbook, then testing it in Excel for the web using the same account. Please keep your original workbook unchanged.
If the new workbook works, the issue may be specific to the original file. If only certain tickers fail, please share one example and its exchange so I can help check the scope.
If you use STOCKHISTORY, please also share the formula. It generally returns historical data after the trading day completes, rather than live intraday prices.
Reference: Microsoft’s STOCKHISTORY guidance.