# Fii Dii Flow Tracker

> >

- **Type:** Skill
- **Install:** `agentstack add skill-ajeeshworkspace-indian-trading-skills-fii-dii-flow-tracker`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [ajeeshworkspace](https://agentstack.voostack.com/s/ajeeshworkspace)
- **Installs:** 0
- **Category:** [Finance & Payments](https://agentstack.voostack.com/c/finance-and-payments)
- **Latest version:** 0.1.0
- **License:** MIT
- **Upstream author:** [ajeeshworkspace](https://github.com/ajeeshworkspace)
- **Source:** https://github.com/ajeeshworkspace/indian-trading-skills/tree/master/skills/fii-dii-flow-tracker

## Install

```sh
agentstack add skill-ajeeshworkspace-indian-trading-skills-fii-dii-flow-tracker
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# 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:

```python
# 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:

```python
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 ( +5000cr | Bullish for Nifty, INR strengthening |
| **FII Net Seller** | FII net negative for 5+ consecutive days or MTD 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 retail buying) or FII buying but Nifty falling (other factors dominating)

Use the calculator tool for correlation computation if needed:

```python
calculator(list_of_expressions=[
    "correlation coefficient formula components"
])
```

### Step 7: Assess Sector-Level Impact

If the user requests sector-level analysis, use web search:

```
WebSearch: "FII DII sector wise investment {current_month} {current_year}"
WebSearch: "FII portfolio allocation India sectors {current_year}"
```

Key sector dynamics:
- **Banking/Financials**: Largest FII holding, most sensitive to FII flows
- **IT Services**: Benefits from INR depreciation caused by FII outflows
- **FMCG**: DII/MF favorite, relatively insulated from FII selling
- **Oil & Gas, Metals**: Driven by global commodity + FII positioning

### Step 8: Generate the Flow Report

Use the report template from `assets/flow_report_template.md` to structure the output. Fill in all sections with the analyzed data.

Present the report in a clear, structured format with:
- Summary box at the top (today's key numbers)
- Tables for historical data
- Clear trend assessment with directional language
- Actionable implications
- Appropriate disclaimer

## Key Metrics Reference

| Metric | Calculation | Significance |
|--------|-------------|-------------|
| FII Daily Net | FII Buy - FII Sell | Direction of foreign capital flow |
| DII Daily Net | DII Buy - DII Sell | Direction of domestic capital flow |
| FII MTD | Sum of FII daily net for current month | Monthly trend strength |
| FII YTD | Sum of FII daily net for current calendar year | Annual positioning |
| DII MTD | Sum of DII daily net for current month | Monthly domestic support |
| DII YTD | Sum of DII daily net for current calendar year | Annual domestic positioning |
| FII:DII Ratio | FII Net / DII Net | Institutional alignment |
| Flow-Nifty Correlation | Statistical correlation over 20 days | Predictive strength |
| Absorption Rate | DII Net / abs(FII Net) when FII selling | DII's ability to offset FII |

## Significance Thresholds

| Level | Daily (crores) | MTD (crores) | YTD (crores) |
|-------|---------------|--------------|--------------|
| Minor |  5,000 | > 25,000 | > 1,00,000 |

## Important Notes

- FII/DII data is typically released by exchanges after market hours (around 6-7 PM IST for provisional data, next day for final data).
- There can be discrepancies between provisional and final data; always note which version is being used.
- FII data includes all Foreign Portfolio Investors (FPIs) registered with SEBI.
- DII data includes mutual funds, insurance companies, banks, and financial institutions.
- Derivative market FII positions (available from NSE) are a leading indicator and should be consulted alongside cash market data.
- Always present flows in Indian Rupee crores (the standard unit for institutional flow reporting).
- Always include a disclaimer that institutional flow data alone should not be used as the sole basis for investment decisions.

## Reference Materials

- `references/flow_analysis_methodology.md` - Comprehensive methodology for analyzing FII/DII flows
- `references/flow_interpretation_guide.md` - Practical guide for interpreting flow signals
- `assets/flow_report_template.md` - Markdown template for generating flow reports

## Tools Used

Use whichever broker MCP is connected (Groww or Zerodha Kite):

| Action | Groww MCP | Zerodha Kite MCP | Fallback |
|--------|-----------|------------------|----------|
| Nifty LTP | `get_ltp` | `get_ltp` | yfinance |
| Historical data | `fetch_historical_candle_data` | `get_historical_data` | yfinance |
| Trading calendar | `resolve_market_time_and_calendar` | — | Web search |
| Market movers | `fetch_market_movers_and_trending_stocks_funds` | — | Web search |
| Shareholding data | `fetch_stocks_fundamental_data` | — | Web search |
| Portfolio check | `get_equity_portfolio_holdings` | `get_holdings` | — |

| Tool | Purpose |
|------|---------|
| `WebSearch` | Fetch latest FII/DII data from NSDL, NSE, MoneyControl |
| `WebFetch` | Scrape specific FII/DII data pages for structured data |
| `calculator` | Compute flow ratios, correlations, and aggregates |

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [ajeeshworkspace](https://github.com/ajeeshworkspace)
- **Source:** [ajeeshworkspace/indian-trading-skills](https://github.com/ajeeshworkspace/indian-trading-skills)
- **License:** MIT

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-ajeeshworkspace-indian-trading-skills-fii-dii-flow-tracker
- Seller: https://agentstack.voostack.com/s/ajeeshworkspace
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.