Forum Discussion
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.
- If the end date is fixed, change it to TODAY(). Also check that the interval argument is 0 for daily data.
- Go to Formulas > Calculation Options > Automatic, then select Calculate Now.
- 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.
This is the result, and today is 11/09/2026, so it looks like an issue related to Microsoft-specific LSEG feed or Microsoft processing.
These steps don't solve the problem for me. Do they solve it for you, CameronTaylor?
It seems the issue continues today. Microsoft and LSEG need to resolve this on their end, not the users' end.
Thanks but I have been using STOCKHISTORY from the beginning and tried several different versions of the formula and spoke to two different support agents for an hour each as they ran me through troubleshooting. Both arrived at the same conclusion........ Data is not provided after 9/4/2026. Let me ask you, did you try it in your Excel and did you get a result?
