Options_Analysis

Generating Buy Sell Signals in Derivatives (Options) segment of Bank-Nifty on NSE, by Fetching (live ~ upto 3-5 minutes delay) Data from NSE India Website using power query in MS Excel.

Task:- Application of MS Excel in Trading and Derivatives Research.

Data Description:

Raw Options Data Fetched contains the following columns for various strike prices.

• Underlying
• Volume
• Buy Quantity
• Sell Quantity
• Open Interest

Query

• 

Analysis Result

•