Query url for Banknifty Option is: https://www.nse-india.com/live_market/dynaContent/live_watch/option_chain/optionKeys.jsp?segmentLink=17&instrument=OPTIDX&symbol=BANKNIFTY&date=5JAN2017
is there a space in the query URL for options?
That might be breaking the link.
Bcos the spot is correct, that means the Future page is downloaded correctly.
is there a space in the query URL for options?
That might be breaking the link.
Bcos the spot is correct, that means the Future page is downloaded correctly.
I have a different kind of issue .. i am not able to see any values in the cells other than the futures .. The values for options were updating till last week. suddenly it stopped displaying values in the cells ...
is there a space in the query URL for options?
That might be breaking the link.
Bcos the spot is correct, that means the Future page is downloaded correctly.
Somehow the sheet is broken for Nifty_OAT.xslm. Even updating the query produces blank. Its unable to import the query into the sheet for some reason. Anyone else face the issue? Have pointed the table to correct query for Jan Expiry. But the Option data is just bot being picked
OAT files should work for everyone, just need to update the NO or BNO URL under data > connections > NIFTY OPTION > properties > Definition tab
EDIT QUERY
Page loads in browser, select desired month and click import.