Forum Discussion
Stockhistory function appears to no longer be updating past Feb 10 2023
DismalDave Hello, is STOCKHISTORY able to give the current day's close?
Eg using this formula STOCKHISTORY("MSFT",TODAY()-7,TODAY()), I only get data up to Mar-2, even though Mar-3 market has closed. Is STOCKHISTORY acting up again, or am I not using the function correctly? Thanks.
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.