How to Read FII/DII Data (Cash & Futures) — A Beginner's Guide

Every weekday at around 6:30 PM, a quiet little report drops on the NSE website and gets screen-grabbed across thousands of trader WhatsApp groups within minutes. It is just a few rows of numbers. It does not look like much. And yet it shapes the next morning's open more than almost anything else.

This is the FII/DII data. And once you learn to read it — properly, not just the one big "net" number everybody screenshots — you start seeing the market the way institutions see it. Let me walk you through exactly what is in those reports, where to find them, and how to actually use them.

Who Are FIIs and DIIs?

Two groups of large investors dominate the Indian stock market. Together, they are among the most influential participant groups on most trading days. Retail investors like you and me account for a meaningful share too, but the institutional combined footprint usually sets the day's tone.

An easy way to remember the dynamic: FIIs often influence direction; DIIs often cushion or amplify the move. When FIIs sell hard and DIIs do not buy, you get a crash. When FIIs sell hard and DIIs absorb, you get a slow grind down. The interplay between the two is much of the story.

Why Their Daily Moves Move the Market

The simple reason: scale. When a foreign fund decides to reduce its India exposure, it does not sell ₹10 lakh worth of stock — it sells ₹10,000 crore over a few weeks. That kind of size cannot move through the order book quietly. Prices have to move to find enough buyers on the other side. The cash-market FII number is the daily evidence of that selling — or buying — happening.

Notice the pattern in the third example. In March 2026, FIIs sold the highest amount in a single month in Indian market history — more than the Covid crash. Yet Nifty fell only single-digit-to-low-teens percentages from where it could have, because DIIs absorbed a large chunk of the selling via record monthly SIP inflows. The two flows partially cancelled out. Without watching both, you would have either panicked or missed the cushion completely.

Where the Real Data Lives

One of the more frustrating things about FII/DII data is that the official version is scattered across multiple websites, each maintained by a different regulator. Here is the journey a single day's trade takes from execution to publication.

• 3:30 PM · Close

  Trading ends

  Markets close at 3:30 PM IST. Through the day, custodian banks have tagged each trade with the client's PAN, which classifies the order as FII, DII, proprietary, or retail.

• 6:00–7:00 PM · Provisional release

  NSE publishes the cash-segment FII/DII report

  The first version of the data appears on the NSE FII/DII Trading Activity page (nseindia.com/reports/fii-dii). This is the number you see screenshotted everywhere by 7 PM. Note: it is provisional, based on PANs from NSDL, and can be revised slightly after custodian confirmation.

• 7:00 PM · Futures & Options

  NSE publishes Participant-wise Open Interest

  A separate file lists the open positions of FIIs, DIIs, Pro, and Clients in index and stock futures and options. This is where the real "smart money positioning" data lives — and where most beginners never look.

• Next morning · Final FPI

  NSDL consolidates final data

  NSDL is the body that holds the depository records for foreign portfolio investors. Its FPI portal (fpi.nsdl.co.in) publishes the final, custodian-confirmed numbers — typically a day later than the NSE provisional. Same for CDSL.

• Monthly · Aggregates

  SEBI & depositories publish summaries

  SEBI's FPI statistics page aggregates the monthly and yearly figures — equity, debt, and hybrid combined. This is what financial reporters use when they write "FIIs sold ₹X crore in FY25." Long-term context, not daily signal.

Three takeaways from that flow. One, the "official" daily number you usually see is the NSE provisional. Two, the futures positioning data is a separate file most people never open. Three, by the time the data is everywhere on financial news the next morning, you are already a step behind.

Reading the Cash Market Report

This is the simpler of the two reports — and the one almost every beginner starts with. Three numbers per category, that is it. Here is what NSE's cash-segment FII/DII table looks like on any given day, with the data laid out the way it actually appears.

Three Things to Look at, Not Just One

Most beginners glance only at the net column for FIIs. That is leaving information on the table. Here is the better way to read it:

1. Gross Purchase + Gross Sale = activity. Add them up. If the total is high, institutions are moving — that day matters. If both numbers are tiny, the market is sleeping regardless of the net.
2. Net FII tells you direction of foreign flows. A negative net is selling; positive is buying. The size matters — a ₹500 crore net is a non-event, ₹5,000 crore is a meaningful day, ₹15,000+ crore is a market-moving day.
3. Net DII tells you whether there is a cushion. If DIIs are absorbing the FII sell-off, downside gets contained. If DIIs are also selling — rare, but it happens — that is a red flag.

Reading the Futures Positioning Report

If the cash report tells you what institutions did today, the futures report tells you how they are positioned — either as directional bets or as hedges against their cash holdings. This is the file most retail traders never open — and the one that carries the most signal.

The official name is the "Participant-wise Open Interest" report. NSE publishes it once a day, after market close, and it splits all open derivative positions into four buckets: FII, DII, Pro (proprietary desks at brokerages and HFT firms), and Client (retail and high-net-worth individuals). For each bucket, it shows long and short open positions in index futures, stock futures, index options, and stock options.

The Long-Short Ratio, Explained Simply

The single most useful number to pull out of this report is the FII long-short ratio in index futures. It compresses everything FIIs are doing in Nifty, Bank Nifty, and MidCap Nifty futures into one number. Here is how to read it:

• Above 2: FIIs are aggressively bullish — over two long bets for every short. The market usually has the wind at its back.
• Between 1 and 2: Constructive but not euphoric. The default "growth-mode" range.
• Around 1: Neutral. They are hedged. Sideways markets often look like this.
• Below 0.5: Clearly bearish. More than two shorts for every long. Caution.
• Below 0.2: Capitulation-level bearish. Five-plus shorts for every long. The May 2024 pre-election reading hit 0.15.

This is a multi-week sentiment indicator, not a day-trading signal. Markets can absolutely rise on a day when FIIs are net short — institutions do not always get it right, and short squeezes happen. The ratio is most useful when you watch its trend over five to ten trading days, not its absolute value on one day.

The Four FII × DII Combos Decoded

Once you have the cash data and the futures data, the daily reading boils down to a simple 2×2: what are FIIs doing in cash, and what are DIIs doing in cash? Four possible combinations, four different stories.

Now layer the futures positioning on top. If both FIIs and DIIs are buying in cash and FII long-short ratio is above 2, that is the cleanest bull signal you will ever see in this data. If both are selling and FII long-short is below 0.3, that is a fire alarm.

Four Mistakes Beginners Make Reading This Data

I see the same misreadings in student WhatsApp groups every week. Here are the four most common — and how to avoid each.

Mistake 1 · Reacting to a single day

"FIIs sold ₹3,000 crore today, I am going short tomorrow." This is the most common error and almost always wrong. Single-day flows are noisy. The market routinely rises after a heavy FII selling day. Look at the running five-day or twenty-day net — that is where the signal lives.

Mistake 2 · Reading cash, ignoring futures

You can have FIIs net buying in the cash segment and net short in futures on the same day. They are different bets — one is portfolio investment, one is hedging or directional trading. Reading only the cash report and missing the futures positioning means you are reading half a sentence.

Mistake 3 · Treating retail (Client) as smart money

The Client bucket — retail and HNI traders — is sometimes a useful contrarian indicator. When retail is heavily long and FIIs are heavily short, the setup deserves caution because institutions may be positioned against the crowd, hedging, or both. The participant-wise OI report is not "what to follow" for the Client row — at minimum it is "what to think twice about" before taking the same side.

Mistake 4 · Reading data without context

FII selling around Lok Sabha results in May 2024 was driven by political uncertainty. FII selling in March 2026 was a geopolitical and macro risk-off wave — West Asia tensions and crude above $115/bbl. FII selling in March 2020 was global pandemic panic. Same data, very different causes — and very different consequences. The number on the screen is just the symptom. Always ask: what is the macro context this number sits inside?

How to Use FII/DII Data in a Daily Market Routine

The full data set takes about 90 seconds to read once you know what you are looking at. Here is the order I personally go through, and the one we teach in the programs.

1. Check the FII cash net first. Red or green? How large versus the last few days?
2. Then DII cash net. Did DIIs absorb the FII flow, or move in the same direction?
3. Combined institutional flow. Add FII + DII net. If both are positive or both negative, that is the strongest single-day signal in the data set.
4. FII index-futures long-short ratio. Compare today's reading to the last 5–10 trading days. Tightening or loosening?
5. Cross-check with Nifty close, India VIX direction, and the advance-decline ratio. If the institutional flow and these three internals all agree, the read is high-conviction. If they conflict, the day is mixed — trade smaller, or sit out.
6. Never commit to a trade decision based on a single day's flow alone. The data informs the bias; price action and your own setup execute the trade.

In about a minute and a half, you have a far richer view of the day than the majority of retail traders, who either skip this entirely or look only at the FII net number on a news headline.