Dear All,
I was just wondering the calculation of the “change in Open Interest”. How this can be done in excel . If anybody know just tell me k.
Thank you all for your valuable time,
Regards,
Sonjoe Joseph
Hey @SonjoeJoseph
You can alternatively get this info by opening the Sensibull option chain on Kite.
Check out this video on how to use the option chain -
This is not answer to my question ok. I just want to do my own calculation with regard to the “Change in Open Interest” in Excel. I don’t use Sensibull at all since its not so useful for me.
https://www.nseindia.com/products/content/derivatives/equities/archieve_fo.htm
from this link you can get Bhav copy of everyday session after 6.15pm , here you can get the OI data of your stock then you can do your math.
I have not asked about Open Interest…Just asked the calculation of the “change in open interest”. The above link u provided i have already read a few years back.
Did you get that guys, this is not what he is looking for. Try to put some more efforts and then come back with perfect answer😉
“change in open interest” = Today OI - Yesterday OI
In % terms = ((Today OI - Yesterday OI)/(Yesterday OI)) x 100
I dont know excel.
2 Likes
Ok friend but still a doubt. In the Nest trading terminal there is Total Open Interest, Open Interest & Prev Oi. So according to the formula it will be “Open Interest - Prev OI” or should i take “Total Open Interest - Prev OI”.
Just clarify ok
Anyway u have come with an apt answer.
I dont know NEST, so I cant be accurate but most probably it is
Total = full day cumulative OI probably, I dont know.
Can anybody kindly confirm on the above calculation.
the calculation of ‘p699’ is correct.
Thank You very much Yuvraj.
Hi,
Did you got any answer on your question of calculate of change in oi easy way
You only need a simple subtraction.
If column A has the date and column B has open interest, then create a new column for “Change.”
In that column use: =B2-B1
That will give you the difference between the current day and the previous day.