HAVELLS INDIA LIMITED
Last close
₹1,132.40
18 Sep 2026 · −28.9% over the year
Held by
153funds
latest disclosure month
Average weight per holder
0.9%
Σ across holders 134.8% · +13.37% over 3 months
Days to exit
259
aggregate MF position at 20% of average daily volume
Who holds it
every fund's latest position, when it first appeared, and the price then against now · 175 rows: 153 holders and recent exits
| Fund | Weight | Since | Entry close | Now vs entry | 3-mo change | Action |
|---|---|---|---|---|---|---|
| DSP Nifty Midcap 150 Quality 50 ETF Other ETFs · held 3 mo | 2.13% | Jun 2026 | ₹1,159.30 | −2% | +2.13% | entered |
| DSP Nifty Midcap 150 Quality 50 Index Fund Index Funds · held 3 mo | 2.13% | Jun 2026 | ₹1,159.30 | −2% | +2.13% | entered |
| UTI Nifty Midcap 150 Quality 50 Index Fund Equity Funds · held 3 mo | 2.13% | Jun 2026 | ₹1,159.30 | −2% | +2.13% | entered |
| Franklin Build India Fund Sectoral/ Thematic · held 1 mo | 1.54% | Aug 2026 | ₹1,244.10 | −9% | +1.54% | entered |
| SBI CONSUMPTION OPPORTUNITIES FUND Sectoral/ Thematic · held 8 mo | 1.43% | Aug 2018 | ₹725.25 | +56% | +1.43% | entered |
| Franklin India Focused Equity Fund Focused · held 1 mo | 1.40% | Aug 2026 | ₹1,244.10 | −9% | +1.40% | entered |
| DSP Large & Mid Cap Fund Large & Mid Cap · held 1.8 yrs | 1.07% | Nov 2015 | ₹285.75 | +296% | +1.07% | entered |
| Franklin India Flexi Cap Fund Flexi Cap · held 2 mo | 1.04% | Jul 2026 | ₹1,260.70 | −10% | +1.04% | entered |
| Franklin India ELSS Tax Saver Fund ELSS · held 2.3 yrs | 0.99% | Dec 2014 | ₹275.35 | +311% | +0.99% | entered |
| HDFC Mid Cap Fund Mid Cap · held 2 mo | 0.90% | Jul 2026 | ₹1,260.70 | −10% | +0.90% | entered |
| TATA MULTICAP FUND Multi Cap · held 1.8 yrs | 1.26% | Feb 2019 | ₹715.35 | +58% | +0.82% | added |
| UTI BSE Housing Index Fund Equity Funds · held 3.3 yrs | 4.82% | Jun 2023 | ₹1,282.80 | −12% | +0.69% | added |
| Tata Focused Fund Focused · held 6 mo | 3.57% | Mar 2026 | ₹1,190.60 | −5% | +0.67% | added |
| ICICI Prudential Rural Opportunities Fund Sectoral/ Thematic · held 1.4 yrs | 2.72% | Jan 2025 | ₹1,566.20 | −28% | +0.58% | added |
| BANDHAN Flexi Cap Fund Flexi Cap · held 9 mo | 0.66% | Nov 2025 | ₹1,441.90 | −21% | +0.50% | added |
| ICICI Prudential Bharat Consumption Fund Sectoral/ Thematic · held 2.8 yrs | 2.38% | May 2019 | ₹747.95 | +51% | +0.40% | added |
| SBI AGGRESSIVE HYBRID FUND Aggressive Hybrid · held 10 mo | 0.31% | Aug 2018 | ₹725.25 | +56% | +0.31% | entered |
| Tata BSE Multicap Consumption 50 30 20 Index Fund Index Funds · held 9 mo | 0.88% | Dec 2025 | ₹1,424.90 | −21% | +0.31% | added |
| UTI - Mid Cap Fund Mid Cap · held 9 mo | 1.19% | Dec 2025 | ₹1,424.90 | −21% | +0.30% | added |
| HDFC Focused Fund Focused · held 10 mo | 2.68% | Nov 2025 | ₹1,441.90 | −21% | +0.26% | added |
| BANDHAN MULTI CAP FUND Multi Cap · held 11 mo | 0.65% | Oct 2025 | ₹1,493.90 | −24% | +0.25% | added |
| Tata Dividend Yield Fund Dividend Yield · held 4 mo | 0.65% | May 2026 | ₹1,176.80 | −4% | +0.19% | added |
| Franklin India Mid Cap Fund Mid Cap · held 3.9 yrs | 1.48% | Dec 2014 | ₹275.35 | +311% | +0.17% | added |
| Axis BSE India Sector Leaders Index Fund Equity Funds · held 7 mo | 1.02% | Feb 2026 | ₹1,397.10 | −19% | +0.17% | added |
| Bandhan BSE India Sector Leaders Index Fund Index Funds · held 1.0 yrs | 1.02% | Sep 2025 | ₹1,502.00 | −25% | +0.17% | added |
| HDFC BSE India Sector Leaders Index Fund Index Funds · held 10 mo | 1.01% | Nov 2025 | ₹1,441.90 | −21% | +0.16% | added |
| ICICI Prudential Large Cap Fund (erstwhile Bluechip Fund) Large Cap · held 1.8 yrs | 0.43% | Oct 2014 | ₹285.40 | +297% | +0.15% | added |
| HDFC Housing Opportunities Fund Sectoral/ Thematic · held 1.3 yrs | 1.87% | May 2025 | ₹1,527.00 | −26% | +0.14% | held |
| Motilal Oswal Arbitrage Fund Arbitrage · held 2 mo | 0.14% | Jul 2026 | ₹1,260.70 | −10% | +0.14% | entered |
| UTI ELSS Tax Saver Fund ELSS · held 2.4 yrs | 1.07% | Dec 2015 | ₹304.70 | +272% | +0.14% | added |
| ICICI Prudential Nifty 200 Quality 30 ETF Other ETFs · held 3.1 yrs | 1.85% | Aug 2023 | ₹1,384.55 | −18% | +0.07% | trimmed |
| ICICI Prudential Nifty200 Quality 30 Index Fund Index Funds · held 1.3 yrs | 1.85% | Jun 2025 | ₹1,551.10 | −27% | +0.07% | added |
| Aditya Birla Sun Life Nifty 200 Quality 30 ETF Equity ETF · held 4.1 yrs | 1.85% | Aug 2022 | ₹1,391.50 | −19% | +0.07% | trimmed |
| BANDHAN MULTI ASSET ALLOCATION FUND Multi Asset Allocation · held 8 mo | 0.33% | Jan 2026 | ₹1,285.00 | −12% | +0.07% | added |
| Bandhan Nifty 200 Quality 30 Index Fund Index Funds · held 1.8 yrs | 1.86% | Dec 2024 | ₹1,675.10 | −32% | +0.07% | added |
| SBI Nifty 200 Quality 30 ETF Other ETFs · held 5.5 yrs | 1.85% | Dec 2018 | ₹691.50 | +64% | +0.07% | added |
| SBI Nifty200 Quality 30 Index Fund Index Funds · held 1.3 yrs | 1.85% | Jun 2025 | ₹1,551.10 | −27% | +0.07% | added |
| UTI Nifty 200 Quality 30 Index Fund Equity Funds · held 2.0 yrs | 1.85% | Sep 2024 | ₹2,012.90 | −44% | +0.07% | trimmed |
| Mahindra Manulife Aggressive Hybrid Fund Aggressive Hybrid · held 3.4 yrs | 1.02% | Jul 2019 | ₹645.30 | +75% | +0.06% | added |
| ICICI Prudential ELSS - Tax Saver Fund ELSS · held 7 mo | 0.22% | Oct 2015 | ₹253.60 | +347% | +0.06% | added |
| ICICI PRUDENTIAL HOUSING OPPORTUNITIES FUND Sectoral/ Thematic · held 4.3 yrs | 2.08% | Apr 2022 | ₹1,311.80 | −14% | +0.05% | held |
| TRUSTMF ARBITRAGE FUND Arbitrage · held 2 mo | 0.05% | Jul 2026 | ₹1,260.70 | −10% | +0.05% | entered |
| ICICI PRUDENTIAL ENERGY OPPORTUNITIES FUND Sectoral/ Thematic · held 1.2 yrs | 0.47% | Jun 2025 | ₹1,551.10 | −27% | +0.04% | held |
| LIC MF Nifty Midcap 100 ETF Other ETFs · held 6 mo | 0.90% | Mar 2026 | ₹1,190.60 | −5% | +0.04% | added |
| Tata India Innovation Fund Sectoral/ Thematic · held 5 mo | 0.46% | Apr 2026 | ₹1,240.60 | −9% | +0.04% | held |
| Mirae Asset BSE 200 Equal Weight ETF Equity ETF · held 1.5 yrs | 0.50% | Mar 2025 | ₹1,528.90 | −26% | +0.03% | added |
| ICICI Prudential ESG Exclusionary Strategy Fund Sectoral/ Thematic · held 4.7 yrs | 1.20% | Jan 2022 | ₹1,184.40 | −4% | +0.03% | held |
| Tata Ethical Fund Sectoral/ Thematic · held 6.8 yrs | 1.07% | Mar 2018 | ₹487.85 | +132% | +0.03% | held |
| Nippon India Nifty 500 Equal Weight Index Fund Index Funds · held 2.0 yrs | 0.21% | Sep 2024 | ₹2,012.90 | −44% | +0.02% | added |
| QUANTUM ESG BEST IN CLASS STRATEGY FUND Sectoral/ Thematic · held 6.7 yrs | 1.67% | Jan 2020 | ₹602.80 | +88% | +0.02% | held |
A holder disclosed the stock in the latest month or the one before; an exit is listed for three disclosures. Entry close is the split- and bonus-adjusted close at the end of the month the fund first disclosed the position; “now vs entry” is price only, not the fund's return on the position. Estimated cost basis per fund from monthly unit deltas is not computed in this build.
Three-month flow
+0.13 pp
net change in Σ fund weight over the last three disclosures (percentage points summed across funds) · 84 added or entered, 62 trimmed or exited
Crowding
153 funds hold it, at an average weight of 0.9% each (134.8% summed across holders). At a fifth of average daily volume (10,81,863 shares), the aggregate fund position would take about 259 trading days to exit.
Why this might matterThe curation backtest found consensus positions anti-correlated with forward upside: when everyone already owns it, the marginal buyer is gone, and a crowded exit moves the price against every seller at once.
Why it might notBreadth of ownership is also what a large, liquid, well-run company looks like. Crowding measures how many funds agree, not whether they are right; MF ownership as a share of the company needs issue size, which is not loaded.
Who moved last quarter
the three-month flow, fund by fund — largest move first
Exited: funds that held it three disclosures ago and no longer do.
| Fund | 3-mo change | Weight now | Since | Now vs entry |
|---|---|---|---|---|
| HDFC NIFTY100 QUALITY 30 ETF Other ETFs | -1.78% | 0 · left May 2026 | Apr 2024 | −32% |
| HDFC Nifty100 Quality 30 Index Fund Index Funds | -1.78% | 0 · left May 2026 | Feb 2025 | −20% |
| Bajaj Finserv Consumption Fund Sectoral/ Thematic | -1.48% | 0 · left Jul 2026 | Nov 2024 | −34% |
| HSBC Consumption Fund Sectoral/ Thematic | -1.30% | 0 · left Jun 2026 | Sep 2023 | −18% |
| Aditya Birla Sun Life Focused Fund Focused | -1.09% | 0 · left Jun 2026 | Oct 2025 | −24% |
| Nippon India ELSS Tax Saver Fund ELSS | -0.77% | 0 · left Jul 2026 | Oct 2021 | −10% |
| Mirae Asset Flexi Cap Fund Flexi Cap | -0.63% | 0 · left Jun 2026 | Mar 2023 | −5% |
| Aditya Birla Sun Life Consumption Fund Sectoral/ Thematic | -0.59% | 0 · left Jun 2026 | Feb 2016 | +316% |
| WhiteOak Capital ESG Best-In-Class Strategy Fund Sectoral/ Thematic | -0.55% | 0 · left Jul 2026 | Oct 2024 | −31% |
| Groww Aggressive Hybrid Fund Aggressive Hybrid | -0.44% | 0 · left May 2026 | Apr 2026 | −9% |
| Mirae Asset Nifty 100 ESG Sector Leaders ETF Equity ETF | -0.33% | 0 · left May 2026 | Aug 2021 | −11% |
| Invesco India Arbitrage Fund Arbitrage | -0.31% | 0 · left Aug 2026 | Jul 2016 | +191% |
| Mirae Asset Arbitrage Fund Arbitrage | -0.27% | 0 · left Jul 2026 | Jan 2022 | −4% |
| ICICI Prudential Large & Mid Cap Fund Large & Mid Cap | -0.27% | 0 · left Jun 2026 | Apr 2026 | −9% |
| WhiteOak Capital Arbitrage Fund Arbitrage | -0.09% | 0 · left Jun 2026 | Sep 2025 | −25% |
| JioBlackRock Arbitrage Fund Arbitrage | -0.09% | 0 · left Jul 2026 | May 2026 | −4% |
| Nippon India Arbitrage Fund Arbitrage | -0.08% | 0 · left Jul 2026 | Dec 2014 | +311% |
| Axis Arbitrage Fund Arbitrage | -0.08% | 0 · left Aug 2026 | Apr 2021 | +14% |
| ICICI Prudential Balanced Advantage Fund Dynamic Asset Allocation or Balanced Advantage | -0.08% | 0 · left Jul 2026 | Dec 2014 | +311% |
| ADITYA BIRLA SUN LIFE ARBITRAGE FUND Arbitrage | -0.05% | 0 · left Jul 2026 | May 2018 | +108% |
| Parag Parikh Arbitrage Fund Arbitrage | -0.04% | 0 · left Jul 2026 | Nov 2023 | −13% |
| Bajaj Finserv Arbitrage Fund Arbitrage | -0.02% | 0 · left Jul 2026 | Jul 2024 | −39% |
| BARODA BNP PARIBAS ARBITRAGE FUND Arbitrage | -0.01% | 0 · left Jul 2026 | Jul 2024 | −39% |
| HSBC Arbitrage Fund Arbitrage | -0.01% | 0 · left Jul 2026 | Dec 2022 | +3% |
One year, adjusted
daily close, split- and bonus-adjusted
Prices are the NSE close — the company quotes on both exchanges and the NSE carries the liquidity for almost every dual listing, so one series is shown rather than two that would mostly agree. The series is adjusted for splits and bonuses so a 1:1 bonus does not read as a 50% fall. A dated corporate-action timeline (rights, demergers) is not loaded in this build and is not shown rather than guessed.