NSE live BANK NIFTY option chain data in Excel sheet

Get the Live NIFTY Bank Index Option Chain Data in Excel Sheet for CE & PE.

Bank Nifty Trend can analyzed from this Excel based on Change in Open Interest, Price and Volume.





Fetch the various data such as Last Traded Price (LTP), Open Interest (OI), Change in Open Interest (%), Change in Price (%), Total Volume Traded, Buy Volume, Sell Volume, Implied Volatility (IV), etc., for both Calls and Puts.


A simplified Excel sheet for traders of Bank Nifty Index, coded in VBA, to fetch the real-time NSE BANK NIFTY option chain price data with different expiry dates and at a few strike prices from the underlying price.

Analyze in-depth for the changes in Open Interest (OI), Changes in Price as well as the Buy, Sell Volumes, Total Volumes Traded etc., at a few different strike prices with At the Money (ATM). 


Screenshot






Important Disclaimer:
This Excel Sheet is designed for educational purposes only. 
Either this web page or the Administrator of this web page (www.enote.page) is not responsible for any losses incurred by trading in Bank Nifty Options based on this Excel sheet. 
Before real-time trading, check the relevant data from NSE India.



Download from SourceForge

Download Bank NIFTY Option Chain in Excel




Please contact for errors.


Also, check the pages for Excel Live Stock Option Chain data and NIFTY.

Stock Option Chain: 

NIFTY Option Chain