stock market quotes

Manuel Silva 0 Reputation points
2026-09-14T13:30:46.9866667+00:00

I cannot update the stock market price history; it is configured for the period from September 14, 2025, to September 14, 2026, but it gets stuck at September 4, 2026, and skips to September 14, 2026.

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

2 answers

Sort by: Newest
Most helpful Newest Oldest
  1. Kai-H 26,840 Reputation points Microsoft External Staff Moderator
    2026-09-15T11:12:01.9666667+00:00

    Hi, Manuel Silva

    The missing dates may be caused by the formula’s interval setting, not by the selected date range. In STOCKHISTORY, interval 1 returns weekly data, so Excel intentionally omits individual trading days.

    Here are some suggestions you can try:

    Change the fourth argument from 1 to 0 to request daily prices:

    =STOCKHISTORY("IBM",DATE(2025,9,14),DATE(2026,9,14),0,2)

    Here, 0 means daily, 1 means weekly, and 2 means monthly.

    If you use only a ticker symbol, specify the exchange as well, for example:

    =STOCKHISTORY("XNAS:MSFT",DATE(2025,9,14),DATE(2026,9,14),0,2)

    This helps Excel identify the correct security when the same ticker exists on multiple exchanges.

    Test the same formula in a new blank workbook with only one stock. If the dates appear there, the original workbook may have too many background stock requests. Large numbers of STOCKHISTORY formulas can take longer to update.

    Also note that weekends and market holidays will not have trading records.

    Thank you for your patience in reading, I hope this information has been helpful to you. 

    If the answer is helpful, please click "Yes" 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?

  2. AI answer

    2026-09-14T13:31:05.6433333+00:00

    This matches a known Excel Stocks/STOCKHISTORY service issue that affected many locales starting in early September 2026. There is currently no documented self-service fix in the available guidance.

    Supported actions:

    1. Report the problem from Excel: Help > Feedback > Report a Problem.
    2. If using Microsoft 365 through an organization, ask the Microsoft 365 admin to go to Microsoft 365 Admin Center > Health > Service health > Report an issue.
    3. If the formula uses typed date text, use DATE() instead of locale-dependent text dates. Example: =STOCKHISTORY("IBM",DATE(2025,9,14),DATE(2026,9,14),1,2)

    The DATE() change helps only when the problem is caused by regional date parsing. If the history still stops at September 4, 2026 and then jumps to September 14, 2026, that behavior is consistent with the reported backend service problem and must be resolved on the service side.

    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.