Forum Discussion
excel 365 not updating stock prices, retreives only prior day close
Windows 11 based machine with microsoft 365, my spreadsheet worked great until yesterday, tech help had a workaround which did work yesterday, but not today. Won't retreive price, $ change and % chan...
Some of the data are updating now but some are not. As of 6:00 pm EDT, AMD is updated but ADBE is not; CLF is updating and FCX is not. It looks like we'll just have to wait. I wouldn't be surprised if MSFT wasn't playing with this service and trying to get ChatGPT involved somehow. And broke something.
I have 50 stocks. I sorted my Excel Stocks data by Symbol, copied the column and pasted it to GoogleSheets. I then used the GoogleFinance() operator to obtain quotes this evening. I then copied the data column in GoogleSheets and pasted it to my Excel table column labled Price today. I reformatted the data in the Excel column to Currency. I did not have to change any of the formulas in my Excel Table.
- Awesome, thanks for the reply!
- Looks like everything is updating correctly on my end now!
