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]
r k goenka says
thanks for sharing this nifty option excel sheet. i will try this trading and contact you.
Prabjoth says
Sir, this is not updating the open interest. it shows last update of previous day.
vinay says
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.
d.a.reddy says
pl.advise one or two multibaggers
harshad says
pls update file for august month excel sheet on nifty open interest soon.
gvl reddy says
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.
Madhav says
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.
aarti shelke says
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.?
pushkar singh says
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.
laxman purohit says
Bhaveek sir, this excel sheet is wonderful tool for options traders. Thanks for sharing and keep doing the good work.
Thanks,
Laxman P.
karthik says
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.
Piyush Ninave says
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
ravi raj says
can you share the penny stocks list? i am trading only penny stocks
Laxman says
where do you see nifty / banknifty moving after election result?
i have bought 9000 call and 8700 put option on nifty. kindly suggest.
dhruv says
can u teach nifty trading strategy for intraday trading only
Harrison Delfino says
I like using MarketXLS. It’s great.
Gambler says
Nifty options open interest is at highest ever level, so does it means support or resistance?
Vinay says
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?
ajinkya says
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.
Vikky kote says
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.
Gurpreet says
Do we have any whatsapp group for options traders. If yes add me to that group my cell 9970xxx133
Raja Bhat says
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
ashok manglanee says
Send me index option excel sheet