FII and DII Data: Reading Participant Activity in Indian Markets

What actually gets published

Two distinct datasets get conflated constantly. The first is the cash-market provisional figure released shortly after the close, showing net buying or selling by foreign institutional investors and domestic institutional investors in equities. It is provisional and gets revised.

The second is participant-wise data covering the derivatives segment, which breaks open interest and turnover down across four categories: foreign institutional investors, domestic institutional investors, proprietary traders, and clients. This one is far more informative for anyone trading F&O, and far less widely quoted.

The headline number circulating on social media within minutes of the close is almost always the provisional cash figure alone. On its own it says nothing about how those same institutions are positioned in derivatives, and the two frequently point in opposite directions for entirely legitimate reasons.

The index futures long-short ratio

Of everything published, the foreign institutional long-short ratio in index futures is the number most worth tracking. It compares long index-futures positions held by foreign institutions against their short positions, and it moves slowly enough to describe a genuine stance rather than a day's noise.

A high ratio means foreign institutions are net positioned for upside; a low ratio means they are hedged or outright bearish. What matters is not the level but the trajectory — a ratio grinding higher across two weeks is a far stronger statement than any single day's reading, however extreme.

Treat the extremes with the same caution you would apply to any crowded positioning measure. When the ratio reaches levels rarely seen in the past year, the position is crowded, and crowded positions unwind faster than they were built.

Why FII and DII so often disagree

It is common to see foreign institutions selling heavily while domestic institutions absorb every share, or the reverse. This is not a contradiction and neither side is wrong.

The two groups face different mandates and different constraints. Foreign flows respond to global risk appetite, dollar strength, relative allocation between emerging markets, and rate expectations abroad. Domestic flows are driven substantially by systematic retail inflows into mutual funds, which arrive on a schedule largely independent of what happens on any given day.

That structural difference is why domestic institutions frequently act as the buyer of last resort during foreign outflows. When you see sustained foreign selling met by matching domestic buying, the market is absorbing supply rather than collapsing — the tape often chops sideways rather than trending, because two large flows are cancelling.

What the data cannot tell you

The published figures are net aggregates across an entire category. They collapse thousands of separate decisions into one number and discard everything that made those decisions distinguishable.

• No timing — a large net figure could be one block at the open or steady accumulation all day.
• No intent — hedged, arbitrage and delta-neutral positions are counted identically to directional bets.
• No breakdown — one fund reversing a large position can dominate an entire category's number.
• No intraday use — everything arrives after the close, so none of it helps you during the session.
• Revisions — provisional cash figures change, sometimes materially.

The arbitrage caveat deserves particular attention in Indian markets. A substantial share of foreign derivatives activity is cash-futures arbitrage rather than a directional view. A large short position in index futures held against a matching long cash position is market-neutral, but it appears in the data as a short. Reading it as bearish is a straightforward error.

Using it well

This data is context, not a trigger. It arrives after the close, so by construction it cannot generate an entry. What it can do is tell you which side of the market has been quietly accumulating over recent weeks, which is genuinely useful for deciding whether to favour long or short setups over the coming days.

The workflow that respects the data's limitations is simple: track the series weekly rather than daily, plot it against price to see whether flow is confirming or diverging from the trend, and treat any single day's extreme as noise until the following days repeat it.

• Track rolling weekly or fortnightly sums, never a single day in isolation.
• Prefer participant-wise derivatives data over the provisional cash headline.
• Watch the foreign index-futures long-short ratio for medium-term bias.
• Remember that a large part of foreign derivatives activity is arbitrage, not direction.
• Never let after-close data override what price is doing in front of you.

Where the data comes from

All of it is published by the exchanges and is free. NSE releases provisional cash figures shortly after the close and full participant-wise reports later in the evening. The equivalent BSE data is published on its own site, and the two must be added together for a complete picture — quoting NSE numbers alone understates total activity.

One practical note: the reports are daily snapshots, not a maintained time series. Building anything useful means collecting them day after day and storing the history yourself, which is why most traders end up relying on a platform that has already done that collection.