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

Downside deviation calculations

Excel Help for Downside Deviation Calculations in Excel Portfolio Optimization Template


Forum TopicLogin

Downside Deviation Calculations

Rate this:
(3/5 from 1 vote)
Confused The difference between downside and semi-deviation is only that downside uses the average return as a target while semi uses the target rate specified.

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 on
 
View Full Post

Find relevant Excel templates and add-ins for Downside deviation calculations in the