Fetch Data Table to Excel

[whity]

Hi All,

I am trying to fetch the table as available in the link https://www.nseindia.com/option-chain. I tried using the pull data from Web option in excel but somehow, it is not able to get this table. Can anyone please advise or give me a tip on how to start with this?

 

[Marc L]

Hi,​

​

samples exists here like in many places whatever on the Web​

but instead why don't you just follow the easy way with the 'Download (.csv)' button from your link ?​

​

 

[whity]

Idea is to have this loaded to excel automatically every 5 mins or so. Web importing method of this table to excel is not working, for some reason.

 

[Marc L]

The reason may be obvious : some websites are not compliant with standard html basics features​

in order to not being webscraped too easily …​

​

 

[Marc L]

I tried using the pull data from Web option in excel but somehow, it is not able to get this table

Did you give a chance to other Excel features like the Web Services or Power Query ?​

​

 

[whity]

There is a way to use power query but it requires you to get the cookie value from the site and feed to it every time, which doesnt really work for me.

 

[Marc L]

So in this case the way to go is to pilot MS IE under VBA …​

​