Stock Analysis
Find which mutual funds hold a stock, compare sector changes and explore research answers.
Find funds holding a stock
Type a company name and choose a result.
Havells India Ltd.
Consumer Durables
Monthly ownership
The number of covered funds reporting this stock each month.
Swipe sideways to see every column
| Fund / category | Sep 2026 weight | Aug 2026 weight | Change | Explore |
|---|---|---|---|---|
| Kotak BSE Housing Index FundKotak · Index Funds | 4.47% | 4.83% | 0.36 points lower | Fund details |
| UTI BSE Housing Index FundUTI · Index Funds | 4.34% | 4.82% | 0.48 points lower | Fund details |
| Tata Focused FundTata · Equity · Focused | 3.15% | 3.57% | 0.42 points lower | Fund details |
| Motilal Oswal Nifty MidSmall India Consumption Index FundMotilal · Index Funds | 2.65% | 3.38% | 0.73 points lower | Fund details |
| ICICI Prudential Rural Opportunities FundICICI · Equity · Sectoral / Thematic | 2.40% | 2.72% | 0.32 points lower | Fund details |
| HDFC Focused FundHDFC · Equity · Focused | 2.32% | 2.68% | 0.36 points lower | Fund details |
| ICICI Prudential Bharat Consumption FundICICI · Equity · Sectoral / Thematic | 2.07% | 2.38% | 0.32 points lower | Fund details |
| ICICI PRUDENTIAL HOUSING OPPORTUNITIES FUNDICICI · Equity · Sectoral / Thematic | 2.06% | 2.08% | 0.03 points lower | Fund details |
| Quantum Ethical FundQuantum · Equity · Sectoral / Thematic | 1.90% | 2.07% | 0.17 points lower | Fund details |
| DSP Nifty Midcap 150 Quality 50 ETFDSP · ETF · Other | 1.88% | 2.13% | 0.25 points lower | Fund details |
| DSP Nifty Midcap 150 Quality 50 Index FundDSP · Index Funds | 1.88% | 2.13% | 0.25 points lower | Fund details |
| UTI Nifty Midcap 150 Quality 50 Index FundUTI · Index Funds | 1.88% | 2.13% | 0.25 points lower | Fund details |
| Franklin Build India FundFranklin · Equity · Sectoral / Thematic | 1.68% | 1.54% | 0.14 points higher | Fund details |
| KOTAK NIFTY 200 QUALITY 30 INDEX FUNDKotak · Index Funds | 1.65% | 1.85% | 0.20 points lower | Fund details |
| SBI Nifty 200 Quality 30 ETFSBI · ETF · Other | 1.65% | 1.85% | 0.20 points lower | Fund details |
| SBI Nifty200 Quality 30 Index FundSBI · Index Funds | 1.65% | 1.85% | 0.20 points lower | Fund details |
| UTI Nifty 200 Quality 30 Index FundUTI · Index Funds | 1.65% | 1.85% | 0.20 points lower | Fund details |
| Aditya Birla Sun Life Nifty 200 Quality 30 ETFABSL · ETF · Other | 1.65% | 1.85% | 0.20 points lower | Fund details |
| ICICI Prudential Nifty 200 Quality 30 ETFICICI · ETF · Other | 1.65% | 1.85% | 0.21 points lower | Fund details |
| ICICI Prudential Nifty200 Quality 30 Index FundICICI · Index Funds | 1.64% | 1.85% | 0.21 points lower | Fund details |
| Kotak Nifty200 Quality 30 ETFKotak · ETF · Other | 1.64% | 1.85% | 0.21 points lower | Fund details |
| HDFC Housing Opportunities FundHDFC · Equity · Sectoral / Thematic | 1.62% | 1.87% | 0.25 points lower | Fund details |
| QUANTUM ESG BEST IN CLASS STRATEGY FUNDQuantum · Equity · Sectoral / Thematic | 1.48% | 1.67% | 0.19 points lower | Fund details |
| Taurus Mid Cap FundTaurus · Equity · Mid Cap | 1.33% | 1.58% | 0.25 points lower | Fund details |
| Franklin India Mid Cap FundFranklin · Equity · Mid Cap | 1.30% | 1.48% | 0.18 points lower | Fund details |
| SBI CONSUMPTION OPPORTUNITIES FUNDSBI · Equity · Sectoral / Thematic | 1.25% | 1.43% | 0.18 points lower | Fund details |
| NJ Flexi Cap FundNJ · Equity · Flexi Cap | 1.24% | Not comparable | Not comparable | Fund details |
| Axis Nifty Midcap 50 Index FundAxis · Index Funds | 1.19% | 1.32% | 0.13 points lower | Fund details |
| Kotak Nifty Midcap 50 ETFKotak · ETF · Other | 1.19% | 1.32% | 0.13 points lower | Fund details |
| KOTAK NIFTY MIDCAP 50 INDEX FUNDKotak · Index Funds | 1.19% | 1.32% | 0.13 points lower | Fund details |
Understand the weights and changes
A change from 8% to 10% is 2 points higher. An earlier 0.00% means no positive stock position was reported in the reviewed baseline. “Not comparable” means the earlier filing is missing or needs review. Price moves, cash flows and trades can all change weights.
Data details, coverage & calculation methods
THE DATA, WITHOUT THE GUESSWORK
Know exactly what you are looking at.
Built 28 Oct 2026, 05:36 AM IST. Monthly AMC portfolio disclosures from the existing MF Analyser source feed, normalized into this site’s MySQL research dataset.
What counts as one fund?
One underlying portfolio code per disclosure date. Equivalent source category labels are grouped into readable categories; underlying filing records are retained. Direct, Regular, Growth and IDCW variants share the same holdings and are counted once. Equity positions use exact ISINs; derivatives, fund units, debt and cash are excluded from stock ownership.
What does a sector shift mean?
A difference in the percentage of a fund’s NAV assigned to the sector, averaged equally across the same funds. A rise from 8% to 10% is +2 percentage points, not a 2% investment return. Price changes and cash flows can change weights without a trade.
How are missing or questionable rows handled?
Review-flagged equity rows, ambiguous duplicate ISINs and weights that fail reconciliation are excluded from reviewed comparisons. Unmapped sectors stay Unclassified. Sector changes additionally require all disclosed equity sectors classified at both dates. Pairs where a continuing stock changes sector classification are excluded, so a taxonomy change is not mistaken for a fund allocation change. Missing months never become a zero baseline.
Is this the whole Indian mutual-fund market?
No. Results cover the AMC disclosures loaded into the existing database and passing these checks. The month-specific counts below describe that coverage. Monthly holdings are not real-time positions. Results are research observations, not personalized recommendations.
View filing coverage and quality exclusions
Swipe sideways to see every column
| Filing | Equity portfolios found | Reviewed | Fully sector-classified | Reviewed-out portfolios |
|---|---|---|---|---|
| Sep 2026 | 1,265 | 1,261 | 1,032 | 4 |
| Aug 2026 | 1,276 | 1,269 | 1,138 | 7 |
| Jul 2026 | 1,176 | 1,167 | 997 | 9 |
| Jun 2026 | 659 | 657 | 626 | 2 |
“Reviewed” means the automated source-row checks passed; it does not imply an independent audit of each AMC filing. Very small source weights reported as zero are outside positive-position counts. Snapshot 2 · taxonomy nse-sector-rollup-2026-10-20.1.