Stock History not working since 09/04/2026

Gustafson, Dennis 0 Reputation points
2026-09-10T13:55:27.9166667+00:00

Formula that works:

=STOCKHISTORY("MSFT",DATE(2026,9,4),DATE(2026,9,4),0,0,1)

Formula that fails:

=STOCKHISTORY("MSFT",DATE(2026,9,8),DATE(2026,9,8),0,0,1)

Error:

"The days between start_date and end_date are non trading days"

Additional observations:

  • Issue occurs with all tested tickers.
  • Historical dates prior to 9/4/2026 return correctly.
  • Dates 9/8/2026 and 9/9/2026 return the error.
Microsoft 365 and Office | Excel | Other | Other
0 comments No comments

1 answer

Sort by: Most helpful
  1. AI answer

    2026-09-10T13:55:43.7333333+00:00

    This matches a known service-side issue pattern with Excel stock data functions rather than a problem with the formula syntax.

    The formula structure shown is valid:

    =STOCKHISTORY("MSFT",DATE(2026,9,8),DATE(2026,9,8),0,0,1)

    Relevant supported facts:

    1. STOCKHISTORY accepts DATE(...) for start_date and end_date, so the date argument format being used is correct.
    2. The function returns historical price data from an external provider.
    3. There are documented cases where Excel stock data functions stop working due to temporary server-side problems, and the recommended action is to report the issue through Excel > Help > Send feedback.

    Given that:

    • all tested tickers fail,
    • earlier historical dates still work,
    • the failure is limited to specific recent trading dates,

    this points to missing or delayed market data availability for those dates in the stock data service, not a workbook issue.

    Action to take:

    1. In Excel, open Help.
    2. Select Send feedback.
    3. Report that STOCKHISTORY returns "The days between start_date and end_date are non trading days" for valid trading dates 2026-09-08 and 2026-09-09 across multiple tickers.
    4. Keep using the DATE(...) form in formulas, since that is the recommended locale-safe format.

    If the service recovers, the same formula should begin returning data without workbook changes.


    References:

    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.