Historical tracking error · Calculation guide

Measure the volatility of differences between portfolio and benchmark returns.

Calculation guide

Match dates, currencies and total-return convention. Use sample standard deviation; stable, uncorrelated period returns assumed for annualization.

active_i=r_i−b_i; tracking_error_pct=sampleSD(active) × sqrt(periods_per_year).

Inputs

Periods per year

Example entry 12. Allowed range 1 to 366. Use whole numbers.

Portfolio return

Example entry 3 %. Allowed range -100 to 10000000.0.

Benchmark return

Example entry 2 %. Allowed range -100 to 10000000.0.

Worked example

InputValue
Periods per year12

Periods in chronological order

Portfolio returnBenchmark return
3%2%
2%2%
1%2%
ResultValue
Annualized tracking error3.464102%

Interpreting the result

A constant gap between the portfolio and benchmark gives zero tracking error. For example, consistently trailing by one percentage point has the same tracking error as matching the benchmark every period. Compare average active return to see the difference.

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Periods per year1213Annualized tracking error3.464102%3.605551%
Portfolio return (row 1)3%4%Annualized tracking error3.464102%5.291503%
Benchmark return (row 1)2%3%Annualized tracking error3.464102%2%
Historical tracking error →

Sources