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 |
|---|---|---|---|---|---|---|
| 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 |
| Motilal Oswal Nifty MidSmall India Consumption Index Fund Index Funds · held 5 mo | 3.38% | Apr 2026 | ₹1,240.60 | −9% | -0.08% | trimmed |
| ICICI Prudential Rural Opportunities Fund Sectoral/ Thematic · held 1.4 yrs | 2.72% | Jan 2025 | ₹1,566.20 | −28% | +0.58% | added |
| HDFC Focused Fund Focused · held 10 mo | 2.68% | Nov 2025 | ₹1,441.90 | −21% | +0.26% | added |
| ICICI Prudential Bharat Consumption Fund Sectoral/ Thematic · held 2.8 yrs | 2.38% | May 2019 | ₹747.95 | +51% | +0.40% | added |
| UTI Focused Fund (30 stocks) Focused · held 5.0 yrs | 2.18% | Aug 2021 | ₹1,268.45 | −11% | +0.02% | held |
| 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 |
| ICICI PRUDENTIAL HOUSING OPPORTUNITIES FUND Sectoral/ Thematic · held 4.3 yrs | 2.08% | Apr 2022 | ₹1,311.80 | −14% | +0.05% | held |
| Quantum Ethical Fund Sectoral/ Thematic · held 1.8 yrs | 2.07% | Dec 2024 | ₹1,675.10 | −32% | -0.04% | added |
| HDFC Housing Opportunities Fund Sectoral/ Thematic · held 1.3 yrs | 1.87% | May 2025 | ₹1,527.00 | −26% | +0.14% | held |
| Bandhan Nifty 200 Quality 30 Index Fund Index Funds · held 1.8 yrs | 1.86% | Dec 2024 | ₹1,675.10 | −32% | +0.07% | 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 |
| 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 |
| QUANTUM ESG BEST IN CLASS STRATEGY FUND Sectoral/ Thematic · held 6.7 yrs | 1.67% | Jan 2020 | ₹602.80 | +88% | +0.02% | held |
| Franklin Build India Fund Sectoral/ Thematic · held 1 mo | 1.54% | Aug 2026 | ₹1,244.10 | −9% | +1.54% | entered |
| Franklin India Mid Cap Fund Mid Cap · held 3.9 yrs | 1.48% | Dec 2014 | ₹275.35 | +311% | +0.17% | added |
| 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 |
| HDFC Large Cap Fund Large Cap · held 1.8 yrs | 1.35% | Dec 2024 | ₹1,675.10 | −32% | 0.00% | held |
| Groww Nifty Non-Cyclical Consumer Index Fund Equity Funds · held 8 mo | 1.32% | Dec 2025 | ₹1,424.90 | −21% | -0.08% | trimmed |
| Axis Nifty Midcap 50 Index Fund Equity Funds · held 6 mo | 1.32% | Mar 2026 | ₹1,190.60 | −5% | -0.01% | added |
| TATA MULTICAP FUND Multi Cap · held 1.8 yrs | 1.26% | Feb 2019 | ₹715.35 | +58% | +0.82% | added |
| ICICI Prudential Balanced Hybrid Fund Balanced Hybrid · held 2 mo | 1.24% | Jul 2026 | ₹1,260.70 | −10% | — | held |
| HDFC Retirement Fund - Equity Plan Retirement · held 1 mo | 1.24% | Aug 2026 | ₹1,244.10 | −9% | — | held |
| Mirae Asset Nifty India New Age Consumption ETF Equity ETF · held 1.8 yrs | 1.21% | Dec 2024 | ₹1,675.10 | −32% | -0.15% | trimmed |
| ICICI Prudential ESG Exclusionary Strategy Fund Sectoral/ Thematic · held 4.7 yrs | 1.20% | Jan 2022 | ₹1,184.40 | −4% | +0.03% | held |
| UTI - Mid Cap Fund Mid Cap · held 9 mo | 1.19% | Dec 2025 | ₹1,424.90 | −21% | +0.30% | added |
| UTI - India Consumer Fund Sectoral/ Thematic · held 8.3 yrs | 1.11% | Aug 2014 | ₹284.20 | +298% | -0.29% | trimmed |
| DSP Large & Mid Cap Fund Large & Mid Cap · held 1.8 yrs | 1.07% | Nov 2015 | ₹285.75 | +296% | +1.07% | entered |
| Nippon India ETF BSE Sensex Next 50 Other ETFs · held 7.0 yrs | 1.07% | Sep 2019 | ₹718.30 | +58% | -0.03% | added |
| SBI BSE Sensex Next 50 ETF Other ETFs · held 5.8 yrs | 1.07% | Sep 2018 | ₹594.50 | +90% | -0.04% | trimmed |
| Tata Ethical Fund Sectoral/ Thematic · held 6.8 yrs | 1.07% | Mar 2018 | ₹487.85 | +132% | +0.03% | held |
| UTI - BSE Sensex Next 50 Exchange Traded Fund Equity ETF · held 7.4 yrs | 1.07% | Mar 2019 | ₹772.50 | +47% | -0.04% | trimmed |
| UTI ELSS Tax Saver Fund ELSS · held 2.4 yrs | 1.07% | Dec 2015 | ₹304.70 | +272% | +0.14% | added |
| Mahindra Manulife Large Cap Fund Large Cap · held 3.8 yrs | 1.04% | May 2022 | ₹1,201.80 | −6% | -0.57% | trimmed |
| Franklin India Flexi Cap Fund Flexi Cap · held 2 mo | 1.04% | Jul 2026 | ₹1,260.70 | −10% | +1.04% | entered |
| 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 |
| Mahindra Manulife Aggressive Hybrid Fund Aggressive Hybrid · held 3.4 yrs | 1.02% | Jul 2019 | ₹645.30 | +75% | +0.06% | added |
| HDFC BSE India Sector Leaders Index Fund Index Funds · held 10 mo | 1.01% | Nov 2025 | ₹1,441.90 | −21% | +0.16% | added |
| HDFC Manufacturing Fund Sectoral/ Thematic · held 2.3 yrs | 1.01% | May 2024 | ₹1,907.30 | −41% | +0.01% | held |
| HDFC Retirement Fund - Hybrid-Equity Plan Retirement · held 1 mo | 1.01% | Aug 2026 | ₹1,244.10 | −9% | — | held |
| HDFC Aggressive Hybrid Fund Aggressive Hybrid · held 1 mo | 1.00% | Aug 2026 | ₹1,244.10 | −9% | — | 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.