Hi all,

In my company there seems to be a bit of confusion over the sortino ratio and how exactly we are calculating this.

Conventionally: Rp - Target Return / Downside Deviation (vol)

Target return we have set to 0.

For the downside deviation various articles are showing different formulas.

We have decided to essentially take the return stream and apply an IF formula to say any returns that are below 0 are shown, if they are above 0, make them equal to 0.

The downside deviation is then caluclated as the Sum of Squares of the negative returns / TOTAL number of observations (including the 0’s)

Some articles show that N (total periods) should be all periods including 0, some suggest N should just be for the negative periods as that is what we are trying to work the volatility on.

Can anyone please explain how they would calculate this on a return stream? If you are able to share your excel formula that would be really useful.

Thanks