Live data updates from web to excel

[HemangShah74]

Hi, how to get live data from the web to excel? 

[#2]

@HemangShah74 Perhaps Power Query?

[#3]

From the Data menu --> from Get External Data --> click From Web
In New Web Query windows enter the URL address

[#4]

I wish to analyze live updates from the finance site. which can be refresh automatically on period set.

[#5]

thank you, dear, but it's not working.

[#6]

@HemangShah74 "the finance site". Which one? What Excel version are you on? Windows, Mac?

[#7]

Hello Riny, I use windows and the finance site is www.nseindia.com

[#8]

https://www1.nseindia.com/live_market/dynaContent/live_watch/option_chain/optionKeys.jsp?symbolCode=...

[#9]

would you please give more details,:

What is version of Excel you use?
Is the live data public can you send the URL, or from certain online database

[#10]

@HemangShah74 You need to be more specific. Which data you want to connect to? Power Query might definitely be your way out here, but perhaps not.

[#11]

Hey Riny, Sorry for the same. I am using Windows 7 and the link is as under.
https://www1.nseindia.com/live_market/dynaContent/live_watch/option_chain/optionKeys.jsp?symbolCode=...

[#12]

@HemangShah74 Just saw your post with the extended link to a page with a large table. Are you familiar with Power Query?

[#13 · Accepted solution]

Nope. Please guide me.

[#14]

It's only for office 2010 and 2013. Anyway thanks for your replies.