On getting huge success in Nifty options live open interest data, I have started to test data for banknifty options in Microsoft Excel sheet. After editing and testing today I got all things working fine on my test machine, as in case of nifty options same excel sheet has been used and it will make query to nse servers for live option OI data. See live bank nifty call put options open interest on chart for free.
Use this link to download.
After the download follow these steps to update data:
- Open Excel sheet from Bank-Nifty-Options-Live-OI.zip
- Now press Alt+Ctrl+F5 to update the data.
- It will show Security Warning (Don’t worry), Just press OK.
- Data will be updated from NSE servers instantly.
- Repeate above steps every time you wish to update data.
Share your views on this as I have spend few hours on this little piece of indicator. There is an opportunity for beginner traders to learn technical analysis online trade different types of strategies in market, become independent trader. Call +91-9970777789 to know more about course.
If you like this application then share it with your friends and relative on Facebook and Twitter. You can also reach me directly by commenting below:
About 
thanks for this great update Bhaveek, its really helpful in tracking real time OI data.
Thanks Anand, I would like to know if you are interested in tracking options OI for stocks. Then do share the stocks name if they have enough liquidity in options segment.
Obliged if I get OI change LIVE chart for INDUSIND, Bank Nifty & NIFTY
dear sir,
pls share this updated exel sheet with me pls pls
ok, as of now I am tracking Nifty & BankNifty OI data only. If interested in any stock, will surely let you know.
Thanks
Anand, Thanks for your active participation in open interest data. I will keep on publishing new trading strategies based on OI, support/resistance, volume and trend. 🙂
when i wil get august series nifty and bank nifty future oi excel sheet
Hi Ani, I will be posting options open interest excel sheet for August series on Monday once the testing is done. Stay in touch and keep visiting.
patel sir ………thanks a lot for proviiding excel for beginner to understand oi in simple way with ur detailed explanation. if possible arrange stocks in nifty50 more turnover stocks like sbi, infy,L&T etc. . Whether we must download excel every month for new series?
Good suggestion Ani, I will definitely work on this and most probably we will see top 10 stocks in F&O with high liquid options. I will publish those excel sheet once I am done with it.
Regards,
Bhaveek Patel
Thanks a lot for ur hard work. august nf and bnf excel sheet for oi?
I will share nifty and bank nifty oi excel sheet in this week itself.
Hi
Please let me know if the Excel with stock is ready
S
nifty option open interest tracker doesn’t work.it is not refreshing open interest value fro nse server.msg shows > request could not found (http/1.0404)
how to solve the problem pls suggest..
pls update new excel format its not working now so..
I opened sheet for BN & Nifty but its not updating. I am using office 365
Bank nifty options are now getting more and more liquid. Open interest analysis on nifty works great for nifty options. but i am yet to do trading in bank nifty options.
Dear Bhaweek pl respond on . Need BNF and NF option sheet.
thanks
Shriprakash
Can you advice on below as i was making query excel, but not able to make can you advice me how to modify link
https://www1.nseindia.com/live_market/dynaContent/live_watch/option_chain/optionKeys.jsp?segmentLink=17&instrument=OPTSTK&symbol=FEDERALBNK&date=28JAN2021
I WANT ALL INDICES OI,IV, MOST ACTIVE CALL PUTS EXEL SHEET