When we have a job, we are trading our time for money, and the more we work, the more we are expecting to be paid. Therefore, we are paying more attention to the hourly pay instead of the total salary. When we invest, we are actually trading risk for money. Similarly to our job, the higher is the risk we are taking the higher is the money we want to make. The reason is that when there is a success, we need to have enough profits that will cover also the losses that we incur when the investment fails.

It is easy to calculate the hourly rate of your salary, unfortunately it is much more difficult to calculate the return of investment per unit of risk of your investment, because many investors don’t know the right tool for assessing the risk/reward ratio. This is especially true for retail investors who don’t have access to advanced software or to professional wealth manager.

In this article, I will explain you how to calculate the Sharpe Ratio, which is one of the key metric that assess risk/reward ratio of an investment, fund, or eToro popular investor.

The Sharpe Ratio

Briefly, the Sharpe Ratio is the profit made for each unit of risk taken by the investment. From the profit, we also need to subtract the profit that we would have normally made without taking any risk. For example if we invest in short term US bonds, that is typically considered a risk-free investment. Let’s look at the steps in detail.

1. Retrieve investment returns

The Sharpe Ratio is typically calculated on monthly returns. Therefore, you need to take all investment returns for the time window you want to use. This is the easy part.

2. Retrieve the risk free returns

3. Calculate standard deviation

Calculate Sharpe Ratio in Excel

Let’s start by adding the monthly return to a spread sheet.

Next we download the risk free rates from https://fred.stlouisfed.org/series/TB3MS

We first pick the right time interval then we download the data as excel format and we just copy and paste the data in our spread sheet and modify them in %.

As explain in part 2, we need to convert to the monthly yield like this

Next step is to calculate the return – the risk free return

Now we have everything to calculate the Sharpe Ratio. First we calculate the total return

From that we calculate the expected monthly return (above the risk free rate).

We can use Excel formula for the Standard deviation

The monthly Sharpe ratio is simply the division of the last 2 cells we calculated

Finally, we can annualize the Sharpe ratio as explained above by multiplying by SQRT(12)

And with this we have successfully calculate the Sharpe Ratio of our investment!

Download our free Sharpe Ratio calculation Excel spreadsheet

All calculations shown above can be easily downloaded here, so you can adjust the numbers and try yoursef.


We often forget about risk when deciding which investment is the best. This is especially true for retail investors who wants to copy popular investors. Sharpe Ratio is a key metric to help us deciding the right investment. When searching for mutual funds, ETF, it is a good idea to search by Sharpe ratio instead of overall performance for the reason explained in the introduction. So make sure to add this metric to your investment decision process.

One thought on “How to calculate Sharpe Ratio (with Excel example)

Leave a Reply

Your email address will not be published. Required fields are marked *