Stockhistory in Excel not returning values for the past 2 days for any stock symbol

david brager 0 Reputation points
2026-09-11T04:38:25.0566667+00:00

Stockhistory in Excel not returning values for the past 2 days for any stock symbol. It does continue to provide values for prior dates. Reloaded Office and 365 so that's not the issue. Using Windows machine.

Microsoft 365 and Office | Excel | For home | Windows

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. DaveM121 929K Reputation points Independent Advisor
    2026-09-11T05:12:15.5566667+00:00

    There is no problem with your Office installation or Windows, this is a widely reported problem with StockHistory for the last two days, Microsoft have indicated they are aware of the problem we just need to wait for them to resolve the problem on their side and StockHistory will then work again.

    Was this answer helpful?

    2 people found this answer helpful.

  2. AI answer

    2026-09-11T04:38:36.96+00:00

    This matches a reported service-side issue with Excel Stocks data and STOCKHISTORY, where recent data stops updating and Excel shows server-related problems. Since Office and Microsoft 365 were already reloaded, repeating that step is unlikely to help.

    Use these checks:

    1. Confirm the formula is not trying to return today’s intraday data. STOCKHISTORY generally updates only after a trading day completes, so current-day trading details are not available until after market close or after the day completes for that market.
    2. Test with a formula that avoids locale-sensitive text dates, for example: =STOCKHISTORY("MSFT",DATE(2025,1,1),TODAY(),0,1,0,1) Using DATE() avoids regional date-format issues that can affect start_date.
    3. If the last two completed trading days are still missing for all symbols, treat it as a backend data-service issue rather than a local Windows or Office installation problem.
    4. In Excel, use Help > Feedback to report the issue. If the account is part of an organization, an admin can also check the Microsoft 365 Service Health Dashboard and report the incident through the Microsoft 365 Admin Center.
    5. Wait and retry after a few hours. Similar incidents have been reported as temporary service interruptions.

    Also note:

    • Stock information in Excel is delayed and provided as-is.
    • Some instruments available as Stocks data types do not have historical data, but that would not explain the same failure across all symbols.
    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

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.