From what I can see, the Stockhistory function has stopped pulling data. Last date of data is Feb 10 2023. It does not give data past that date. It is not giving an error. It will pull older data before that date. I have tried restarting computer.I have checked for updates to Win11 and Office. Office updated. I'm using Office 365 for enterpriseSince I'm not seeing more outcry about this I'm wondering if there is something that I need to do on my end. There is one other post on this site. But I can find no other posts complaining about this.

I am also in the same boat. I noticed it Monday and thought it was just a glitch or something but even still at 9:52 on 2/15/23 my stock history will not update past 2/10/23DismalDave Very worried.

Hnorajr Yes its fixed...thank goodness!! I'm so relieved.Also thank you to @DismalDave for terming the issue correctly for me to find...

My stockhistory finally started working again for all positions. Hurrah

Most recent as of Tuesday 3/7/23 9AM Pacific is that it looks like it's back up again. One day of blindness.Hooray, until next time. 3/6/23 Monday, it looks like we are having trouble again. As of 9:30 PM Pacific I'm not getting anything. Nada. It normally has shown up by 6:30 PM. Most recent as of morning of Thursday 16 2023Looks like all stocks are working. Good enough for me. But, Currency, some ETS, and Crypto are not working. Sorry for those of you using those. Hopefully they keep working on this. Would love to know what the cause was. but doubt that will come out. Most recent info from erdem71 I have the same issue and the answer I received : "This known issue is being known by the Excel team and is being actively investigated. If the server data is back to normal, there will be a version update to state that the STOCKHISTORY function issue fixed."2/15/23 12:30 PM Pacific time DismalDave I did not get a chance to login. Had to set up a second account. For the second time today I ran Update and this time it had an update for 2023-02 Win11 and .NETI did both of those expecting that would solve the problem. It did not. Still no data past the date of Feb 2 2023. **************************************************** I'm not sure why this isn't showing up when I look at the thread. But it was sent to my email.I was hoping someone had a way to check with MSFT internally. This was sent to me by Vega2677 (Occasional Visitor) posted a new reply in Excel on Feb 14 2023 07:55 PM:Re: STOCKHISTORY functionSpoke with tech support midnight last night. He told me they know about the problem and the engineers are working to resolve the problem. He said wait 24 hrs and retest. Let's hope they are able to resolve the problem soon.

DismalDave only data from 2/10/23 and prior was available for me today.

Stockhistory function appears to no longer be updating past Feb 10 2023

85 Replies

Joseph_Kellerstrass
Copper Contributor
Feb 15, 2023
I am also in the same boat. I noticed it Monday and thought it was just a glitch or something but even still at 9:52 on 2/15/23 my stock history will not update past 2/10/23DismalDave

Very worried.
MichaelO1865
Copper Contributor
Feb 15, 2023
DismalDave
I have the same problem, but the .Price formula still works for seeing live prices on the current day.
- MoxiG
  Copper Contributor
  Feb 15, 2023
  Yes thank goodness...but some models (like mine in particular) needs previous price history to function...
Patrick2788
Silver Contributor
Feb 15, 2023
It could be an issue with the data supplier Refinitiv. I've looked them up and there's been no word on this issue yet. Stay tuned.
MoxiG
Copper Contributor
Feb 15, 2023
Also contacted support...been waiting for them to call Me back...hope they solve this issue urgently. My whole model depends on this live prices 😞
Hari_Bhatta
Copper Contributor
Feb 15, 2023
I am having the same issue. Stock history function is not updating after 10th Feb 2023.
MoxiG
Copper Contributor
Feb 15, 2023
DismalDave I'm having the same problem...who do we contract?? this is an urgent matter!!
MarkjL
Copper Contributor
Feb 15, 2023
Still not working as of 6:45 am EST on Feb 15 2023 DismalDave
- Andrew1625
  Copper Contributor
  Feb 15, 2023
  Still no fix as of 7:33am EST MarkjL
roughy64
Copper Contributor
Feb 15, 2023
same issue for me
EricVB
Copper Contributor
Feb 15, 2023
Well at least I am not alone, same issue here
MarcoBazzani
Copper Contributor
Feb 15, 2023
same issue here

Forum Discussion

Stockhistory function appears to no longer be updating past Feb 10 2023

85 Replies

Resources