• 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 21 Comments

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. 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...
  2. 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...
  3. 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...
  4. [Update] Nifty options Open Interest in MS Excel Sheet Beginning of this June F&O series, nifty options open interest application on excel was displaying data in incorrect way. So I have gone through the issue and have updated the data selection for OI graph....
  5. 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...

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

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

  • 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 2021 Should you buy?
  • BSE Penny Stocks List 2021
  • [UPDATED] Nasdaq Penny Stocks List 2021
  • When to short sell Nifty options, how much margin required for Option Selling
  • Bank Nifty Option chain trading strategy

Popular Categories

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

About Us | Contact Us | Privacy Policy | Disclaimer


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