Rajandran R FollowFounder of Marketcalls and Co-Founder Algomojo. Full-Time Derivative Trader. Expert in Designing Trading Systems (Amibroker, Ninjatrader, Metatrader, Python, Pinescript). Trading the markets since 2006. Mentoring Traders on Trading System Designing, Market Profile, Orderflow and Trade Automation.
Simple Live Nifty Options Open Interest Monitoring Tool
13 sec read
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.
Rajandran R FollowFounder of Marketcalls and Co-Founder Algomojo. Full-Time Derivative Trader. Expert in Designing Trading Systems (Amibroker, Ninjatrader, Metatrader, Python, Pinescript). Trading the markets since 2006. Mentoring Traders on Trading System Designing, Market Profile, Orderflow and Trade Automation.
Nifty Apr Series on the hourly timeframe showed trend exhaustion and the Nifty Futures is trading with 100 pts of premium. Trading sentiment flipped...
20 Replies to “Simple Live Nifty Options Open Interest Monitoring Tool”
HAPPY BONVOYAGE SIR
What is password for you option oi software ?
Thanks.
please 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.
Sir, your previous photo was a good person sir.
WHY Live Nifty Option page is not getting loaded..???
WHY Live Nifty Option page is not getting uploaded..???
Due to changes in nseindia unable to fetch the data automatically from nseindia. Looking for alternative arrangements.
thank you bro …
wasnt working the last time
Thanks. ok.
Hi Rajandran
Can this excel be tweaked to get similar presentation for stocks which are traded in Options?
Thanks
yes it can be done
Wow! Can you please add similar Excel for SBIN, LT ? I am zero coding/programming and excel. It’d be a great help!
Thanks!
hi 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..
hi 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……………………..
HAPPY BONVOYAGE SIR
What is password for you option oi software ?
Thanks.
please 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.
Sir, your previous photo was a good person sir.
WHY Live Nifty Option page is not getting loaded..???
WHY Live Nifty Option page is not getting uploaded..???
Due to changes in nseindia unable to fetch the data automatically from nseindia. Looking for alternative arrangements.
thank you bro …
wasnt working the last time
Thanks. ok.
Hi Rajandran
Can this excel be tweaked to get similar presentation for stocks which are traded in Options?
Thanks
yes it can be done
Wow! Can you please add similar Excel for SBIN, LT ? I am zero coding/programming and excel. It’d be a great help!
Thanks!
hi 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..
hi 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……………………..
Sir its NOT Updating
Hi Shiraj,
Now the tool is ported online you can watch Live OI for Nifty options here
what is most imp tool to predict nifty movement ????
As a human being we cant use math tools to predict the market. Prediction is really tough here.
I 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 ?