Need help with EOD options prices

#1
Hi Seniors,
is there any way to get combined closing options prices for ALL stocks being traded in F&O segment? To get data from NSE site, you have to individually select stocks, then expiry and then option type. Doing this for all 190 stocks is too time consuming. Can we automate it in some way? I want to get this data in single file, preferably excel and closing prices only. Please help.
 

Similar threads