NIFTY Options Trading by RAJ

[Raj232]

Below is the screenshot:After editing and refresh

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

Thanks !

 

[travi]

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.

 

[Raj232]

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 it has started working now. Thanks for the help !! :thumb::thumb::thumb:

 

[rakerocks]

HI..

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 ...

 

[Option.Trader]

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

 

[Option.Trader]

Which file are you referring to ?

Nifty_OAT.xslm... i think some issues with import of data.. has NSE changed the format? or is it the year change that is causing issues? Any idea?

 

[travi]

Nifty_OAT.xslm... i think some issues with import of data.. has NSE changed the format? or is it the year change that is causing issues? Any idea?

You need to update the URL for FnO.

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.

 

[Option.Trader]

You need to update the URL for FnO.

Please see the screenshot below. I have updated the URL with the following, still it is returning blanks

https://www.nse-india.com/live_mark...instrument=OPTIDX&symbol=NIFTY&date=25JAN2017

http://imgur.com/dO1tIkX

 

[travi]

Please see the screenshot below. I have updated the URL with the following, still it is returning blanks

https://www.nse-india.com/live_mark...instrument=OPTIDX&symbol=NIFTY&date=25JAN2017

http://imgur.com/dO1tIkX

Use this URL for NSE website
https://www.nseindia.com/live_marke...instrument=OPTIDX&symbol=NIFTY&date=25JAN2017

 

[san_ic]

Hi travi, changed the links for both Nifty and Banknifty OAT's and both return blank values. Please help