Calculation guide
Uses all observations in the downside denominator, including zeros for returns above target. Annualized ratio assumes square-root-of-time scaling.
x_i=r_i−target; d=sqrt(Σmin(x_i,0)^2 / n); Sortino=mean(x)/d × sqrt(periods_per_year). If d=0 the ratio is undefined.
Inputs
Periods per year
Example entry 1. Allowed range 1 to 366. Use whole numbers.
Target return per period
Example entry 0 %. Allowed range -99.99999999999999 to 10000000.0.
Portfolio return
Example entry -2 %. Allowed range -100 to 10000000.0.
Worked example
| Input | Value |
|---|---|
| Periods per year | 1 |
| Target return per period | 0% |
Periods in chronological order
| Portfolio return |
|---|
| -2% |
| 0% |
| 3% |
| 3% |
| Result | Value |
|---|---|
| Annualized ratio | 1 |
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 |
|---|---|---|---|---|---|
| Periods per year | 1 | 2 | Annualized ratio | 1 | 1.414214 |
| Target return per period | 0% | 1% | Annualized ratio | 1 | 0 |
| Portfolio return (row 1) | -2% | -1% | Annualized ratio | 1 | 2.5 |
