FII and DII Daily Net Flows in Indian Markets

What FII and DII Actually Mean on the NSE Provisional Report

A Foreign Institutional Investor (FII), in the data you read every evening, is a foreign-registered fund, pension, sovereign wealth fund, hedge fund or insurance pool buying and selling Indian securities through a SEBI-registered route. Since 2014 these entities are formally classified by SEBI as Foreign Portfolio Investors (FPI), but the exchange and the financial press still print the label FII out of habit. A Domestic Institutional Investor (DII) is an Indian-domiciled pool: mutual funds, insurance companies like LIC, banks, pension funds and the NPS corpus. When you see a line such as FII net sold Rs 3,200 crore and DII net bought Rs 4,100 crore, those are real money flows settled on the NSE and BSE that day.

The figure is computed simply. NSE adds up the rupee value of every share an FII bought in the cash segment, subtracts the rupee value of every share an FII sold, and prints the difference. A positive number means net buying and net inflow. A negative number means net selling and net outflow. The DII line is the same arithmetic for domestic institutions. These are cash segment figures only. The same institutions also trade index futures, stock futures, index options and stock options, and NSE reports that derivatives activity in a completely separate table that most retail traders never open.

Why does the distinction matter for you as a trader? Because the cash flow and the derivatives flow can point in opposite directions on the same day. FIIs can dump Rs 5,000 crore of cash equity while simultaneously building long positions in Nifty futures because they are hedging or rotating. If you read only the scary cash number you can be positioned exactly wrong. Always treat the daily FII cash figure as one input, not a trading signal on its own.

Where the Daily Rupee Crore Numbers Come From and When

NSE publishes the FII and DII trading activity on its website under Market Data, with cash segment figures released as provisional data at roughly 6 PM IST after the cash market closes at 3:30 PM. BSE publishes a parallel set. These provisional numbers are what financial channels flash by evening. The next business morning the exchange replaces them with finalised settlement figures, and separately the depositories NSDL and CDSL publish the official FPI flow, which is the cleanest long-term record because it captures primary market and bulk deal activity the intraday provisional number can miss.

The provisional and final numbers are usually close but not identical. It is normal for a provisional FII figure of minus Rs 2,000 crore to settle at minus Rs 2,350 crore once block deals and corrections are folded in. For day-to-day sentiment the provisional number is fine. For building a serious flow model or a backtest, use the finalised NSDL FPI series so your data is not contaminated by intraday revisions.

Illustrative Daily Net Flow Figures in Rupee Crore

The table below shows the shape and scale of typical daily provisional cash flows seen across 2024 and 2025, a period when FIIs were structurally heavy sellers and DIIs were the buyers of last resort. Treat these as illustrative ranges for understanding magnitude, not as a record of one specific date. On a calm day net flows on either side sit in the low thousands of crore. On a panic day or an expiry day they can spike to Rs 10,000 crore or more on a single side.

The pattern that defined 2024 and 2025 is the negative-FII, positive-DII row repeating for weeks at a time. Foreign money left on a strong US dollar and high US bond yields, while relentless domestic SIP inflows into Indian mutual funds, running well above Rs 20,000 crore a month, gave DIIs the firepower to keep buying. That is the structural reason Nifty did not collapse despite tens of thousands of crore in cumulative FII outflows.

Reading the FII Derivatives Book Alongside the Cash Number

Serious traders watch the FII index futures long-short ratio far more than the cash headline. NSE publishes, in the participant-wise open interest report, how many index future contracts FIIs hold long versus short. When FIIs are net long index futures, say 70 percent of their index future positions are on the long side, the smart money is positioned for upside even if the cash number printed negative that day. When that ratio collapses toward 30 percent long, foreigners are betting on a fall.

This is the cleanest way to resolve the contradiction described earlier. Cash selling plus derivatives buying often means rotation or hedging, not a directional bear bet. Cash selling plus a falling futures long ratio is a genuine bearish alignment and deserves your attention. Layer the two reports and you get a far higher quality read than the evening TV headline alone.

• FII cash net positive and FII index futures long ratio rising: strongest bullish alignment.
• FII cash net negative but futures long ratio rising: likely rotation or hedging, not outright bearish.
• FII cash net negative and futures long ratio falling: genuine bearish conviction, tighten risk.
• DII consistently positive under FII selling: domestic floor under the market, supports buy-on-dip.

A Worked Nifty Example Using a Flow-Driven Bias

Here is a fully worked, illustrative example of how a trader might act on flow data. Suppose the evening NSE provisional report shows FII cash net minus Rs 1,100 crore but the participant report shows FIIs added to net long index futures, pushing their long ratio up. DIIs are net buyers at plus Rs 2,400 crore. You read this as cash selling being absorbed domestically while foreigners quietly position long, a mildly bullish setup. Nifty spot is at 23,500.

You buy one lot of a weekly Nifty 23,600 call option. The Nifty lot size is 65. The premium is Rs 90 per share, so your outlay is 90 times 75, which is Rs 6,750 plus charges. Over the next two sessions DII buying continues and Nifty rallies to 23,850. The 23,600 call premium rises to Rs 230. You exit. Your gross gain is (230 minus 90) times 75, which is 140 times 75, equal to Rs 10,500 before costs.

Now the costs, because this is options and India taxes them as business income, not capital gains. STT on options is charged at 0.1 percent of premium on the sell side, so 0.1 percent of (230 times 75 equals Rs 17,250) is about Rs 17. Brokerage at a typical Rs 20 per order flat, two legs, is Rs 40. Add exchange transaction charges, GST at 18 percent on brokerage and charges, SEBI fees and stamp duty, and your all-in cost is roughly Rs 90 to Rs 110. Net profit lands near Rs 10,400. Because F&O is business income, that profit is added to your total income and taxed at your slab rate, and the whole turnover must be reported in your ITR-3, even on a winning trade.

Why DII Buying Held the Market Up While FIIs Sold

The most important market structure shift of the last few years is the rise of the Indian retail investor channelled through DIIs. Monthly SIP inflows into mutual funds crossed Rs 20,000 crore and kept climbing. That money arrives on the first few working days of every month regardless of what the Nifty did yesterday, which gives DIIs a predictable, price-insensitive buying engine. When FIIs sold Rs 6,000 crore on a risk-off day, DIIs frequently bought a similar or larger amount, neutralising the impact on the index.

This is why the old playbook of shorting the market whenever FIIs turn net sellers stopped working. In earlier cycles, heavy FII selling reliably tanked the Nifty because there was no domestic counterweight. Today the domestic counterweight is structural and large. A trader who shorted purely on negative FII prints through 2024 would have been repeatedly squeezed as DII buying defended every dip. The lesson is to read both lines together, never the FII line alone.

Comparing FII and DII Behaviour Side by Side

Use this table as a mental checklist when a flow number surprises you. If FIIs sold heavily, the first question is whether the trigger was global, such as a US rate decision or a dollar spike. If DIIs bought heavily, ask whether it is month-start SIP flow or genuine conviction buying. The answer changes how much weight you should put on the number for tomorrow.

Common Mistakes Traders Make With FII and DII Data

The biggest error is treating the daily cash number as a same-day trading signal. By the time the provisional figure is published at 6 PM, the market has already closed and the move is in the past. You cannot trade on a number that describes a session that already finished. Flow data is a bias and context tool for the next session, not a real-time trigger. A second error is ignoring the derivatives book, which we covered above and which frequently tells the opposite story to the cash line.

A third error is forgetting that a single big day can be a one-off block deal, an index rebalancing such as an MSCI or FTSE adjustment, or an IPO or large QIP, none of which represent ongoing sentiment. Always look at the five-day and twenty-day cumulative FII and DII flow, not one print, before drawing a conclusion. Sustained direction over many sessions is meaningful. One spike usually is not.

• Do not trade the same-day move on a number published after the close.
• Do not read the FII cash line without checking the FII index futures long-short ratio.
• Do not confuse a one-day block deal or index rebalance with a sentiment shift.
• Do not ignore DII flow, it is the structural floor under the current market.
• Do not mix provisional NSE data with final NSDL data in the same comparison.

How to Build FII and DII Tracking Into Your Trading Routine

Make checking the provisional flow part of a fixed evening routine. After the market closes, note the FII cash net, the DII cash net, and the FII index futures long-short ratio from the participant report. Log the five-day cumulative for each. Pair this with your Nifty levels and your own open positions so you can see whether the smart money is on your side or against it before the next session opens.

Recording these numbers in a structured trading journal turns scattered evening glances into a real edge. Over a few months you will see your own patterns: maybe you do best buying dips when DIIs are net buyers and the FII futures long ratio is rising, and you bleed when you fight a falling FII long ratio. That feedback loop, not any single day's rupee crore figure, is what actually improves results.

Sources and Further Reading

Always pull the live figures yourself rather than relying on third-hand screenshots. Primary sources are NSE India for the daily provisional FII and DII cash activity and the participant-wise open interest report, NSDL for finalised FPI flow data, and SEBI for the FPI regulatory framework. Confirm current STT rates, lot sizes and tax rules on the official source before you trade, because contract specifications and rates change.

Sources and Further Reading

For authoritative data and further reading on this topic, refer to SEBI (Securities and Exchange Board of India), NSE India and NSE Indices (Nifty Indices). Always confirm current rules, rates and contract specifications on the official source before you trade.