stockhistory function not pulling data later than 9/4/2026

Michael Smith 0 Reputation points
2026-09-10T10:24:07.74+00:00

Stockhistory function doesn't pull data later than 9/4/2026. If I use the function with start date of 1/1/2026 and end date of 9/9/2026, the function displays data from 1/2/2026 through 9/4/2026. The last date that appears with data is 9/4/2026. It does not include data for 9/8/2026 and 9/9/2026 which were active trading days. Is there an issue with the stockhistory function at this time?

Microsoft 365 and Office | Excel | For home | Windows
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. SD - IA 178.9K Reputation points Independent Advisor
    2026-09-10T11:02:31.64+00:00

    Hi,

    STOCKHISTORY has been down for many locales since 7th September:

    https://www.reddit.com/r/excel/comments/1wcbwuy/excel_stock_data_down/

    https://learn.microsoft.com/en-us/answers/questions/5999002/stockhistory-data-for-9-8-2026

    You may want to send feedback to Microsoft using Help > Report a problem - this can only be solved by Microsoft or the data provider, LESG, I am afraid.

    I hope this information helps. If you have any more questions, don't hesitate to reach out. Wishing you good luck!

    Standard 3rd party link disclaimer:

    There may be links to non-Microsoft websites that provide accurate and safe information. Watch out for ads on websites frequently classified as PUP (Potentially Unwanted Products). There is no need to buy paid products to fix your computers, as they sometimes do more harm than good.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments

  2. AI answer

    2026-09-10T10:24:27.6133333+00:00

    Yes. The behavior described matches a known service-side issue pattern that has affected Excel Stocks and STOCKHISTORY before, where recent dates stop returning and users see incomplete or stale data.

    Supported facts relevant to this case:

    1. STOCKHISTORY generally updates only after a trading day completes, so it cannot return the current day’s trading details before market close.
    2. Historical and price data for Stocks and STOCKHISTORY come from an online data source, so service-side problems can affect refresh results.
    3. Community reports for similar outages indicate there may be periods where the function is broken for many users, and the practical action is to report it from Excel.

    For the specific dates listed, 9/8/2026 and 9/9/2026 are after 9/4/2026, so if those were completed trading days and still do not appear, that points to a data/service issue rather than normal STOCKHISTORY timing behavior.

    Recommended next step:

    • In Excel, go to Help > Send Feedback and report the issue to the Office developers.

    Also note:

    • Stock information is delayed and provided “as-is.”
    • STOCKHISTORY and Stocks data depend on the connected online provider.
    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.