Home > Forum Home > Excel Portfolio Optimization Template > Sortino Ratio - Downside Deviation versus Semi-Deviation
| Share |

Forum Topic | Post Reply Login |

## Sortino Ratio - Downside Deviation Versus Semi-deviation | Rate this: (4/5 from 2 votes) |

Hello, I am trying to understand the differences between the downside deviation and semi-deviation calculations for the two sortino ratio options for the portfolio optimization model. The semi-deviation model only calculates volatility below a target return level, so theoretically, if target return and RfR are 0%, then the raw negative asset returns shown would be used to calculate the downside deviation. However, for the downside deviation option, the model (help box) states that "only volatility below the average is used" - what average is the model referring to? The overall return? The target return? As well, how do you actually calculate the downside deviation or standard deviation more generally? There are multiple methods of calculating sortino ratios and I am unable to match what the optimization model produces with my own calculations of sortino/sharpe ratios (the total returns match, but the standard deviations are slightly off). Many thanks in advance. | ||

Posted by A.Yu on |

Replies - Displaying 1 to 3 of 3 | Order Replies By: Most Recent | Chronological | Highest Rated |

Rate this: (3/5 from 1 vote) Both calculations account for periods during the time series of data when the return is below this target and the variance thereof to calculate deviation. This differs from standard deviation which looks at all variance of returns both up and down. The only circumstance where downside or semi deviation can be zero is when all periods in the time frame have returns greater than the target rate i.e. a continuous uptrend. | |

Excel Business Forums Administrator | |

Posted by Excel Helper on |

Rate this: (3/5 from 1 vote) | |

Posted by A.Yu on |

Rate this: (4/5 from 2 votes) | |

Excel Business Forums Administrator | |

Posted by Excel Helper on |

Displaying page 1 of 1 |

Find relevant Excel templates and add-ins for Sortino Ratio - Downside Deviation versus Semi-Deviation in the Excel Business Solutions Directory |