Posts

Showing posts with the label NSE NIFTY Index live option chain in Excel

NSE NIFTY Index live option chain data in Excel sheet

Image
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 Designed by, Dr. M Kanagasabapathy Important Dis