# Sharpe ratio calculator: yearly, monthly or daily returns

> Free Sharpe ratio calculator. Use return, risk-free rate and volatility, or paste daily or monthly returns. With the formula and real S&P 500 numbers.

Written by [Tactfolio Research Lab](https://tactfolio.com/about/editorial-policy.md), published 2026-11-11, updated 2026-11-11, data as of 2026-11-10.

The **Sharpe ratio** shows how much extra return an investment earned for each unit of risk it took. This free Sharpe ratio calculator works it out two ways. Type three yearly numbers: the average return, the risk-free rate and the volatility. Or paste a list of daily, weekly, monthly or yearly returns, and it does the rest, Sortino ratio included.

- Sharpe ratio = (average return − risk-free rate) ÷ standard deviation of returns.
- SPY, the oldest S&P 500 fund, scored 0.73 over the 10 years to November 2026: (15.7% − 2.5%) ÷ 18.0%.
- From monthly returns, multiply the monthly Sharpe ratio by √12, about 3.46. From daily returns, multiply by √252, about 15.9.
- Use the plain average return, not the CAGR. The CAGR is lower, so it gives a Sharpe ratio that is too low.
- Over 10 years or more, above 0.5 is good and above 1 is rare.

## How to use the Sharpe ratio calculator

The first calculator takes three numbers, each for a whole year:

- **Average return per year:** the plain average of the yearly returns, in percent.
- **Risk-free rate:** what you could have earned with almost no risk over the same years. Most people use the 3-month US Treasury bill rate, which the St. Louis Fed publishes every day ([FRED](https://fred.stlouisfed.org/series/DTB3)).
- **Volatility:** how much the returns swung, measured as their standard deviation over a year. Fund fact sheets and backtests often show it.

The second calculator starts from raw returns. Paste them in percent, with commas, spaces or new lines between them. Use a dot for decimals, so 2.5 means 2.5%. Pick how often the returns are measured, and type the yearly risk-free rate. It shows the yearly Sharpe ratio, the Sortino ratio, and each number it used along the way.

Both calculators start with real numbers from Tactfolio's backtest of SPY, with dividends reinvested.

## How do you calculate the Sharpe ratio?

```text
Sharpe ratio = (average return − risk-free rate)
÷ standard deviation of returns
```

1. Find the average return.
2. Subtract the risk-free rate for the same period. What is left is the **excess return**, the extra you earned for taking risk.
3. Divide by the standard deviation. It measures how far returns usually land from their average.

Economist William Sharpe introduced the ratio in 1966 to compare mutual funds ([JSTOR](https://www.jstor.org/stable/2351741)). In 1994 he defined it on the gap between the fund's return and the risk-free return in each period ([Stanford](https://web.stanford.edu/~wfsharpe/art/sr/sr.htm)). This calculator uses one risk-free rate for every period. Then those gaps swing exactly as much as the returns do, so both ways give the same answer.

## A worked example with the S&P 500

Here is SPY over the 10 years from November 10, 2016 to November 10, 2026. The numbers come from Tactfolio's backtest on daily prices.

| Step | Number |
| --- | --- |
| Average return per year | 15.7% |
| Average 3-month T-bill rate | 2.5% |
| Excess return | 15.7% − 2.5% = 13.2% |
| Volatility per year | 18.0% |
| Sharpe ratio | 13.2 ÷ 18.0 = 0.73 |

That is the same 0.73 our [Sharpe ratio guide](https://tactfolio.com/learn/sharpe-ratio.md#what-is-the-sharpe-ratio-of-the-sp-500) gets from SPY's daily returns.

Notice that SPY grew 15.0% a year over that decade, not 15.7%. The 15.0% is the CAGR, the steady yearly rate that gives the same end result. When returns swing, the CAGR is always below the plain average. Put 15.0% into the calculator and you get 0.69. That is too low, because the Sharpe ratio is built on the plain average.

## From monthly or daily returns

Most data comes as a list: daily prices, monthly statements, or yearly returns on a fact sheet. The second calculator works out the Sharpe ratio for one period, then scales it up to a year.

Here are SPY's monthly returns in 2025: 2.7%, −1.3%, −5.6%, −0.9%, 6.3%, 5.1%, 2.3%, 2.1%, 3.6%, 2.4%, 0.2% and 0.1%. The 3-month T-bill rate averaged 4.1% that year.

1. Average monthly return: 1.42%.
2. Monthly T-bill return: 4.1% ÷ 12 = 0.34%.
3. Excess return: 1.42% − 0.34% = 1.08%.
4. Standard deviation of the monthly returns: 3.18%.
5. Monthly Sharpe ratio: 1.08 ÷ 3.18 = 0.338.
6. Yearly Sharpe ratio: 0.338 × √12 = 0.338 × 3.46 = 1.17.

So 2025 alone scored 1.17, far above SPY's 0.73 for the whole decade. One calm, rising year says little. Judge a Sharpe ratio over many years, through good markets and bad.

To turn a Sharpe ratio for one period into a yearly one, multiply by the square root of the number of periods in a year:

| Your returns are | Periods in a year | Multiply by |
| --- | --- | --- |
| Daily | 252 trading days | √252, about 15.87 |
| Weekly | 52 | √52, about 7.21 |
| Monthly | 12 | √12, about 3.46 |
| Quarterly | 4 | √4 = 2 |
| Yearly | 1 | 1 |

Why the square root? Over more periods, the average return adds up in step with time. The swings add up more slowly, with the square root of time. So the ratio grows with the square root too.

This shortcut assumes one period's return gives no hint about the next. When returns are linked from month to month, it can be off. Andrew Lo showed in 2002 that it can overstate a hedge fund's yearly Sharpe ratio by as much as 65% ([Financial Analysts Journal](https://doi.org/10.2469/faj.v58.n4.2453)).

### The Sortino ratio from the same list

The second calculator also shows the [Sortino ratio](https://tactfolio.com/learn/sortino-ratio.md). It counts only the returns that fell below the risk-free rate as risk. For SPY's 2025 it comes out at 2.05, against a Sharpe ratio of 1.17. Its downside deviation divides by every return, gains included. Dividing by only the losing returns is the [most common mistake](https://tactfolio.com/learn/sortino-ratio.md#the-most-common-mistake) people make by hand.

Set the risk-free rate to 0 to measure from zero instead. That is how Tactfolio's fund pages show both ratios.

## What is a good Sharpe ratio?

Over 10 years or more, a Sharpe ratio above 0.5 is good and above 1 is rare. Here is a rough guide for long records, after subtracting the T-bill rate:

| Sharpe ratio | What it usually means |
| --- | --- |
| Below 0 | It earned less than Treasury bills. |
| 0 to 0.3 | A weak reward for the risk taken. |
| 0.3 to 0.6 | About what US stocks have paid over the long run. |
| 0.6 to 1.0 | Above the market's long-run level. Strong if it held for 10 years or more. |
| Above 1.0 | Rare over long periods. Check for luck, a short record or hidden risk. |

Two real numbers set the bar. SPY scored 0.51 from 1994 to November 2026 in Tactfolio's backtest. Warren Buffett's Berkshire Hathaway scored 0.76 from 1976 to 2011, higher than any other US stock or mutual fund with more than 30 years of history ([NBER](https://www.nber.org/papers/w19681)). The [Sharpe ratio guide](https://tactfolio.com/learn/sharpe-ratio.md#what-is-a-good-sharpe-ratio) explains why cutoffs like "above 2 is very good" fit only short records.

### Numbers to try in the calculator

Here are popular funds and classic strategies over the same 10 years, to November 10, 2026. T-bills averaged 2.5% a year. Type a row's numbers into the first calculator to check its Sharpe ratio.

| Fund or strategy | Average return per year | Volatility | Sharpe ratio |
| --- | --- | --- | --- |
| [QQQ](https://tactfolio.com/etf/QQQ.md) | 21.0% | 22.8% | 0.81 |
| [200-day moving average](https://tactfolio.com/strategies/200-day-moving-average.md) on the S&P 500 | 11.6% | 12.2% | 0.75 |
| [SPY](https://tactfolio.com/etf/SPY.md) | 15.7% | 18.0% | 0.73 |
| [60/40 portfolio](https://tactfolio.com/strategies/60-40-portfolio.md) | 9.6% | 10.7% | 0.66 |
| [Global Tactical Asset Allocation](https://tactfolio.com/strategies/global-tactical-asset-allocation.md) | 6.8% | 6.9% | 0.62 |
| [GLD](https://tactfolio.com/etf/GLD.md) | 12.7% | 16.6% | 0.62 |
| [Dual momentum (GEM)](https://tactfolio.com/strategies/dual-momentum.md) | 10.5% | 16.7% | 0.48 |

GLD comes out at 0.61 from the rounded numbers. The 0.62 is from the full ones.

![Scatter chart of average yearly return against volatility for seven funds and strategies, with a line from the 2.5% T-bill rate through each. QQQ has the steepest line, a Sharpe ratio of 0.81, then the 200-day moving average at 0.75 and SPY at 0.73. The 60/40 portfolio scores 0.66, Global Tactical Asset Allocation and GLD 0.62, and dual momentum has the flattest line at 0.48.](https://tactfolio.com/images/figures/sharpe-ratio-as-slope-from-cash.svg)

*A fund higher up earned more, but the Sharpe ratio asks how steeply it climbed from cash. GLD and dual momentum swung about as much as SPY yet earned less, so their lines are flatter.*

Two things stand out. The 200-day rule earned less than SPY but scored higher, because it swung much less. And Global Tactical Asset Allocation matched gold's score with about half of gold's return. The Sharpe ratio rewards a smooth ride, not the biggest gain.

## How do you calculate the Sharpe ratio in Excel?

Put 12 monthly returns in cells A2 to A13, and the yearly T-bill rate in B1. Type them all the same way, such as 2.7 for 2.7% and 4.1 for 4.1%. Then type this into any empty cell:

```text
=(AVERAGE(A2:A13)-B1/12)/STDEV.S(A2:A13)*SQRT(12)
```

For daily returns, use 252 in place of both 12s. STDEV.S treats your returns as a sample and divides by one less than their count ([Microsoft](https://support.microsoft.com/en-us/office/stdev-s-function-7d69cf97-0c1f-4acf-be27-f3e83904cc23)). The calculator above does the same, so the two answers match. Google Sheets has the same functions.

## Common mistakes with the Sharpe ratio

- **Mixing periods.** A monthly return with a yearly risk-free rate gives nonsense. Put every number on the same period, then scale the answer to a year.
- **Using the CAGR.** The Sharpe ratio needs the plain average return. SPY's CAGR gives 0.69 in place of 0.73.
- **Trusting a short record.** SPY scored 1.17 in 2025 alone and 0.73 over 10 years. A year or two of data can't tell skill from luck.
- **Comparing different dates.** The same fund scored −0.05 in 2000 to 2009 and 0.88 in 2010 to 2019. Compare over the same years.
- **Skipping the risk-free rate.** Some tools measure from zero. SPY's 10-year Sharpe ratio is 0.87 from zero and 0.73 over T-bills. Check which one you are reading.

## What the Sharpe ratio leaves out

- **It counts gains as risk.** A sudden jump up counts the same as a sudden drop. The Sortino ratio fixes that.
- **It hides the worst fall.** Check the [max drawdown](https://tactfolio.com/learn/max-drawdown.md) too. The [Calmar ratio](https://tactfolio.com/learn/calmar-ratio.md) divides yearly growth by that single worst drop.
- **It looks back.** A high past Sharpe ratio is not a forecast. In backtests it is often partly luck.

## Try it on Tactfolio

Every [ETF page](https://tactfolio.com/etf/SPY.md) on Tactfolio shows a fund's Sharpe, Sortino and Calmar ratios over five years, measured from zero. Every Tactfolio backtest shows the Sharpe ratio both from zero and over T-bills. Our guide on [how to read a backtest](https://tactfolio.com/docs/concepts/reading-a-backtest.md) explains where each one fits.

The [classics scorecard](https://tactfolio.com/strategies/classics/scorecard.md) tracks the Sharpe ratio of every classic strategy since its paper came out, next to the S&P 500's. To find the mix of funds with the best Sharpe ratio in the past, try the [portfolio optimizer](https://tactfolio.com/trading-tools/portfolio-optimizer.md). To test a mix you already hold, use the [portfolio backtest](https://tactfolio.com/trading-tools/backtest-portfolio.md). To work out growth per year, use the [CAGR calculator](https://tactfolio.com/trading-tools/cagr-calculator.md). Every tool is on the [free trading calculators](https://tactfolio.com/trading-tools.md) page.

## Common questions

### How do you calculate the Sharpe ratio?

Subtract the risk-free rate from the average return, then divide by the standard deviation of the returns. With an average return of 15.7%, a T-bill rate of 2.5% and volatility of 18%, the Sharpe ratio is 13.2 ÷ 18 = 0.73.

### What is a good Sharpe ratio?

Over 10 years or more, above 0.5 is good and above 1 is rare. SPY scored 0.51 from 1994 to 2026, and Berkshire Hathaway scored 0.76 from 1976 to 2011. Very high numbers from a short record are often luck.

### How do I annualize a Sharpe ratio from monthly returns?

Multiply the monthly Sharpe ratio by the square root of 12, about 3.46. For daily returns, multiply by the square root of 252, about 15.9. For weekly returns, multiply by the square root of 52, about 7.2.

### What risk-free rate should I use?

Use the average 3-month US Treasury bill rate over the same dates as your returns. It averaged 2.5% in the 10 years to November 2026 and was about 4% in November 2026. Use 0 if you want to measure from zero, as many fund pages do.

### Should I use the average return or the CAGR?

The plain average. The CAGR is lower whenever returns swing, so it gives a Sharpe ratio that is too low. SPY's 10-year Sharpe ratio is 0.73 with its average return and 0.69 with its CAGR.

### Can a Sharpe ratio be negative?

Yes. If the average return is below the risk-free rate, the Sharpe ratio is below zero. SPY's was −0.79 in 2022, when stocks fell and T-bills paid more.

### How do you calculate the Sharpe ratio in Excel?

With 12 monthly returns in A2 to A13 and the yearly T-bill rate in B1, type `=(AVERAGE(A2:A13)-B1/12)` in one cell and `=STDEV.S(A2:A13)` in another. Divide the first by the second, then multiply by `SQRT(12)`.

## The details

We worked out the yearly figures from the daily values of Tactfolio's backtests, which use closing prices adjusted for splits and dividends. The average return per year is the average daily return times 252, and the volatility is the daily standard deviation times √252. The T-bill rate is the 3-month Treasury bill rate from FRED, averaged over the same days. Over T-bills, the engine divides the average daily excess return by its standard deviation and multiplies by √252. Recomputed from FRED's rates, every Sharpe ratio on this page matches the engine's to two decimals.

The calculator's yearly risk-free rate is split evenly over the periods: 4.1% a year is 4.1 ÷ 12 = 0.34% a month. Its standard deviation divides by one less than the number of returns, like STDEV.S. Its Sortino ratio squares each shortfall below the risk-free rate, averages over every return, and takes the square root. Both ratios are scaled to a year by the square root of the periods in a year.

## Understand the numbers

- [Efficient frontier tool](https://tactfolio.com/trading-tools/efficient-frontier.md): Draw the efficient frontier for up to 8 US stocks or ETFs from real past prices.
- [ETF screener](https://tactfolio.com/screener.md): A free ETF screener for 162 US-listed funds. Filter by type, issuer and fee, sort by returns or worst drop, and compare funds side by side.
- [Backtesting](https://tactfolio.com/learn/backtesting-explained.md): What backtesting is, how to backtest a trading strategy step by step, the biases that fool people, and why out-of-sample testing matters.

## Sources

- [Mutual Fund Performance](https://www.jstor.org/stable/2351741), William F. Sharpe, The Journal of Business 39(1), 1966, accessed 2026-11-11
- [The Sharpe Ratio](https://web.stanford.edu/~wfsharpe/art/sr/sr.htm), William F. Sharpe, Stanford University, accessed 2026-10-16
- [The Statistics of Sharpe Ratios](https://doi.org/10.2469/faj.v58.n4.2453), Andrew W. Lo, Financial Analysts Journal 58(4), 2002, accessed 2026-11-11
- [3-Month Treasury Bill Secondary Market Rate, Discount Basis (DTB3)](https://fred.stlouisfed.org/series/DTB3), Federal Reserve Bank of St. Louis, FRED, accessed 2026-11-11
- [Buffett's Alpha](https://www.nber.org/papers/w19681), Frazzini, Kabiller and Pedersen, National Bureau of Economic Research working paper 19681, accessed 2026-11-11
- [STDEV.S function](https://support.microsoft.com/en-us/office/stdev-s-function-7d69cf97-0c1f-4acf-be27-f3e83904cc23), Microsoft Support, accessed 2026-11-11
- [SPY ETF: fees, returns, drawdowns and holdings](https://tactfolio.com/etf/SPY), Tactfolio, figures as of November 10, 2026, accessed 2026-11-11
- [What a backtest simulates](https://tactfolio.com/docs/backtests), Tactfolio, accessed 2026-11-11
