• 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

Bank Nifty Options open interest Data Live on MS Excel Sheet

By Bhaveek Patel 20 Comments

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:

  1. Open Excel sheet from Bank-Nifty-Options-Live-OI.zip
  2. Now press Alt+Ctrl+F5 to update the data.
  3. It will show Security Warning (Don’t worry), Just press OK.
  4. Data will be updated from NSE servers instantly.
  5. 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:

Share2
Tweet
Pin
2 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. 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. Live Nifty Options open interest in Excel sheet 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...
  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: Bank Nifty Options OI Data/ Live Data

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. anand says

    thanks for this great update Bhaveek, its really helpful in tracking real time OI data.

    Reply
    • Bhaveek Patel says

      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.

      Reply
      • Shyam says

        Obliged if I get OI change LIVE chart for INDUSIND, Bank Nifty & NIFTY

        Reply
      • ra ju g says

        dear sir,
        pls share this updated exel sheet with me pls pls

        Reply
  2. anand says

    ok, as of now I am tracking Nifty & BankNifty OI data only. If interested in any stock, will surely let you know.

    Thanks

    Reply
    • Bhaveek Patel says

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

      Reply
  3. ani says

    when i wil get august series nifty and bank nifty future oi excel sheet

    Reply
    • Bhaveek Patel says

      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.

      Reply
  4. ani says

    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?

    Reply
    • Bhaveek Patel says

      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

      Reply
  5. ani says

    Thanks a lot for ur hard work. august nf and bnf excel sheet for oi?

    Reply
    • Bhaveek Patel says

      I will share nifty and bank nifty oi excel sheet in this week itself.

      Reply
  6. Shiva says

    Hi

    Please let me know if the Excel with stock is ready

    S

    Reply
  7. arindam das says

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

    Reply
  8. jagadish says

    pls update new excel format its not working now so..

    Reply
  9. Hemant Chugh says

    I opened sheet for BN & Nifty but its not updating. I am using office 365

    Reply
  10. tanmoy says

    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.

    Reply
  11. Shripraksh Mamgain says

    Dear Bhaweek pl respond on . Need BNF and NF option sheet.

    thanks

    Shriprakash

    Reply
  12. Rajeev Sharma says

    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

    Reply
  13. RAVICHANDRA says

    I WANT ALL INDICES OI,IV, MOST ACTIVE CALL PUTS EXEL SHEET

    Reply

Leave a Reply Cancel reply

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

Previous Post: Nifty future has added short positions today, Still Confusing me
Next Post: Intraday trade: Buy Nifty Future May Series, Fibonacci Support Zone

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 2023
  • 7 Ways to Boost Your Revenue
  • NYSE Penny Stocks List for 2023
  • 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 2023 Should you buy?
  • BSE Penny Stocks List 2023

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 - 2023 OurNifty.com Trading ideas published here cannot be reproduced without permission from the author.
OurNifty is Powered by Wordpress and hosted on Digital Ocean