Calculating Downside Risk in Excel 

Thank you for the Video, And Specially for the Array Formula 💯

Fantastic do you have FRTB and New Margin rules too

this array function thingy is only necessary if you don't create an extra column as you did for the portfolio return right?

Do you know how to do this for a matrix were the columns are different fund returns in Matlab?, Would be really helpful...

What is the difference from the sortino ratio or ulcer index? Which is better to use for optimization?

Hey, so quick question. Wanted to know how to calculate downside deviation of monthly from the daily data.

Economics explained !! recognize the voice !!

Hi, in the additional column of downside, the formula that you wrote is if the value of Rp is less than the average of the whole Rp than place it as value otherwise make it blank. My question is blank means zero? since i cannot find any covariance matrix from this downside. Thank you.

Hiya, are the portfolio returns excess return (i.e. minus Rf)? Why not then consider only the actual negative returns? If they are above rf but below the avrg you don't want them to consider in the downside risk?!

thx.

sir, could you provide a link to the data used here? Thanks for the tut.

Thank you for this useful information, it helped me a lot to learn excel. But excel's formula for the standard deviation calculate automatically the mean of the cells you picked. But the downside risk is calculated with the mean of all the data so it won't give the same answer when you manually do it. The gaps won't be the same 'cause the mean aren't the same. Am i wrong? 'Cause when i do it by hand it doesn't give me the same answer and it's the only explanation i've found.

The downside beta should be mentioned here

Hi, I believe your downside side risk calculation is wrong: in column 'G', you should have calculated the sum of the squared negative differences of the monthly returns with the mean return of the portfolio and then, take the square root of the result in order to properly calculate the downside risk of the portfolio. Instead, you only took the std deviation of the monthly returns below the average; which does not mean anything.