Here is a simple Excel tool to monitor the Live Nifty Options Open Interest. Apart from Monitoring the Open Interest of Puts and Calls you can also monitor the change in Open Interest for both puts and callls across the strike prices for that day. Tested in Excel 2007 & Excel 2010.
Download Live Nifty Options – Open Interest Chart
Related Readings and Observations
Highest Open Interest in Stock Options Visualized Highest Open Interest among option strike price is the widely used terminology to identify where most of the liquidity flow happens i.e where more of the writers and buyers willing to hang […]
Interpreting Options Price and Open Interest Relationship We know that Open Interest is nothing but the total number of outstanding contracts. And for Options we have Open Interest for every individual strike price. It is a myth that 90% of the […]
Nifty Futures September 2016 Overview Nifty Futures currently trading in a broader consolidation range for the entire august month and the September series contract is still trading in the broader range between 8575-8800. […]
Reasons Why Nifty Will test 8217 before this expiry After 6 consecutive losses nifty spot made an attempt to close positive marginally. Nifty Daily sentiment turned positive at open and maintained the positivism throughout the session. […]
Nifty and Bank Nifty Futures – Daily Sentiment Update Nifty and Bank Nifty Daily Sentiment oscillators are holding positive and currently. Minor Resistance zone coming around 7870 and 16800 respectively. Breakout is likely to be on the upper […]
Nifty and Bank Nifty Futures September Series Outlook Nifty and Bank Nifty weekly future charts suggests the RSX is still in declining mode and at the extreme. Current downtrend is expected to end this week before bottoming out. Support is […]
sureshkumar.d says
October 7, 2012 at 5:20 pmHAPPY BONVOYAGE SIR
sharadha says
October 7, 2012 at 7:55 pmWhat is password for you option oi software ?
Sandeep says
October 8, 2012 at 7:32 pmThanks.
TAM says
October 12, 2012 at 9:55 amplease do provide the backtested results
as per
how many times it hit T2 or T1 etc after giving arrow signal
in each month / intra day / btst / week.
in livesignals chart
of nifty, banknifty, sbin, lt, tamo.
senthil says
October 19, 2012 at 2:25 pmSir, your previous photo was a good person sir.
DD says
October 22, 2012 at 6:13 pmWHY Live Nifty Option page is not getting loaded..???
DD says
October 22, 2012 at 6:13 pmWHY Live Nifty Option page is not getting uploaded..???
Rajandran R says
October 23, 2012 at 4:22 amDue to changes in nseindia unable to fetch the data automatically from nseindia. Looking for alternative arrangements.
deman says
October 30, 2012 at 12:58 pmthank you bro …
wasnt working the last time
DD says
October 30, 2012 at 10:33 pmThanks. ok.
Nikhil says
December 20, 2012 at 1:40 pmHi Rajandran
Can this excel be tweaked to get similar presentation for stocks which are traded in Options?
Thanks
Rajandran R says
December 21, 2012 at 12:14 pmyes it can be done
Nikhil says
December 21, 2012 at 12:27 pmWow! Can you please add similar Excel for SBIN, LT ? I am zero coding/programming and excel. It’d be a great help!
Thanks!
Apoorva says
February 6, 2013 at 3:11 pmhi Rajandran
its really nice work on excel if you could provide me the password for protected sheet input2 then i think i could make such excel for other Index option too like banknifty and so liquid stock option.. I would appreciate.. it you can share that..
kalpesh says
March 12, 2013 at 9:40 pmhi raj,,,,,,,,,,
its kalpesh from mumbai, nallasopara……
m want to know how could we get such an access about live stock future open interest as we have this nifty live open interest………………
plz favour for this……………………..
Shiraj says
November 2, 2013 at 5:18 amSir its NOT Updating
Rajandran R says
November 3, 2013 at 12:25 pmHi Shiraj,
Now the tool is ported online you can watch Live OI for Nifty options here
sunil says
November 18, 2013 at 11:40 pmwhat is most imp tool to predict nifty movement ????
Rajandran R says
November 19, 2013 at 12:22 amAs a human being we cant use math tools to predict the market. Prediction is really tough here.
Rohit says
August 24, 2015 at 5:25 pmI have modified connection query string to get the data for option stocks but some how it is not working, what other changes I need to do ?