Beta against a benchmark · Calculation guide

Estimate portfolio sensitivity to changes in matched benchmark returns.

Calculation guide

Ordinary least squares slope with intercept. Match all observation dates and return definitions. Zero benchmark variance gives an undefined result.

beta = Σ[(r_i−mean(r))(b_i−mean(b))] / Σ(b_i−mean(b))^2.

Inputs

Portfolio return

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

Benchmark return

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

Worked example

Periods in chronological order

Portfolio returnBenchmark return
-2%-1%
2%1%
6%3%
ResultValue
Beta coefficient2

Interpreting the result

If the benchmark has exactly the same return in every observation, beta is undefined. If its return varies and the portfolio earns twice the benchmark return in every period, the slope is 2. Compare returns for the same dates and intervals.

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Portfolio return (row 1)-2%-1%Beta coefficient21.75
Benchmark return (row 1)-1%0%Beta coefficient22.571429
Beta against a benchmark →

Sources