Excel STOCKHISTORY Function not working - Jan 1st, 2026

Hwy17 500 Reputation points
2026-01-01T22:26:17.78+00:00

Hi: We have been using STOCKHISTORY to load historical data in Excel workbook for about 20 stocks. For some reason today morning its not working and now is almost 3 hrs.

Microsoft 365 and Office | Excel | For business | Windows

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Julien 40 Reputation points
    2026-01-02T17:25:56.2533333+00:00

    Same issue here. Annoying. I get the issue is not on user side, an ETA for a fix would be appreciated.

    Was this answer helpful?

    8 people found this answer helpful.
  2. Michael Bahnmiller 15 Reputation points
    2026-01-03T14:42:37.2966667+00:00

    Same problem and it's now Jan 3. I buy 365 exclusively for this function. Very disappointed.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  3. Mark B 70 Reputation points
    2026-01-02T16:27:20.1533333+00:00

    last time this happened it did take multiple days, it appears based on some of the time stamps of global users, this is already past a 24 hour issue. it always DOES get resolved, my guess worst case scenario it will be Saturday. Yahoo Finance used to be the go to backup, but now Yahoo makes you have to pay to get similar data (you have to manually download it into a CSV). anyways, patience is probably needed. annoying, yes, but it will get fixed - always does.

    Was this answer helpful?

    3 people found this answer helpful.
  4. Vivian-HT 17,885 Reputation points Microsoft External Staff Moderator
    2026-01-05T00:16:44.79+00:00

    Dear @Hwy17 and everyone,

    First of all, I’m truly sorry for the inconvenience this issue has caused. I completely understand how inconvenient when STOCKHISTORY suddenly stops working without warning. Thank you for your patience while working through this.

    Therefore, I would make a brief summary of this post so that other forum members could easily find useful information here:

    Issue Description:

    • The Excel STOCKHISTORY function stopped working on January 1st, 2026. Other users have also reported the same issue around the same time, indicating it was likely a temporary service‑side disruption with Microsoft’s stock data provider.

    Recommended Steps to Try

    • Step 1: Test in Excel for the Web or a New File
    • Step 2: Refresh Your Excel Session
      • Sign out of Excel: File > Account > Sign out > Close Excel completely > Restart your computer > Open Excel and sign back in
    • Step 3: Repair Microsoft Office Apps. For more tips, see Repair an Office application.
    • Step 4: Report a Problem (Go to Excel > Help > Feedback > Report a problem)
      • If the problem continues, I recommend you report an issue directly inside the Excel app so the Microsoft product team can review the logs and investigate the behavior mor e accurately.

    Current Update (Good News)

    • Based on feedback from other users experiencing the same outage, the STOCKHISTORY function is now working again and has been restored on Microsoft’s side.

    Again, I truly appreciate your patience and understanding. Please understand that as forum moderator, my primary goal is to provide helpful guidance and support through general troubleshooting steps. While I don’t have access to internal systems or test devices required to resolve backend issues, I truly appreciate your understanding of these limitations. I genuinely hope the information I share helps guide you in the right direction, and I'm always here to assist as much as I can within my scope.

    I hope this information is helpful. If you have any further questions or need clarification, please feel free to reach out.

    Thank you for your patience and your understanding.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments

  5. AI answer

    2026-01-01T22:26:23.3066667+00:00

    If the STOCKHISTORY function in Excel is not working, there could be several reasons for this issue. Here are some common troubleshooting steps you can take:

    1. Check Internet Connection: Ensure that your internet connection is stable, as the STOCKHISTORY function requires access to online data.
    2. Excel Updates: Make sure that your Excel application is updated to the latest version. Sometimes, bugs in older versions can cause functions to fail.
    3. Function Syntax: Verify that the syntax of the STOCKHISTORY function is correct. Ensure that you are using the correct parameters for the function, such as the stock symbol, start date, and end date.
    4. Service Availability: Occasionally, the data service that provides stock history may experience outages or maintenance. Check if there are any announcements regarding service interruptions.
    5. Excel Limits: If you are trying to pull a large amount of data, ensure that you are not exceeding any limits set by Excel for data retrieval.

    If the problem persists after these checks, consider reaching out to Microsoft support for further assistance.

    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.