ICICI Prudential Housing Opportunities Fund vs Tata Flexi Cap Fund
Direct Plan, Growth option · Data as on 30-10-2026
ICICI Prudential Housing Opportunities Fund is a Thematic fund and Tata Flexi Cap Fund is a Flexi Cap fund. In the 3 years to 30-10-2026, ICICI Prudential Housing Opportunities Fund (Direct) returned 10.3% a year and Tata Flexi Cap Fund (Direct) returned 9.1% a year. ICICI Prudential Housing Opportunities Fund charges 1.22% a year and Tata Flexi Cap Fund 0.89% (Direct plans). Their portfolios overlap 31.8%: they hold 18 of the same securities.
ICICI Prudential Housing Opportunities Fund
Thematic
- 3 year return
- 10.3%
- Expense ratio
- 1.22%
- NAV
- ₹16.96
Which is better, ICICI Prudential Housing Opportunities or Tata Flexi Cap? Key differences
It depends on what you want from the fund. These are the differences in numbers, from the data on this page.
- ICICI Prudential Housing Opportunities returned more over 3 years: 10.3% a year against 9.1%.
- ICICI Prudential Housing Opportunities returned more over 1 year: −9.4% against −10.2%.
- Tata Flexi Cap costs less: 0.89% a year against 1.22% (Direct plans).
- Tata Flexi Cap swung less over 3 years: a standard deviation of 12.7% a year against 14.1%.
- Tata Flexi Cap fell less in its worst fall since 19-04-2022: −14.6% against −16.7%.
- Tata Flexi Cap is the larger fund: ₹3,454 Cr against ₹2,631 Cr.
- Their portfolios overlap 31.8%: 18 of the same holdings.
Past returns do not promise future returns. This page is information, not investment advice.
Key facts
From each fund's scheme summary document and AMFI
| Fact | ICICI Prudential Housing Opportunities Fund | Tata Flexi Cap Fund |
|---|---|---|
| Fund house | ICICI Prudential Mutual Fund | Tata Mutual Fund |
| Category | Thematic | Flexi Cap |
| AUM | ₹2,631 Cr (30-09-2026) | ₹3,454 Cr (30-09-2026) |
| NAV | ₹16.96 (Direct) | ₹25.03 (Direct) |
| Expense ratio (Direct) | 1.22% | 0.89% |
| Expense ratio (Regular) | 2.07% | 2.13% |
| Riskometer | Not available | Very High |
| Benchmark | Nifty Housing TRI | Nifty 500 TRI |
| Launch date | 18-04-2022 | 06-09-2018 |
| Minimum investment | ₹5,000 | ₹5,000 |
| Lock in | None | None |
| Fund managers | Sanket Gaidhani | Anand Sharma, Aditya Bagul |
| Exit load | 1 % of applicable Net Asset Value If the amount sought to be redeemed or switch out within 1 months from allotment. Nil If the amount sought to be redeemed or switched out more than 1 months. | Redemption/Switch-out/SWP/STP: 1. On or before 30 days from the date of allotment: 0.50%. 2. After 30 days from the date of allotment: NIL. |
ICICI Prudential Housing Opportunities vs Tata Flexi Cap: Returns Comparison
Returns as on 30-10-2026. Up to one year they are absolute returns. Longer periods are a rate per year.
| Fund | 1M | 3M | 6M | 1Y | 3Y | 5Y | 10Y |
|---|---|---|---|---|---|---|---|
| ICICI Prudential Housing Opportunities Fund (Direct) | −2.25% | −7.17% | −5.88% | −9.45% | +10.33% | -- | -- |
| Tata Flexi Cap Fund (Direct) | −1.02% | −6.54% | −4.90% | −10.21% | +9.08% | +7.88% | -- |
| Thematic average | −2.09% | −4.52% | +0.86% | −1.22% | +13.76% | -- | -- |
| Flexi Cap average | −1.62% | −4.17% | +1.00% | −3.58% | +12.37% | +10.04% | -- |
Category average: the average of the 235 Thematic funds and the 46 Flexi Cap funds, same plan type.
ICICI Prudential Housing Opportunities vs Tata Flexi Cap: Year-wise Returns
| Year | ICICI Prudential Housing OpportunitiesICICI Prudential Housing Opportunities | Tata Flexi CapTata Flexi Cap |
|---|---|---|
| 2026to date | −6.97% | −10.28% |
| 2025 | +7.17% | +12.01% |
| 2024 | +16.35% | +14.03% |
| 2023 | +32.43% | +29.48% |
| 2022 | -- | −2.15% |
| 2021 | -- | +28.33% |
ICICI Prudential Housing Opportunities vs Tata Flexi Cap: Rolling Returns
Every holding period of both funds, against Nifty Housing TRI, the benchmark of ICICI Prudential Housing Opportunities Fund
Rolling returns
Every 3-year holding period, 378 of them, one for each trading day from 21-04-2025 to 30-10-2026: the yearly return (CAGR) of each, plotted on the day it ended. One lucky or unlucky start day cannot flatter or hide a fund.
ICICI Prudential Housing Opportunities Fund (Direct)
Tata Flexi Cap Fund (Direct)
Nifty Housing TRI
to
Jun 2025Sept 2022
to
Sept 2025Dec 2022
to
Dec 2025Mar 2023
to
Mar 2026Jun 2023
to
Jun 2026Sept 2023
to
Sept 2026
How the periods spread
| Fund | Below 0% | 0-5% | 5-10% | 10-15% | 15-20% | 20-25% | Above 25% | Mean | Median | Lowest | Highest | Beat benchmark |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ICICI Prudential Housing Opportunities | 0.0 | 0.0 | 3.4 | 18.5 | 58.5 | 19.6 | 0.0 | 17.5% | 18.0% | 9.2% | 24.3% | 100% |
| Tata Flexi Cap | 0.0 | 0.0 | 8.2 | 20.9 | 61.9 | 9.0 | 0.0 | 16.1% | 17.0% | 7.9% | 22.1% | 71% |
| Nifty Housing TRI | 0.0 | 0.0 | 8.2 | 53.7 | 34.1 | 4.0 | 0.0 | 14.5% | 14.2% | 7.8% | 21.5% | -- |
The table shows the % of periods in each return band; a darker cell holds more of them. Lumpsum: the yearly rate (CAGR) from a period's first NAV to its last. SIP: the XIRR of the monthly instalments. The benchmark is Nifty Housing TRI, over the same periods. "Beat benchmark" counts the periods in which the fund did better. Every fund is measured over the days all of them have, from 19-04-2022. Past returns do not promise future returns.
ICICI Prudential Housing Opportunities vs Tata Flexi Cap: SIP and Lumpsum Returns
What the same monthly or one-time investment would be worth in each fund today, from their own NAV history
Growth of an investment
₹10,000 on the first trading day of every month, from 19-04-2022 to 30-10-2026: 55 instalments, ₹5,50,000 in all.
| Investment | Invested | Value now | Gain | Return a year |
|---|---|---|---|---|
| ICICI Prudential Housing OpportunitiesICICI Prudential Housing Opportunities Fund (Direct) | ₹5,50,000 | ₹6,56,407 | ₹1,06,407 | 7.7% |
| Tata Flexi CapTata Flexi Cap Fund (Direct) | ₹5,50,000 | ₹6,39,717 | ₹89,717 | 6.5% |
ICICI Prudential Housing OpportunitiesICICI Prudential Housing Opportunities Fund (Direct)
Tata Flexi CapTata Flexi Cap Fund (Direct)
Amount invested
From each plan's published NAV (Growth option), over the same days. Return a year: XIRR for a SIP, CAGR for a lumpsum, shown for a year or more. It does not include exit load, stamp duty or tax. Past returns do not promise future returns.
ICICI Prudential Housing Opportunities vs Tata Flexi Cap: Risk and Drawdowns
How much each fund swings, and the worst fall over the same days
Risk and return
| Measure | ICICI Prudential Housing Opportunities Fund (Direct) | Tata Flexi Cap Fund (Direct) |
|---|---|---|
| Return (CAGR) | −9.45% | −10.21% |
| Standard deviation | 14.93% | 13.19% |
| Sharpe ratio | -0.98 | -1.17 |
| Sortino ratio | -1.32 | -1.54 |
| Maximum drawdown | −13.3% (23-03-2026) | −14.1% (31-03-2026) |
| Beta | 0.86 | 0.90 |
| Alpha | −4.12% | −4.10% |
From daily NAVs, 30-10-2025 to 30-10-2026. Standard deviation: how much the daily value swings, scaled to a year. Sharpe: return above the risk-free rate (NSE's overnight rate index) per unit of swing. Sortino: the same, counting only the falls. Beta and alpha compare each fund with its own benchmark's TRI.
| Measure | ICICI Prudential Housing Opportunities Fund (Direct) | Tata Flexi Cap Fund (Direct) |
|---|---|---|
| Return (CAGR) | +10.33% | +9.08% |
| Standard deviation | 14.05% | 12.68% |
| Sharpe ratio | 0.31 | 0.24 |
| Sortino ratio | 0.42 | 0.33 |
| Maximum drawdown | −16.7% (28-02-2025) | −14.6% (03-03-2025) |
| Beta | 0.80 | 0.86 |
| Alpha | +1.14% | −0.56% |
From daily NAVs, 30-10-2023 to 30-10-2026. Standard deviation: how much the daily value swings, scaled to a year. Sharpe: return above the risk-free rate (NSE's overnight rate index) per unit of swing. Sortino: the same, counting only the falls. Beta and alpha compare each fund with its own benchmark's TRI.
| Measure | ICICI Prudential Housing Opportunities Fund (Direct) | Tata Flexi Cap Fund (Direct) |
|---|---|---|
| Return (CAGR) | +12.44% | +11.95% |
| Standard deviation | 12.48% | 15.24% |
| Sharpe ratio | 0.51 | 0.44 |
| Sortino ratio | 0.70 | 0.59 |
| Maximum drawdown | −16.7% (28-02-2025) | −33.5% (23-03-2020) |
| Beta | 0.73 | 0.87 |
| Alpha | +4.28% | +1.17% |
From daily NAVs, 19-04-2022 to 30-10-2026. Standard deviation: how much the daily value swings, scaled to a year. Sharpe: return above the risk-free rate (NSE's overnight rate index) per unit of swing. Sortino: the same, counting only the falls. Beta and alpha compare each fund with its own benchmark's TRI.
Drawdowns
How far below its previous high each one was on every day: the falls an investor had to sit through. 0% means it was at a new high.
ICICI Prudential Housing Opportunities Fund (Direct)
Tata Flexi Cap Fund (Direct)
Nifty Housing TRI
| Fund | Worst fall | High before it | Bottom | Back at the high | Time to climb back | Below its high today |
|---|---|---|---|---|---|---|
| ICICI Prudential Housing Opportunities Fund (Direct) | −16.7% | 26-09-2024 | 28-02-2025 | 16-10-2025 | 8 months | −9.6% |
| Tata Flexi Cap Fund (Direct) | −14.6% | 26-09-2024 | 03-03-2025 | 09-06-2025 | 3 months | −11.0% |
| Nifty Housing TRI | −19.9% | 26-09-2024 | 28-02-2025 | Not yet | -- | −9.1% |
From daily values since 19-04-2022, the first day every fund has.
Rolling standard deviation
Whether the swings have grown or calmed over time: the standard deviation of daily changes over every 1-year window, scaled to a year, plotted on the window's last day. Higher means a bumpier ride.
ICICI Prudential Housing Opportunities Fund (Direct)
Tata Flexi Cap Fund (Direct)
Nifty Housing TRI
Whether the swings have grown or calmed over time: the standard deviation of daily changes over every 3-year window, scaled to a year, plotted on the window's last day. Higher means a bumpier ride.
ICICI Prudential Housing Opportunities Fund (Direct)
Tata Flexi Cap Fund (Direct)
Nifty Housing TRI
Against Nifty Housing TRI
| Fund | Up capture | Down capture | Tracking error |
|---|---|---|---|
| ICICI Prudential Housing Opportunities Fund (Direct) | 83% | 60% | 7.60% |
| Tata Flexi Cap Fund (Direct) | 74% | 61% | 8.88% |
From month-end values since 19-04-2022. Up capture: a fund's average month when the benchmark rose, as % of the benchmark's; above 100% it gained more. Down capture: the same for months the benchmark fell; below 100% it fell less. Tracking error: how far the monthly returns strayed from the benchmark's, a year; an index fund aims near 0.
ICICI Prudential Housing Opportunities vs Tata Flexi Cap: Portfolio Overlap
From each fund's latest monthly portfolio: ICICI Prudential Housing Opportunities Fund, September 2026; Tata Flexi Cap Fund, September 2026
Holdings in common
- Overlap
- 31.8%
- Held by both
- 18
- Only in ICICI Prudential Housing Opportunities
- 41
- Only in Tata Flexi Cap
- 51
| Security | % of ICICI Prudential Housing Opportunities | % of Tata Flexi Cap |
|---|---|---|
| HDFC Bank Ltd. | 6.52% | 6.28% |
| ICICI Bank Ltd. | 6.31% | 6.13% |
| Larsen & Toubro Ltd. | 4.72% | 2.62% |
| NTPC Ltd. | 7.08% | 2.46% |
| Axis Bank Ltd. | 1.97% | 3.87% |
| State Bank Of India | 2.93% | 1.53% |
| Orient Electric Ltd. | 1.79% | 1.50% |
| Ambuja Cements Ltd. | 1.44% | 1.49% |
| The Phoenix Mills Ltd. | 1.85% | 1.26% |
| Sobha Ltd. | 2.00% | 1.25% |
| Life Insurance Corporation of India | 1.14% | 1.51% |
| Jindal Steel Ltd. | 0.82% | 0.90% |
| Tata Steel Ltd. | 6.04% | 0.80% |
| Pidilite Industries Ltd. | 0.78% | 1.66% |
| Kotak Mahindra Bank Ltd. | 0.76% | 1.83% |
| Bajaj Electricals Ltd. | 0.56% | 1.27% |
| Jsw Dulux Ltd. | 0.48% | 0.64% |
| IndusInd Bank Ltd. | 0.05% | 1.66% |
Overlap: for each holding both funds own, the smaller of its two weights, added up. 31.8% means 31.8% of each fund's money sits in positions the other also holds. Matched by ISIN. Cash and hedged positions are left out.
Largest holdings only in ICICI Prudential Housing Opportunities Fund
| Security | % of fund |
|---|---|
| Asian Paints Ltd. | 5.32% |
| Ultratech Cement Ltd. | 3.82% |
| Oberoi Realty Ltd. | 3.76% |
| Shree Cements Ltd. | 3.65% |
| Blue Star Ltd. | 2.67% |
Largest holdings only in Tata Flexi Cap Fund
| Security | % of fund |
|---|---|
| RELIANCE INDUSTRIES LTD | 4.23% |
| BHARTI AIRTEL LTD | 3.79% |
| MARUTI SUZUKI INDIA LTD | 2.28% |
| SBI LIFE INSURANCE COMPANY LTD | 2.04% |
| ITC LTD | 1.67% |
Asset and sector split
Share of each fund, from its latest monthly portfolio
Asset allocation
| Asset | ICICI Prudential Housing Opportunities | Tata Flexi Cap |
|---|---|---|
| Equity | 96.5% | 94.8% |
| Debt | 0.0% | 0.0% |
| Cash and others | 3.5% | 5.2% |
Market cap of stocks
| Market cap | ICICI Prudential Housing Opportunities | Tata Flexi Cap |
|---|---|---|
| Large Cap | 54.2% | 58.8% |
| Mid Cap | 21.1% | 15.5% |
| Small Cap | 20.3% | 18.2% |
| Not on AMFI's list | 0.9% | 2.3% |
Share of the whole fund. Groups follow AMFI's latest list: Large Cap is the 100 largest companies, Mid Cap the next 150, Small Cap the rest.
Largest sectors
| Sector | ICICI Prudential Housing Opportunities | Tata Flexi Cap |
|---|---|---|
| Banks | 19.1% | 21.3% |
| Consumer Durables | 16.3% | 5.2% |
| Realty | 14.3% | 2.5% |
| Cement & Cement Products | 9.8% | 3.6% |
| Power | 9.7% | 3.1% |
| Ferrous Metals | 9.5% | 1.7% |
| Insurance | 1.1% | 6.0% |
| Petroleum Products | 0.0% | 5.2% |
| Telecom - Services | 0.0% | 5.2% |
| Pharmaceuticals & Biotechnology | 0.0% | 4.2% |
The six largest sectors of each fund's stocks, % of the fund.
ICICI Prudential Housing Opportunities vs Tata Flexi Cap: Expense Ratio
What each plan charges a year, from AMFI's expense ratio file
| Charge | ICICI Prudential Housing Opportunities Fund | Tata Flexi Cap Fund |
|---|---|---|
| Total expense ratio (Direct) | 1.22% | 0.89% |
| Base expense ratio (Direct) | 0.95% | 0.59% |
| Total expense ratio (Regular) | 2.07% | 2.13% |
| Base expense ratio (Regular) | 1.70% | 1.65% |
The expense ratio comes out of the fund's assets every day, so every return on this page is already after it. Base expense ratio: the fund house's own fee. The total adds brokerage, transaction costs, and levies with GST.
More comparisons
Each fund against the others of its category
Compare ICICI Prudential Housing Opportunities with
- ICICI Prudential Housing Opportunities vs Nippon India Taiwan Equity
- ICICI Prudential Housing Opportunities vs HDFC Defence
- ICICI Prudential Housing Opportunities vs HDFC Pharma and Healthcare
- ICICI Prudential Housing Opportunities vs SBI Healthcare Opportunities
- ICICI Prudential Housing Opportunities vs Aditya Birla Sun Life International Equity
ICICI Prudential Housing Opportunities Fund vs Tata Flexi Cap Fund: Frequently Asked Questions
What is the difference between ICICI Prudential Housing Opportunities Fund and Tata Flexi Cap Fund?
ICICI Prudential Housing Opportunities Fund is a Thematic fund, Tata Flexi Cap Fund is a Flexi Cap fund, run by ICICI Prudential Mutual Fund and Tata Mutual Fund. Their portfolios overlap 31.8%. ICICI Prudential Housing Opportunities Fund charges 1.22% a year and Tata Flexi Cap Fund 0.89%.
Which has given higher returns, ICICI Prudential Housing Opportunities Fund or Tata Flexi Cap Fund?
Over 1 year: ICICI Prudential Housing Opportunities Fund −9.45%, Tata Flexi Cap Fund −10.21%. Over 3 years: ICICI Prudential Housing Opportunities Fund +10.33% a year, Tata Flexi Cap Fund +9.08% a year. As on 30-10-2026. Past returns do not promise future returns.
Which has the lower expense ratio, ICICI Prudential Housing Opportunities Fund or Tata Flexi Cap Fund?
Tata Flexi Cap Fund charges less: 0.89% a year against 1.22%. These are the Direct plans' total expense ratios reported to AMFI.
How much do ICICI Prudential Housing Opportunities Fund and Tata Flexi Cap Fund overlap?
31.8%. They hold 18 of the same securities, the largest shared ones being HDFCBANK, ICICIBANK, LT. From each fund's latest monthly portfolio.
Which is better for SIP, ICICI Prudential Housing Opportunities Fund or Tata Flexi Cap Fund?
Over the last 3 years, a monthly SIP of ₹10,000 from 03-10-2023 to 30-10-2026 grew to ₹3,75,319 in ICICI Prudential Housing Opportunities Fund (XIRR 0.9% a year) and ₹3,73,170 in Tata Flexi Cap Fund (XIRR 0.5% a year). Both received 37 instalments. Past returns do not promise future returns.
Can I invest in both ICICI Prudential Housing Opportunities Fund and Tata Flexi Cap Fund?
Yes. 31.8% of each fund's money sits in the same holdings, so some of the two investments would move together.
Who manages ICICI Prudential Housing Opportunities Fund and Tata Flexi Cap Fund?
ICICI Prudential Housing Opportunities Fund: Sanket Gaidhani. Tata Flexi Cap Fund: Anand Sharma, Aditya Bagul.
Sources: NAV and expense ratio from AMFI. Holdings from each fund house's monthly portfolio statement. Fund facts from each scheme summary document.
This page is information, not investment advice. Mutual fund investments are subject to market risks; read all scheme related documents carefully. Past returns do not promise future returns. Figures come from AMFI, NSE, BSE and each fund house's own documents.