Forum Discussion
Insert stock prices from web into Office excel 365
I have lost the capability to get stock prices into my Excel spreadsheet queried from the internet. Lately I was using Yahoo Finance for this but that has now been shut down. Followed a lot of rabb...
I found this somewhere else.
Hopefully it is still working, although I can't get international exchanges such as Canadian Stocks/ETFs with this formula.
=WEBSERVICE("https://api.iextrading.com/1.0/stock/" & A3 & "/quote/delayedPrice")
See the original message here: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10/ms-office-365-importing-a-stock-quote-to-a-cell/c189f863-4ba9-4cb2-8c66-151ba16be989