SOLVED

Live data updates from web to excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1936595%22%20slang%3D%22en-US%22%3ELive%20data%20updates%20from%20web%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1936595%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20how%20to%20get%20live%20data%20from%20the%20web%20to%20excel%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1936595%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1936637%22%20slang%3D%22en-US%22%3ERe%3A%20Live%20data%20updates%20from%20web%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1936637%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F883761%22%20target%3D%22_blank%22%3E%40HemangShah74%3C%2FA%3E%26nbsp%3BPerhaps%20Power%20Query%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1936657%22%20slang%3D%22en-US%22%3ERe%3A%20Live%20data%20updates%20from%20web%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1936657%22%20slang%3D%22en-US%22%3EFrom%20the%20Data%20menu%20--%26gt%3B%20from%20Get%20External%20Data%20--%26gt%3B%20click%20From%20Web%3CBR%20%2F%3EIn%20New%20Web%20Query%20windows%20enter%20the%20URL%20address%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1936665%22%20slang%3D%22en-US%22%3ERe%3A%20Live%20data%20updates%20from%20web%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1936665%22%20slang%3D%22en-US%22%3EI%20wish%20to%20analyze%20live%20updates%20from%20the%20finance%20site.%20which%20can%20be%20refresh%20automatically%20on%20period%20set.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1936678%22%20slang%3D%22en-US%22%3ERe%3A%20Live%20data%20updates%20from%20web%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1936678%22%20slang%3D%22en-US%22%3Ethank%20you%2C%20dear%2C%20but%20it's%20not%20working.%3C%2FLINGO-BODY%3E
Occasional Contributor

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

13 Replies

@HemangShah74 Perhaps Power Query?

From the Data menu --> from Get External Data --> click From Web
In New Web Query windows enter the URL address
I wish to analyze live updates from the finance site. which can be refresh automatically on period set.
thank you, dear, but it's not working.

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

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


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

 

 

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

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

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

Best Response confirmed by HemangShah74 (Occasional Contributor)
Solution
Nope. Please guide me.
It's only for office 2010 and 2013. Anyway thanks for your replies.