Insert stock prices from web into Office excel 365

[Levi Nigg]

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 rabbits around the web but nothing addresses my question except an add-in program called "Stock Connector".  It only works for stocks and not stock funds.

I would rather not add something into Excel in Office 365 for this purpose for fear that it is not from a trustworthy source.

Does anyone have a solution?

Thanks!

[#2]

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