Live stock prices

**bananacitizen** · 07-12-2018, 04:13 AM

Hi,
Is there anyway I can update live stock prices automatically in excel. I have look into few YouTube videos but they dont seem that clear. Apparently Yahoo Finance doesn't support their API for this as well.

**AliGW** · 07-12-2018, 04:15 AM

Whose API? Which site? More specific detail, please!

PowerQuery has live web options, so you might wish to look into that.

**bananacitizen** · 07-12-2018, 04:33 AM

Mainly EUROPEAN EXCHANGES and US. Thanks I will look into Powerquery. I meant Yahoo Finance report daily share prices on most of the main exchanges worldwide and they apparently had an API for excel before. Now they have stopped it.

**AliGW** · 07-12-2018, 04:35 AM

Thanks for the clarification. A web link to the site you wish to scrape from might help, though!

**bananacitizen** · 07-12-2018, 05:18 AM

https://uk.finance.yahoo.com/

**AliGW** · 07-12-2018, 05:29 AM

OK, and how do you want it to appear in Excel? Can you provide a manually mocked-up workbook for helpers to use?

**bananacitizen** · 07-12-2018, 05:54 AM

See the excel sheet attached show the live stock prices for four stocks in London Stock Exchange(manually updated now). These prices getting updated all day between 8.00am-17.00 hrs. So without manually typing
can someone propose a reliable method to extract these updated prices from any financial website and update on excel