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 b...
Live Stock is only on Excel 365 now. There's actually a ~15-minute delay, so not truly "live". It's easy to use, doesn't need any coding, and can pull out all sorts of info, e.g. Beta, P/E, shares outstanding, price etc. It's also very stable, except past couple of days.
But we can't use to to get prices at a specific date (which Stockhistory does)... which is a shame because if we want to lock in a close price for the month, e.g. for your month-end column, we're out of luck. Stockhistory is great for this... if only it is more stable!
But we can't use to to get prices at a specific date (which Stockhistory does)... which is a shame because if we want to lock in a close price for the month, e.g. for your month-end column, we're out of luck. Stockhistory is great for this... if only it is more stable!
STOCKHISTORY doing the thing again. Updates for BTCUSD and ETHUSD stopped as of 10/19/23. I contacted Microsoft support and was told to do an Office 365 repair. I did (didn't work obviously) and asked if there was a backend data issue (because they happen frequently) and was basically told to buzz off, do my app repair, and be happy with whatever the outcome. Looks like I'm just going to have to bite the bullet and figure out my own pricing database to populate via Python and Yahoo Finance. STOCKHISTORY could be so great, but it simply isn't stable.
