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 return | Benchmark return |
|---|---|
| -2% | -1% |
| 2% | 1% |
| 6% | 3% |
| Result | Value |
|---|---|
| Beta coefficient | 2 |
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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Portfolio return (row 1) | -2% | -1% | Beta coefficient | 2 | 1.75 |
| Benchmark return (row 1) | -1% | 0% | Beta coefficient | 2 | 2.571429 |
