Tracking error: the return gap and its variability

This guide compares 60% SPY + 40% AGG, with unchanged quantities, against two reference mixtures using real price history. Example portfolio, not a recommendation. The references are a daily constant stock-and-bond mix and SPY alone. SPY and AGG are exchange-traded funds (ETFs), funds traded on an exchange, representing the S&P 500 and US aggregate bonds. The same example shows how both the choice of ingredients and rebalancing affect the comparison.

What the tool answers

Tracking asks how far, and how steadily, the holdings diverge from a reference you define. Excess return describes the gap between the two cumulative results; tracking error describes how much their return differences vary. The result describes that difference only. It does not judge whether the reference is appropriate for you or whether either portfolio's result meets a personal objective. These questions depend on information outside the calculation.

Defining a reference

A reference contains 1 to 5 components from 23 cached ETFs plus cash in the display currency. Whole percentages add up to 100%, and each user has one saved reference. When none is saved, the card uses 60% SPY + 40% AGG, marked as an example. The available funds represent markets and styles; cash keeps a constant value in the display currency. The reference editor defines the comparison mixture without changing the holdings used in the replay.

Daily constant weights versus unchanged quantities

The reference returns to its stated weights every day. Each day's return is the weighted sum of its components' returns, linked to the previous day's index value. The replay keeps quantities unchanged, so price movements change its weights. Even with identical ingredients and identical starting weights, these two rules create different paths. This comparison models those rules; it does not model trading costs or reconstruct transactions in an account.

Reading the five-year excess curves

The dashed horizontal line is zero: both sides have the same cumulative return there. Above it, the example's cumulative return is greater; below it, the reference's is greater. The curves end at +5.12 percentage points against the daily constant mix and -37.43 against SPY. The caption also states each curve's minimum and maximum with dates. A curve's level is a cumulative gap, not a daily return or the tracking-error figure.

  • Excess vs daily constant mix
  • Excess vs SPY
60% SPY + 40% AGG, Oct 11, 2021 to Oct 9, 2026. Example portfolio, not a recommendation. End excess against the daily constant mix: +5.12 points; against SPY: -37.43 points. Mix minimum -0.75 on May 4, 2023, maximum +5.19 on Oct 6, 2026; SPY minimum -37.58 on Oct 6, 2026, maximum +1.69 on Jun 16, 2022.

Comparing one year and five years

Each table uses a fresh starting mix at the beginning of its own window. The one-year and five-year columns therefore answer separate historical comparisons, rather than cutting the last year from an already-drifted five-year portfolio. The tables repeat the card's cumulative and annualized rows and tracking error, with 247 overlapping samples for one year and 1,250 for five years. Amounts are percentages or percentage points, without a judgement label.

60% SPY + 40% AGG. Reference: 60% SPY + 40% AGG, rebalanced daily. Example portfolio, not a recommendation. One-year window Oct 9, 2025 to Oct 9, 2026; five-year window Oct 11, 2021 to Oct 9, 2026.
Metric1 year5 years
Your portfolio (cumulative)9.73%54.07%
Reference (cumulative)9.52%48.94%
Excess return (cumulative)0.21%5.12%
Excess return (annualized)0.21%0.74%
Tracking error (annualized)0.20%0.97%
Overlapping five-day samples2471,250
60% SPY + 40% AGG. Reference: 100% SPY. Example portfolio, not a recommendation. One-year window Oct 9, 2025 to Oct 9, 2026; five-year window Oct 11, 2021 to Oct 9, 2026.
Metric1 year5 years
Your portfolio (cumulative)9.73%54.07%
Reference (cumulative)17.26%91.50%
Excess return (cumulative)-7.53%-37.43%
Excess return (annualized)-7.53%-4.85%
Tracking error (annualized)4.47%5.44%
Overlapping five-day samples2471,250

The same-assets comparison

Against the daily constant stock-and-bond mix, the ingredients are the same. The example is not rebalanced, and SPY's share drifted from 60% to 74.6% over five years in a rising stock market. This explains its positive excess and its small but non-zero tracking error: 0.20% over one year and 0.97% over five years. The difference comes from the paths created by the two weight rules, even though both portfolios began with the same funds.

The SPY comparison

SPY alone has different ingredients from the example. Tracking error is 4.47% over one year and 5.44% over five years. Roughly, a 5% tracking error means the yearly gap typically varied by about 5 percentage points. It does not mean a fixed 5% loss, or specify which side finishes ahead. The final excess can be negative while tracking error remains positive, because a standard deviation measures variability without carrying the direction of the final gap.

Cumulative and annualized excess return

Cumulative excess is the example's cumulative return minus the reference's cumulative return, expressed in percentage points. Annualized excess subtracts their two separately annualized returns. It is not the annualization of the gap itself. Calendar days determine the annualization period. Short spans magnify this conversion, so an annualized difference can look large even when the underlying cumulative difference covers only a brief interval.

Why overlapping five-day returns

Tracking error uses the sample standard deviation of overlapping 5-day return differences, multiplied by the square root of 252/5. Markets close at different times; daily returns can reflect that timing rather than a difference in exposure. On Hong Kong and A-share mixtures, daily tracking error was 1.6 to 1.8 times the five-day figure; for US-only mixtures it was about 0.9 to 1.05 times. At least 10 samples are required. Overlapping windows share days and are not independent samples.

Window, currency and missing data

The comparison follows the replay span, from 1M to 5Y, with a 1Y default, and follows its display currency. Components use historical exchange rates on each date. If a component lacks data needed for the comparison, the reference is unavailable; another fund is not substituted. The example's tables illustrate the one-year and five-year spans only. Different windows can contain different events and produce different comparisons.

Why there is no information ratio

The information ratio is not offered. It evaluates active management and can become unstable on short spans. This tool describes a gap and its variability without turning that comparison into a judgement about management or personal fit. Like the other Jade tools, it records historical movement of today's mixture, rather than predicting a future result.

References

Roll, R., A Mean/Variance Analysis of Tracking Error, Journal of Portfolio Management 18(4), 1992.