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