Stockhistory function not updating since 7th September

First check whether the formula’s end date is fixed at September 7. STOCKHISTORY will only return data within the dates you request, and it provides historical prices rather than live quotes.

1. If the end date is fixed, change it to TODAY(). Also check that the interval argument is 0 for daily data.
2. Go to Formulas > Calculation Options > Automatic, then select Calculate Now.
3. In a blank workbook, try this test formula:
   =STOCKHISTORY("XNAS:MSFT",TODAY()-14,TODAY(),0,1)

      It requests available daily prices for Microsoft over the last two weeks. Use your local formula separators        if Excel rejects the commas.

      4. If your original stock is still missing dates, test it in Excel for the web too. If multiple stocks show the          same cutoff in both versions, that points toward a data-service issue rather than your workbook.

STOCKHISTORY normally updates after the trading day finishes, and weekends or market holidays will not have daily trading entries. For US exchanges, September 7, 2026 was a market holiday, but that would not explain missing data for subsequent completed trading days.