Insert stock prices from web into Office excel 365

%3CLINGO-SUB%20id%3D%22lingo-sub-147619%22%20slang%3D%22en-US%22%3EInsert%20stock%20prices%20from%20web%20into%20Office%20excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-147619%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20lost%20the%20capability%20to%20get%20stock%20prices%20into%20my%20Excel%20spreadsheet%20queried%20from%20the%20internet.%26nbsp%3B%20Lately%20I%20was%20using%20Yahoo%20Finance%20for%20this%20but%20that%20has%20now%20been%20shut%20down.%26nbsp%3B%20Followed%20a%20lot%20of%20rabbits%20around%20the%20web%20but%20nothing%20addresses%20my%20question%20except%20an%20add-in%20program%20called%20%22Stock%20Connector%22.%26nbsp%3B%20It%20only%20works%20for%20stocks%20and%20not%20stock%20funds.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20would%20rather%20not%20add%20something%20into%20Excel%20in%20Office%20365%20for%20this%20purpose%20for%20fear%20that%20it%20is%20not%20from%20a%20trustworthy%20source.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDoes%20anyone%20have%20a%20solution%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-147619%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-262877%22%20slang%3D%22en-US%22%3ERe%3A%20Insert%20stock%20prices%20from%20web%20into%20Office%20excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-262877%22%20slang%3D%22en-US%22%3E%3CP%3EI%20found%20this%20somewhere%20else.%3C%2FP%3E%3CP%3EHopefully%20it%20is%20still%20working%2C%20although%20I%20can't%20get%20international%20exchanges%20such%20as%20Canadian%20Stocks%2FETFs%20with%20this%20formula.%3C%2FP%3E%3CP%3E%3DWEBSERVICE(%22%3CA%20href%3D%22https%3A%2F%2Fapi.iextrading.com%2F1.0%2Fstock%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fapi.iextrading.com%2F1.0%2Fstock%2F%3C%2FA%3E%22%20%26amp%3B%20A3%20%26amp%3B%20%22%2Fquote%2FdelayedPrice%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20the%20original%20message%20here%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fmsoffice_excel-mso_win10%2Fms-office-365-importing-a-stock-quote-to-a-cell%2Fc189f863-4ba9-4cb2-8c66-151ba16be989%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fmsoffice_excel-mso_win10%2Fms-office-365-importing-a-stock-quote-to-a-cell%2Fc189f863-4ba9-4cb2-8c66-151ba16be989%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Visitor

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!

1 Reply
Highlighted

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