Forum Discussion
Stockhistory function not updating since 7th September
The historical data of stocks is not getting updated after 7th September, how to fix it.
Please help
21 Replies
- VivekJJBrass Contributor
Gold and Crypto prices are getting updated but not Equity prices
- I_Love_ExcelTin Contributor
I would have assumed there was a large community globally that uses the stockhistory function; however, am beginning to wonder :) are we the only ones this is affecting or is it a global issue. If global you would think there would be more posts? Confused...
- bstribCopper Contributor
It's definitely global. Same problem down here in Australia...
It's happened a few times before, so I suspect most are just waiting for MS to fix it.
I just reinstalled the latest EXCEL update (Build 20326.20144) from 8th Sep - didn't fix it. Not sure, but wouldn't be surprised if it was this update is what broke the function.
- I_Love_ExcelTin Contributor
just tried the following function with excel online
=STOCKHISTORY("msft","2026-09-1","2026-12-31",0,1,0,2,3,4,1,5)
And has the same issue with excel online. The data does not do past September 4th, 2026.
- stevestevesteveTin Contributor
strano che le ultime date siano diverse... forse dipende dalle borse diverse (questa è Milano)?
- I_Love_ExcelTin Contributor
are you getting any data for Sept 10 and today the 11th?
- I_Love_ExcelTin Contributor
Is there a moderator for this discussion? All my replies are still in review?
- I_Love_ExcelTin Contributor
Issue still persists. Thank you all for your suggestions and ideas. However, it seems to be a global issue. As any stock stops updating after September 4th. And yes the end date is set correctly :) MS told me to post here to resolve. However, are there actual MS staff here that can escalate and assist?
- stevestevesteveTin Contributor
è un grosso casino questo blocco, ho i dati solo fino al 07/09/26.
Come si fa a sbloccare?
Nella formula c'è "OGGI" come dati finali e il foglio si è sempre aggiornato all'apertura del file- stevestevesteveTin Contributor
ci si arriva da qui
- CameronTaylor1998Brass Contributor
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.
- FernandoRangelOccasional Reader
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.
- Dude73Copper Contributor
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.
- djgabelBrass Contributor
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?
- I_Love_ExcelTin Contributor
Having the same issue also since Tuesday - 09/08/2026. Last data available is from, Friday - 09/04/2026. Regardless of what stock or market you try it does not refresh past September 4th, 2026.
Updated excel, also did a repair of office. Then proceed to recreate the stockhistory functions thinking that maybe the parameters had changed. Even removed and edited a few parameters; however, received the same results.
Then proceeded to chat with a MS representative and opened a case number. Who could not help and told me to post here :)
This has happened before and the odd day has been lost but we are now on day 3 and this function is the number one reason I use MS products besides email. Sucks that things like this get lost and take too long to resolve. You just have to hope it will work again? Not great....Also posted in Excel the issues yesterday as per the report data issues function... am using Win 11Pro and Excel build Microsoft® Excel® for Microsoft 365 MSO (Version 2608 Build 16.0.20326.20072) 64-bit
- PFNikolaiTin Contributor
- Dude73Copper Contributor
Same issue here. No STOCKHISTORY data after 9/4/2026. I used the Feedback function to let Microsoft know.