How to download this data in one excel file but in multiple sheets ?

[papertrader]

I am trying to pull Historical data for derivatives into excel and keep running into a wall.


https://www.nseindia.com/products/content/derivatives/equities/historical_fo.htm


This is the link from where I wish to download the data into excel. I can pull the CSV file individually from the website for each scrip that I need.


An example will be -


Select Instrument : Stock Futures Select Symbol : ACC Select Year : 2019 Select Expiry: 29-8-2019 Select Option Type: Select Option Type Enter Strike Price: For past: 24 Months


A table will be generate along with a link for a CSV file. But that will be the individual file for one scrip (ACC, in this case). These are the parameters that I wish to download for each scrip. I have a list of 150 scrips. It is not optimum to download 150 files daily and copy pasting them into one file on different sheets.


I have tried "inspecting" the table on the website to find a URL which I can feed into the query. However, that does not work.


The parameters would remain nearly the same (except for the Symbol Name and Expiry). Expiry would change only once we move into the next month's series.


I am interested in knowing if there is a way to automate this whereby I could link excel query to refresh the report for ALL scrips in derivatives segment each day. I have in mind one sheet per Symbol Name. So, each sheet will have a link for that Symbol which will pull the report afresh each day.


Is there any way of achieving this ?


My apologies if this is not the right place to post this. Am new to this and would request your indulgence.


Thanks for taking the time to read. Do let me know if I have not made myself clear. Any help from you guys would be greatly appreciated. Thanks again.