@chinmay_23 look,first fetch the FULL mode data of the instrument which option chain you want. then extract the oi,vol,ltp(premium),ask bid etc. from the retrieved data. then transfer it to excel. for coi,you can just use the current oi-last day's oi. This is what i know.
Thank You @SRIJAN for your insight. I found this article regarding the calculation of IV. Can you tell me how to get the spot price of indices(Nifty 50) using 'kite.ltp()' or anything else.
https://kevinpmooney.blogspot.com/2017/07/calculating-implied-volatility-from.html