Tuesday, January 18, 2011

Understanding the Sharpe Ratio

This is a repost of the article I wrote on my hedge fund blog a couple years ago. Please feel free to comment here. Enjoy.

Explaining the Sharpe Ratio (again) 

Having the Hedge Fund Calculator built into every product we develop is great. As we develop the platform, we get suggestions from our clients which help us enhance the number of statistics we calculate as well as the speed at which they are generated.

One of the issues that we have with statistics is that regardless of how close we stick to any given standard we find someone who interprets something  differently and gets different results. Often others “tweak” the algorithm simply out of a misunderstanding of the algorithm, other times as we will discuss later, choosing an alternate calculation intentionally creates better results.

The Sharpe ratio is one of the simplest ratios, it is also one of the ratios which is most often miscalculated. I will explain what the Sharpe ratio is, the correct way to calculate the ratio as well as a couple of the most common errors made when performing this calculation.


What is it?

The Sharpe ratio was created to answer the question “Given the same amount of risk, which investment provides me with the highest reward.” To do this the Sharpe ratio balances the returns in excess of a risk free benchmark with the standard deviation of the return set. This provides a uniform risk platform which funds with different risk levels can benchmark against.

We’re going to start our example with our return sets:

Investment Monthly Returns


JanFebMarAprMayJuneJulAugSepOctNovDec
1.645.859.223.51-0.881.0713.039.410.49-5.08n/an/a

Risk Free Rate


The annual risk free rate which we will use for our example will be 5%. Generally the RFR will be the average yield of a risk free investment (such as a TBill) over the same time span as the investment. Since we are calculating the returns for thousands of hedge funds, many of which are not correlated to any specific index, at HedgeCo we have chosen to use the same RFR for all our funds.

Sharpe Ratio


The Sharpe ratio is defined as: Average Return – RFR / Standard Deviation. We are using monthly returns as our base so the formula looks like:



We want to get the annualized returns, so we multiply the Sharpe by the square root of 12 to get our final result of 2.567.

Where it can go wrong


As seen above, the Sharpe ratio is very simple, however many times it is overcomplicated and miscalculated. I will quickly go over a couple of the different common issues which cause discrepancies between our calculations and the individual calculations of independent hedge fund managers.

1. Different Risk Free Rate

The most common reason why our calculations may not match is because we are using a different risk free rate. This is not an error in calculation.

2. Geometric Averages & CAGR

Using a geometric average or the Compounded Annual Growth Rate as your average for the sake of the Sharpe ratio will overstate your average monthly returns and give you a better Sharpe ratio. Some will argue that compounding returns is more accurate – for the sake of this ratio I disagree.

3. Reporting Frequency

Weekly reports will probably provide a higher Standard Deviation than Monthly reports. Similarly Quarterly reports will likely smooth out the risks and provide lower standard deviation than monthly reports. Even though the year-end return may be the same, the Sharpe ratio of a fund that reports weekly may be different than the same fund when calculated using monthly reports.

4. STDEV vs. STDEVP

One other gotcha that you may see if you are using Excel is the difference between STDEV and STDEVP. The difference between these two functions are described here. If you want to use excel to calculate you Sharpe, use STDEV.

Monday, January 10, 2011

Calculating Average Returns - Arithmetic vs. Geometric Average


The most basic of all calculations a hedge fund will want to report to their investors is their Average returns.

Despite the simple nature of this calculation, the difference between the Arithmetic and Geometric averages as well as the difference between the terminology used to refer to these terms, for example Compounded Annual Rate of Return vs. Compound Annual Growth Rate, have lead to confusion as to what number is being displayed.

The Average, or more accurately Arithmetic Mean is, what most people think of when they refer to the word "average".

Taking the 2010 returns for the S&P 500 Total Returns Index, we'll first generate the Arithmetic Mean

A B
1 January, 2010 -3.597%
2 February, 2010 3.098%
3 March, 2010 6.034%
4 April, 2010 1.579%
5 May, 2010 -7.985%
6 June, 2010 -5.235%
7 July, 2010 7.010%
8 August, 2010 -4.514%
9 September, 2010 8.924%
10 October, 2010 3.810%
11 November, 2010 0.013%
12 December, 2010 6.683%
13 Arithmetic Mean 1.318% =AVERAGE(B1:B12)


The Geometric Mean, is similar to the arithmetic mean, except that the numbers are multiplied and then the nth root (where n is the count of numbers in the set) of the resulting product is taken.

Here we see the same dataset using the Geometric Average


A B
16 1000
17 January, 2010 964.03 =(B1*B16)+B16
18 February, 2010 993.90
19 March, 2010 1053.87
20 April, 2010 1070.51
21 May, 2010 985.03
22 June, 2010 933.46
23 July, 2010 998.90
24 August, 2010 953.81
25 September, 2010 1038.92
26 October, 2010 1078.51
27 November, 2010 1078.65
28 December, 2010 1150.73
29 Geometric Average 1.177% =(B28/B16)^(1/12)-1

Looking at the dataset used above, we see that instead of working off of the percentage gained we're using the decimal multiplier equivalents. In hedge funds, these numbers would be referred to as your VAMI (Value-Added Monthly Index) and very likely seen in a "Growth of $1000" chart.

So when do you use the Geometric Average over a Arithmetic Mean? When it comes to Hedge Funds, it's pretty safe to say always.

In closing, when you hear Compounded Monthly Rate of Return or Monthly CAGR, they are also referring to your Geometric Average.

Additional Reading: