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