ICICI Prudential Housing Opportunities Fund vs Tata Housing Opportunities Fund
Direct Plan, Growth option · Data as on 30-10-2026
ICICI Prudential Housing Opportunities Fund is a Thematic fund and Tata Housing Opportunities Fund is a Thematic fund. In the 3 years to 30-10-2026, ICICI Prudential Housing Opportunities Fund (Direct) returned 10.3% a year and Tata Housing Opportunities Fund (Direct) returned 6.5% a year. ICICI Prudential Housing Opportunities Fund charges 1.22% a year and Tata Housing Opportunities Fund 1.06% (Direct plans). Their portfolios overlap 42.3%: they hold 16 of the same securities.
ICICI Prudential Housing Opportunities Fund
Thematic
- 3 year return
- 10.3%
- Expense ratio
- 1.22%
- NAV
- ₹16.96
Tata Housing Opportunities Fund
Thematic
- 3 year return
- 6.5%
- Expense ratio
- 1.06%
- NAV
- ₹14.97
Which is better, ICICI Prudential Housing Opportunities or Tata Housing Opportunities? 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 6.5%.
- Tata Housing Opportunities returned more over 1 year: −8.4% against −9.4%.
- Tata Housing Opportunities costs less: 1.06% a year against 1.22% (Direct plans).
- ICICI Prudential Housing Opportunities swung less over 3 years: a standard deviation of 14.1% a year against 15.9%.
- ICICI Prudential Housing Opportunities fell less in its worst fall since 09-09-2022: −16.7% against −24.2%.
- ICICI Prudential Housing Opportunities is the larger fund: ₹2,631 Cr against ₹451 Cr.
- Their portfolios overlap 42.3%: 16 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 Housing Opportunities Fund |
|---|---|---|
| Fund house | ICICI Prudential Mutual Fund | Tata Mutual Fund |
| Category | Thematic | Thematic |
| AUM | ₹2,631 Cr (30-09-2026) | ₹451 Cr (30-09-2026) |
| NAV | ₹16.96 (Direct) | ₹14.97 (Direct) |
| Expense ratio (Direct) | 1.22% | 1.06% |
| Expense ratio (Regular) | 2.07% | 2.61% |
| Riskometer | Not available | Very High |
| Benchmark | Nifty Housing TRI | Nifty Housing TRI |
| Launch date | 18-04-2022 | 02-09-2022 |
| Minimum investment | ₹5,000 | ₹5,000 |
| Lock in | None | None |
| Fund managers | Sanket Gaidhani | Aditya Bagul, Kapil Malhotra, Hasmukh Vishariya, Murthy Nagarajan |
| 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. | Exit load of 1%, if redeemed within 30 days. |
ICICI Prudential Housing Opportunities vs Tata Housing Opportunities: 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 Housing Opportunities Fund (Direct) | −1.69% | −7.20% | −2.57% | −8.38% | +6.50% | -- | -- |
| Thematic average | −2.09% | −4.52% | +0.86% | −1.22% | +13.76% | -- | -- |
Category average: the average of the 235 Thematic funds, same plan type.
ICICI Prudential Housing Opportunities vs Tata Housing Opportunities: Year-wise Returns
| Year | ICICI PrudentialICICI Prudential Housing Opportunities | TataTata Housing Opportunities | Nifty Housing TRI |
|---|---|---|---|
| 2026to date | −6.97% | −5.64% | −5.09% |
| 2025 | +7.17% | −1.97% | +7.46% |
| 2024 | +16.35% | +14.02% | +8.38% |
| 2023 | +32.43% | +41.57% | +25.09% |
ICICI Prudential Housing Opportunities vs Tata Housing Opportunities: Rolling Returns
Every holding period of both funds, against Nifty Housing TRI, the benchmark of both
Rolling returns
Every 3-year holding period, 280 of them, one for each trading day from 09-09-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 Housing Opportunities Fund (Direct)
Nifty Housing TRI
to
Oct 2025Dec 2022
to
Dec 2025Mar 2023
to
Mar 2026May 2023
to
May 2026Jul 2023
to
Jul 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 | 4.6 | 25.0 | 67.5 | 2.9 | 0.0 | 16.2% | 16.7% | 9.2% | 20.5% | 100% |
| Tata Housing Opportunities | 0.0 | 0.0 | 21.1 | 37.1 | 41.8 | 0.0 | 0.0 | 13.0% | 13.2% | 5.6% | 18.5% | 35% |
| Nifty Housing TRI | 0.0 | 0.0 | 11.1 | 58.2 | 30.7 | 0.0 | 0.0 | 13.8% | 13.8% | 7.8% | 19.6% | -- |
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 09-09-2022. Past returns do not promise future returns.
ICICI Prudential Housing Opportunities vs Tata Housing Opportunities: 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 01-09-2022 to 30-10-2026: 50 instalments, ₹5,00,000 in all.
| Investment | Invested | Value now | Gain | Return a year |
|---|---|---|---|---|
| ICICI Prudential Housing OpportunitiesICICI Prudential Housing Opportunities Fund (Direct) | ₹5,00,000 | ₹5,70,885 | ₹70,885 | 6.3% |
| Tata Housing OpportunitiesTata Housing Opportunities Fund (Direct) | ₹5,00,000 | ₹5,47,972 | ₹47,972 | 4.4% |
ICICI Prudential Housing OpportunitiesICICI Prudential Housing Opportunities Fund (Direct)
Tata Housing OpportunitiesTata Housing Opportunities 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 Housing Opportunities: 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 Housing Opportunities Fund (Direct) |
|---|---|---|
| Return (CAGR) | −9.45% | −8.38% |
| Standard deviation | 14.93% | 16.36% |
| Sharpe ratio | -0.98 | -0.83 |
| Sortino ratio | -1.32 | -1.11 |
| Maximum drawdown | −13.3% (23-03-2026) | −17.6% (31-03-2026) |
| Beta | 0.86 | 0.93 |
| Alpha | −4.12% | −2.20% |
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 Housing Opportunities Fund (Direct) |
|---|---|---|
| Return (CAGR) | +10.33% | +6.50% |
| Standard deviation | 14.05% | 15.86% |
| Sharpe ratio | 0.31 | 0.03 |
| Sortino ratio | 0.42 | 0.04 |
| Maximum drawdown | −16.7% (28-02-2025) | −24.2% (28-02-2025) |
| Beta | 0.80 | 0.86 |
| Alpha | +1.14% | −2.93% |
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 Housing Opportunities Fund (Direct) |
|---|---|---|
| Return (CAGR) | +12.44% | +10.06% |
| Standard deviation | 12.48% | 14.37% |
| Sharpe ratio | 0.51 | 0.27 |
| Sortino ratio | 0.70 | 0.36 |
| Maximum drawdown | −16.7% (28-02-2025) | −24.2% (28-02-2025) |
| Beta | 0.73 | 0.82 |
| Alpha | +4.28% | +2.23% |
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 Housing Opportunities 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 Housing Opportunities Fund (Direct) | −24.2% | 23-09-2024 | 28-02-2025 | Not yet | -- | −15.5% |
| Nifty Housing TRI | −19.9% | 26-09-2024 | 28-02-2025 | Not yet | -- | −9.1% |
From daily values since 09-09-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 Housing Opportunities 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 Housing Opportunities Fund (Direct)
Nifty Housing TRI
Against Nifty Housing TRI
| Fund | Up capture | Down capture | Tracking error |
|---|---|---|---|
| ICICI Prudential Housing Opportunities Fund (Direct) | 88% | 68% | 5.47% |
| Tata Housing Opportunities Fund (Direct) | 94% | 83% | 8.73% |
From month-end values since 09-09-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 Housing Opportunities: Portfolio Overlap
From each fund's latest monthly portfolio: ICICI Prudential Housing Opportunities Fund, September 2026; Tata Housing Opportunities Fund, September 2026
Holdings in common
- Overlap
- 42.3%
- Held by both
- 16
- Only in ICICI Prudential Housing Opportunities
- 43
- Only in Tata Housing Opportunities
- 14
| Security | % of ICICI Prudential Housing Opportunities | % of Tata Housing Opportunities |
|---|---|---|
| HDFC Bank Ltd. | 6.52% | 9.38% |
| ICICI Bank Ltd. | 6.31% | 7.04% |
| NTPC Ltd. | 7.08% | 5.44% |
| Larsen & Toubro Ltd. | 4.72% | 5.57% |
| Ultratech Cement Ltd. | 3.82% | 8.45% |
| Asian Paints Ltd. | 5.32% | 3.15% |
| JSW Steel Ltd. | 2.25% | 4.86% |
| State Bank Of India | 2.93% | 1.92% |
| Tata Steel Ltd. | 6.04% | 1.82% |
| Orient Electric Ltd. | 1.79% | 2.26% |
| Ambuja Cements Ltd. | 1.44% | 3.37% |
| Jindal Steel Ltd. | 0.82% | 1.10% |
| Kotak Mahindra Bank Ltd. | 0.76% | 2.64% |
| Bajaj Electricals Ltd. | 0.56% | 1.19% |
| Aavas Financiers Ltd. | 0.51% | 1.73% |
| Jsw Dulux Ltd. | 0.48% | 1.47% |
Overlap: for each holding both funds own, the smaller of its two weights, added up. 42.3% means 42.3% 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 |
|---|---|
| Oberoi Realty Ltd. | 3.76% |
| Shree Cements Ltd. | 3.65% |
| Blue Star Ltd. | 2.67% |
| Brigade Enterprises Ltd. | 2.64% |
| APL Apollo Tubes Ltd. | 2.19% |
Largest holdings only in Tata Housing Opportunities Fund
| Security | % of fund |
|---|---|
| PRESTIGE ESTATES PROJECTS LTD | 5.09% |
| VENUS PIPES & TUBES LTD | 4.70% |
| PETRONET LNG LTD | 3.79% |
| PG ELECTROPLAST LTD | 3.17% |
| VOLTAS LTD | 2.73% |
Asset and sector split
Share of each fund, from its latest monthly portfolio
Asset allocation
| Asset | ICICI Prudential Housing Opportunities | Tata Housing Opportunities |
|---|---|---|
| Equity | 96.5% | 95.8% |
| Debt | 0.0% | 0.0% |
| Cash and others | 3.5% | 4.2% |
Market cap of stocks
| Market cap | ICICI Prudential Housing Opportunities | Tata Housing Opportunities |
|---|---|---|
| Large Cap | 54.2% | 56.8% |
| Mid Cap | 21.1% | 16.1% |
| Small Cap | 20.3% | 22.9% |
| Not on AMFI's list | 0.9% | 0.0% |
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 Housing Opportunities |
|---|---|---|
| Banks | 19.1% | 22.8% |
| Consumer Durables | 16.3% | 15.1% |
| Realty | 14.3% | 9.4% |
| Cement & Cement Products | 9.8% | 12.8% |
| Power | 9.7% | 7.5% |
| Ferrous Metals | 9.5% | 7.8% |
The six largest sectors of each fund's stocks, % of the fund.
ICICI Prudential Housing Opportunities vs Tata Housing Opportunities: Expense Ratio
What each plan charges a year, from AMFI's expense ratio file
| Charge | ICICI Prudential Housing Opportunities Fund | Tata Housing Opportunities Fund |
|---|---|---|
| Total expense ratio (Direct) | 1.22% | 1.06% |
| Base expense ratio (Direct) | 0.95% | 0.75% |
| Total expense ratio (Regular) | 2.07% | 2.61% |
| Base expense ratio (Regular) | 1.70% | 2.09% |
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
Compare Tata Housing Opportunities with
ICICI Prudential Housing Opportunities Fund vs Tata Housing Opportunities Fund: Frequently Asked Questions
What is the difference between ICICI Prudential Housing Opportunities Fund and Tata Housing Opportunities Fund?
ICICI Prudential Housing Opportunities Fund is a Thematic fund, Tata Housing Opportunities Fund is a Thematic fund, run by ICICI Prudential Mutual Fund and Tata Mutual Fund. Their portfolios overlap 42.3%. ICICI Prudential Housing Opportunities Fund charges 1.22% a year and Tata Housing Opportunities Fund 1.06%.
Which has given higher returns, ICICI Prudential Housing Opportunities Fund or Tata Housing Opportunities Fund?
Over 1 year: ICICI Prudential Housing Opportunities Fund −9.45%, Tata Housing Opportunities Fund −8.38%. Over 3 years: ICICI Prudential Housing Opportunities Fund +10.33% a year, Tata Housing Opportunities Fund +6.50% 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 Housing Opportunities Fund?
Tata Housing Opportunities Fund charges less: 1.06% 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 Housing Opportunities Fund overlap?
42.3%. They hold 16 of the same securities, the largest shared ones being HDFCBANK, ICICIBANK, NTPC. From each fund's latest monthly portfolio.
Which is better for SIP, ICICI Prudential Housing Opportunities Fund or Tata Housing Opportunities 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,63,958 in Tata Housing Opportunities Fund (XIRR -1.0% 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 Housing Opportunities Fund?
Yes. 42.3% of each fund's money sits in the same holdings, so a large part of the two investments would move together.
Who manages ICICI Prudential Housing Opportunities Fund and Tata Housing Opportunities Fund?
ICICI Prudential Housing Opportunities Fund: Sanket Gaidhani. Tata Housing Opportunities Fund: Aditya Bagul, Kapil Malhotra, Hasmukh Vishariya, Murthy Nagarajan.
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.