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
Added: funds that held it three disclosures ago and hold more of it now.
| Fund | 3-mo change | Weight now | Since | Now vs entry |
|---|---|---|---|---|
| There is no page 6; back to the first. | ||||
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.