This afternoon, 12 of 13 etf/mf symbols work fine with StockHistory function. One etf, VPL, fails consistently. Are there known problems in the data set?
Excel Stock Price Function
Anyone else having a problem this morning with Excel Stock Price updates? This happened at year end 2025 and here we are again. The function is not working on Microsoft's side.
Microsoft 365 and Office | Excel | For home | MacOS
5 answers
Sort by: Most helpful
-
-
Sumit D - IA 157.6K Reputation points Independent Advisor
2026-01-23T16:24:45.0266667+00:00 Absolutely, I think they get notified automatically when this type of issue happens.
-
Sumit D - IA 157.6K Reputation points Independent Advisor
2026-01-23T15:13:59.1633333+00:00 Yes Joe, I completely agree. At that time Teams were on vacation as there are minimal operations during holidays :)
-
Sumit D - IA 157.6K Reputation points Independent Advisor
2026-01-23T14:33:45.07+00:00 Hi Joe,
No reports by other users yet. Since it is a weekday, hopefully in the next few hours it should be fixed.
I hope this information helps. If you have any more questions, don't hesitate to reach out.
Otherwise, please take a moment to rate the answer. Wishing you good luck!
-
Q&A Assist2026-01-23T13:49:25.0133333+00:00 AI generated content. This question contains an answer created with AI from Q&A Assist. Learn moreThe issue you are experiencing with the Excel Stock Price function may be related to the RealTimeData (RTD) function improvements in Excel M365. In recent versions, Microsoft has made performance enhancements to the RTD function, which could affect how stock price updates are processed. If the function is not working, it could be due to temporary issues on Microsoft's side or specific settings in your Excel environment.
If you continue to face problems, consider checking for updates to your Excel version or reviewing any changes in your internet connection or Excel settings that might affect real-time data updates.