Axis BSE Sensex ETF vs Tata Housing Opportunities Fund
Direct Plan where a fund has one, Growth option · Data as on 30-10-2026
Axis BSE Sensex ETF is an ETF fund and Tata Housing Opportunities Fund is a Thematic fund. In the 3 years to 30-10-2026, Axis BSE Sensex ETF returned 6.2% a year and Tata Housing Opportunities Fund (Direct) returned 6.5% a year. Axis BSE Sensex ETF charges 0.04% a year and Tata Housing Opportunities Fund 1.06%. Their portfolios overlap 32.4%: they hold 9 of the same securities.
Tata Housing Opportunities Fund
Thematic
- 3 year return
- 6.5%
- Expense ratio
- 1.06%
- NAV
- ₹14.97
Which is better, Axis BSE Sensex ETF 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.
- Tata Housing Opportunities returned more over 3 years: 6.5% a year against 6.2%.
- Tata Housing Opportunities returned more over 1 year: −8.4% against −10.9%.
- Axis BSE Sensex ETF costs less: 0.04% a year against 1.06%.
- Axis BSE Sensex ETF swung less over 3 years: a standard deviation of 13.2% a year against 15.9%.
- Axis BSE Sensex ETF fell less in its worst fall since 29-03-2023: −16.0% against −24.2%.
- Axis BSE Sensex ETF holds more in large companies: 100.0% of the fund in large caps against 56.8%.
- Tata Housing Opportunities is the larger fund: ₹451 Cr against ₹121 Cr.
- Their portfolios overlap 32.4%: 9 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 | Axis BSE Sensex ETF | Tata Housing Opportunities Fund |
|---|---|---|
| Fund house | Axis Mutual Fund | Tata Mutual Fund |
| Category | ETF | Thematic |
| AUM | ₹121 Cr (30-09-2026) | ₹451 Cr (30-09-2026) |
| NAV | ₹77.37 | ₹14.97 (Direct) |
| Expense ratio (Direct) | Not available | 1.06% |
| Expense ratio (Regular) | Not available | 2.61% |
| Riskometer | Very High | Very High |
| Benchmark | BSE SENSEX TRI | Nifty Housing TRI |
| Launch date | 24-03-2023 | 02-09-2022 |
| Minimum investment | 40000 (Units) | ₹5,000 |
| Lock in | None | None |
| Fund managers | Nandik Malik, Rohit Gautam | Aditya Bagul, Kapil Malhotra, Hasmukh Vishariya, Murthy Nagarajan |
| Exit load | Nil | Exit load of 1%, if redeemed within 30 days. |
Axis BSE Sensex ETF 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 |
|---|---|---|---|---|---|---|---|
| Axis BSE Sensex ETF | +2.77% | −4.30% | −2.43% | −10.95% | +6.21% | -- | -- |
| 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.
Axis BSE Sensex ETF vs Tata Housing Opportunities: Year-wise Returns
| Year | Axis BSE Sensex ETFAxis BSE Sensex ETF | Tata Housing OpportunitiesTata Housing Opportunities |
|---|---|---|
| 2026to date | −11.84% | −5.64% |
| 2025 | +10.32% | −1.97% |
| 2024 | +9.31% | +14.02% |
| 2023 | -- | +41.57% |
Axis BSE Sensex ETF vs Tata Housing Opportunities: Rolling Returns
Every holding period of both funds, against BSE SENSEX TRI, the benchmark of Axis BSE Sensex ETF
Rolling returns
Every 3-year holding period, 146 of them, one for each trading day from 30-03-2026 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.
Axis BSE Sensex ETF
Tata Housing Opportunities Fund (Direct)
BSE SENSEX TRI
to
Apr 2026May 2023
to
May 2026Jun 2023
to
Jun 2026Aug 2023
to
Aug 2026Sept 2023
to
Sept 2026Oct 2023
to
Oct 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Axis BSE Sensex ETF | 0.0 | 13.7 | 80.1 | 6.2 | 0.0 | 0.0 | 0.0 | 7.1% | 7.1% | 3.8% | 11.2% | 0% |
| Tata Housing Opportunities | 0.0 | 0.0 | 40.7 | 59.3 | 0.0 | 0.0 | 0.0 | 10.1% | 10.5% | 5.6% | 14.6% | 100% |
| BSE SENSEX TRI | 0.0 | 12.3 | 81.5 | 6.2 | 0.0 | 0.0 | 0.0 | 7.2% | 7.2% | 3.9% | 11.3% | -- |
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 BSE SENSEX 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 29-03-2023. Past returns do not promise future returns.
Axis BSE Sensex ETF 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 29-03-2023 to 30-10-2026: 44 instalments, ₹4,40,000 in all.
| Investment | Invested | Value now | Gain | Return a year |
|---|---|---|---|---|
| Axis BSE Sensex ETFAxis BSE Sensex ETF | ₹4,40,000 | ₹4,50,676 | ₹10,676 | 1.3% |
| Tata Housing OpportunitiesTata Housing Opportunities Fund (Direct) | ₹4,40,000 | ₹4,58,431 | ₹18,431 | 2.2% |
Axis BSE Sensex ETFAxis BSE Sensex ETF
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.
Axis BSE Sensex ETF vs Tata Housing Opportunities: Risk and Drawdowns
How much each fund swings, and the worst fall over the same days
Risk and return
| Measure | Axis BSE Sensex ETF | Tata Housing Opportunities Fund (Direct) |
|---|---|---|
| Return (CAGR) | −10.95% | −8.38% |
| Standard deviation | 13.98% | 16.36% |
| Sharpe ratio | -1.16 | -0.83 |
| Sortino ratio | -1.55 | -1.11 |
| Maximum drawdown | −16.0% (31-03-2026) | −17.6% (31-03-2026) |
| Beta | 1.00 | 0.93 |
| Alpha | −0.06% | −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 | Axis BSE Sensex ETF | Tata Housing Opportunities Fund (Direct) |
|---|---|---|
| Return (CAGR) | +6.21% | +6.50% |
| Standard deviation | 13.25% | 15.86% |
| Sharpe ratio | 0.01 | 0.03 |
| Sortino ratio | 0.02 | 0.04 |
| Maximum drawdown | −16.0% (31-03-2026) | −24.2% (28-02-2025) |
| Beta | 1.00 | 0.86 |
| Alpha | −0.11% | −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 | Axis BSE Sensex ETF | Tata Housing Opportunities Fund (Direct) |
|---|---|---|
| Return (CAGR) | +8.45% | +10.06% |
| Standard deviation | 12.62% | 14.37% |
| Sharpe ratio | 0.18 | 0.27 |
| Sortino ratio | 0.26 | 0.36 |
| Maximum drawdown | −16.0% (31-03-2026) | −24.2% (28-02-2025) |
| Beta | 1.00 | 0.82 |
| Alpha | −0.13% | +2.23% |
From daily NAVs, 29-03-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.
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.
Axis BSE Sensex ETF
Tata Housing Opportunities Fund (Direct)
BSE SENSEX TRI
| Fund | Worst fall | High before it | Bottom | Back at the high | Time to climb back | Below its high today |
|---|---|---|---|---|---|---|
| Axis BSE Sensex ETF | −16.0% | 02-01-2026 | 31-03-2026 | Not yet | -- | −12.4% |
| Tata Housing Opportunities Fund (Direct) | −24.2% | 23-09-2024 | 28-02-2025 | Not yet | -- | −15.5% |
| BSE SENSEX TRI | −16.1% | 02-01-2026 | 30-03-2026 | Not yet | -- | −12.4% |
From daily values since 29-03-2023, 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.
Axis BSE Sensex ETF
Tata Housing Opportunities Fund (Direct)
BSE SENSEX 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.
Axis BSE Sensex ETF
Tata Housing Opportunities Fund (Direct)
BSE SENSEX TRI
Against BSE SENSEX TRI
| Fund | Up capture | Down capture | Tracking error |
|---|---|---|---|
| Axis BSE Sensex ETF | 99% | 100% | 0.05% |
| Tata Housing Opportunities Fund (Direct) | 117% | 97% | 9.62% |
From month-end values since 29-03-2023. 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.
Axis BSE Sensex ETF vs Tata Housing Opportunities: Portfolio Overlap
From each fund's latest monthly portfolio: Axis BSE Sensex ETF, September 2026; Tata Housing Opportunities Fund, September 2026
Holdings in common
- Overlap
- 32.4%
- Held by both
- 9
- Only in Axis BSE Sensex ETF
- 21
- Only in Tata Housing Opportunities
- 21
| Security | % of Axis BSE Sensex ETF | % of Tata Housing Opportunities |
|---|---|---|
| HDFC Bank Limited | 12.59% | 9.38% |
| ICICI Bank Limited | 11.03% | 7.04% |
| Larsen & Toubro Limited | 5.11% | 5.57% |
| Kotak Mahindra Bank Limited | 3.57% | 2.64% |
| State Bank of India | 4.64% | 1.92% |
| NTPC Limited | 1.78% | 5.44% |
| Tata Steel Limited | 1.77% | 1.82% |
| UltraTech Cement Limited | 1.50% | 8.45% |
| Asian Paints Limited | 1.27% | 3.15% |
Overlap: for each holding both funds own, the smaller of its two weights, added up. 32.4% means 32.4% 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 Axis BSE Sensex ETF
| Security | % of fund |
|---|---|
| Reliance Industries Limited | 9.15% |
| Bharti Airtel Limited | 6.38% |
| Infosys Limited | 4.08% |
| Axis Bank Limited | 4.08% |
| Mahindra & Mahindra Limited | 3.07% |
Largest holdings only in Tata Housing Opportunities Fund
| Security | % of fund |
|---|---|
| PRESTIGE ESTATES PROJECTS LTD | 5.09% |
| JSW STEEL LTD | 4.86% |
| VENUS PIPES & TUBES LTD | 4.70% |
| PETRONET LNG LTD | 3.79% |
| AMBUJA CEMENTS LTD | 3.37% |
Asset and sector split
Share of each fund, from its latest monthly portfolio
Asset allocation
| Asset | Axis BSE Sensex ETF | Tata Housing Opportunities |
|---|---|---|
| Equity | 100.0% | 95.8% |
| Debt | 0.0% | 0.0% |
| Cash and others | 0.0% | 4.2% |
Market cap of stocks
| Market cap | Axis BSE Sensex ETF | Tata Housing Opportunities |
|---|---|---|
| Large Cap | 100.0% | 56.8% |
| Mid Cap | 0.0% | 16.1% |
| Small Cap | 0.0% | 22.9% |
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 | Axis BSE Sensex ETF | Tata Housing Opportunities |
|---|---|---|
| Banks | 35.9% | 22.8% |
| Consumer Durables | 3.5% | 15.1% |
| Cement & Cement Products | 1.5% | 12.8% |
| Realty | 0.0% | 9.4% |
| Petroleum Products | 9.2% | 0.0% |
| IT - Software | 9.1% | 0.0% |
| Ferrous Metals | 1.8% | 7.8% |
| Power | 3.2% | 7.5% |
| Telecom - Services | 6.4% | 0.0% |
| Construction | 5.1% | 5.6% |
| Diversified FMCG | 4.9% | 0.0% |
The six largest sectors of each fund's stocks, % of the fund.
Axis BSE Sensex ETF vs Tata Housing Opportunities: Expense Ratio
What each plan charges a year, from AMFI's expense ratio file
| Charge | Axis BSE Sensex ETF | Tata Housing Opportunities Fund |
|---|---|---|
| Total expense ratio (Direct) | Not available | 1.06% |
| Base expense ratio (Direct) | 0.00% | 0.75% |
| Total expense ratio (Regular) | Not available | 2.61% |
| Base expense ratio (Regular) | 0.03% | 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 Tata Housing Opportunities with
Axis BSE Sensex ETF vs Tata Housing Opportunities Fund: Frequently Asked Questions
What is the difference between Axis BSE Sensex ETF and Tata Housing Opportunities Fund?
Axis BSE Sensex ETF is an ETF fund, Tata Housing Opportunities Fund is a Thematic fund, run by Axis Mutual Fund and Tata Mutual Fund. Their portfolios overlap 32.4%. Axis BSE Sensex ETF charges 0.04% a year and Tata Housing Opportunities Fund 1.06%.
Which has given higher returns, Axis BSE Sensex ETF or Tata Housing Opportunities Fund?
Over 1 year: Axis BSE Sensex ETF −10.95%, Tata Housing Opportunities Fund −8.38%. Over 3 years: Axis BSE Sensex ETF +6.21% 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, Axis BSE Sensex ETF or Tata Housing Opportunities Fund?
Axis BSE Sensex ETF charges less: 0.04% a year against 1.06%. These are the total expense ratios reported to AMFI.
How much do Axis BSE Sensex ETF and Tata Housing Opportunities Fund overlap?
32.4%. They hold 9 of the same securities, the largest shared ones being HDFCBANK, ICICIBANK, LT. From each fund's latest monthly portfolio.
Which is riskier, Axis BSE Sensex ETF or Tata Housing Opportunities Fund?
On SEBI's riskometer, Axis BSE Sensex ETF is rated Very High and Tata Housing Opportunities Fund Very High. Over 3 years, the standard deviation of daily returns was 13.25% and 15.86% a year.
Which is better for SIP, Axis BSE Sensex ETF 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,63,956 in Axis BSE Sensex ETF (XIRR -1.0% 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 Axis BSE Sensex ETF and Tata Housing Opportunities Fund?
Yes. 32.4% of each fund's money sits in the same holdings, so some of the two investments would move together.
Who manages Axis BSE Sensex ETF and Tata Housing Opportunities Fund?
Axis BSE Sensex ETF: Nandik Malik, Rohit Gautam. 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.