/fii-dii-flow-tracker

name: fii-dii-flow-tracker
description: >
  Track and analyze FII/DII daily buy/sell flows in Indian markets.
  Use when user asks about institutional flows, FII selling/buying trends,
  DII activity, or institutional impact on Nifty/market direction.
tags:
  - india
  - fii
  - dii
  - institutional-flows
  - nifty
  - market-analysis
triggers:
  - FII
  - DII
  - institutional flow
  - foreign investor
  - domestic investor
  - FII selling
  - FII buying
  - DII buying
  - institutional activity
  - FII DII data
  - net buy
  - net sell
  - institutional impact
  - FII outflow
  - FII inflow

FII/DII Flow Tracker

Purpose

This skill tracks Foreign Institutional Investor (FII) and Domestic Institutional Investor (DII) daily buy/sell flows in Indian equity markets and correlates them with Nifty 50 movement. It provides actionable insights on institutional positioning, flow trends, regime changes, and market implications.

When to Use

Activate this skill when the user asks about:

• FII or DII daily, weekly, or monthly buy/sell data
• Institutional flow trends and their market impact
• Whether FII are net buyers or net sellers
• DII activity and mutual fund flow support
• Correlation between institutional flows and Nifty direction
• Sector-wise institutional allocation
• Impact of FII flows on INR (Indian Rupee)
• Historical institutional flow patterns during market events
• Flow regime assessment (bullish/bearish/neutral institutional positioning)

Workflow

Follow these steps in order when the user requests FII/DII flow analysis:

Step 1: Fetch Current FII/DII Flow Data

Use web search to retrieve the latest FII/DII cash market data from authoritative sources:

WebSearch: "FII DII data today {current_date} cash market net buy sell"
WebSearch: "NSDL FII activity {current_month} {current_year}"
WebSearch: "MoneyControl FII DII activity {current_date}"

Primary data sources to query:

• **NSDL** (National Securities Depository Limited): Official FII/FPI transaction data
• **NSE** (National Stock Exchange): Daily institutional trading statistics
• **MoneyControl FII/DII page**: Aggregated daily flow data with historical tables
• **CDSL** (Central Depository Services Limited): Supplementary FPI data
• **Trendlyne / Tickertape**: Pre-computed flow summaries and charts

Extract the following data points:

• FII gross buy value (in crores)
• FII gross sell value (in crores)
• FII net buy/sell value (in crores)
• DII gross buy value (in crores)
• DII gross sell value (in crores)
• DII net buy/sell value (in crores)
• Date of the data

Step 2: Fetch Historical Flow Data for Trend Analysis

Use web search to gather flow data for the trailing period:

WebSearch: "FII DII data last 10 trading days {current_month} {current_year}"
WebSearch: "FII net investment {current_month} {current_year} month to date"
WebSearch: "FII DII yearly data {current_year} year to date"

Build a table of the last 10 trading days with daily FII and DII net values.

Step 3: Fetch Nifty 50 Price Data

Use Groww MCP tools to get Nifty price data for correlation analysis:

# Get current Nifty LTP
get_ltp(search_queries=["NIFTY"], segment="CASH", query_type="stocks")

# Get historical Nifty data for correlation (last 30 trading days, daily candles)
fetch_historical_candle_data(
    trading_symbol="NIFTY",
    start_time="{30_trading_days_ago} 09:15:00",
    end_time="{today} 15:30:00",
    interval_in_minutes="1440",
    exchange="NSE",
    segment="CASH"
)

Use `resolve_market_time_and_calendar` to determine the correct trading day range:

resolve_market_time_and_calendar(
    time_period_unit="day",
    number_of_periods=30,
    period_relative_position="previous"
)

Step 4: Analyze Flow Patterns

Perform the following analyses on the collected data:

**A. Daily Flow Assessment**

• Classify today's FII flow: significant buy (> +2000cr), significant sell (< -2000cr), or neutral
• Classify today's DII flow using the same thresholds
• Compare FII vs DII: Are they aligned or divergent?

**B. Trend Analysis (10-day rolling)**

• Count net buying days vs net selling days for both FII and DII
• Calculate cumulative 10-day net flow
• Identify if selling/buying is accelerating or decelerating (compare last 5 days vs prior 5 days)

**C. Monthly and Yearly Context**

• MTD (Month-to-Date) cumulative flow for FII and DII
• YTD (Year-to-Date) cumulative flow for FII and DII
• Compare current month's pace to previous months

**D. FII:DII Flow Ratio**

• Calculate the ratio of FII net to DII net
• Positive ratio with both positive = strong bullish signal
• FII negative, DII positive = DII absorbing FII selling (support floor)
• Both negative = danger signal

Step 5: Identify Flow Regime

Classify the current institutional flow regime:

| Regime | Definition | Market Implication | |--------|------------|-------------------| | **FII Net Buyer** | FII net positive for 5+ consecutive days or MTD > +5000cr | Bullish for Nifty, INR strengthening | | **FII Net Seller** | FII net negative for 5+ consecutive days or MTD < -5000cr | Bearish pressure, INR weakening | | **DII Absorption** | FII selling but DII buying offsetting >70% of FII outflow | Market finds floor, limited downside | | **Dual Buying** | Both FII and DII net buyers for 3+ days | Strong rally likely, broad-based buying | | **Dual Selling** | Both FII and DII net sellers (rare) | Sharp correction risk, liquidity withdrawal | | **Transition Phase** | FII switching from seller to buyer (or vice versa) within last 5 days | Trend reversal potential, watch for confirmation |

Step 6: Correlate Flows with Nifty Movement

Analyze the relationship between institutional flows and Nifty price action:

• Map daily FII net flow to Nifty daily change (same day)
• Check if FII flows are leading Nifty (flow change precedes price change by 1-2 days)
• Identify divergences: FII selling but Nifty rising (DII support or