...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 at different strike prices.
Predict the trend of the Bank Nifty movement.