• Trading Account
  • Downloads
  • Nifty Options OI
    • Nifty Max Pain Chart
    • Nifty Option Change in OI Chart
    • Nifty Put Call Ratio
    • Nifty Option Total Change in OI
    • Nifty Trend Finder
  • BankNifty Option OI
  • About Us
  • Learn Technical Analysis
    • Advance Option Trading Course

OurNifty.com

A Indian Stock Market Blog

  • Forex
  • Gold
  • Intraday Stocks
  • Midcap Stocks
  • Multibagger
  • Nifty
  • Nifty Option
  • NSE
  • Amibroker

Live Nifty Options open interest in Excel sheet

By Bhaveek Patel 23 Comments

Table of Contents

    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]

    Share
    Tweet
    Pin
    0 Shares

    You Should Read This:

    1. Bank Nifty Options open interest Data Live on MS Excel Sheet 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...
    2. Live Nifty options open interest data on excel sheet for July F&O series Nifty options live open interest data excel sheet has been updated for July F&O series. Also traders use it to know the trend of Nifty future. Use the link below to download the file. Download...
    3. Nifty options Excel OI sheet for September F&O series As I am preparing and sharing the nifty options open interest excel sheet. This time I am a reason for you to smile as I have added few stocks like ICICI bank, State bank of...
    4. Nifty options open interest sheet for November expiry series Here is the link to download excel sheet to keep a track on the nifty options open interest and do analysis on it. This is how you can do the analysis using open interest data...
    5. Positional Trading with Nifty Options Live Open Interest Nifty futures has been quite volatile for almost three months now. We are just seeing a sideways move just before a new/fresh upside move. In this type of scenario we find trading in options quite...

    Category: Nifty Option Tags: Live Data/ Nifty Options/ Open Interest

    About Bhaveek Patel

    Bhaveek Patel is one of the most successful traders, technical analyst, and investor, his areas of interest include stock market, forex, and gold trading. Apart from this, he is often seen in the golf course. He is having more than 10 years of experience in trading, had placed his first order on 19 June 2006 with IndiaInfoline.

    Comments

    1. r k goenka says

      thanks for sharing this nifty option excel sheet. i will try this trading and contact you.

      Reply
    2. Prabjoth says

      Sir, this is not updating the open interest. it shows last update of previous day.

      Reply
    3. 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.

      Reply
    4. d.a.reddy says

      pl.advise one or two multibaggers

      Reply
    5. harshad says

      pls update file for august month excel sheet on nifty open interest soon.

      Reply
    6. 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.

      Reply
    7. 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.

      Reply
    8. 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.?

      Reply
    9. 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.

      Reply
    10. 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.

      Reply
    11. 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.

      Reply
    12. 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

      Reply
    13. ravi raj says

      can you share the penny stocks list? i am trading only penny stocks

      Reply
    14. 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.

      Reply
    15. dhruv says

      can u teach nifty trading strategy for intraday trading only

      Reply
    16. Harrison Delfino says

      I like using MarketXLS. It’s great.

      Reply
    17. Gambler says

      Nifty options open interest is at highest ever level, so does it means support or resistance?

      Reply
    18. 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?

      Reply
    19. 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.

      Reply
    20. 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.

      Reply
    21. Gurpreet says

      Do we have any whatsapp group for options traders. If yes add me to that group my cell 9970xxx133

      Reply
    22. 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

      Reply
    23. ashok manglanee says

      Send me index option excel sheet

      Reply

    Leave a Reply Cancel reply

    Your email address will not be published. Required fields are marked *

    Previous Post: Nifty Options trading strategy for Budget Session
    Next Post: Positional Trading with Nifty Options Live Open Interest

    Advance Options Trading Course

    options trading course

    Lowest Brokerage Trading A/c

    Lowest brokerage trading account opening in India

    Learn Technical Analysis

    technical analysis course

    Recent Articles

    • ASX Penny Stocks List for 2025
    • 7 Ways to Boost Your Revenue
    • NYSE Penny Stocks List for 2025
    • Short On Cash? Here’s How You Can Manage Your Priority Spends
    • FREE Webinar on Option Chain Analysis
    • LSE Penny stocks list for trading in 2025 Should you buy?
    • BSE Penny Stocks List 2025

    Popular Categories

    Amibroker Finance Forex Gold Intraday Stocks IPO Midcap Stocks Multibagger NEWS Nifty Nifty Option NSE Results Short Term Stocks Technical Analysis

    About Us | Contact Us | Privacy Policy | Disclaimer


    Copyright © 2009 - 2025 OurNifty.com Trading ideas published here cannot be reproduced without permission from the author.
    OurNifty is Powered by Wordpress and hosted on Digital Ocean