Sortino Ratio Calculator
Measure risk-adjusted performance using downside risk. Enter a series of portfolio returns and a minimum acceptable return (MAR) to calculate the Sortino ratio, downside deviation, and average excess return.
Sortino ratio calculation formulas
The Sortino ratio focuses on downside risk rather than total volatility. It compares your portfolio’s excess return over a minimum acceptable return (MAR) to the amount of negative variation below that target. The core formulas are straightforward but powerful when used consistently.
1. Excess return per period
Excess returnᵢ = Returnᵢ − MAR
Each period’s excess return is the portfolio return minus the minimum acceptable return. Positive excess returns are good; negative excess returns represent downside.
2. Downside deviation
Downside deviation = √( Σ (min(Excess returnᵢ, 0))² ÷ N )
Only negative excess returns are included in downside deviation. Positive excess returns are treated as zero in the downside calculation. The squared negative values are averaged and then square-rooted to produce a volatility-like measure focused on losses relative to MAR.
3. Average excess return
Average excess return = Σ Excess returnᵢ ÷ N
This is the mean of all excess returns across the periods you entered. It represents how much your portfolio has outperformed (or underperformed) the MAR on average.
4. Sortino ratio
Sortino ratio = Average excess return ÷ Downside deviation
The Sortino ratio expresses how much excess return you earn per unit of downside risk. Higher values indicate better risk-adjusted performance, with more reward for each unit of negative volatility.
These formulas work together to separate “good” volatility from “bad” volatility. Instead of penalizing upside swings, the Sortino ratio focuses on returns that fall below your chosen MAR, which many investors find more intuitive when evaluating risk.
Understanding the Sortino ratio and downside risk
The Sortino ratio is a refinement of the Sharpe ratio that focuses on downside volatility. While the Sharpe ratio treats all volatility as risk, the Sortino ratio distinguishes between upside and downside movements. For many investors, this distinction matters: large positive swings are rarely viewed as a problem, but large negative swings can be emotionally and financially painful.
Why downside risk matters
Traditional risk metrics often assume that investors dislike volatility in both directions. In practice, most people are far more sensitive to losses than to gains. A portfolio that occasionally spikes upward may look “risky” in a standard deviation sense, but it may feel perfectly acceptable if those spikes are positive. Downside deviation focuses only on returns that fall below a chosen threshold, such as 0% or the risk-free rate.
By using a minimum acceptable return (MAR), you define what counts as a “bad” outcome. Returns above MAR are treated as fine; returns below MAR are treated as downside. This framing aligns more closely with how many investors think about risk: they want to avoid falling below a certain floor, not necessarily avoid all volatility.
How this calculator models Sortino
When you enter a series of returns, the calculator converts each one into an excess return by subtracting your MAR. It then identifies which excess returns are negative and squares them to measure the magnitude of downside. These squared values are averaged and square-rooted to produce downside deviation. At the same time, the calculator computes the average excess return across all periods.
The Sortino ratio is then calculated as average excess return divided by downside deviation. If your portfolio has strong excess returns and relatively little downside, the ratio will be high. If your portfolio frequently dips below MAR or has large negative swings, the ratio will be lower, even if the average return looks decent.
Worked example
Imagine a portfolio with eight monthly returns (in %): 1.5, -0.8, 2.3, -1.2, 0.9, 1.1, -0.4, and 1.8. Suppose you set MAR to 0%. The calculator will treat positive returns as excess returns above MAR and negative returns as downside. It will square the negative excess returns (-0.8, -1.2, -0.4), average them, and take the square root to compute downside deviation.
At the same time, it will average all eight excess returns to find the mean excess return. Dividing the mean excess return by downside deviation yields the Sortino ratio. If you change MAR to 2%, more of the returns become downside, increasing downside deviation and potentially lowering the ratio. This sensitivity to MAR is one reason it’s important to choose a threshold that reflects your goals and risk tolerance.
Practical tips for using Sortino
- Use consistent periods: all monthly, weekly, or daily returns. Mixing periods can distort the ratio.
- Choose a MAR that reflects your real-world expectations, such as 0% or the risk-free rate.
- Compare Sortino ratios across portfolios or strategies, not in isolation. A higher ratio generally indicates better downside-adjusted performance.
- Remember that Sortino is backward-looking. It reflects historical returns, not guaranteed future outcomes.
- Use the CSV export to extend the analysis in a spreadsheet, add more periods, or compare multiple portfolios side by side.
Ultimately, the Sortino ratio is one tool among many. It can help you see whether a portfolio’s returns have been earned with relatively modest downside risk or whether gains have come with frequent dips below your comfort level. Combine it with other metrics, such as drawdown, Sharpe ratio, and diversification measures, to build a more complete picture of risk and reward.
Frequently Asked Questions
What data should I use for returns?
Use periodic portfolio returns expressed as percentages, such as monthly or weekly performance. Make sure all periods are consistent. You can start with up to 12 periods here and extend the analysis in a spreadsheet if needed.
How do I choose the minimum acceptable return (MAR)?
Common choices include 0% (no loss), the risk-free rate, or a personal target return. A higher MAR will classify more returns as downside, increasing downside deviation and potentially lowering the Sortino ratio.
Is a higher Sortino ratio always better?
Generally, yes. A higher Sortino ratio indicates more excess return per unit of downside risk. However, context matters: compare ratios across similar strategies and timeframes, and consider other risk metrics as well.
Can I compare Sortino ratios across different assets?
You can, but be careful to use consistent data (same period length, similar sample size) and the same MAR. Comparing a monthly Sortino ratio for one asset with a daily ratio for another can be misleading.
Does this tool handle compounding?
This calculator treats each period’s return as a simple percentage for the purpose of Sortino ratio computation. It does not model full portfolio compounding or cash flows. For more advanced analytics, export the CSV and extend the model in a spreadsheet.
Is this investment advice?
No. This tool is for education and planning. It can help you understand downside risk and risk-adjusted performance, but it is not personalized investment advice. Consider speaking with a qualified advisor before making major decisions.
Related tools
Information on this site is for educational purposes only and is not financial, tax, or legal advice. Calculations are estimates and may not reflect actual results. See our Privacy Policy and Disclaimer.