Forum Discussion
Stockhistory function appears to no longer be updating past Feb 10 2023
It's working for me.
It's 7:23 PM Pacific time for me. I find that it doesn't start working until after about 6:30 PM my time. I know it says it's supposed to work at different times. I've never seen it work until the market has been closed for a while. Specifically after 6:30 PM Pacific.
It sure would be convenient to get it closer to market closing time. But it's way better than what I was doing before.
Thanks. Yes, I noticed it worked around 11pm ET (8pm PT). Pity that it isn't "live", like the Data-Stocks function in Excel 365.
I use it to lock in end-of-month prices, and also to see current prices in the middle of the month. Unfortunately, STOCKHISTORY doesn't work very well to retrieve the current price 😞
Hey everyone,
It seems Microsoft Stockhistory is acting up again...does anyone get this popup message when refreshing their worksheet?
Your assistance will be of great help...
MoxiG
- No issue on my side... only that the price were from two days ago Mar 5, rather than Mar 6 (which we noted above could be due to Stockhistory only updating after 8pm PST).
I wondered if your issue is due to foreign exchange tickers (eg the JSE). But I tried using your XJSE tickers and it worked for me.
Pity that Stockhistory is a bit unstable. But Google Drive Sheet's equivalent "=Googlefinance" also blows up from time to time on foreign tickers. Could be issues with connections with Refinitiv.- It is 9:30 PM Pacific time here and I am not getting today's numbers. It usually has shown up 3 hours ago.
I am not getting a popup. I'm not getting anything.
Not again!
No Mr Bill!! (US SNL reference there)