Forum Discussion

Copper Contributor

Nov 27, 2020

Solved

Live data updates from web to excel

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

HemangShah74
Nov 27, 2020
Nope. Please guide me.

Copper Contributor

Nov 27, 2020

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

Riny_van_Eekelen

Platinum Contributor

Nov 27, 2020

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

HemangShah74
Copper Contributor
Nov 27, 2020
https://www1.nseindia.com/live_market/dynaContent/live_watch/option_chain/optionKeys.jsp?symbolCode=-10000&symbol=NIFTY&symbol=NIFTY&instrument=-&date=-&segmentLink=17&symbolCount=2&segmentLink=17
- Riny_van_Eekelen
  Platinum Contributor
  Nov 27, 2020
  HemangShah74 Just saw your post with the extended link to a page with a large table. Are you familiar with Power Query?
  - HemangShah74
    Copper Contributor
    Nov 27, 2020
    It's only for office 2010 and 2013. Anyway thanks for your replies.
HemangShah74
Copper Contributor
Nov 27, 2020
Hello Riny, I use windows and the finance site is http://www.nseindia.com
- Riny_van_Eekelen
  Platinum Contributor
  Nov 27, 2020
  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.
  - HemangShah74
    Copper Contributor
    Nov 27, 2020
    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=-10000&symbol=NIFTY&symbol=NIFTY&instrument=-&date=-&segmentLink=17&symbolCount=2&segmentLink=17

Resources