SORTINORATIO
Measure risk-adjusted returns relative to downside deviations.
Last updated
Measure risk-adjusted returns relative to downside deviations.
Last updated
The Sortino ratio measures the risk-adjusted return of an instrument (or portfolio) normalized by its downside deviation. This ratio is often considered a variant of the Sharpe ratio as it only considers downside risk. This is useful for investors and analysts to assess an investment's performance under undesirable volatility environments.
The following describes the function signature for use in Microsoft Excel's formula bar.
Vector of Sortino ratio estimate(s).
Argument
Description
returns
Required. Time series or matrix of instrument returns.
threshold
Optional. Return threshold. If the argument is not defined, it will use zero.