Feb 14 2023 09:44 AM
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 enterprise
Since 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.
Feb 14 2023 11:56 AM - edited Mar 07 2023 09:07 AM
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 2023
Looks 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
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 .NET
I 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:
Feb 14 2023 04:23 PM
@DismalDave only data from 2/10/23 and prior was available for me today.
Feb 14 2023 04:24 PM
Feb 14 2023 04:50 PM
Feb 14 2023 06:36 PM - edited Feb 14 2023 06:37 PM
the same issue
no data after 2-10-23
Feb 14 2023 07:22 PM
Same problem here. All spreadsheets aren't retrieving past 2-10-23.
Feb 14 2023 07:57 PM
Feb 14 2023 08:22 PM
@DismalDave I'm traveling in South America and thought maybe it was a local issue but it is not working for me either.
Feb 14 2023 09:20 PM
Feb 14 2023 10:52 PM
Feb 14 2023 11:06 PM
Feb 15 2023 01:08 AM
Feb 15 2023 03:47 AM - edited Feb 15 2023 03:48 AM
Still not working as of 6:45 am EST on Feb 15 2023 @DismalDave
Feb 15 2023 04:33 AM
Still no fix as of 7:33am EST @MarkjL
Feb 15 2023 05:50 AM
@DismalDave I'm having the same problem...who do we contract?? this is an urgent matter!!
Feb 15 2023 06:13 AM
Feb 15 2023 06:20 AM
Feb 15 2023 06:25 AM
Feb 15 2023 06:49 AM
I have the same problem, but the .Price formula still works for seeing live prices on the current day.