# FII/DII Flow Report Template

Use this template to generate standardized institutional flow analysis reports. Replace all placeholders (wrapped in curly braces) with actual data. Remove any sections that are not applicable.

---

## Report Output Begins Below

---

# Institutional Flow Analysis Report

**Report Date:** {report_date}
**Market Status:** {market_open_or_closed}
**Data Type:** {provisional_or_final}
**Nifty 50 Close:** {nifty_close} ({nifty_change_pct}%)

---

## 1. Flow Summary

### Today's Institutional Activity

| Category | Gross Buy (Cr) | Gross Sell (Cr) | Net (Cr) | Signal |
|----------|---------------|----------------|----------|--------|
| **FII/FPI** | {fii_gross_buy} | {fii_gross_sell} | **{fii_net}** | {fii_signal_emoji_text} |
| **DII** | {dii_gross_buy} | {dii_gross_sell} | **{dii_net}** | {dii_signal_emoji_text} |
| **Combined** | {combined_gross_buy} | {combined_gross_sell} | **{combined_net}** | {combined_signal_emoji_text} |

> **Signal Legend:** NET BUYER = Positive net inflow | NET SELLER = Negative net outflow | NEUTRAL = Absolute net below 500cr

### Period Aggregates

| Period | FII Net (Cr) | DII Net (Cr) | Combined Net (Cr) |
|--------|-------------|-------------|-------------------|
| Today | {fii_net_today} | {dii_net_today} | {combined_net_today} |
| Last 5 Days | {fii_net_5d} | {dii_net_5d} | {combined_net_5d} |
| MTD ({current_month}) | {fii_net_mtd} | {dii_net_mtd} | {combined_net_mtd} |
| Last Month ({previous_month}) | {fii_net_prev_month} | {dii_net_prev_month} | {combined_net_prev_month} |
| YTD ({current_year}) | {fii_net_ytd} | {dii_net_ytd} | {combined_net_ytd} |

---

## 2. Daily Flow Table (Last 10 Trading Days)

| Date | FII Net (Cr) | DII Net (Cr) | Combined Net (Cr) | Nifty Close | Nifty Chg (%) | Flow-Price Alignment |
|------|-------------|-------------|-------------------|-------------|---------------|---------------------|
| {date_1} | {fii_1} | {dii_1} | {combined_1} | {nifty_1} | {nifty_chg_1} | {alignment_1} |
| {date_2} | {fii_2} | {dii_2} | {combined_2} | {nifty_2} | {nifty_chg_2} | {alignment_2} |
| {date_3} | {fii_3} | {dii_3} | {combined_3} | {nifty_3} | {nifty_chg_3} | {alignment_3} |
| {date_4} | {fii_4} | {dii_4} | {combined_4} | {nifty_4} | {nifty_chg_4} | {alignment_4} |
| {date_5} | {fii_5} | {dii_5} | {combined_5} | {nifty_5} | {nifty_chg_5} | {alignment_5} |
| {date_6} | {fii_6} | {dii_6} | {combined_6} | {nifty_6} | {nifty_chg_6} | {alignment_6} |
| {date_7} | {fii_7} | {dii_7} | {combined_7} | {nifty_7} | {nifty_chg_7} | {alignment_7} |
| {date_8} | {fii_8} | {dii_8} | {combined_8} | {nifty_8} | {nifty_chg_8} | {alignment_8} |
| {date_9} | {fii_9} | {dii_9} | {combined_9} | {nifty_9} | {nifty_chg_9} | {alignment_9} |
| {date_10} | {fii_10} | {dii_10} | {combined_10} | {nifty_10} | {nifty_chg_10} | {alignment_10} |

> **Flow-Price Alignment** indicates whether FII net direction matched Nifty direction that day. "Aligned" means FII buying + Nifty up OR FII selling + Nifty down. "Divergent" means FII buying + Nifty down OR FII selling + Nifty up (suggests other forces dominating).

### 10-Day Summary Statistics

| Metric | FII | DII |
|--------|-----|-----|
| Net Buying Days | {fii_buy_days}/10 | {dii_buy_days}/10 |
| Net Selling Days | {fii_sell_days}/10 | {dii_sell_days}/10 |
| Largest Single-Day Buy | {fii_max_buy} ({fii_max_buy_date}) | {dii_max_buy} ({dii_max_buy_date}) |
| Largest Single-Day Sell | {fii_max_sell} ({fii_max_sell_date}) | {dii_max_sell} ({dii_max_sell_date}) |
| 10-Day Cumulative | {fii_10d_cumulative} | {dii_10d_cumulative} |
| Daily Average | {fii_daily_avg} | {dii_daily_avg} |

---

## 3. Trend Analysis

### FII Flow Trend

**Current Trend:** {fii_trend_direction} (Buying / Selling / Neutral)

**Trend Strength:** {fii_trend_strength} (Strong / Moderate / Weak)

**Trend Duration:** {fii_trend_duration} consecutive {buying_or_selling} days

**Acceleration/Deceleration:**
- Last 5 days average: {fii_avg_last_5d} cr/day
- Prior 5 days average: {fii_avg_prior_5d} cr/day
- Change: {fii_acceleration} (Accelerating if magnitude increasing, Decelerating if magnitude decreasing)

**Interpretation:** {fii_trend_interpretation}

> Example: "FII selling has been decelerating over the past week, with daily net selling declining from -3,500cr to -1,200cr. This deceleration suggests the current selling wave may be nearing exhaustion. If FII net crosses into positive territory in the next 2-3 days, it would signal a regime transition."

### DII Flow Trend

**Current Trend:** {dii_trend_direction} (Buying / Selling / Neutral)

**Trend Strength:** {dii_trend_strength} (Strong / Moderate / Weak)

**Trend Duration:** {dii_trend_duration} consecutive {buying_or_selling} days

**Interpretation:** {dii_trend_interpretation}

> Example: "DII have been consistent net buyers for the past 8 trading days, deploying an average of 2,100cr per day. This is above the baseline SIP-driven flow of approximately 1,200-1,500cr/day, indicating active deployment by mutual fund managers beyond SIP obligations. DII absorption rate of FII selling has averaged 72%."

### Monthly Comparison

| Month | FII Net (Cr) | DII Net (Cr) | Nifty Return |
|-------|-------------|-------------|--------------|
| {month_minus_3} | {fii_m3} | {dii_m3} | {nifty_ret_m3}% |
| {month_minus_2} | {fii_m2} | {dii_m2} | {nifty_ret_m2}% |
| {month_minus_1} | {fii_m1} | {dii_m1} | {nifty_ret_m1}% |
| {current_month} (MTD) | {fii_mtd} | {dii_mtd} | {nifty_ret_mtd}% |

**Monthly Trend Observation:** {monthly_trend_observation}

> Example: "FII selling has moderated significantly from -25,000cr in January to -8,000cr in February, and the current month is tracking at -3,000cr MTD. If this deceleration continues, March could see FII turning net positive. DII buying has been consistently above 15,000cr/month for the past 3 months, providing strong market support."

---

## 4. Nifty Correlation Analysis

### Flow-Price Correlation (Last 20 Trading Days)

| Metric | Value | Interpretation |
|--------|-------|----------------|
| FII Net vs Nifty Daily Change (same day) | {correlation_same_day} | {interpretation_same_day} |
| FII Net (t) vs Nifty Change (t+1) (predictive) | {correlation_predictive} | {interpretation_predictive} |
| FII 5-Day Sum vs Nifty 5-Day Return | {correlation_5d} | {interpretation_5d} |

> **Correlation Scale:** Above 0.7 = Strong, 0.4-0.7 = Moderate, Below 0.4 = Weak

### Flow-Price Alignment Score

Over the last 10 trading days, FII flow direction matched Nifty direction on **{alignment_days}/10 days** ({alignment_pct}%).

- **Above 70%:** FII flows are the dominant market driver currently.
- **50-70%:** FII flows are one of several factors influencing the market.
- **Below 50%:** Other factors (DII, retail, global cues, earnings) are more dominant than FII flows.

### Divergence Analysis

{divergence_analysis}

> Example: "Notable divergence observed on March 8 and March 9, where FII were net sellers (-1,800cr and -2,200cr respectively) but Nifty closed positive (+0.4% and +0.6%). This divergence was driven by strong DII buying (+2,500cr and +3,100cr) that more than offset FII outflow. DII buying power exceeded FII selling, indicating robust domestic demand at current levels."

---

## 5. Flow Regime Assessment

### Current Regime: **{current_regime}**

{regime_description}

> One of:
> - **FII Net Buyer Regime**: FII have been consistently net buyers. Market has a bullish bias from institutional flows. INR likely to be stable or strengthening.
> - **FII Net Seller Regime**: FII have been consistently net sellers. Market faces headwinds from foreign outflows. INR under depreciation pressure.
> - **DII Absorption Regime**: FII selling is being substantially absorbed by DII buying. Market is range-bound with a support floor from domestic flows.
> - **Dual Buying Regime**: Both FII and DII are net buyers. This is the most bullish institutional flow configuration. Strong rally potential.
> - **Dual Selling Regime**: Both FII and DII are net sellers. This is extremely rare and bearish. Sharp correction risk.
> - **Transition Phase**: Institutional flows are in the process of changing direction. Watch for confirmation over the next 3-5 trading days.

### Regime Details

| Metric | Value |
|--------|-------|
| Regime Start Date (approximate) | {regime_start_date} |
| Regime Duration | {regime_duration} trading days |
| FII Cumulative Since Regime Start | {fii_cumulative_regime} cr |
| DII Cumulative Since Regime Start | {dii_cumulative_regime} cr |
| DII Absorption Rate (if FII selling) | {absorption_rate}% |
| Nifty Change Since Regime Start | {nifty_change_regime}% |

### Regime Transition Watch

**Probability of Regime Change:** {regime_change_probability} (Low / Medium / High)

**Transition Signals:**
{transition_signals_list}

> Example:
> - FII selling magnitude has declined 40% over the last 5 days (deceleration signal)
> - FII posted one net buying day within the last 5 days (early reversal signal)
> - The catalyst for FII selling (US yield spike) has stabilized (fundamental driver fading)
> - FII index futures long/short ratio has improved from 0.45 to 0.62 (derivative positioning turning)
> - **Assessment: Medium probability of transition to FII Net Buyer Regime within 5-7 trading days**

---

## 6. Sector Impact Analysis

### Sector-Level Institutional Flow Indicators

| Sector | FII Positioning | DII Positioning | Net Institutional View | Key Stocks Affected |
|--------|----------------|-----------------|----------------------|-------------------|
| Banking/Financials | {banking_fii} | {banking_dii} | {banking_net} | {banking_stocks} |
| IT/Technology | {it_fii} | {it_dii} | {it_net} | {it_stocks} |
| FMCG/Consumer | {fmcg_fii} | {fmcg_dii} | {fmcg_net} | {fmcg_stocks} |
| Pharma/Healthcare | {pharma_fii} | {pharma_dii} | {pharma_net} | {pharma_stocks} |
| Automobile | {auto_fii} | {auto_dii} | {auto_net} | {auto_stocks} |
| Oil & Gas | {oil_fii} | {oil_dii} | {oil_net} | {oil_stocks} |
| Metals/Mining | {metals_fii} | {metals_dii} | {metals_net} | {metals_stocks} |
| Capital Goods/Infra | {capgoods_fii} | {capgoods_dii} | {capgoods_net} | {capgoods_stocks} |

> **Note:** Sector-level flow data is approximated from sectoral index performance, stock-level block deal activity, and quarterly shareholding changes. Daily sector-wise FII/DII data is not officially published; this assessment is based on available proxies.

### Sector Rotation Observations

{sector_rotation_observations}

> Example: "Over the past 2 weeks, banking stocks have underperformed the broader market by 2.3%, consistent with FII selling pressure on their largest sector holding. Conversely, IT stocks have outperformed by 1.8%, benefiting from both INR depreciation (driven by FII outflows) and relative valuation comfort. DII appear to be increasing allocation to Pharma and FMCG, based on mutual fund portfolio disclosures and sectoral index strength."

---

## 7. Market Implications

### Near-Term Outlook (1-2 Weeks)

**Institutional Flow Bias:** {near_term_bias} (Bullish / Bearish / Neutral)

**Confidence Level:** {near_term_confidence} (High / Medium / Low)

**Key Assessment:**

{near_term_assessment}

> Example: "The institutional flow environment currently favors a cautious-to-positive near-term outlook for Nifty. While FII remain net sellers, the deceleration in selling intensity combined with robust DII absorption (averaging 75%) suggests the worst of the selling pressure may be behind us. Combined institutional flow has been only mildly negative (-800cr/day average over the last 5 days), which is insufficient to drive significant further downside. If FII selling continues to moderate, Nifty can stabilize in the 22,500-23,000 range and potentially attempt a recovery toward 23,300-23,500."

### Medium-Term Outlook (1-3 Months)

**Institutional Flow Bias:** {medium_term_bias}

**Key Factors:**

1. {medium_term_factor_1}
2. {medium_term_factor_2}
3. {medium_term_factor_3}

{medium_term_assessment}

> Example:
> 1. FII YTD outflow of -45,000cr is significant but below the FY2022 pace (-1.4L cr FY total). If current monthly pace (-8,000cr/month) continues, full-year FII outflow would be approximately -96,000cr, manageable for the market.
> 2. DII buying capacity remains strong. SIP flows are stable at 25,000cr/month with no signs of slowing. Insurance and EPFO deployment continues on schedule.
> 3. The primary catalyst for FII selling (US Fed rate expectations) could shift in Q2 if US inflation data cooperates, which would reduce the pressure.
> Medium-term view: Cautiously positive. The DII floor limits downside to 5-7% from current levels, while FII selling moderation or reversal could trigger a 8-12% rally.

### Risk Scenarios

**Upside Risk (Bullish Scenario):**
{upside_scenario}

> Example: "If FII reverse to net buyers (triggered by a Fed dovish pivot or significant India GDP upgrade), Nifty could rally 8-12% from current levels within 2-3 months. Historical precedent: FII turning buyer in Q1 2024 preceded a 15% Nifty rally."

**Downside Risk (Bearish Scenario):**
{downside_scenario}

> Example: "If FII selling accelerates beyond 5,000cr/day (triggered by a global recession scare or India-specific shock), and DII absorption falls below 50%, Nifty could correct 8-12% from current levels. This would take Nifty toward the 20,500-21,000 zone."

---

## 8. Key Levels to Watch (In Context of Flows)

### Nifty Levels with Institutional Flow Context

| Level | Type | Flow Context |
|-------|------|-------------|
| {resistance_2} | Strong Resistance | {resistance_2_context} |
| {resistance_1} | Immediate Resistance | {resistance_1_context} |
| **{current_nifty}** | **Current Level** | **{current_context}** |
| {support_1} | Immediate Support | {support_1_context} |
| {support_2} | Strong Support | {support_2_context} |

> Example:
> | 23,500 | Strong Resistance | FII were last net buyers at this level; requires FII buying to sustain breakout above |
> | 23,000 | Immediate Resistance | Short-term supply zone; FII selling intensified on last test |
> | **22,650** | **Current Level** | **DII absorption providing floor; combined institutional flow mildly negative** |
> | 22,200 | Immediate Support | DII increased buying on last dip to this level; SIP-driven floor |
> | 21,800 | Strong Support | Major DII buying zone during previous correction; FII selling exhausted here last time |

### Critical Flow Thresholds

- **FII daily net needed for Nifty to sustain above {resistance_1}:** At least {fii_needed_for_breakout} cr/day net buying
- **DII daily net needed to hold {support_1}:** At least {dii_needed_for_support} cr/day net buying (if FII selling continues at current pace)
- **Combined institutional flow needed for trend reversal:** At least {combined_needed_for_reversal} cr/day for 5+ consecutive days

---

## 9. FII Derivative Position Summary (Supplementary)

| Metric | Current Value | Previous Day | Change | Signal |
|--------|-------------|-------------|--------|--------|
| FII Index Futures Long Contracts | {fii_fut_long} | {fii_fut_long_prev} | {fii_fut_long_chg} | {fii_fut_long_signal} |
| FII Index Futures Short Contracts | {fii_fut_short} | {fii_fut_short_prev} | {fii_fut_short_chg} | {fii_fut_short_signal} |
| FII Index Futures Net | {fii_fut_net} | {fii_fut_net_prev} | {fii_fut_net_chg} | {fii_fut_net_signal} |
| FII Long/Short Ratio | {fii_ls_ratio} | {fii_ls_ratio_prev} | {fii_ls_ratio_chg} | {fii_ls_ratio_signal} |
| FII Index Options Net (Calls) | {fii_opt_calls_net} | {fii_opt_calls_prev} | {fii_opt_calls_chg} | - |
| FII Index Options Net (Puts) | {fii_opt_puts_net} | {fii_opt_puts_prev} | {fii_opt_puts_chg} | - |

**Derivative Positioning Interpretation:** {derivative_interpretation}

> Example: "FII index futures long/short ratio has improved from 0.52 to 0.61 over the past 5 days, indicating gradual short-covering and long addition. While still net short (below 1.0), the trend is positive. FII have also been writing puts at 22,000-22,200 strikes, suggesting they do not expect Nifty to fall below these levels. Combined cash + derivative positioning is turning less bearish."

---

## 10. Disclaimer

**Important:** This report is for informational and educational purposes only. It does not constitute investment advice, a recommendation to buy or sell securities, or an offer of any financial product.

**Data Limitations:**
- FII/DII data reported here is based on publicly available sources (NSE, NSDL, MoneyControl). Minor discrepancies may exist between sources.
- Provisional data (if used) may differ from final data by 2-5%.
- Daily aggregate FII/DII data does not reveal stock-level or sector-level flows. Sector assessments in this report are based on proxies and should be treated as indicative, not definitive.
- Derivative position data is based on NSE participant-wise open interest reports and reflects positions at end of day.

**Analytical Limitations:**
- Institutional flow analysis is one input among many for market assessment. It should not be used in isolation.
- Historical patterns and correlations may not repeat in the future.
- Flow data is backward-looking (what happened) and has limited predictive power for future flows.
- Single-day data is inherently noisy. Trends identified over 5-10 day periods are more reliable than daily readings.

**Risk Warning:**
- Equity investments are subject to market risk. Past institutional flow patterns do not guarantee future market performance.
- FII flows can reverse rapidly and without warning based on global events.
- The correlation between institutional flows and market direction varies over time and can break down during unusual market conditions.

**This report was generated on {report_date} at {report_time} IST. Data reflects the most recent available information at the time of generation.**

---

*Report generated using the FII/DII Flow Tracker skill. Data sourced from NSE, NSDL, and market data providers.*

# FII/DII Flow Analysis Methodology

## Table of Contents

1. [What FII/DII Data Means for Indian Markets](#what-fiidii-data-means-for-indian-markets)
2. [Understanding the Participants](#understanding-the-participants)
3. [Historical Patterns and Behavioral Tendencies](#historical-patterns-and-behavioral-tendencies)
4. [Correlation Framework: Flows and Nifty Movement](#correlation-framework-flows-and-nifty-movement)
5. [Flow Regime Definitions](#flow-regime-definitions)
6. [Significance Thresholds](#significance-thresholds)
7. [Sector Rotation via Institutional Flows](#sector-rotation-via-institutional-flows)
8. [Impact on INR and Cross-Asset Implications](#impact-on-inr-and-cross-asset-implications)
9. [DII as Counter-Weight: The SIP Floor](#dii-as-counter-weight-the-sip-floor)
10. [Data Sources and Reliability](#data-sources-and-reliability)
11. [Historical Case Studies](#historical-case-studies)
12. [Limitations and Caveats](#limitations-and-caveats)

---

## What FII/DII Data Means for Indian Markets

Foreign Institutional Investors (FII) and Domestic Institutional Investors (DII) are the two largest categories of institutional participants in Indian equity markets. Their daily buying and selling activity, reported by exchanges and depositories, is one of the most closely watched indicators by market participants in India.

### Why Institutional Flows Matter

Indian equity markets have a distinctive ownership structure:

- **FII/FPI**: Hold approximately 17-20% of the total market capitalization of NSE-listed companies. Despite this relatively modest share, FII flows disproportionately influence short-to-medium-term price movements because FII are the marginal buyer/seller in many large-cap stocks.

- **DII (Mutual Funds + Insurance + Banks)**: Hold approximately 15-17% of total market capitalization. DII flows have become increasingly important since 2016-17, driven by the explosion of Systematic Investment Plans (SIPs) in mutual funds.

- **Retail/HNI**: Hold approximately 7-9% directly (excluding mutual fund holdings).

- **Promoters**: Hold the largest share at approximately 50-55%.

The marginal pricing power of FII is significant because:
1. FII operate with large ticket sizes, moving individual stocks and indices.
2. FII flows are correlated with global risk appetite, making them a transmission mechanism for global macro to Indian markets.
3. FII flows directly impact INR demand/supply through USD-INR conversion.
4. FII positioning in derivatives (futures and options) amplifies their cash market impact.

### Cash Market vs Derivative Market Data

There are two types of FII/DII flow data:

**Cash Market Data (Primary Focus of This Skill)**
- Reports actual equity purchases and sales by FII and DII on each trading day.
- Published daily by NSDL (for FII/FPI) and exchanges (combined FII + DII).
- Measured in Indian Rupees (crores).
- Directly reflects capital allocation decisions.

**Derivative Market Data (Supplementary)**
- Reports FII open interest and daily position changes in index futures, stock futures, index options, and stock options.
- Available from NSE daily reports.
- FII derivative positions often lead cash market flows by 1-3 days.
- Index futures long/short ratio is a key sentiment indicator.

This skill primarily tracks cash market flows but references derivative positioning when relevant.

---

## Understanding the Participants

### Foreign Institutional Investors (FII) / Foreign Portfolio Investors (FPI)

**Who They Are:**
FII is the older SEBI classification. Since 2014, SEBI reclassified all foreign portfolio-based investors under three FPI categories:
- **Category I**: Government and government-related investors (sovereign wealth funds, central banks, multilateral agencies).
- **Category II**: Regulated entities (mutual funds, banks, insurance companies, pension funds from abroad).
- **Category III**: All other FPIs (hedge funds, family offices, corporate bodies, individuals meeting criteria).

In common market usage, "FII" and "FPI" are used interchangeably to refer to all foreign portfolio investors.

**Key Behavioral Characteristics:**
- Driven by global macro: US interest rates, Dollar Index (DXY), global risk-on/risk-off cycles, and relative valuations.
- Tend to move in herds: When one large FII starts selling, others follow, creating momentum.
- Concentrated in large-cap liquid stocks: Heaviest weights in Financials (HDFC Bank, ICICI Bank, Kotak Bank), IT (Infosys, TCS), Reliance Industries, and select Consumer names.
- Sensitive to India's macro fundamentals: Current account deficit, fiscal deficit, inflation, GDP growth trajectory.
- Influenced by MSCI/FTSE index rebalancing: Quarterly index changes trigger passive FII buying/selling.
- Calendar effects: March (financial year-end redemptions), December (year-end positioning), January (new allocations).

**Typical FII Selling Triggers:**
- US Fed rate hikes or hawkish pivot (higher US yields make EM less attractive)
- Rising US Dollar (DXY above 105-107 historically pressure on EM flows)
- Global risk-off events (geopolitical crises, banking contagion, pandemic fears)
- India-specific risks (tax policy changes, regulatory surprises, macro deterioration)
- Overvaluation concerns (Nifty PE above 22-23x trailing considered expensive by many FII)
- Better opportunities elsewhere (China reopening rotation in late 2022)

**Typical FII Buying Triggers:**
- US Fed rate cuts or dovish pivot
- Dollar weakness (DXY below 100-102)
- Improving India macro (GDP acceleration, reforms, stable politics)
- Relative undervaluation vs peers
- MSCI weight increase for India
- Global risk-on rallies

### Domestic Institutional Investors (DII)

**Who They Are:**
- **Mutual Funds**: The largest DII component, managing over 60 lakh crore in AUM. Equity-oriented MFs are the primary DII buyers.
- **Insurance Companies**: LIC (Life Insurance Corporation) is the single largest DII entity. Private insurers (HDFC Life, SBI Life, ICICI Prudential Life) also significant.
- **Banks**: Proprietary trading desks and treasury operations.
- **Financial Institutions**: NaBFID, SIDBI, and other development financial institutions.

**Key Behavioral Characteristics:**
- Driven by domestic fund flows: MF SIPs, insurance premiums, and EPFO allocations.
- Counter-cyclical tendency: DII (especially MFs) often buy when markets fall (deploying SIP inflows) and sell when markets rise sharply (profit booking / rebalancing).
- Less sensitive to global macro: DII flows are primarily a function of domestic savings rates and investor confidence.
- Long-term orientation: Insurance and pension money has multi-decade investment horizons.
- Forced buyers: Monthly SIP inflows of approximately 25,000-26,000 crore (as of 2025-26) must be deployed regardless of market conditions, creating a consistent buying floor.

**DII Flow Dynamics:**
- **SIP inflows**: Provide a steady, predictable base demand of approximately 25,000cr/month, deployed across market levels.
- **NFO (New Fund Offer) launches**: Can create lumpy buying in specific sectors/themes.
- **Profit booking**: When markets rally sharply, MFs may sell to book profits and maintain cash buffers for redemptions.
- **Insurance/EPFO**: Tend to buy in a more steady-state manner, with quarterly deployment cycles.

---

## Historical Patterns and Behavioral Tendencies

### The FII-DII Seesaw

One of the most distinctive features of Indian markets is the inverse relationship between FII and DII flows. This seesaw has become more pronounced since 2017 as DII (particularly mutual fund SIP) flows have scaled up:

- When FII sell aggressively, market dips trigger SIP buying by retail through MFs, resulting in DII net buying.
- When FII buy and markets rally, some domestic investors redeem MF units or reduce new investments, while MFs book profits.
- This counter-cyclical dynamic creates a natural stabilizer that reduces volatility compared to other emerging markets.

### Seasonal Patterns

**January-March (Q4 FY):**
- FII often sell in March due to year-end portfolio adjustments and emerging market fund redemptions.
- DII buying typically strong as insurance companies and pension funds deploy annual allocations.
- MSCI rebalancing in February can trigger FII passive flows.

**April-June (Q1 FY):**
- Start of new financial year, fresh FII allocation decisions.
- MF tax-loss harvesting in March often followed by redeployment in April.
- Q4 earnings season (April-May) drives stock-specific institutional flows.

**July-September (Q2 FY):**
- Monsoon-dependent sentiment for rural/agri-linked sectors.
- US Fed September meeting often a catalyst for FII flow direction.
- MSCI August rebalancing.

**October-December (Q3 FY):**
- Festive season typically positive for DII flows (SIP momentum).
- FII positioning for calendar year-end.
- Global risk appetite around US elections (every 4 years) or year-end rallies.

### Long-Term FII Flow Trends

| Period | FII Net (approx.) | Key Driver |
|--------|-------------------|------------|
| FY2014-FY2017 | Positive (net buyers) | Modi election, reform optimism, low US rates |
| FY2018 | Negative | US rate hikes, LTCG tax introduction |
| FY2019 | Marginally positive | Pre-election positioning, value buying |
| FY2020 | Negative (COVID year) | Sharp selling Mar 2020, partial recovery H2 |
| FY2021 | Strongly positive (+2.7L cr) | Global liquidity flood, post-COVID recovery |
| FY2022 | Strongly negative (-1.4L cr) | Russia-Ukraine, US rate hikes, inflation |
| FY2023 | Negative (-37,000cr) | Continued US tightening, China reopening rotation |
| FY2024 | Positive (+1.7L cr) | Rate pause, India growth story, EM reallocation |
| FY2025 (partial) | Mixed | Valuation concerns, DXY strength, but India structural flows |

---

## Correlation Framework: Flows and Nifty Movement

### Same-Day Correlation

FII cash market flows and Nifty daily movement show a moderate-to-strong positive correlation (typically 0.5-0.7 over rolling 60-day periods). This means:

- On days when FII are net buyers, Nifty tends to close positive more often than not.
- On days when FII are net sellers, Nifty tends to close negative.
- The correlation is not perfect because DII, retail, and HNI flows can offset FII impact.

### Lead-Lag Relationship

Research on Indian markets suggests:

1. **FII derivative positions lead cash flows by 1-3 days**: FII first build/reduce positions in index futures before deploying in cash. Monitoring FII index futures OI and net long/short gives an early signal.

2. **FII cash flows are coincident with Nifty**: The same-day relationship is the strongest. FII buying/selling is both a cause and effect of price movement (reflexive relationship).

3. **DII flows lag Nifty by 0-1 days**: DII (especially MF) deploy SIP inflows on pre-set dates but also respond to market dips with buying, creating a slight lag.

### Correlation Breakdown Scenarios

The FII-Nifty correlation breaks down in specific scenarios:

- **DII overpowering FII**: When DII buying exceeds FII selling by a large margin, Nifty can rally despite FII outflows. This has become more common since 2020.
- **Derivative-driven moves**: When FII are active in derivatives but not cash, the cash flow data does not capture their full impact.
- **Block deals and bulk deals**: Large negotiated trades may show up as FII buying/selling but do not represent directional conviction (e.g., PE exit via block deal).
- **IPO-related flows**: FII buying in IPOs is recorded as cash market buying but represents new issuance, not secondary market demand.

### Constructing a Flow-Price Model

For quantitative correlation analysis:

1. Collect daily FII net, DII net, and Nifty close for at least 60 trading days.
2. Calculate daily Nifty % change.
3. Calculate rolling 5-day sum of FII net and DII net.
4. Compute Pearson correlation between:
   - FII daily net and Nifty daily % change (same day)
   - FII 5-day rolling sum and Nifty 5-day % change (trend correlation)
   - FII daily net (t) and Nifty daily % change (t+1) (predictive lead)
5. A correlation above 0.6 suggests FII are the dominant pricing force.
6. A declining correlation below 0.3 suggests other factors are dominating.

---

## Flow Regime Definitions

Classification of the current institutional flow environment:

### Regime 1: FII Net Buyer Regime

**Identification Criteria:**
- FII net positive for 5 or more consecutive trading days, OR
- FII MTD net positive exceeding +5,000 crore, OR
- FII 20-day rolling sum positive and rising

**Market Characteristics:**
- Nifty typically in uptrend or consolidation-with-upward-bias.
- INR tends to strengthen (USD/INR declining).
- Large-cap outperformance over mid/small-cap (FII concentrated in large-caps).
- Banking and Financial index outperforms (heaviest FII weight).
- Market breadth may be narrow (FII-driven rallies are often index-heavy).

**Historical Frequency:** Approximately 35-40% of all trading months.

### Regime 2: FII Net Seller Regime

**Identification Criteria:**
- FII net negative for 5 or more consecutive trading days, OR
- FII MTD net negative exceeding -5,000 crore, OR
- FII 20-day rolling sum negative and declining

**Market Characteristics:**
- Nifty under pressure, either declining or struggling to rally.
- INR tends to weaken (USD/INR rising).
- Large-caps may underperform (direct FII selling pressure).
- IT sector may outperform (beneficiary of INR depreciation).
- DII buying provides support, limiting downside (SIP floor).
- If FII selling exceeds 2,000-3,000cr/day consistently, markets tend to fall 1-3% per week.

**Historical Frequency:** Approximately 30-35% of all trading months.

### Regime 3: DII Absorption Regime

**Identification Criteria:**
- FII net negative for 5+ days
- DII net positive and absorbing >70% of FII selling
- Nifty relatively stable (not falling proportionally to FII selling)

**Market Characteristics:**
- Choppy, range-bound market.
- Nifty finds support at key levels but lacks upward momentum.
- Sector rotation: DII-favored sectors (FMCG, Pharma) may outperform.
- This regime can persist for weeks or months.
- Often resolves when FII selling exhausts (prices become attractive) or DII buying slows (SIP flows plateau).

**Historical Frequency:** Approximately 15-20% of all trading months.

### Regime 4: Dual Buying Regime

**Identification Criteria:**
- Both FII and DII net positive for 3+ consecutive days
- Combined daily inflow exceeding 3,000 crore

**Market Characteristics:**
- Strong rally, Nifty typically rising 1-3% per week.
- Broad-based buying: both large-cap and mid-cap participate.
- High market breadth (advance-decline ratio > 2:1).
- VIX tends to decline.
- This is the most bullish flow regime, but also tends to be short-lived (7-15 days).

**Historical Frequency:** Approximately 10-15% of all trading periods.

### Regime 5: Dual Selling Regime (Rare)

**Identification Criteria:**
- Both FII and DII net negative for 3+ consecutive days
- Combined daily outflow exceeding -2,000 crore

**Market Characteristics:**
- Sharp market correction, Nifty can fall 3-7% in a week.
- Liquidity vacuum: no institutional buying support.
- VIX spikes significantly.
- This regime is rare because DII (especially MFs with SIP inflows) are almost always deploying capital.
- Occurs during extreme events: pandemic panics, systemic financial crises, sudden regulatory shocks.

**Historical Frequency:** Less than 5% of trading periods.

### Regime 6: Transition Phase

**Identification Criteria:**
- FII switching from net seller to net buyer (or vice versa) within the last 5 trading days
- Alternating positive/negative days with no clear trend
- Daily absolute values declining (flow intensity reducing)

**Market Characteristics:**
- Market at an inflection point.
- Nifty typically in a tight range, building a base or top.
- Watch for confirmation: 3+ consecutive days in the new direction confirms regime change.
- Often occurs near major Nifty support/resistance levels.

**Historical Frequency:** Approximately 10-15% of trading periods.

---

## Significance Thresholds

Understanding the magnitude of institutional flows is critical. Not all net buying/selling is equal:

### Daily Flow Thresholds

| Category | FII Net (crores) | Market Impact |
|----------|-----------------|---------------|
| Noise | -500 to +500 | Negligible; normal daily variation |
| Mild | -1,000 to -500 or +500 to +1,000 | Minor influence; other factors dominate |
| Moderate | -2,000 to -1,000 or +1,000 to +2,000 | Noticeable impact; contributes to daily direction |
| Significant | -5,000 to -2,000 or +2,000 to +5,000 | Strong influence; likely primary driver of daily move |
| Extreme | Beyond -5,000 or +5,000 | Dominant force; market moves 1%+ in flow direction |

### Monthly (MTD) Flow Thresholds

| Category | FII MTD Net (crores) | Trend Implication |
|----------|---------------------|-------------------|
| Balanced | -5,000 to +5,000 | No clear monthly trend |
| Moderate trend | -10,000 to -5,000 or +5,000 to +10,000 | Developing monthly trend |
| Strong trend | -25,000 to -10,000 or +10,000 to +25,000 | Clear monthly directional flow |
| Major trend | Beyond -25,000 or +25,000 | Significant monthly capital movement |

### Yearly (YTD) Flow Thresholds

| Category | FII YTD Net (crores) | Strategic Implication |
|----------|---------------------|----------------------|
| Neutral | -25,000 to +25,000 | No clear annual preference |
| Moderate | -50,000 to -25,000 or +25,000 to +50,000 | Gradual positioning shift |
| Significant | -1,00,000 to -50,000 or +50,000 to +1,00,000 | Major annual trend |
| Extreme | Beyond -1,00,000 or +1,00,000 | Structural capital flow shift |

### Context-Adjusted Thresholds

These thresholds should be adjusted for market conditions:

- **During high-volatility periods** (VIX > 20): Flows appear larger in absolute terms; raise thresholds by 50%.
- **During derivatives expiry weeks**: Cash market flows may be distorted by hedging activity; focus on 5-day rolling sum instead of daily.
- **During IPO/OFS weeks**: Large FII buying may be primary market participation, not secondary market demand; adjust accordingly.
- **Market cap context**: In 2025-26, Indian market cap is approximately 400 lakh crore. A 5,000cr daily flow represents ~0.0125% of market cap. Adjust thresholds proportionally as market cap grows.

---

## Sector Rotation via Institutional Flows

### FII Sector Preferences (Typical Allocation)

FII portfolio allocation in Indian equities (approximate weights):

| Sector | FII Weight | Sensitivity to FII Flows |
|--------|-----------|-------------------------|
| Banking & Financial Services | 30-35% | Very High |
| IT & Technology | 12-15% | High |
| Oil & Gas (Reliance) | 8-10% | High |
| Consumer/FMCG | 7-9% | Moderate |
| Automobile | 5-7% | Moderate |
| Pharma/Healthcare | 4-6% | Moderate |
| Metals & Mining | 3-5% | Moderate |
| Telecom | 3-4% | Low-Moderate |
| Capital Goods/Infra | 3-4% | Low-Moderate |
| Others | 10-15% | Low |

### DII Sector Preferences (Typical Allocation)

| Sector | DII Weight | Notes |
|--------|-----------|-------|
| Banking & Financial Services | 25-30% | Slightly underweight vs FII |
| FMCG/Consumer | 10-12% | Higher weight than FII |
| IT & Technology | 10-12% | Similar to FII |
| Pharma/Healthcare | 7-9% | Higher weight than FII |
| Automobile | 5-7% | Similar to FII |
| Capital Goods/Infra | 5-7% | Higher weight than FII |
| Oil & Gas | 5-7% | Lower weight than FII |
| Others | 15-20% | More diversified, includes mid-caps |

### Sector Rotation Signals from Flows

**FII Rotation Into Sector:** When FII data shows increased buying in a specific sector (visible through stock-level FII holding changes reported quarterly), it signals:
- Global thematic positioning (e.g., clean energy rotation into Indian green energy stocks)
- Relative valuation play (sector derated, becoming attractive)
- Macro view expression (buying rate-sensitive financials before expected rate cuts)

**DII Rotation Into Sector:** When DII (especially MFs) increase allocation to a sector:
- New thematic/sectoral NFO launches directing flows (e.g., defense fund, PSU fund)
- Bottom-up stock picking by active fund managers
- Index rebalancing if sector weight changes in Nifty

### Cross-Referencing with Holdings Data

Quarterly shareholding data (available from BSE/NSE filings) provides confirmation of sector rotation:
- Compare FII holding % in specific stocks across quarters
- Rising FII holding confirms buying trend visible in daily flow data
- Falling FII holding confirms the sustained selling was stock/sector-specific

---

## Impact on INR and Cross-Asset Implications

### FII Flows and USD/INR

FII flows have a direct mechanical impact on the Indian Rupee:

**FII Buying (Capital Inflow):**
1. FII convert USD to INR to buy Indian equities.
2. This creates demand for INR in the forex market.
3. INR tends to appreciate (USD/INR falls).
4. RBI may intervene to prevent sharp appreciation (buys USD, adds to reserves).

**FII Selling (Capital Outflow):**
1. FII sell Indian equities and convert INR proceeds back to USD.
2. This creates supply of INR / demand for USD.
3. INR tends to depreciate (USD/INR rises).
4. RBI may intervene to prevent sharp depreciation (sells USD from reserves).

**Magnitude of Impact:**
- Monthly FII outflow of 20,000-30,000cr typically causes INR depreciation of 1-2% (absent RBI intervention).
- RBI's reserve adequacy (approximately $600-650 billion as of 2025) provides significant intervention capacity.
- The impact is more pronounced when FII selling coincides with trade deficit widening or oil price spikes.

### Cross-Asset Implications

| FII Flow Direction | Equity Impact | INR Impact | Bond Impact | Sector Winners | Sector Losers |
|-------------------|---------------|------------|-------------|----------------|---------------|
| Strong buying | Nifty bullish | INR strengthens | Yields may fall (capital inflow) | Financials, Autos | IT (INR strength) |
| Strong selling | Nifty bearish | INR weakens | Yields may rise (capital outflow) | IT (INR weakness) | Financials, Importers |
| Mixed/Neutral | Nifty range-bound | INR stable | Yields driven by macro | Stock-specific | Stock-specific |

---

## DII as Counter-Weight: The SIP Floor

### The Structural Shift

The most significant change in Indian market structure over the past decade is the rise of Systematic Investment Plans (SIPs). Key statistics:

- Monthly SIP flows: Approximately 25,000-26,000 crore (as of late 2025)
- Total SIP AUM: Over 13 lakh crore
- Number of SIP accounts: Over 10 crore (100 million)
- Average SIP ticket size: Approximately 2,500 per month

### How SIPs Create a Floor

SIPs are automatic, monthly equity investments that:
1. **Deploy regardless of market level**: SIP amounts are fixed and flow in on pre-set dates each month.
2. **Buy more units when markets fall**: Rupee-cost averaging means more shares are purchased during dips.
3. **Are sticky**: SIP cancellation rates are low (approximately 1-2% per month). Most investors continue SIPs for 3-5+ years.
4. **Scale with financial inclusion**: SIP flows have grown at 20-25% CAGR and show no signs of slowing.

### The DII Absorption Capacity

With SIP flows of approximately 25,000cr/month (approximately 1,200cr/trading day), DII have a baseline buying capacity even before accounting for:
- Insurance premium deployment (approximately 5,000-10,000cr/month into equities)
- EPFO allocations (approximately 3,000-5,000cr/month)
- Lump-sum MF inflows and NFOs

Total DII baseline monthly buying capacity: approximately 35,000-40,000cr/month (approximately 1,500-2,000cr/trading day).

This means:
- FII daily selling up to 1,500-2,000cr can be fully absorbed by DII without market decline.
- FII daily selling of 2,000-4,000cr causes moderate market pressure (DII absorbs partially).
- FII daily selling above 4,000-5,000cr overwhelms DII absorption capacity, leading to market decline.

### Historical DII Absorption Examples

| Period | FII Monthly Sell | DII Monthly Buy | Absorption Rate | Nifty Monthly Change |
|--------|-----------------|-----------------|-----------------|---------------------|
| Oct 2021 | -13,500cr | +12,800cr | 95% | -0.5% |
| Jan 2022 | -33,300cr | +23,600cr | 71% | -3.5% |
| Mar 2022 | -41,100cr | +31,800cr | 77% | -2.4% |
| Jun 2022 | -50,200cr | +32,300cr | 64% | -4.8% |
| Jan 2023 | -28,800cr | +15,400cr | 53% | -2.5% |
| Oct 2024 | -94,000cr | +96,200cr | 102% | -6.2%* |

*Note: Oct 2024 shows that even 100%+ DII absorption may not prevent decline if FII selling is extreme and broad-based. Retail panic selling can amplify the move.

---

## Data Sources and Reliability

### Primary Sources

**1. NSDL (National Securities Depository Limited)**
- URL: https://www.fpi.nsdl.co.in
- Data: FPI/FII daily and monthly investment data in equity and debt
- Granularity: Daily, with buy/sell/net breakdowns
- Reliability: Official depository data, considered the gold standard
- Timing: Available next day by noon for previous day's data

**2. NSE (National Stock Exchange)**
- URL: https://www.nseindia.com (under "Market Data" > "FII/DII Statistics")
- Data: Combined FII and DII cash market activity
- Granularity: Daily, with gross buy, gross sell, and net for both FII and DII
- Reliability: Official exchange data
- Timing: Provisional data available after market close (by 7 PM IST), final data next day

**3. CDSL (Central Depository Services Limited)**
- URL: https://www.cdslindia.com
- Data: FPI holding data, supplementary to NSDL
- Reliability: Official depository data
- Usage: Cross-verification and holding-level data

**4. SEBI (Securities and Exchange Board of India)**
- URL: https://www.sebi.gov.in
- Data: FPI registration data, aggregate monthly reports, regulatory circulars
- Reliability: Regulatory authority, definitive
- Usage: Historical trends, regulatory context, FPI category breakdowns

### Secondary/Aggregator Sources

**5. MoneyControl**
- URL: https://www.moneycontrol.com/stocks/marketstats/fii_dii_activity/
- Data: Aggregated FII/DII daily and monthly data, historical tables
- Reliability: Good; sources from official data but may have slight delays
- Advantage: Easy-to-read tables, historical comparisons, sector-level data

**6. Trendlyne**
- URL: https://trendlyne.com/fii-dii/
- Data: FII/DII daily data with charts and trend analysis
- Reliability: Good; derived from official sources
- Advantage: Visual charts, rolling averages, comparative analysis

**7. Tickertape**
- URL: https://www.tickertape.in/market-mood-index (includes FII/DII data)
- Data: Flow data alongside market mood indicators
- Reliability: Good
- Advantage: Combined with other sentiment indicators

### Data Reconciliation

There can be discrepancies between sources due to:
- **Provisional vs final data**: NSE provisional data (same day) may differ from final data (next day) by 2-5%.
- **NSDL vs NSE classification**: Minor differences in FPI categorization.
- **Primary vs secondary market**: Some sources include IPO/OFS purchases, others do not.
- **Reporting cut-off times**: Data published at different times may capture different trade sets.

**Best Practice:** Use NSE data for daily tracking (most timely) and NSDL data for monthly/yearly analysis (most comprehensive).

---

## Historical Case Studies

### Case Study 1: COVID-19 Crash (March 2020)

**Context:** Global pandemic lockdowns triggered the fastest bear market in history.

**FII Activity:**
- March 2020: FII sold approximately 65,000 crore in Indian equities in a single month.
- Peak daily selling: Over 7,000 crore on multiple days.
- Selling was indiscriminate: large-caps, mid-caps, and all sectors affected.
- FII derivative positions showed massive short buildup in index futures.

**DII Response:**
- DII bought approximately 55,000 crore in March 2020.
- Absorption rate: approximately 85% (impressive but insufficient to prevent crash).
- SIP flows continued unabated, providing steady buying.
- LIC was a notable buyer during the crash.

**Market Impact:**
- Nifty fell from 12,000 to 7,500 (37.5% decline in March alone).
- USD/INR moved from 72 to 76 (5.5% INR depreciation).
- VIX spiked from 15 to 85 (highest ever).

**Recovery:**
- FII turned net buyers from April 2020 onwards.
- FY2021 saw FII net buying of approximately 2.7 lakh crore (historic high at that point).
- Nifty recovered to pre-COVID levels by November 2020 and hit new highs by January 2021.

**Key Lesson:** During extreme global events, even strong DII buying cannot fully offset FII panic selling. However, the recovery is typically rapid once FII return, and DII buying during the dip generates strong returns for domestic investors.

### Case Study 2: Russia-Ukraine War and Global Tightening (FY2022)

**Context:** Russia invaded Ukraine in February 2022. US Fed began aggressive rate hikes. Commodity prices spiked.

**FII Activity:**
- FY2022 (April 2021 - March 2022): FII sold approximately 1.4 lakh crore, the largest annual outflow at that time.
- Selling was sustained over 10 months (October 2021 to July 2022).
- Peak monthly selling: June 2022 at approximately 50,000 crore.
- FII rotated capital from India to China (China reopening trade) and developed markets (US yields rising).

**DII Response:**
- DII bought approximately 2.7 lakh crore in FY2022.
- DII not only absorbed all FII selling but added net liquidity to the market.
- SIP flows grew from approximately 10,000cr/month to 13,000cr/month during this period.
- This was the first year where DII decisively overpowered FII selling.

**Market Impact:**
- Nifty fell approximately 15% from October 2021 highs (18,600) to June 2022 lows (15,200).
- Recovery was faster than expected due to DII support: Nifty was back at 18,000 by August 2022.
- USD/INR moved from 74 to 82 (approximately 10% INR depreciation) due to oil price spike plus FII outflows.
- Mid-caps and small-caps outperformed large-caps (less FII exposure, more DII support).

**Key Lesson:** DII have become structurally capable of absorbing sustained FII selling. The Indian market's dependence on FII flows has meaningfully declined. However, INR still remains sensitive to FII flows due to the forex market mechanics.

### Case Study 3: FII Exodus of October 2024

**Context:** A combination of China stimulus-driven rotation, rich Indian valuations (Nifty trailing PE near 24x), and global uncertainty led to historic FII selling.

**FII Activity:**
- October 2024: FII sold approximately 94,000 crore, one of the highest monthly outflows ever.
- Daily selling consistently above 4,000-5,000 crore.
- Driven primarily by: (a) China stimulus announcement triggering EM rotation, (b) Indian valuation premium vs peers, (c) US election uncertainty.

**DII Response:**
- DII bought approximately 96,200 crore in October 2024, exceeding FII selling.
- SIP flows remained robust at approximately 25,000cr/month.
- NFOs and lump-sum investments added to DII buying power.

**Market Impact:**
- Despite 100%+ DII absorption, Nifty fell approximately 6.2% in October 2024.
- This demonstrated that extreme FII selling creates price impact beyond what DII buying can offset.
- Breadth deteriorated: many mid/small-caps fell 15-20%.
- USD/INR breached 84 for the first time.

**Key Lesson:** There is a threshold of FII selling intensity beyond which DII absorption alone cannot prevent decline. When FII selling exceeds approximately 80,000-90,000cr/month, the selling pressure overwhelms all domestic absorption capacity, and retail panic selling amplifies the decline.

### Case Study 4: FII Return Post-COVID (FY2021)

**Context:** Global central banks flooded markets with liquidity. India emerged from lockdowns with strong corporate earnings recovery.

**FII Activity:**
- FY2021: FII invested approximately 2.74 lakh crore in Indian equities.
- Monthly flows consistently above 15,000-25,000 crore.
- India was a favored EM destination due to digital/tech themes, pharma demand, and IT services growth.

**DII Response:**
- DII were mixed: some months net buyers, some net sellers.
- MFs saw redemptions as retail investors booked profits in the rally.
- Insurance continued steady deployment.

**Market Impact:**
- Nifty rallied from 8,600 (April 2020) to 15,000 (March 2021): approximately 75% gain.
- INR strengthened from 76 to 73.
- IPO market boomed (FII participation drove oversubscriptions).
- Small and mid-cap rally was extraordinary.

**Key Lesson:** When FII flows align positively with improving fundamentals, the rally can be powerful and sustained. FII buying of this magnitude lifts all boats and creates a virtuous cycle of price appreciation, positive sentiment, and more inflows.

---

## Limitations and Caveats

### What FII/DII Data Does Not Tell You

1. **No stock-level granularity in daily data**: Daily FII/DII data is aggregate across all stocks. You cannot determine which stocks FII bought or sold from daily flow data alone. Stock-level data is available only quarterly through shareholding disclosures.

2. **No intent information**: The data shows what happened, not why. FII selling could be profit-booking, risk reduction, fund redemptions, or macro positioning. The motivation matters for predicting future flows.

3. **Block deals distortion**: Large block deals (negotiated off-market transactions settled on exchange) show up in daily FII/DII data but do not represent incremental directional positioning. A PE fund selling a stake to another FII via block deal appears as FII selling + FII buying (net neutral) but the gross numbers inflate the data.

4. **IPO/OFS participation**: When FII participate in IPOs or OFS (Offer for Sale), it shows up as FII buying in cash market data. This is primary market issuance, not secondary market demand. During IPO-heavy months, FII buying numbers can be misleadingly high.

5. **DII data aggregation**: DII includes mutual funds, insurance, banks, and FIs. These have very different mandates and time horizons. Aggregate DII data masks sector rotation within DII.

6. **No real-time data**: FII/DII data is available after market hours (provisional) or next day (final). It cannot be used for intraday decision-making.

7. **Does not capture P-Notes**: Participatory Notes (P-Notes) issued by registered FPIs to unregistered foreign investors are included in FPI/FII numbers but may have different behavioral patterns.

### Common Analytical Mistakes

1. **Over-reacting to single-day data**: One day of high FII selling does not make a trend. Always look at 5-10 day rolling averages.

2. **Ignoring derivative flows**: Cash market data alone gives an incomplete picture. FII derivative positions (available from NSE Participant-wise OI data) often provide earlier and more nuanced signals.

3. **Assuming causation**: FII buying does not guarantee Nifty will rise. Multiple factors drive markets. FII flows are one important input, not the sole determinant.

4. **Linear extrapolation**: Assuming this month's selling pace will continue into next month. FII flows can reverse rapidly based on global events.

5. **Ignoring the absolute size context**: As Indian market cap grows, the same absolute flow number (e.g., 5,000cr) represents a smaller percentage of the market. Thresholds should be periodically recalibrated.

6. **Comparing across different market cap eras**: FII selling of 10,000cr in 2015 (when market cap was approximately 100 lakh crore) was far more significant than the same amount in 2025 (market cap approximately 400 lakh crore).

# FII/DII Flow Interpretation Guide

## Table of Contents

1. [How to Read FII/DII Data Tables](#how-to-read-fiidii-data-tables)
2. [Bullish Flow Signals](#bullish-flow-signals)
3. [Bearish Flow Signals](#bearish-flow-signals)
4. [Neutral Flow Signals](#neutral-flow-signals)
5. [Combining Flows with Market Breadth and Technical Levels](#combining-flows-with-market-breadth-and-technical-levels)
6. [Common Mistakes to Avoid](#common-mistakes-to-avoid)
7. [FII Derivative Positions as Leading Indicator](#fii-derivative-positions-as-leading-indicator)
8. [Quick Reference Decision Matrix](#quick-reference-decision-matrix)
9. [Practical Examples](#practical-examples)

---

## How to Read FII/DII Data Tables

### Standard Data Format

FII/DII data is typically presented in the following format (all values in Indian Rupees, crores):

| Date | FII Gross Buy | FII Gross Sell | FII Net | DII Gross Buy | DII Gross Sell | DII Net |
|------|-------------|--------------|---------|-------------|--------------|---------|
| 12-Mar-2026 | 8,500 | 10,200 | -1,700 | 7,800 | 6,100 | +1,700 |
| 11-Mar-2026 | 9,200 | 11,800 | -2,600 | 8,500 | 6,300 | +2,200 |
| 10-Mar-2026 | 7,800 | 8,100 | -300 | 6,200 | 6,400 | -200 |

### Understanding the Columns

**Gross Buy:** The total value of shares purchased by FII/DII on that day across all stocks. This number includes all buy transactions regardless of whether the same entity also sold shares.

**Gross Sell:** The total value of shares sold by FII/DII on that day across all stocks.

**Net (Buy-Sell):** Gross Buy minus Gross Sell. This is the most important number:
- **Positive Net = Net buyer**: FII/DII bought more than they sold. Capital is flowing into the market.
- **Negative Net = Net seller**: FII/DII sold more than they bought. Capital is flowing out of the market.
- **Zero or near-zero Net**: Balanced activity, no directional flow.

### Key Reading Principles

1. **Focus on Net, not Gross**: A day with FII Gross Buy of 15,000cr and Gross Sell of 16,000cr (Net = -1,000cr) is mildly bearish. Do not get distracted by the high gross numbers; what matters is the net direction and magnitude.

2. **Look at trends, not individual days**: A single day's data can be noisy. Look at 5-day and 10-day rolling net flows to identify trends.

3. **Compare FII and DII in tandem**: The relationship between FII and DII flows tells a more complete story than either alone.

4. **Note the magnitude**: FII Net of -500cr is noise. FII Net of -5,000cr is a strong signal. Always contextualize the absolute value (refer to significance thresholds in the methodology document).

5. **Check for gross activity level**: If both Gross Buy and Gross Sell are unusually high (say, both above 12,000-15,000cr for FII), it suggests high institutional churning/rotation, even if Net is small. This indicates sector rotation rather than directional flow.

### Monthly and Yearly Aggregation

**MTD (Month-to-Date):** Sum of daily Net values from the 1st of the month to the current date. This shows the monthly trend in progress.

**YTD (Year-to-Date):** Sum of daily Net values from January 1st (or April 1st for FY) to the current date. This shows the annual positioning trend.

**Rolling Averages:**
- 5-day rolling average: Smooths daily noise, shows weekly trend.
- 20-day rolling average: Approximates monthly trend, good for regime identification.

---

## Bullish Flow Signals

The following flow patterns suggest positive market outlook. Listed in order of decreasing signal strength:

### Signal 1: Dual Institutional Buying (Strongest Bullish)

**Pattern:** Both FII and DII are net buyers for 3 or more consecutive trading days.

**What it means:** Foreign and domestic institutions are simultaneously deploying capital. This indicates broad-based institutional confidence. Since FII and DII have different information sets, mandates, and decision frameworks, their alignment is a strong signal.

**How to confirm:**
- Check if combined daily net (FII + DII) exceeds 3,000cr.
- Verify that Nifty is responding with positive closes.
- Check market breadth: advance-decline ratio should be above 1.5:1.
- VIX should be declining or stable.

**Historical success rate:** When both FII and DII buy for 5+ consecutive days, Nifty has historically risen 2-4% in the following 10 trading days approximately 75% of the time.

**Caveats:** This signal is rare (occurs in perhaps 10-15% of trading periods). When it does occur, much of the move may already be priced in by the time the data is published.

### Signal 2: FII Turning Net Buyer After Sustained Selling

**Pattern:** FII have been net sellers for 10+ trading days (or a full month) and then post 3+ consecutive days of net buying.

**What it means:** The selling pressure that was weighing on markets has exhausted. FII have either completed their de-risking or are re-entering based on improved valuations/outlook. This is often the start of a new uptrend.

**How to confirm:**
- FII net buying days should show increasing magnitude (Day 1: +500cr, Day 2: +1,200cr, Day 3: +2,000cr).
- Nifty should be breaking above the range it was stuck in during the selling phase.
- USD/INR should be stabilizing or declining.
- FII derivative data should show long buildup in index futures.

**Historical success rate:** FII regime transitions from seller to buyer have preceded Nifty rallies of 3-8% over the following month approximately 70% of the time.

**Caveats:** False starts happen. FII may buy for 2-3 days and then resume selling. Always wait for confirmation (5+ days of buying or MTD turning positive) before considering this a regime change.

### Signal 3: DII Buying Accelerating During FII Selling

**Pattern:** FII are selling, but DII buying is not only absorbing FII outflow but exceeding it, resulting in net positive institutional flow.

**What it means:** Domestic institutions see value at current levels that FII are missing. DII buying exceeding FII selling suggests the market has strong domestic demand support and the selling is being treated as a buying opportunity by domestic money managers.

**How to confirm:**
- Calculate absorption rate: (DII Net / abs(FII Net)) > 100%.
- Nifty should be holding support levels or forming a base.
- SIP flow data should be stable or growing.
- Check if MF cash levels are declining (indicating deployment).

### Signal 4: FII Net Buying with Rising Gross Activity

**Pattern:** FII Net is positive, and Gross Buy is significantly higher than the 20-day average.

**What it means:** FII are not just passively buying; they are actively increasing their India allocation. High gross buy with positive net indicates conviction buying, not just short-covering or routine rebalancing.

**How to confirm:**
- FII Gross Buy should be 20-30% above the 20-day average.
- The buying should be accompanied by positive Nifty movement.
- Look for large-cap financial stocks (Bank Nifty) outperforming, as this typically indicates FII large-cap buying.

### Signal 5: FII Selling Decelerating

**Pattern:** FII remain net sellers, but the daily net selling amount is declining over 5+ days (e.g., -4,000cr, -3,000cr, -2,000cr, -1,500cr, -800cr).

**What it means:** The worst of FII selling may be over. While still negative, the declining intensity suggests exhaustion of the selling driver. This is often a precursor to Signal 2 (FII turning net buyer).

**How to confirm:**
- Plot the 5-day trend line of FII net. Slope should be turning upward (becoming less negative).
- Nifty should be stabilizing (daily declines getting smaller).
- Check the fundamental driver of selling: if the catalyst is fading (e.g., US yields stabilizing after Fed meeting), the deceleration is likely genuine.

---

## Bearish Flow Signals

The following flow patterns suggest caution or negative market outlook:

### Signal 1: Sustained FII Selling Above Significance Threshold (Strongest Bearish)

**Pattern:** FII net selling exceeds 2,000cr per day for 5+ consecutive trading days, with weekly cumulative exceeding 10,000-15,000cr.

**What it means:** FII are engaged in systematic de-risking of India exposure. This is not profit-booking or portfolio rebalancing; this is a directional call against the Indian market. Sustained selling of this magnitude typically reflects a macro-level decision (global risk-off, India downgrade, policy concern).

**How to confirm:**
- FII selling should be consistent (no days of net buying breaking the streak).
- DII should be unable to fully absorb (absorption rate < 80%).
- Nifty should be making lower lows and lower highs.
- USD/INR should be rising (INR weakening).
- India VIX should be elevated (above 16-18).

**Market impact:** When this pattern persists for 2+ weeks, Nifty typically declines 5-10% from the start of the selling phase.

**Historical examples:** October 2021 to June 2022 (prolonged FII selling), October 2024 (extreme monthly selling).

### Signal 2: DII Unable to Absorb FII Selling

**Pattern:** FII are net sellers, and DII are net buyers, but DII absorption rate is below 60% for 5+ days.

**What it means:** The selling pressure is overwhelming domestic demand. Even with strong SIP flows, the magnitude of FII selling is too large for DII to offset. This creates a net negative institutional flow, putting pressure on prices.

**How to confirm:**
- Calculate daily absorption rate: DII Net / abs(FII Net).
- If consistently below 60%, the market lacks sufficient buy-side support.
- Nifty should be declining or failing to bounce from support levels.
- Check if DII buying is actually declining (possible if MFs face redemptions in a falling market, creating a negative feedback loop).

### Signal 3: Dual Institutional Selling (Strongest Bearish, Rare)

**Pattern:** Both FII and DII are net sellers for 2+ consecutive days.

**What it means:** This is the most dangerous flow signal. When both foreign and domestic institutions are selling simultaneously, it indicates a systemic concern. There is no institutional buying support for the market.

**How to confirm:**
- Both FII and DII Net should be negative for 2+ days.
- Combined daily outflow should exceed 2,000cr.
- Market breadth should be very poor (advance-decline below 0.3:1).
- VIX should be spiking.

**Historical context:** Dual selling is extremely rare (occurred briefly during COVID March 2020, during the demonetization shock in November 2016, and during isolated panic days). It typically does not last more than 3-5 days because DII SIP flows automatically create buying.

**Action implication:** If this signal appears, extreme caution is warranted. It often coincides with 3-5% single-day or multi-day market crashes.

### Signal 4: FII Selling Accelerating

**Pattern:** FII daily net selling is increasing in magnitude over 5+ days (e.g., -1,500cr, -2,200cr, -3,000cr, -4,500cr, -5,800cr).

**What it means:** The selling is not a one-time adjustment; it is intensifying. Each day, more capital is leaving. This suggests the underlying driver is worsening (e.g., escalating geopolitical crisis, accelerating rate hikes, deteriorating India macro).

**How to confirm:**
- Plot the 5-day trend of FII net. Slope should be steepening downward.
- Look for the catalyst: news flow should reveal the fundamental driver.
- Check global EM flow data: if selling is India-specific, it is more bearish than if it is a broad EM phenomenon.

### Signal 5: FII Buying Exhausting After Brief Return

**Pattern:** After a period of selling, FII bought for 2-3 days, then reverted to selling.

**What it means:** The initial buying was likely short-covering, month-end rebalancing, or a reactive bounce, not a genuine change in positioning. The quick reversion suggests the structural selling driver is intact.

**How to confirm:**
- The 2-3 buying days should have had declining magnitude.
- Nifty should have failed to sustain the bounce.
- FII derivative data should still show net short or declining long positions.

---

## Neutral Flow Signals

### Signal 1: Mixed Flows with Low Absolute Values

**Pattern:** FII and DII alternate between small net buying and selling days. Absolute daily net values are below 1,000cr for both.

**What it means:** Neither FII nor DII have a strong directional view. Institutional money is in wait-and-watch mode. This typically occurs:
- Between major events (between Fed meetings, between earnings seasons)
- When valuations are fair (not cheap enough to buy aggressively, not expensive enough to sell)
- During holiday-impacted low-volume weeks

**Market implication:** Nifty is likely range-bound. Direction will be driven by stock-specific factors, news flow, or retail activity.

### Signal 2: FII and DII Flows Offsetting Exactly

**Pattern:** FII net selling approximately equals DII net buying (or vice versa) consistently. Combined net is near zero.

**What it means:** A liquidity equilibrium. Foreign money leaving is being precisely replaced by domestic money. The market finds a price level where both sides are comfortable.

**Market implication:** Nifty consolidates in a range. Breakout will occur when one side changes behavior (FII stops selling, or DII buying slows).

### Signal 3: High Gross Activity but Low Net

**Pattern:** FII Gross Buy and Gross Sell are both very high (say, 12,000-15,000cr each), but Net is close to zero.

**What it means:** Heavy institutional churning and sector rotation. FII are actively buying some stocks/sectors while selling others. The overall allocation to India is not changing, but the composition is shifting.

**Market implication:** Index may be stable, but significant sector/stock-level moves. Look for which sectors are seeing FII buying (will outperform) and which are seeing selling (will underperform).

---

## Combining Flows with Market Breadth and Technical Levels

Flow data becomes much more powerful when combined with other market indicators:

### Flow + Market Breadth

| FII Flow | Market Breadth (A/D) | Interpretation |
|----------|---------------------|----------------|
| FII buying | Breadth > 2:1 | Strong broad-based rally, sustainable |
| FII buying | Breadth < 1:1 | Index-driven rally (FII buying index heavyweights), narrow, fragile |
| FII selling | Breadth > 1.5:1 | Market resilient despite FII selling (DII/retail buying breadth stocks) |
| FII selling | Breadth < 0.5:1 | Broad-based decline, high risk |

### Flow + Nifty Technical Levels

**FII buying at Nifty support levels:** Very bullish. Smart money is buying at technically significant levels, likely to trigger a bounce.

**FII selling at Nifty resistance levels:** Bearish. FII are selling into strength, which suggests the resistance level will hold and Nifty may pull back.

**FII buying as Nifty breaks above resistance:** Momentum signal. FII buying into a breakout suggests the move is likely to sustain.

**FII selling as Nifty breaks below support:** Capitulation signal. FII selling into a breakdown amplifies the move and suggests lower levels.

### Flow + VIX (India VIX)

| FII Flow | VIX Level | Interpretation |
|----------|-----------|----------------|
| FII buying | VIX < 13 | Complacent buying; late-stage rally |
| FII buying | VIX 13-18 | Healthy buying; sustainable trend |
| FII selling | VIX 18-25 | Elevated fear, but not panic; watch for DII absorption |
| FII selling | VIX > 25 | Panic selling; potential capitulation and reversal zone |

### Flow + Nifty PE Valuation

| FII Flow | Nifty Trailing PE | Interpretation |
|----------|--------------------|----------------|
| FII buying | PE < 18 | Value buying; strong fundamental support |
| FII buying | PE 18-22 | Fair-value buying; earnings-driven |
| FII buying | PE > 22 | Momentum/FOMO buying; elevated risk |
| FII selling | PE > 22 | Valuation-driven selling; rational de-risking |
| FII selling | PE < 18 | Forced selling (panic/redemptions); potential bottom |

---

## Common Mistakes to Avoid

### Mistake 1: Over-Reacting to Single-Day Data

**The error:** Seeing "FII sold 4,000cr today" and concluding the market will crash.

**Why it is wrong:** Single-day data is noisy. A large daily sell number can be caused by:
- A single block deal (PE fund selling stake)
- Derivative expiry-related hedging adjustments
- Quarterly rebalancing by a large FPI
- IPO/OFS settlement flows

**Correct approach:** Always look at the 5-day and 10-day rolling sum. A single day of -4,000cr followed by +2,000cr and +1,500cr the next two days is a net -500cr over 3 days, which is noise. The trend matters, not the individual data point.

### Mistake 2: Ignoring Derivative Market Flows

**The error:** Forming a view solely based on cash market FII/DII data.

**Why it is wrong:** FII derivative positions are often a leading indicator. FII may be net buyers in cash but building short positions in index futures (hedging their portfolio). The cash buying looks bullish, but the net exposure (cash + derivatives) may be neutral or bearish.

**Correct approach:** Always check FII derivative data (available from NSE Participant-wise OI data) alongside cash flow data. Key metric: FII net long/short contracts in index futures.

### Mistake 3: Treating All FII as One Entity

**The error:** Assuming "FII are selling" means all foreign investors share the same bearish view.

**Why it is wrong:** FII/FPI includes thousands of entities with different strategies, mandates, and time horizons. Global pension funds have different views than EM hedge funds. Passive ETFs rebalance mechanically while active funds make discretionary calls. Aggregate data masks significant heterogeneity.

**Correct approach:** When possible, differentiate between categories:
- Are passive funds selling (MSCI rebalancing)? This is temporary and mechanical.
- Are active EM funds selling? This may reflect a genuine bearish view.
- Is selling concentrated in one category? Check NSDL FPI category-wise data for monthly breakdowns.

### Mistake 4: Linear Extrapolation of Trends

**The error:** FII sold 20,000cr this week, so they will sell 20,000cr next week too, and the market will fall further.

**Why it is wrong:** FII flows can reverse rapidly. The driver of selling may resolve (Fed becomes dovish, geopolitical tension eases), or prices may fall enough to make India attractive again. Flow trends are mean-reverting, not permanent.

**Correct approach:** Instead of extrapolating, identify the catalyst for the current flow pattern and assess whether it is strengthening or weakening. If the catalyst is fading, expect flows to moderate or reverse.

### Mistake 5: Confusing Correlation with Causation

**The error:** FII bought, and Nifty rose, therefore FII buying caused the rally.

**Why it is wrong:** Both FII buying and Nifty rising may be caused by a third factor (positive earnings, rate cut, global risk-on). FII buying is also partly reactive: when markets rise, FII may buy more to increase allocation to a performing market.

**Correct approach:** Use FII flow data as one input among many. Combine with fundamental analysis, technical analysis, macro data, and sentiment indicators to form a holistic view.

### Mistake 6: Ignoring the Calendar

**The error:** Treating FII selling on MSCI rebalancing day or F&O expiry week the same as regular selling.

**Why it is wrong:** Certain calendar events create mechanical flows that do not reflect genuine positioning changes:
- MSCI/FTSE quarterly rebalancing (February, May, August, November) triggers passive FII flows.
- F&O monthly expiry (last Thursday) creates hedging-related cash market flows.
- Quarterly earnings season triggers stock-specific institutional activity.
- March (FY end) triggers tax-related and rebalancing flows.

**Correct approach:** Flag these calendar events and interpret flow data accordingly. Flows during these periods may be larger in absolute terms but less meaningful directionally.

### Mistake 7: Not Adjusting for Market Cap Growth

**The error:** Comparing FII selling of 10,000cr/month in 2015 with the same figure in 2025 as equally significant.

**Why it is wrong:** Indian market capitalization has roughly quadrupled from approximately 100 lakh crore in 2015 to approximately 400 lakh crore in 2025. The same absolute flow represents a much smaller percentage of the market.

**Correct approach:** Express flows as a percentage of market cap, or at minimum, adjust significance thresholds over time. A flow of 10,000cr/month was 0.1% of market cap in 2015 but only 0.025% in 2025.

---

## FII Derivative Positions as Leading Indicator

### Why Derivative Data Matters

FII derivative positions in Indian markets provide a critical leading signal for cash market flows:

1. **Derivatives allow leverage**: FII can express large directional views through futures with only margin capital. Changes in derivative positions amplify the signal from cash market data.

2. **Derivatives precede cash**: FII typically establish derivative positions before deploying or withdrawing cash. A buildup of FII long positions in index futures often precedes cash market buying by 1-5 trading days.

3. **Put-Call Ratio (PCR)**: FII activity in index options (Nifty/Bank Nifty puts and calls) provides sentiment information. High FII put buying suggests hedging/bearishness; high FII call buying suggests bullishness.

### Key Derivative Metrics to Track

**FII Index Futures Net OI (Open Interest):**
- This is the single most important derivative metric.
- Net long (more long contracts than short contracts) = FII bullish on market direction.
- Net short (more short contracts than long contracts) = FII bearish on market direction.
- The absolute number of contracts and the daily change both matter.

**FII Index Futures Long/Short Ratio:**
- Ratio = Long contracts / Short contracts.
- Above 1.0 = net long (bullish). Above 2.0 = strongly bullish.
- Below 1.0 = net short (bearish). Below 0.5 = strongly bearish.
- Historical average is approximately 0.6-0.8 (FII tend to maintain a slight net short as hedging for their long cash positions).

**FII Stock Futures Net OI:**
- FII net long in stock futures indicates bullish positioning on specific stocks.
- FII net short in stock futures indicates bearish single-stock views or hedging.
- Stock futures are less reliable as a directional indicator than index futures because they include hedging positions.

**FII Index Options Activity:**
- FII call buying: Bullish or upside hedging.
- FII put buying: Bearish or downside hedging.
- FII put writing: Bullish (selling insurance = confident market won't fall).
- FII call writing: Bearish (selling upside = confident market won't rally).

### Interpreting Derivative Data Alongside Cash Flows

| Cash Flow | Derivative Position | Combined Interpretation |
|-----------|-------------------|----------------------|
| FII cash buying | FII index futures net long increasing | Strongly bullish. Cash + derivative alignment. |
| FII cash buying | FII index futures net short increasing | Cautious. Buying cash but hedging via futures. Net exposure may be neutral. |
| FII cash selling | FII index futures net short increasing | Strongly bearish. Selling cash + adding derivative shorts. |
| FII cash selling | FII index futures net long increasing | Complex. May be selling expensive large-caps and buying index futures (relative value trade). Less bearish than it appears. |
| FII cash neutral | FII index futures net long increasing | Moderately bullish. Positioning via derivatives before cash deployment. Watch for cash buying to follow. |
| FII cash neutral | FII index futures net short increasing | Moderately bearish. Hedging or building bearish positions without selling cash (may be locked in due to disclosure thresholds). |

### Where to Find FII Derivative Data

- **NSE Daily Reports**: "Participant-wise Trading in Equity Derivatives" published daily after market hours.
- **NSE FII Derivative Statistics**: Aggregate FII long/short contracts in index futures, stock futures, index options, and stock options.
- **MoneyControl/Trendlyne**: Aggregated FII derivative data with historical charts.

---

## Quick Reference Decision Matrix

Use this matrix for rapid assessment of the institutional flow environment:

| # | FII Cash | DII Cash | FII Derivatives | Market Regime | Nifty Outlook | Confidence |
|---|----------|----------|-----------------|---------------|---------------|------------|
| 1 | Strong buy (>2000cr/day) | Buy | Net long increasing | Dual buying | Bullish | High |
| 2 | Strong buy | Sell | Net long increasing | FII-driven rally | Bullish (narrow) | Medium |
| 3 | Strong sell (<-2000cr/day) | Strong buy (absorbing >80%) | Net short | DII absorption | Range-bound | Medium |
| 4 | Strong sell | Buy (absorbing <60%) | Net short increasing | Bearish pressure | Bearish | High |
| 5 | Strong sell | Sell | Net short increasing | Dual selling (rare) | Strongly bearish | Very High |
| 6 | Mild sell (-500 to -2000cr) | Mild buy | Neutral | Mild headwind | Slightly negative | Low |
| 7 | Neutral (<500cr either way) | Neutral | Neutral | No signal | Directionless | Very Low |
| 8 | Turning from sell to buy | Buy | Long building | Transition to bullish | Positive bias | Medium |
| 9 | Turning from buy to sell | Sell | Short building | Transition to bearish | Negative bias | Medium |

---

## Practical Examples

### Example 1: Reading a Bullish Flow Setup

**Data observed:**

| Date | FII Net | DII Net | Nifty Close | Nifty Change |
|------|---------|---------|-------------|-------------|
| Day 1 | +1,200 | +800 | 22,400 | +0.6% |
| Day 2 | +2,300 | +1,100 | 22,650 | +1.1% |
| Day 3 | +1,800 | +600 | 22,730 | +0.4% |
| Day 4 | +3,100 | +400 | 22,900 | +0.7% |
| Day 5 | +2,500 | +900 | 23,050 | +0.7% |

**Interpretation:**
- FII have been net buyers for 5 consecutive days (cumulative: +10,900cr). This crosses the significance threshold for a weekly sum.
- DII are also net buyers, though with smaller amounts (cumulative: +3,800cr). Dual buying regime.
- FII buying magnitude is increasing (1,200 to 3,100), suggesting accelerating conviction.
- Nifty has responded positively each day, confirming flow-price alignment.
- Combined 5-day inflow: +14,700cr. This is very strong.

**Assessment:** This is a Signal 1 (Dual Institutional Buying) bullish pattern. The trend is strong and accelerating. Expect continued upside unless a major external catalyst disrupts.

**What to watch:** FII derivative data should confirm this (net long increasing). If FII are buying cash but their derivative longs are not increasing, the buying may be short-term (MSCI rebalancing, month-end flows).

### Example 2: Reading a Bearish Flow Setup

**Data observed:**

| Date | FII Net | DII Net | Nifty Close | Nifty Change |
|------|---------|---------|-------------|-------------|
| Day 1 | -2,800 | +1,500 | 23,800 | -0.8% |
| Day 2 | -3,500 | +2,200 | 23,550 | -1.0% |
| Day 3 | -4,200 | +2,800 | 23,300 | -1.1% |
| Day 4 | -5,100 | +3,100 | 22,950 | -1.5% |
| Day 5 | -4,800 | +2,600 | 22,700 | -1.1% |

**Interpretation:**
- FII selling is heavy and accelerating (2,800 to 5,100), crossing the extreme threshold.
- DII buying is increasing in response (counter-cyclical behavior from SIPs and value-buying).
- Absorption rate: Day 1: 54%, Day 2: 63%, Day 3: 67%, Day 4: 61%, Day 5: 54%. DII are absorbing only 54-67%, insufficient to prevent decline.
- Nifty is making lower lows each day, with selling pressure increasing.
- Cumulative 5-day FII outflow: -20,400cr. Cumulative DII inflow: +12,200cr. Net institutional outflow: -8,200cr.

**Assessment:** This is a Signal 1 (Sustained FII Selling) + Signal 2 (DII Unable to Absorb) bearish pattern. The trend is strongly negative and intensifying. Nifty likely to see further 3-5% downside unless FII selling decelerates.

**What to watch:** Track the catalyst (likely global, such as US rate hike or geopolitical event). If the catalyst shows signs of resolution, FII selling may peak. Look for a day where FII selling drops below 2,000cr as a potential deceleration signal. Also monitor DII: if DII buying starts to decline (SIP flow slowing, MF redemptions increasing), the downside risk multiplies.

### Example 3: Reading a Transition Setup

**Data observed:**

| Date | FII Net | DII Net | Nifty Close | Nifty Change |
|------|---------|---------|-------------|-------------|
| Day 1 | -3,200 | +2,800 | 21,800 | -0.9% |
| Day 2 | -2,100 | +1,900 | 21,700 | -0.5% |
| Day 3 | -800 | +600 | 21,750 | +0.2% |
| Day 4 | +400 | +300 | 21,850 | +0.5% |
| Day 5 | +1,200 | +500 | 22,000 | +0.7% |

**Interpretation:**
- FII selling decelerated from -3,200 to -800, then turned to net buying (+400, +1,200).
- This is a textbook transition from seller to buyer regime.
- DII buying also decreased in tandem (less need to absorb as FII selling reduced).
- Nifty has found a base around 21,700 and is beginning to recover.
- The transition took 5 days, with Day 3 being the pivot day (FII selling below noise threshold).

**Assessment:** This is a Signal 2 (FII Turning Net Buyer After Sustained Selling) bullish transition. If FII buying continues for 2-3 more days, this confirms a regime change.

**What to watch:** Day 6 and Day 7 are critical. If FII net remains positive and above +1,000cr, the regime change is confirmed. If FII revert to selling on Day 6, it was a false start (Signal 5 bearish). Also check FII derivative positions: if index futures longs are increasing, the transition is genuine.

### Example 4: Reading a Churning/Rotation Setup

**Data observed:**

| Date | FII Gross Buy | FII Gross Sell | FII Net | DII Net | Nifty Change |
|------|-------------|--------------|---------|---------|-------------|
| Day 1 | 14,500 | 14,200 | +300 | -100 | +0.1% |
| Day 2 | 15,200 | 15,800 | -600 | +400 | -0.2% |
| Day 3 | 13,800 | 13,500 | +300 | +200 | +0.3% |
| Day 4 | 16,100 | 15,900 | +200 | -300 | -0.1% |
| Day 5 | 14,900 | 14,600 | +300 | +100 | +0.2% |

**Interpretation:**
- FII Net is minimal (between -600 and +300). Noise-level directional flow.
- However, FII Gross Buy and Gross Sell are both very high (13,500-16,100cr range). Normal gross activity for FII is approximately 8,000-12,000cr.
- This elevated gross activity with low net means heavy sector/stock rotation. FII are actively reallocating within their India portfolio.
- DII flows are also minimal and mixed.
- Nifty is essentially flat.

**Assessment:** This is a Signal 3 (High Gross Activity, Low Net) neutral pattern. No directional signal for Nifty. The important action is happening at the sector/stock level.

**What to investigate:** Use stock-level data (if available) or sector index performance to identify where FII are rotating. For example, if Bank Nifty is outperforming while IT index is underperforming, FII may be rotating from IT to Financials.