Fii Dii Data Analysis - Excel Sheet Download Free

Serious traders don't just look at the Cash Market. They look at and Index Options data. Cash Market: Indicates long-term sentiment.

To see the correlation between flows and price action. Essential Excel Formulas Net Flow: =B2 + C2 (FII + DII) Trend Signal: =IF(D2 > 0, "Bullish", "Bearish") fii dii data analysis excel sheet download

There are two primary ways to get this data into your Excel sheet: 1. Manual Download from NSE The National Stock Exchange (NSE) publishes daily reports. Go to the website. Navigate to Resources > Daily Reports . Look for "FII/DII Trading Activity." Copy the data and paste it into your Excel sheet. 2. Automated Data Import (Power Query) To avoid manual work, use Excel’s Power Query feature: Go to the Data tab in Excel. Select From Web . Serious traders don't just look at the Cash Market

If FIIs are selling but the market is staying flat, it indicates strong DII support. To see the correlation between flows and price action

If both FIIs and DIIs are buying, the trend is strongly bullish.

Before you download or build a tracker, you need to understand what these numbers represent.