Rajandran R FollowTelecom Engineer turned Full-time Derivative Trader. Mostly Trading Nifty, Banknifty, USDINR and High Liquid Stock Derivatives. Trading the Markets Since 2006 onwards. Using Market Profile and Orderflow for more than a decade. Designed and published 100+ open source trading systems on various trading tools. Strongly believe that market understanding and robust trading frameworks are the key to the trading success. Writing about Markets, Trading System Design, Market Sentiment, Trading Softwares & Trading Nuances since 2007 onwards. Author of Marketcalls.in and Co-Creator of Algomojo (Algorithmic Trading Platform for DIY Traders)
Nifty Open Interest Update for Oct 2011 Option Series
16 sec read
Nifty higher open interest shifts from 4900PE to 4700PE. Sell signal holds in all the time frames but still PE writers are confident of holding 4700 as a support zone.
[wp_ad_camp_5]
One thing should be noted cautiously initially put option writers build higher open interest in 4800PE later they shifted building Open interest on 4900PE and now they are building on 4700PE strike prices. which indicates that 4800PE and 4900PE are written for shorter term.
Rajandran R FollowTelecom Engineer turned Full-time Derivative Trader. Mostly Trading Nifty, Banknifty, USDINR and High Liquid Stock Derivatives. Trading the Markets Since 2006 onwards. Using Market Profile and Orderflow for more than a decade. Designed and published 100+ open source trading systems on various trading tools. Strongly believe that market understanding and robust trading frameworks are the key to the trading success. Writing about Markets, Trading System Design, Market Sentiment, Trading Softwares & Trading Nuances since 2007 onwards. Author of Marketcalls.in and Co-Creator of Algomojo (Algorithmic Trading Platform for DIY Traders)
Bank Nifty Futures - Market Profile Charts and Overheated Emotions - September Series
8 Replies to “Nifty Open Interest Update for Oct 2011 Option Series”
Hi Rajandran,
I am using google docs to import the NSE – NIfty Option Chain into google spreadsheet by using import html function. It is not returning any value or data. Pls find the following url i am trying to import.
I tried to use the =IMPORTHTML(ʺhttp://nseindia.com/marketinfo/fo/optionKeys.jsp?symbol=NIFTY&instrument=-&date=-%E2%80%9C,1ʺ,ʺtableʺ,4) command.
Please can you elaborate on this and help me out!
Hi,
You NSEindia website protects their data from parsing the data using importhtml command.
Hi Rajandran,
I am using google docs to import the NSE – NIfty Option Chain into google spreadsheet by using import html function. It is not returning any value or data. Pls find the following url i am trying to import.
http://www.nseindia.com/live_market/dynaContent/live_watch/option_chain/optionKeys.jsp?symbolCode=-10004&symbol=NIFTY&symbol=NIFTY&instrument=OPTIDX&date=-&segmentLink=17&segmentLink=17
I am able to use edit query & import data into MS spreadsheet. Can you pls let me know how to do it in google spreadsheet.
Regards,
Praveen
@Praveen
Try to Extract from this link
http://nseindia.com/marketinfo/fo/optionKeys.jsp?symbol=NIFTY&instrument=-&date=-“,1
Instead u can use editgrid to extract option data
check out the Nifty OI Tracker Edit Grid Sheet
http://www.editgrid.com/user/rajandran/Nifty_Open_Interest_Tracker
Thanks Rajendran. I will check with the link provided by you & update you on the same. Thanks once again.
Thanks rajendran..able to extract option data using your link..
http://nseindia.com/marketinfo/fo/optionKeys.jsp?symbol=NIFTY&instrument=-&date=-“,1
Praveen I was also trying to extract data in google docs but failed to do this using this link http://nseindia.com/marketinfo/fo/optionKeys.jsp?symbol=NIFTY&instrument=-&date=-“,1
I tried to use the =IMPORTHTML(ʺhttp://nseindia.com/marketinfo/fo/optionKeys.jsp?symbol=NIFTY&instrument=-&date=-%E2%80%9C,1ʺ,ʺtableʺ,4) command.
Please can you elaborate on this and help me out!
Hi,
You NSEindia website protects their data from parsing the data using importhtml command.
Hello Mr. Rajendran,
I’m unable to use the link http://nseindia.com/marketinfo/fo/optionKeys.jsp?symbol=NIFTY&instrument=-&date=-“,1 to get option data into the google spreadsheet. can you please help me with any other option.
Regards,
Bharanidharan
Try with http://optionaction.in it solves most of the option trading analysis