Forum Discussion

Levi Nigg's avatar
Levi Nigg
Copper Contributor
Jan 23, 2018

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

office 365

1 Reply

Sort By
  • Mark Allen's avatar
    Mark Allen
    Copper Contributor
    Sep 26, 2018

    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

     

     

Resources