#### Directional

##### Experienced member

- Messages
- 1,992

- Likes
- 251

been very grateful for help from you excel slicers in the past, so thought I'd throw this one out to you.

I've got a long list of trades, and 34 months worth of monthly % return on money calculated. I want to work out the risk adjusted return ratio's and was planning to do this via Sharpe ratio, unless anyone has a better recommendation?

I understand from a bit of googling that the Sharpe ratio is:

annual return rate / annualized standard deviation of returns

STDEV(C1:C34) - am i correct that this formula will work out the standard deviation for the cells in the brackets? If so, then I've already worked out what the standard deviation of the 34 monthly returns is.

The bits I need some extra help with:

I dont know how to convert the standard deviation of my monthly returns into an annualised figure - and - I'm not sure I want to, since I have 34 months worth of data.

I'd ideally like to work out the Sharpe ratio for all 34 months worth of trades, but what this means in terms of tweaking the standard deviation part of the equation, i'm really not too sure - any help or input with the maths and the excel bits would be appreciated.