It is a quarter past six in the evening and the headline is already circulating: foreign investors sold ₹2,340 crore today, domestic institutions bought ₹1,980 crore. By eight o’clock it has been turned into a view about the direction of the market, and by the next morning somebody has built a strategy on it. The underlying number is real, published free by the exchange, and rests on a measurement whose boundaries almost nobody quoting it could describe.
A shopkeeper tells you his day was ₹630 down. It sounds like a bad day until you see the register: ₹12,480 of goods came in, ₹13,110 went out. The ₹630 is the difference between two large, busy numbers, and a small change in either would have flipped its sign entirely. It describes the residue of the day, not its character.
Every net institutional flow figure is that residue. Gross buying and gross selling are both enormous; the net is a thin difference between them, and it is the only part that reaches the headline.
Four different datasets, routinely conflated
| What is published | When | What it actually measures |
|---|---|---|
| Provisional cash-market figures for foreign and domestic institutions | The same evening, shortly after the close | Institutional buying and selling in that exchange’s cash segment, computed quickly and subject to revision |
| Final cash-market figures | The following working day | The corrected version. It differs from the provisional one often enough that a strategy built on the evening print is being built on a draft |
| Depository and regulator data on foreign portfolio investors | On its own schedule | A wider basis — it can include activity the exchange secondary-market figure never counted, such as primary issuance. This is why two credible sources report different foreign flows for the same period, and neither is wrong |
| Category-wise turnover and participant-wise open interest | Daily, with the derivatives files | Turnover and derivative positions split across foreign institutions, domestic institutions, proprietary desks and clients. Far more informative than the net cash headline and far less quoted |
The net is a thin difference between two large numbers
The bucket labelled “client”
Category-wise turnover divides all participation into foreign institutions, domestic institutions, proprietary desks and clients. Three of those are what they sound like. The fourth is everybody else — individual retail investors, high net worth individuals, corporates, family offices, partnerships and trusts, all in one residual bucket. Every sentence beginning “retail bought the dip” is an inference from a category that was never a measurement of retail.
What moves these numbers and is not a view
- Index rebalancing. When a stock enters or leaves an index, funds tracking it must transact regardless of price, and the flow lands in these figures as though it were an opinion.
- Block and bulk deals. One negotiated transaction can dominate a day’s category numbers by itself. The bulk and block deal files are published the same evening and tell you exactly which, with names attached.
- Primary market activity. Money going into a large public issue is a real institutional flow that the exchange secondary-market print does not capture at all — one of the main reasons the various published foreign-flow series disagree.
- Hedged pairs. Selling cash while carrying long index futures is one position. Read only the cash leg and you have recorded the seller and missed the trade.
- Redemptions and inflows. A domestic fund buying because savers put money in this month is not the fund manager expressing a view about Thursday.
- 1Keep the series yourself, from the exchange files
Provisional numbers get revised, and most aggregators never update the earlier row. Building your own table from the published files takes minutes a day and is the only version that stays correct.
- 2Look at a rolling window, not a day
A twenty-session cumulative line tells you whether a persistent flow is under way. A single evening tells you what one day’s residue happened to be.
- 3Read cash and derivatives together
Participant-wise open interest shows how the same categories are positioned in index and stock derivatives. Cash selling alongside a growing long futures position is a different story from cash selling alongside a growing short one.
- 4Check the same evening’s bulk and block deal file
If one disclosed transaction explains most of the day, you have the name of the buyer instead of a category — better information, published in the same place, at the same time.
- 5Decide in advance what would change your mind
Flow data is descriptive. Write down what run of it would alter a position of yours before you start watching it, or it will function as after-the-fact justification for whatever you already wanted to do.
A fourth consecutive day of foreign selling
The evening print shows foreign institutions net sellers for a fourth session running, domestic institutions net buyers each time, and the index down 1.1% over the four days. You hold two positional trades that are still above their stops.
Foreign institutions are shown as net sellers of ₹2,340 crore and domestic institutions as net buyers of ₹1,980 crore on the same day. What does the pairing tell you?
Dukaandaar bola "aaj 630 rupaye ka ghaata". Register kholo — 12,480 ka maal aaya, 13,110 ka gaya. 630 do bade numberon ka farq hai, din ka mizaaj nahi. "FII ne itne crore beche" wahi 630 hai. Aur jise sab "retail" samajh kar padhte hain, woh asal mein client ka khaana hai — jisme aap bhi ho aur ek bade family office ka desk bhi.
- India publishes daily participant-wise flow data that most major markets do not — the asset is real.
- Provisional evening figures are revised, and depository-based foreign flow data uses a wider basis.
- Net flow is a thin difference between very large gross buying and gross selling.
- The client category is everybody who is not an institution or a proprietary desk, not retail.
- Categories net to zero by construction, so the useful signal is a rolling series, not one evening’s pairing.
Mark it done to track your progress through the curriculum.
Common questions
Short, direct answers to what people ask about this topic.
- what does the daily fii and dii figure actually measure
- It measures the net of gross buying against gross selling by foreign and domestic institutions in that exchange’s cash segment for the session — a thin residue of two very large numbers rather than one decision. A headline of foreign institutions selling ₹2,340 crore can sit on top of roughly ₹12,000 crore of purchases and ₹14,800 crore of sales, meaning about nine-tenths of the activity cancelled out. The figure is also the sum of hundreds of separate mandates, redemptions, rebalances and hedges, so it becomes informative as a rolling series over weeks rather than as one evening’s print.
- in exchange turnover data everybody who is not an institution or a proprietary desk is grouped under
- The client category. It is a residual bucket holding individual retail investors alongside high net worth individuals, corporates, family offices, partnerships and trusts, so every sentence beginning “retail bought the dip” is an inference rather than a reading. A single family office rebalancing can outweigh a great many individual investors inside the same number.
- when is fii dii data published each day in india
- The exchanges publish provisional cash-market figures for foreign and domestic institutions the same evening, shortly after the close, and the final corrected figures the following working day. The two differ often enough that a strategy built on the evening print is being built on a draft. Most aggregators never update the earlier row once the revision lands, which is the argument for keeping your own series from the published files.
- why do fii flow numbers differ between sources
- Because they measure different things on different bases. The exchange print covers institutional activity in that exchange’s cash segment and stays provisional until the next working day, while depository and regulator data on foreign portfolio investors uses a wider basis that can include activity the secondary-market figure never counted, such as money going into a primary issue. Two credible sources can therefore report different foreign flows for the same period with neither of them being wrong.
- participant wise open interest meaning
- Participant-wise open interest is the daily file in which the Indian exchanges split outstanding derivative positions across foreign institutions, domestic institutions, proprietary desks and clients. It is published with the derivatives files every session and carries more than the net cash headline does, because cash selling alongside a growing long index futures position is a different story from cash selling alongside a growing short one. Selling cash while holding long futures is one position, and reading only the cash leg records a seller who was never a seller.