Want to Get Live data

[chssundeep]

Hi Excel Lovers,

I need a get the live updates of stocks in excel from nse website i.e. www.nseindia.com

Could you please help me...

Thanks in advance

 

[Luke M]

Go to Data, Get External Data group, select "From Web". Punch in website of where you want to go, select table(s) where data is, ok out. Refresh as often as needed.

 

[chssundeep]

Dear Luke thank you very much for the reply....

I tried to do the procedure you have told me but I missed some where....I could not get it

I want the table from the following link

http://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm

But when I selected the table in settings I selected as FULL HTML FORMATTING it ends up saying "NO DATA"...

Could you please help me

 

[Luke M]

Hmm. Looks like the website isn't built to actually give a table meant for exporting, but is individual fields. Makes it so that XL can't recognize the data we want.

While searching around, I did find this article:
http://www.stockrants.com/2011/10/20/how-to-build-a-stock-watch-list.html

which might offer some alternatives. Talks about Google's tools for a bit, but then lists XL at the end. Perhaps that will be more promising?