ZQQ.TO vs. MSFT.TO

Last updated Jun 4, 2026

ZQQ.TO (BMO NASDAQ 100 Equity (CAD Hedged)) is Nasdaq-100 fund tracking the NASDAQ-100 Index, while MSFT.TO (Microsoft CDR (CAD Hedged)) is a stock. Over the past 3 years, ZQQ.TO returned 26.42%/yr vs 7.17%/yr for MSFT.TO. A 0.77 correlation means they provide meaningful diversification when combined.

Performance

ZQQ.TO vs. MSFT.TO - Performance Comparison

The chart below illustrates the hypothetical performance of a CA$10,000 investment in BMO NASDAQ 100 Equity (CAD Hedged) (ZQQ.TO) and Microsoft CDR (CAD Hedged) (MSFT.TO). The values are adjusted to include any dividend payments, if applicable.

Returns By Period

In the year-to-date period, ZQQ.TO achieves a 19.82% return, which is significantly higher than MSFT.TO's -12.19% return.

ZQQ.TO

• 1D: -0.28%
• 1M: 10.63%
• YTD: 19.82%
• 6M: 18.08%
• 1Y: 38.53%
• 3Y*: 26.42%
• 5Y*: 16.12%
• 10Y*: 20.08%

MSFT.TO

• 1D: -3.34%
• 1M: 3.45%
• YTD: -12.19%
• 6M: -11.44%
• 1Y: -9.32%
• 3Y*: 7.17%
• 5Y*: —
• 10Y*: —

*Multi-year figures are annualized to reflect compound growth (CAGR)

ZQQ.TO vs. MSFT.TO - Yearly Performance Comparison

	2026 (YTD)	2025	2024	2023	2022	2021
ZQQ.TO BMO NASDAQ 100 Equity (CAD Hedged)	19.82%	18.38%	24.00%	52.52%	-33.75%	11.23%
MSFT.TO Microsoft CDR (CAD Hedged)	-12.19%	12.65%	11.26%	56.34%	-29.26%	16.37%

Correlation

The correlation between ZQQ.TO and MSFT.TO is 0.49, which is low. Their price movements are largely independent, making them effective diversification partners.

	Correlation
Correlation (1Y) Calculated over the trailing 1-year period	0.49
Correlation (3Y) Calculated over the trailing 3-year period	0.68
Correlation (All Time) Calculated using the full available price history since Oct 6, 2021	0.77

Over the past year, the correlation between ZQQ.TO and MSFT.TO has dropped to 0.49 - well below their long-term average of 0.77, suggesting their price drivers have been diverging.

Return for Risk

ZQQ.TO vs. MSFT.TO — Risk / Return Rank

Compare risk-adjusted metric ranks to identify better-performing investments over the past 12 months.

ZQQ.TO

ZQQ.TO Risk / Return Rank: 67
ZQQ.TO Sharpe Ratio Rank: 74
ZQQ.TO Sortino Ratio Rank: 69
ZQQ.TO Omega Ratio Rank: 69
ZQQ.TO Calmar Ratio Rank: 60
ZQQ.TO Martin Ratio Rank: 61

MSFT.TO

MSFT.TO Risk / Return Rank: 26
MSFT.TO Sharpe Ratio Rank: 24
MSFT.TO Sortino Ratio Rank: 22
MSFT.TO Omega Ratio Rank: 22
MSFT.TO Calmar Ratio Rank: 31
MSFT.TO Martin Ratio Rank: 30

The rank (0–100) shows how this investment's returns compare to the risk taken. Higher = better. Based on the past 12 months of data, combining Sharpe, Sortino, and other metrics used by quantitative funds and institutional investors.

ZQQ.TO vs. MSFT.TO - Risk-Adjusted Trends Comparison

This table presents a comparison of risk-adjusted performance metrics for BMO NASDAQ 100 Equity (CAD Hedged) (ZQQ.TO) and Microsoft CDR (CAD Hedged) (MSFT.TO). Risk-adjusted metrics are performance indicators that assess an investment's returns in relation to its risk, enabling a more accurate comparison of different investment options.

	ZQQ.TO	MSFT.TO	Difference
Sharpe ratio: Return per unit of total volatility	2.46	-0.37	+2.83
Sortino ratio: Return per unit of downside risk	3.25	-0.35	+3.59
Omega ratio: Gain probability vs. loss probability	1.43	0.95	+0.47
Calmar ratio: Return relative to maximum drawdown	3.01	-0.27	+3.28
Martin ratio: Return relative to average drawdown	11.25	-0.57	+11.81
Data is calculated on a 1-year rolling basis and updated daily. The trend shows the change in the indicator over the past month.

ZQQ.TO vs. MSFT.TO - Sharpe Ratio Comparison

The current ZQQ.TO Sharpe Ratio is 2.46, which is higher than the MSFT.TO Sharpe Ratio of -0.37. The chart below compares the historical Sharpe Ratios of ZQQ.TO and MSFT.TO, calculated using daily returns over the previous 12 months. A higher Sharpe Ratio indicates better risk-adjusted performance relative to the risk-free rate.

Sharpe Ratios by Period

	ZQQ.TO	MSFT.TO	Difference
Sharpe Ratio (1Y) Calculated over the trailing 1-year period	2.46	-0.37	+2.83
Sharpe Ratio (5Y) Calculated over the trailing 5-year period	0.72	—	—
Sharpe Ratio (10Y) Calculated over the trailing 10-year period	0.90	—	—
Sharpe Ratio (All Time) Calculated using the full available price history	0.91	0.29	+0.62

Drawdowns

ZQQ.TO vs. MSFT.TO - Drawdown Comparison

The maximum ZQQ.TO drawdown since its inception was -36.39%, roughly equal to the maximum MSFT.TO drawdown of -37.95%. Use the drawdown chart below to compare losses from any high point for ZQQ.TO and MSFT.TO.

Drawdown Indicators

	ZQQ.TO	MSFT.TO	Difference
Max Drawdown Largest peak-to-trough decline	-36.39%	-37.95%	+1.56%
Max Drawdown (1Y) Largest decline over 1 year	-12.86%	-34.43%	+21.57%
Max Drawdown (3Y) Largest decline over 3 years	-22.79%	-34.43%	+11.64%
Max Drawdown (5Y) Largest decline over 5 years	-36.39%	—	—
Max Drawdown (10Y) Largest decline over 10 years	-36.39%	—	—
Current Drawdown Current decline from peak	-0.28%	-21.97%	+21.69%
Average Drawdown Average peak-to-trough decline	-5.37%	-12.37%	+7.00%
Ulcer Index Depth and duration of drawdowns from previous peaks	3.43%	16.51%	-13.08%

Volatility

ZQQ.TO vs. MSFT.TO - Volatility Comparison

The current volatility for BMO NASDAQ 100 Equity (CAD Hedged) (ZQQ.TO) is 4.54%, while Microsoft CDR (CAD Hedged) (MSFT.TO) has a volatility of 10.22%. This indicates that ZQQ.TO experiences smaller price fluctuations and is considered to be less risky than MSFT.TO based on this measure. The chart below showcases a comparison of their rolling one-month volatility.

Volatility by Period

	ZQQ.TO	MSFT.TO	Difference
Volatility (1M) Calculated over the trailing 1-month period	4.54%	10.22%	-5.68%
Volatility (6M) Calculated over the trailing 6-month period	12.02%	22.52%	-10.50%
Volatility (1Y) Calculated over the trailing 1-year period	15.73%	25.17%	-9.44%
Volatility (5Y) Calculated over the trailing 5-year period, annualized	22.57%	27.31%	-4.74%
Volatility (10Y) Calculated over the trailing 10-year period, annualized	22.41%	27.31%	-4.90%

Dividends

ZQQ.TO vs. MSFT.TO - Dividend Comparison

ZQQ.TO's dividend yield for the trailing twelve months is around 0.22%, less than MSFT.TO's 0.84% yield.

Position	TTM	2025	2024	2023	2022	2021	2020	2019	2018	2017	2016	2015
MSFT.TO Microsoft CDR (CAD Hedged)	0.84%	0.71%	0.73%	0.75%	1.07%	0.18%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
ZQQ.TO BMO NASDAQ 100 Equity (CAD Hedged)	0.22%	0.27%	0.37%	0.32%	0.45%	0.14%	0.41%	0.51%	0.64%	0.57%	1.60%	0.81%

Frequently Asked Questions

Can I hold both ZQQ.TO and MSFT.TO in my portfolio?

ZQQ.TO and MSFT.TO have a correlation of 0.49, meaning they provide meaningful diversification benefit when combined. Depending on your allocation goals, holding both could reduce overall portfolio risk.