Rajandran R Founder 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.

Download Live Nifty Options – Open Interest Chart

Rajandran R Founder 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.

Short Covering from an Extreme Short Term Inventory –…

Nifty trading inventory goes short to too short as on last Monday trading session followed by a short-covering rally and this inventory adjustment process...
Rajandran R
22 sec read

State of the Market – 20th June 2022

It's Monday morning and SGX Nifty is trading sub 15300 levels and a little bit of nervousness in the markets as the last Thursday's...
Rajandran R
1 min read

Nifty Hourly Exhaustion and Trading Inventory getting short to…

Nifty Futures on Monday's trading session opened a gap down and started trading inline with the global sentiment. However, in the second half of...
Rajandran R
19 sec read

20 Replies to “Simple Live Nifty Options Open Interest Monitoring Tool”

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

  2. Hi Rajandran

    Can this excel be tweaked to get similar presentation for stocks which are traded in Options?

    Thanks

  3. Wow! Can you please add similar Excel for SBIN, LT ? I am zero coding/programming and excel. It’d be a great help!

    Thanks!

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

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

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

Leave a Reply

Get Notifications, Alerts on Market Updates, Trading Tools, Automation & More