Nifty options are the most popular instrument to make a lot of money in trading. Nifty futures and options have the highest turnover than any other instrument traded on the stock exchange. Nifty option traders look for open interest to make any trading decisions. So, it is very important to study nifty options open interest on a regular basis.
How to use Nifty Options open interest:
After almost 1.5 years, I am again sharing the live open interest excel sheet. Previously we were unable to get a source from which we get live open interest data. This excel sheet will show you strike price and open interest for both nifty call options and nifty put options.
This excel-based open interest tracker is a live trend finding tool, that gets you only nifty options open interest on the realtime (live) basis.
All you need to do is just download the excel sheet and follow the procedure in the file. Live open interest for nifty will auto-refresh every 5 minutes.
Using Nifty options open interest you can very accurately find the areas of support and resistance. Also if you are an experienced trader then, you can write options during the expiry week.
Download the file from here
How to work with this excel sheet?
This file will work for Nifty all expiry series and on the day of expiry, I will share next month’s file and give you an update. Here is one of the most profitable nifty options trading strategy based on open interest. Those who follow it strictly can get decent returns in the current market scenario.
Also, we would like to remind our readers, that we have started a low brokerage trading account service. All those traders who are still paying high brokerages can fill the form here and one of our staff members will guide you.
Learn to trade nifty options profitably, join our Options Trading Course and we will teach you 14 options strategy. Call us at +91-9970777789 or email us at [email protected]
About 
thanks for sharing this nifty option excel sheet. i will try this trading and contact you.
Sir, this is not updating the open interest. it shows last update of previous day.
Bhaveek i appreciate your work. Just wanted to know how much accurate is your trading strategy on nifty options using open interest.?
eagerly waiting for your reply.
pl.advise one or two multibaggers
pls update file for august month excel sheet on nifty open interest soon.
Sir, I am nifty and bank nifty options trader. I am making very small profit. kindly suggest me nifty options strategy to increase my profit. I trade intraday with capital of 20k but some times with 30 to 40k in a trade.
Hi bhavik, I wanted to learn nifty options open interest trading strategy for positional trading. also wanted to learn technical analysis with you. pls contact me on 95384xxxx2.
sir, i am beginner in stock market. i came across your website and its very informative. I wanted to know how much money i can make on daily basis if i trade in shares and also if i trade in f&o like nifty options.?
I am nifty options trader from last 2 years, but still i am making loss in stock market. kindly teach me some profitable options trading strategy in nifty. i have 50000 capital left for trading.
Bhaveek sir, this excel sheet is wonderful tool for options traders. Thanks for sharing and keep doing the good work.
Thanks,
Laxman P.
Sar, i trade nifty option and bank nifty option. but i am completely loss sar. please help me to earn profit in option strategy in nifty and bank nifty. i loss 2lac rupees in stock option in last 1 year.
Hi bhaveek, I am following your blog from almost 1 year and its been a long time you didnt update it. I am fan of your analysis, your options strategies had made me profitable trader. Eagerly waiting for your new analysis article.
Regards,
Piyush Ninave
can you share the penny stocks list? i am trading only penny stocks
where do you see nifty / banknifty moving after election result?
i have bought 9000 call and 8700 put option on nifty. kindly suggest.
can u teach nifty trading strategy for intraday trading only
I like using MarketXLS. It’s great.
Nifty options open interest is at highest ever level, so does it means support or resistance?
Can this sheet automatically refresh at a particular interval. Nifty options open interest needs to be tracked carefully so we need live tick by tick open interest.
Do you know any such provider?
i am a small trader in options, but now a days it is very difficult to make money in buying options. can you share some options strategies that works well for option writers.
Traders say buying options is less risky as loss is limited to the premium paid. For option writer the risk is unlimited and profit is limited to the premium earned while selling options.
Still in my knowledge the options writers makes more money than the options buyers.
Do we have any whatsapp group for options traders. If yes add me to that group my cell 9970xxx133
Sir, i want to trade nifty and bank nifty using 15 minutes candle with supertrend. will u please give me the formula in the excel sheet.
thanking u with regards.
Raja