Forum Discussion
srr4791
Mar 16, 2023Copper Contributor
Excel Stock Data not Loading
Does anyone face issues with the Microsoft Excel Stock Prices and Data not loading on 16th March 2023?
RyzenRisn
Mar 20, 2023Copper Contributor
At 11:10 AM EST nothing is working for me. Looking at the "Last trade time" in the stock table, which is supposed to be EST, the times make no sense. They are all times in the future and hours apart for actively traded stocks. This feature is still completely broken.
Almac42
Mar 20, 2023Brass Contributor
Im in the eastern time zone -- I adjust all the times by 4 hours as they are GMT -- before the time change a week ago I adjusted all times by 5 hours
- RyzenRisnMar 20, 2023Copper ContributorOK, thanks. So if it's GMT, several stock times are correct, ~3:25PM. But several are also around 11:30PM, including AMD and ARKF (but not ARKK or ARKG).
- Almac42Mar 20, 2023Brass ContributorInteresting -- with my adjustment of 4/24 -- I get the correct EDT for AMD (on Nasdaq)
- RyzenRisnMar 20, 2023Copper ContributorBetween my last post and now, AMD has changed from 11:30PM GMT to 3:37PM GMT, which is off by 14 minutes compared to the stocks that are behaving correctly. ARKF still shows 11:37PM GMT.
- vladievMar 20, 2023Copper ContributorI confirm that AMD is also not working for me. (And I also confirm that ARKK is). Some others that I have that are NOT WORKING are:
SCHW
LMT
Are those working for anyone else? My last update is Friday March 17, 2023 for those. Does anyone else have any other stocks, etfs and/or indexes that are NOT WORKING?- tota1159Mar 20, 2023Copper ContributorStill got a few not working like NKE. Even AMD is working but not up to date. Still of 15 mins or so. Much better though. I guess the pull the info from different servers.
- tota1159Mar 20, 2023Copper Contributor
So you changed the time on your PC to be 4 hours earlier?
- Almac42Mar 20, 2023Brass ContributorNo, I adjust the cell by 4/24- so the formula is "[last trade time]-4/24"