ICICI Prudential Housing Opportunities Fund vs Tata Focused Fund
Direct Plan, Growth option · Data as on 30-10-2026
ICICI Prudential Housing Opportunities Fund is a Thematic fund and Tata Focused Fund is a Focused fund. In the 3 years to 30-10-2026, ICICI Prudential Housing Opportunities Fund (Direct) returned 10.3% a year and Tata Focused Fund (Direct) returned 8.4% a year. ICICI Prudential Housing Opportunities Fund charges 1.22% a year and Tata Focused Fund 0.94% (Direct plans). Their portfolios overlap 31.5%: they hold 10 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 Focused? 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 8.4%.
- ICICI Prudential Housing Opportunities returned more over 1 year: −9.4% against −10.3%.
- Tata Focused costs less: 0.94% 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 14.5%.
- ICICI Prudential Housing Opportunities fell less in its worst fall since 19-04-2022: −16.7% against −19.6%.
- Tata Focused holds more in large companies: 67.0% of the fund in large caps against 54.2%.
- ICICI Prudential Housing Opportunities is the larger fund: ₹2,631 Cr against ₹1,625 Cr.
- Their portfolios overlap 31.5%: 10 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 Focused Fund |
|---|---|---|
| Fund house | ICICI Prudential Mutual Fund | Tata Mutual Fund |
| Category | Thematic | Focused |
| AUM | ₹2,631 Cr (30-09-2026) | ₹1,625 Cr (30-09-2026) |
| NAV | ₹16.96 (Direct) | ₹23.66 (Direct) |
| Expense ratio (Direct) | 1.22% | 0.94% |
| Expense ratio (Regular) | 2.07% | 2.29% |
| Riskometer | Not available | Very High |
| Benchmark | Nifty Housing TRI | Nifty 500 TRI |
| Launch date | 18-04-2022 | 05-12-2019 |
| Minimum investment | ₹5,000 | ₹5,000 |
| Lock in | None | None |
| Fund managers | Sanket Gaidhani | Anand Sharma, Hasmukh Vishariya |
| 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 0.50%, if redeemed within 30 days. |
ICICI Prudential Housing Opportunities vs Tata Focused: 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 Focused Fund (Direct) | −1.22% | −8.77% | −5.05% | −10.26% | +8.45% | +8.50% | -- |
| Thematic average | −2.09% | −4.52% | +0.86% | −1.22% | +13.76% | -- | -- |
| Focused average | −1.00% | −4.12% | +1.39% | −3.09% | +12.30% | +10.21% | -- |
Category average: the average of the 235 Thematic funds and the 28 Focused funds, same plan type.
ICICI Prudential Housing Opportunities vs Tata Focused: Year-wise Returns
| Year | ICICI Prudential Housing OpportunitiesICICI Prudential Housing Opportunities | Tata FocusedTata Focused |
|---|---|---|
| 2026to date | −6.97% | −9.90% |
| 2025 | +7.17% | +1.37% |
| 2024 | +16.35% | +19.99% |
| 2023 | +32.43% | +29.82% |
| 2022 | -- | +6.58% |
| 2021 | -- | +35.41% |
ICICI Prudential Housing Opportunities vs Tata Focused: 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 Focused 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 Focused | 0.0 | 0.0 | 9.3 | 24.9 | 56.1 | 9.8 | 0.0 | 15.7% | 16.1% | 7.4% | 22.4% | 58% |
| 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 Focused: 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 FocusedTata Focused Fund (Direct) | ₹5,50,000 | ₹6,25,275 | ₹75,275 | 5.6% |
ICICI Prudential Housing OpportunitiesICICI Prudential Housing Opportunities Fund (Direct)
Tata FocusedTata Focused 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 Focused: 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 Focused Fund (Direct) |
|---|---|---|
| Return (CAGR) | −9.45% | −10.26% |
| Standard deviation | 14.93% | 14.03% |
| Sharpe ratio | -0.98 | -1.10 |
| Sortino ratio | -1.32 | -1.47 |
| Maximum drawdown | −13.3% (23-03-2026) | −14.2% (31-03-2026) |
| Beta | 0.86 | 0.94 |
| Alpha | −4.12% | −3.62% |
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 Focused Fund (Direct) |
|---|---|---|
| Return (CAGR) | +10.33% | +8.45% |
| Standard deviation | 14.05% | 14.49% |
| Sharpe ratio | 0.31 | 0.17 |
| Sortino ratio | 0.42 | 0.23 |
| Maximum drawdown | −16.7% (28-02-2025) | −19.6% (13-03-2025) |
| Beta | 0.80 | 0.98 |
| Alpha | +1.14% | −1.67% |
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 Focused Fund (Direct) |
|---|---|---|
| Return (CAGR) | +12.44% | +13.31% |
| Standard deviation | 12.48% | 17.55% |
| Sharpe ratio | 0.51 | 0.47 |
| Sortino ratio | 0.70 | 0.62 |
| Maximum drawdown | −16.7% (28-02-2025) | −37.3% (23-03-2020) |
| Beta | 0.73 | 0.99 |
| Alpha | +4.28% | −0.29% |
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 Focused 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 Focused Fund (Direct) | −19.6% | 26-09-2024 | 13-03-2025 | Not yet | -- | −14.6% |
| 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 Focused 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 Focused 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 Focused Fund (Direct) | 80% | 68% | 8.35% |
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 Focused: Portfolio Overlap
From each fund's latest monthly portfolio: ICICI Prudential Housing Opportunities Fund, September 2026; Tata Focused Fund, September 2026
Holdings in common
- Overlap
- 31.5%
- Held by both
- 10
- Only in ICICI Prudential Housing Opportunities
- 49
- Only in Tata Focused
- 18
| Security | % of ICICI Prudential Housing Opportunities | % of Tata Focused |
|---|---|---|
| HDFC Bank Ltd. | 6.52% | 8.03% |
| ICICI Bank Ltd. | 6.31% | 7.58% |
| NTPC Ltd. | 7.08% | 4.44% |
| Larsen & Toubro Ltd. | 4.72% | 3.93% |
| Ultratech Cement Ltd. | 3.82% | 5.21% |
| Havells India Ltd. | 2.06% | 3.15% |
| Axis Bank Ltd. | 1.97% | 6.30% |
| Life Insurance Corporation of India | 1.14% | 2.15% |
| Jindal Steel Ltd. | 0.82% | 2.83% |
| Pidilite Industries Ltd. | 0.78% | 0.54% |
Overlap: for each holding both funds own, the smaller of its two weights, added up. 31.5% means 31.5% 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 |
|---|---|
| Tata Steel Ltd. | 6.04% |
| Asian Paints Ltd. | 5.32% |
| Oberoi Realty Ltd. | 3.76% |
| Shree Cements Ltd. | 3.65% |
| State Bank Of India | 2.93% |
Largest holdings only in Tata Focused Fund
| Security | % of fund |
|---|---|
| RELIANCE INDUSTRIES LTD | 4.92% |
| BHARTI AIRTEL LTD | 4.42% |
| HEALTHCARE GLOBAL ENTERPRISES LTD | 4.14% |
| SBI LIFE INSURANCE COMPANY LTD | 4.05% |
| INFOSYS LTD | 4.03% |
Asset and sector split
Share of each fund, from its latest monthly portfolio
Asset allocation
| Asset | ICICI Prudential Housing Opportunities | Tata Focused |
|---|---|---|
| Equity | 96.5% | 93.7% |
| Debt | 0.0% | 0.0% |
| Cash and others | 3.5% | 6.3% |
Market cap of stocks
| Market cap | ICICI Prudential Housing Opportunities | Tata Focused |
|---|---|---|
| Large Cap | 54.2% | 67.0% |
| Mid Cap | 21.1% | 11.6% |
| Small Cap | 20.3% | 12.8% |
| Not on AMFI's list | 0.9% | 2.4% |
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 Focused |
|---|---|---|
| Banks | 19.1% | 21.9% |
| Consumer Durables | 16.3% | 5.0% |
| Realty | 14.3% | 2.7% |
| Cement & Cement Products | 9.8% | 5.2% |
| Power | 9.7% | 4.4% |
| Ferrous Metals | 9.5% | 2.8% |
| Insurance | 1.1% | 9.0% |
| Construction | 6.9% | 5.5% |
| Telecom - Services | 0.0% | 6.4% |
| Healthcare Services | 0.0% | 5.9% |
The six largest sectors of each fund's stocks, % of the fund.
ICICI Prudential Housing Opportunities vs Tata Focused: Expense Ratio
What each plan charges a year, from AMFI's expense ratio file
| Charge | ICICI Prudential Housing Opportunities Fund | Tata Focused Fund |
|---|---|---|
| Total expense ratio (Direct) | 1.22% | 0.94% |
| Base expense ratio (Direct) | 0.95% | 0.64% |
| Total expense ratio (Regular) | 2.07% | 2.29% |
| Base expense ratio (Regular) | 1.70% | 1.80% |
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 Focused Fund: Frequently Asked Questions
What is the difference between ICICI Prudential Housing Opportunities Fund and Tata Focused Fund?
ICICI Prudential Housing Opportunities Fund is a Thematic fund, Tata Focused Fund is a Focused fund, run by ICICI Prudential Mutual Fund and Tata Mutual Fund. Their portfolios overlap 31.5%. ICICI Prudential Housing Opportunities Fund charges 1.22% a year and Tata Focused Fund 0.94%.
Which has given higher returns, ICICI Prudential Housing Opportunities Fund or Tata Focused Fund?
Over 1 year: ICICI Prudential Housing Opportunities Fund −9.45%, Tata Focused Fund −10.26%. Over 3 years: ICICI Prudential Housing Opportunities Fund +10.33% a year, Tata Focused Fund +8.45% 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 Focused Fund?
Tata Focused Fund charges less: 0.94% 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 Focused Fund overlap?
31.5%. They hold 10 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 Focused 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,62,692 in Tata Focused Fund (XIRR -1.3% 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 Focused Fund?
Yes. 31.5% 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 Focused Fund?
ICICI Prudential Housing Opportunities Fund: Sanket Gaidhani. Tata Focused Fund: Anand Sharma, Hasmukh Vishariya.
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.