Forum Discussion
Stockhistory function appears to no longer be updating past Feb 10 2023
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.
85 Replies
- Mike19822180Copper Contributor
DismalDave you are not the only one I have seen posts from 2020 and 2023, I have the same problem as of 12/1/2023. I wish Microsoft once for all fix these updating issues we are having. Why does it all of a sudden just stop updating? nothing has changed with my settings. Just real frustrating. you mean to tell me they can be on the forefront of Generative AI but can't get the data to refresh?
- FSBassettCopper Contributor
I am having the same problem. It is delayed in giving me the true last day's closing price. I'm getting the price of the stock two days ago when I use TODAY() as my end date input. And it's inconsistently updating several stocks I have in the same worksheet. Some stocks will show a last close date of two days ago and some will be a different date. This is very frustrating. WHY CAN'T MICROSOFT JUST FIX THIS ALREADY!?
I should note that the tickers I'm looking at are all for mutual funds, not individual stocks.
- Yen_LimauCopper ContributorIs there a Microsoft channel that we can collectively provide feedback to?
- DismalDave2ndtimeCopper ContributorThis is all I have found. I have an account through the college I teach for. When I go to leave 'feedback' in Excel it says to talk to the site admin. So, I can't even do that.
By making the heading of this something that the google would pick up on and that hopefully would get enough views to become obnoxious I was hopeful that MSFT would look at it. I excel in obnoxious.
- PFNikolaiCopper ContributorDismalDave I seem to have access to the data again. Sample of five ticker symbols as of 3/8/23 9:27AM CT: Data for UPRO, TQQQ, URTY, FNGU, and BULZ for 3/7/23 was pulled successfully.
- PFNikolaiCopper Contributor
DismalDave Down again. Sample of five ticker symbols as of 3/7/23 7:59AM CT: Data for UPRO, TQQQ, URTY, FNGU, and BULZ for 3/6/23 is missing. I'll start bugging the data provider @Refinitiv on Twitter at https://twitter.com/Refinitiv
- Andrew1625Copper ContributorI'm shorting DHT and NAT and long SIRI above 4. These are the stocks I tried this AM with no luck!
- DismalDave2ndtimeCopper ContributorMine is back up as of 9AM Pacific 3/7/23
- Yen_LimauCopper Contributor
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.
- DismalDave2ndtimeCopper Contributor
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.
- Yen_LimauCopper Contributor
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 😞
- PFNikolaiCopper ContributorThanks for raising this issue. Hopefully our squeaking helped spur the fix!
- MarkjLCopper ContributorAs of Feb 16 2023 11:30 EST while most of my Stock lookup is now working the symbol “SPY” is NOT - it is a Charles Schwab fund that continues to correctly work pre 2/11 but not now.
- erdem71Copper Contributor
- smarzottoCopper Contributor
It seems to be working for some assets but not all.
Randomness is not acceptable. What is your experience lately?
- PFNikolaiCopper Contributor
Sample of five ticker symbols as of 2/16/23: Data for UPRO, TQQQ, and URTY is still missing. Data for FNGU and BULZ data for 2/15/23 seems to be available. The data provider is Refinitiv and they are at @Refinitiv on Twitter at https://twitter.com/Refinitiv
- CA_Monil_ShahCopper Contributor
Still facing the same issue.
16/02/2013 12:35
India
Microsoft need to solve this issue soon.
- HnorajrCopper ContributorThe problem was fixed. Close and Open your spreadsheet and it gonna be updated