NSE NIFTY Index live option chain data in Excel sheet

Get the Live NIFTY Index Option Chain Data in Excel Sheet for CE & PE. Gives the snapshot of the NIFTY option chain with change in price, OI and volume.


NIFTY Trend can analyzed from this Excel based on Change in Open Interest, Price and Volume. Useful for NIFTY option chain traders.





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 NIFTY Index, coded in VBA, to fetch the real-time NSE 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 different strike prices especially few 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 NIFTY Options based on this Excel sheet. 
Before real-time trading, check the relevant data from NSE India.



Download from SourceForge

Download 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 BANK Option Chain

 

 

 

Get the tutorial and the complete code for this Excel, from here.

 

Link to codes