Excel Lab
  • Excel Lab
  • Release Notes
  • Getting Started
    • Installing Excel Lab
      • Step 1: Download Files
      • Step 2: Register Libraries
      • Step 3: Activate Add-in
      • Step 4: Verify Installation
  • Functions
    • General
      • ISMATRIXPSD
      • MATRIX
      • XLABHELP
      • XLABINFO
      • XLABLICENSE
      • RESETPASSWORD
    • Return Models
      • CAPM
      • DESMOOTHRETURNS
      • IMPLIEDRETURNS
      • MLERETURNS
    • Risk Models
      • ANNUALIZERISK
      • EWMA
      • HISTORICALRISK
      • MLERISK
      • PORTFOLIORISK
      • TURBULENTRISK
      • QUIETRISK
    • Optimization
      • MVO
      • MTO
      • MVT
      • MVFRONTIER
      • MTFRONTIER
      • ISORETURN
    • Simulation
      • MCNORM
      • BOOTSTRAP
    • Exposure to Loss
      • LOSSPR
      • OMEGARATIO
      • SORTINORATIO
      • TAILRATIO
      • VALUEATRISK
      • MAXDD
    • Regression Analysis
      • FACTORANALYSIS
      • PSR
    • Scenario Analysis
      • MAHALANOBIS
      • SCENARIOPR
      • IMPLIEDSCENARIO
  • Frequently Asked Questions
    • Common Issues
    • FAQ
  • Further Reading
  • Windham's Research Insights
  • Watch Our Educational Videos
Powered by GitBook
On this page
  • Description
  • Syntax
  • Input(s)
  • Output(s)
  • Example
  1. Functions
  2. Exposure to Loss

SORTINORATIO

Measure risk-adjusted returns relative to downside deviations.

PreviousOMEGARATIONextTAILRATIO

Last updated 3 years ago

Description

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.

Syntax

The following describes the function signature for use in Microsoft Excel's formula bar.

=SORTINORATIO(returns, threshold)

Input(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.

Output(s)

Vector of Sortino ratio estimate(s).

Example

56KB
RATIOS.xlsx
Example Workbook: RATIOS