Getting live datas from webpage to Excel Sheet

4 posts · originally from https://geek.digit.in/community/threads/getting-live-datas-from-webpage-to-excel-sheet.49906/

I just want to know whether is it possible to get live data from a webpage to excel sheet i.e.,

*img294.imageshack.us/img294/6638/icicidh5.jpg
*content.icicidirect.com/research/topsearchquotes.asp?icicicode=icici&category=corporate

This is the live quotes page from ICICI direct. And the stock name is ICICI.

I want to get only that marked figure i.e. 61.25 to excel sheet.

Is it possible to get it???

Thanks in advance...

Data --> Get External Data --> Paste URL --> Select Table --> Select update Interval.

^^^thank u man...

If we do this the entire table is selected.... I just want that particular data...

Is it possible to do so???

you need to get the entire data on one sheet and then link it to the desired cell on your main sheet.