Excel Stock Price Function

Joe Pa 40 Reputation points
2026-01-23T13:47:45.2566667+00:00

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
{count} votes

5 answers

Sort by: Most helpful
  1. What's Next 0 Reputation points
    2026-01-26T23:26:41.6766667+00:00

    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?


  2. 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.

    0 comments No comments

  3. 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 :)


  4. 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!


  5. Q&A Assist
    2026-01-23T13:49:25.0133333+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    The 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.

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.