Home > Forum Home > Analyzing Corporate Financial Data > Sortino ratio
| Share |

Forum Topic | Post Reply Login |

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

Hello and thank you for both the template and the ability to post qusetions. My question pertains to the calculation of the Sortino Ratio. As per Dr. Frank Sortino the ratio is the portfolio return minus the target rate of return over the downside risk or semi variation ( http://en.wikipedia.org/wiki/Sortino_ratio) I have chose to optimize a sample portfolio with Semi-Deviation as my risk, with maximum Sortino as the result. I ran the optimization twice and only changed the risk free rate... but the Sortino ratio for the portfolios changed. How come? Secondly the optimizer allocated a large portion of the portfolio to an asset whose estimate return is below the target, but it is still showing a positive Sortino ratio. How does that happen? Again thank you for you assistance. | ||

M. Tilden | ||

Posted by mtilden on |

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

Rate this: (4.3/5 from 3 votes) A large weighting for an asset can be made even though the return is low as its contribution to overall risk may be significant as either low risk or negatively correlated to other assets risk. | |

Excel Business Forums Administrator | |

Posted by Excel Helper on |

Rate this: (3/5 from 1 vote) So the Sortino Ratio is using the risk free rate instead of the target rate in the calculation? | |

M. Tilden | |

Posted by mtilden on |

Rate this: (3/5 from 1 vote) To make the Sortino ratio calculate with only the target rate, we can equate the risk free rate to the target return rate. | |

Excel Business Forums Administrator | |

Posted by Excel Helper on |

Displaying page 1 of 1 |

Find relevant Excel templates and add-ins for Sortino ratio in the Excel Business Solutions Directory |