0
Still curious? Ask our experts.
Chat with our AI personalities
Jordan
Ezra
RossAdd your answer:
Earn +20 pts
How do you calculate sortino ratio?
The Sortino Ratio is the actual return minus the target return, all divided by the downside risk. The downside risk is either calculated by the semi standard deviation, or the 2nd order lower partial moment. The related link "Calculate the Sortino Ratio with Excel" provideds an Excel spreadsheet to calculate the Sortino Ratio
How do you calculate treynor ratio in Excel?
calculate the effective return (mean return minus the risk free rate) divided by the beta. the excel spreadsheet in the related link has an example.
The Sortino Ratio?
I've written before about the Sharpe Ratio, a measure of risk-adjusted returns for an asset or portfolio. The Sharpe ratio functions by dividing the difference between the returns of that asset or portfolio and the risk-free rate of return by the standard deviation of the returns from their mean. So it gives you an idea of the level of risk assumed to earn each marginal unit of return. The problem with using the Sharpe Ratio is that it assumes that all deviations from the mean are risky, and therefore bad. But often those deviations are upward movements. Why should an investment strategy by graded so sharply by the Sharpe Ratio for good performance? In the real world, investors don't usually mind upside deviations from the mean. Why would they? These were the questions on the mind of Frank Sortino when he developed what has been dubbed the Sortino Ratio. The ratio that bears his name is a modification of the Sharpe Ratio that only takes into account negative deviations and counts them as risk. To me, it always made a lot more sense not to include upside volatility from the equation because I rather like to see some upside volatility in my portfolios. With the Sortino Ratio only downside volatility is used as the denominator in the equation. So the way you calculate it is to divide the difference between the expected rate of return and the risk-free rate by the standard deviation of negative asset returns. (It can be a bit tricky the first time you try to do it. The positive deviations are set to values of zero during the standard deviation calculation in order to calculate downside deviation.) By using the Sortino Ratio instead of the Sharpe Ratio you’re not penalizing the investment manager or strategy for any upside volatility in the portfolio. And doesn’t that make a whole lot more sense?
Is it true that a ratio is a rate?
No. It can be but need not be. For example, you might calculate the ratio of today's temperature in Celsius and in Fahrenheit and calculate the ratio. That is not a rate.
How to get a ratio?
calculate the ratio between proton&electron
