Which MCP server has FII and DII flow data for India?

What do people mean by FII and DII data?

FII stands for foreign institutional investors and DII for domestic institutional investors. The phrase covers four different datasets. They differ in what they measure and how often they update, so they live in separate tools.

How do I get daily FII and DII cash flow?

get_market_fii_dii_flow returns one row per trading day with FII and DII buy, sell and net values in rupees crore. Net equals buy minus sell. That is the only arithmetic applied. The same data drives the FII and DII page on this site.

On 28 October 2026 the row also carries the inputs: FII buy 16,834.53 and sell 15,962.70, DII buy 17,240.90 and sell 16,597.55. FII net is 16,834.53 minus 15,962.70, which is 871.83. There are no rows for 24 and 25 October because those were a weekend. A negative net means sales exceeded purchases that day.

Is there FII flow by sector?

Yes, fortnightly. get_sector_fpi_investment returns NSDL’s Fortnightly Sector-wise FPI Investment report. Each row has the fortnight start and end, the sector, net investment and assets under custody in both rupees crore and US dollars million, as NSDL published them. It covers every FPI across both depositories (NSDL and CDSL). The browsable version is on the FPI sector investment page.

“Grand Total” is NSDL’s own all-sector row. For the fortnight ending 15 October 2026 it also shows net investment of USD -5,044 million and assets under custody of rupees 65,94,378 crore. Do not add the Grand Total row to the sector rows.

You can ask for one sector. For the sector “Financial Services”, equity, the three most recent fortnights returned these net values in rupees crore:

Sector labels follow BSE’s Common Industry Classification from 30 April 2022. Earlier reports use NSDL’s older sector list, so sectors do not compare across that break. The sector labels are NSDL’s own and may differ from the sector shown for a company in other DalalOS tools.

Where are the daily sector and stock FII flows?

get_sector_fii_flow and get_stock_fii_flow read a CDSL trade-wise feed. CDSL stopped publishing it after March 2025. On 29 October 2026 we called both tools:

• get_sector_fii_flow with the default last-30-days window returned zero rows. The response reports dataset_status: discontinued, latest_data_date: 2025-03-28 and the discontinuation after 31 March 2025.
• get_stock_fii_flow for RELIANCE over 7 days returned an empty series and no summary, with the same discontinued status and the same latest data date of 28 March 2025.

The feed also covered CDSL only, never NSDL, so even before it stopped it was a partial view. We did not query dates before March 2025 for this page, so we state only what the status fields say: the last data date is 28 March 2025.

How do I get FII and DII positions in futures and options?

get_fo_participant_activity returns NSE’s participant-wise table. Each row is one trade date and one client type (FII, DII, Pro, Client or TOTAL). A row has two blocks, oi for open interest and volume, each with long and short contract counts for index futures, stock futures, and index and stock call and put options, plus total_long and total_short. The counts are raw. This is a separate dataset from the cash-market flow above.

We called it with days=1. It returned 10 rows: five client types for each of two trade dates, 27 and 28 October 2026. So a one-day window can return more than one date. The FII row for 28 October 2026 looked like this:

{
  "trade_date": "2026-10-28",
  "client_type": "FII",
  "oi": {
    "fut_idx_long": 35808,
    "fut_idx_short": 270850,
    "fut_stk_long": 3578447,
    "fut_stk_short": 2704517,
    "opt_idx_call_long": 523927,
    "opt_idx_put_long": 972837,
    "opt_idx_call_short": 838851,
    "opt_idx_put_short": 477895,
    "opt_stk_call_long": 105308,
    "opt_stk_put_long": 164434,
    "opt_stk_call_short": 168879,
    "opt_stk_put_short": 98280,
    "total_long": 5380761,
    "total_short": 4559272
  },
  "volume": { "total_long": 5669837, "total_short": 5814245 }
}

Where do I find FII and DII holding percentages?

get_shareholding returns the promoter, FII, DII and public holding percentages by quarter for one company, from the shareholding pattern it files with BSE. A detail block adds pledged percentage and number of shareholders. A breakdown block splits the institutions into categories such as mutual funds, insurers, and Foreign Portfolio Investors Category I and II, and names individual holders above the reporting threshold. This is a quarterly holding, not a daily trade.

For Reliance Industries (RELIANCE) the latest period was 30 September 2026: promoter 50.44%, FII 16.67%, DII 21.72%, public 49.56%. The previous period, 30 June 2026, showed FII 17.20% and DII 21.19%. The data was cached on 21 October 2026.

{
  "nse_symbol": "RELIANCE",
  "period_end": "2026-09-30",
  "promoter_pct": 50.44,
  "fii_pct": 16.67,
  "dii_pct": 21.72,
  "public_pct": 49.56,
  "breakdown": {
    "institutions": [
      { "category": "Mutual Funds", "pct": 10.31 },
      { "category": "Insurance Companies", "pct": 9.47 },
      { "category": "Foreign Portfolio Investors Category I", "pct": 15.98 },
      { "category": "Foreign Portfolio Investors Category II", "pct": 0.52 }
    ]
  }
}

There is also a page on shareholding and promoter pledge.

Which tool answers which question?

• How much did FIIs and DIIs buy and sell in the cash market yesterday? Use get_market_fii_dii_flow.
• How much net foreign money went into a sector over a fortnight? Use get_sector_fpi_investment.
• How many index futures contracts are FIIs long and short? Use get_fo_participant_activity.
• What share of one company do FIIs hold? Use get_shareholding.

How do I ask for it?

To set it up, connect your AI, or follow the guide for Claude, ChatGPT or Cursor and other AI tools. The server is at https://mcp.dalalos.in/mcp. The code and docs are public: DalalOS-Indian-Stock-Research on GitHub.

How we checked

On 29 October 2026 we called get_market_fii_dii_flow, get_sector_fpi_investment, get_fo_participant_activity, get_shareholding, get_sector_fii_flow and get_stock_fii_flow on the live server. The daily table and the Grand Total fortnights come from calls made on the same day. Cache times are given beside each table. Figures change as sources publish. This is research data, not investment advice, and DalalOS does not rank or rate stocks. Found an error? Email hello@dalalos.in.