Forum Discussion

Copper Contributor

Mar 17, 2023

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...

excel

Stu_Becker

Copper Contributor

Mar 17, 2023

5CupsOfCoffee

I am an Office 365 user on a Mac. Started experiencing sporadic freezes on 3/16/23. Spoke with Microsoft Tech Department yesterday morning for nearly one hour. Apparently not on their radar at that time. This morning had no activity with stock price capability. Called Tech Dept. again today and was advised they were aware of the problem and would provide me information by email to receive their update notifications. Unfortunately, I haven't received the email at this writing. It was described to me as a system wide problem with this service. If anyone has the link to receiving notifications, kindly advise.

Thank you.

Bluestone810

Copper Contributor

Mar 17, 2023

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.

jeffreytoo
Copper Contributor
Mar 18, 2023
Bluestone810
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.
- 5CupsOfCoffee
  Copper Contributor
  Mar 18, 2023
  Awesome, thanks for the reply!
  - chalnew
    Copper Contributor
    Mar 18, 2023
    Looks like everything is updating correctly on my end now!