PatternsRadar
Sign in

Mutual fund, FPI and retail holding

The shareholding pattern breaks public ownership into who holds it: mutual funds, insurers, foreign portfolio investors, and individuals split at ₹2 lakh of share capital into retail and HNI. Each comes with its quarter-on-quarter change, and the filing also states how many shareholders the company has.

The same quarterly filing that gives `promoter_pct`, `fii_pct` and `dii_pct` lists the categories beneath them. `mf_pct` is every mutual fund scheme combined and `insurance_pct` every insurer, both part of DII. `fpi_pct` is foreign portfolio investors, the bulk of FII; the rest of FII is foreign direct investment and depository receipts, which do not trade. `retail_pct` counts resident individuals holding up to ₹2 lakh of share capital each and `hni_pct` those above it. All of them are point-in-time on the filing date, like the rest of the shareholding fields.

The changes are what most scans use. `mf_change_qoq > 1` finds stocks funds added a full point of the company to in a quarter, which for a mid-cap is a deliberate position rather than index drift. Institutions buying while `retail_change_qoq` falls is accumulation; the reverse, retail rising as funds and FPIs sell, is the usual shape of distribution. `shareholder_change_qoq` measures the same crowd from the other side: a jump of 20% or more in the number of holders in one quarter is retail discovering a stock.

The caveats come from the filing. It is quarterly, so every field steps on the filing date and can be up to three months stale. The changes compare adjacent quarters only and read NULL when a filing is missing in between, rather than calling a two-year move one quarter's. The ₹2 lakh line is on nominal share capital, shares held times face value, so a rally moves nobody from retail to HNI. The breakdown is dense from Sep-2021; earlier filings are mostly absent and read NULL.

The symbol page lists the named holders behind these numbers: every promoter-group member, and each public holder above 1%, from the latest filing.

In Sift

Written as mf_pct, insurance_pct, fpi_pct, retail_pct, hni_pct — percentages of total shares, 0-100; *_change_qoq — change in percentage points against the previous quarter; shareholder_count — a count; shareholder_change_qoq — percent change in that count. A working scan — Mutual funds added a point or more last quarter while retail holders sold:

where mf_change_qoq > 1 and retail_change_qoq < 0
Run

1

of the 500 most-traded NSE stocks match today, as of 20 Nov 2026

Common questions

What is the difference between FII and FPI holding?

FPI is foreign portfolio investors, the funds that buy and sell Indian shares on the exchange. FII as filed also counts foreign direct investment, such as a foreign parent's stake, and shares held against depository receipts. `fpi_pct` is the tradable part, which is why it moves while a company with a foreign parent can show a large and static `fii_pct`.

Who counts as retail and who as HNI?

The filing splits resident individuals at ₹2 lakh of nominal share capital each, the face value of the shares held rather than what they are worth. Up to that line is `retail_pct`, above it `hni_pct`. NRIs, companies and trusts are counted elsewhere.