The Highest Sharpe Ratio Stocks in the S&P 500 [Free Excel Download]

Sure Dividend

High-Quality Dividend Stocks, Long-Term Plan
The Sure Dividend Investing MethodMember's Area

The Highest Sharpe Ratio Stocks Within The S&P 500

Updated on April 30th, 2021 by Bob Ciura

The goal of most investors is to either:

Perhaps the best metric for analyzing both risk and return is the Sharpe Ratio. With that in mind, we’ve compiled a list of the 100 stocks in the S&P 500 Index with the highest Sharpe Ratios.

You can download your free list (along with relevant financial metrics like dividend yields and price-to-earnings ratios) by clicking on the link below:


The list of 100 stocks in the S&P 500 sorted by Sharpe Ratio available for download above has the following metrics for each stock:

Keep reading this article to learn more about using the Sharpe Ratio to analyze publicly-traded stocks.

How To Use The Sharpe Ratios List To Find Compelling Investment Ideas

Having an Excel document with the 100 highest Sharpe Ratios in the S&P 500 can be extremely useful.

The resource becomes even more powerful when combined with a rudimentary knowledge of how to use the filter function of Microsoft Excel to find investment ideas.

With that in mind, this section will show you step-by-step how to implement a particular investing screen using the Sharpe Ratio stocks list. More specifically, we’ll show you how to screen for stocks with Sharpe Ratios above 1 and forward price-to-earnings ratios below 15.

Step 1: Download the Sharpe Ratio Stocks List by clicking here.

Step 2: Click the filter icon at the top of the Sharpe Ratio column, as shown below.

Sharpe Ratio Image 1

Step 3: Change the filter setting to “Greater Than Or Equal To”, input “1”, and click “OK”. This filters for S&P 500 stocks with Sharpe Ratios greater than or equal to 1.

Step 4: Close out of the filter window (by clicking the exit button, not by clicking the “Clear Filter” button in the bottom right corner). Then, click the filter icon at the top of the “Forward P/E Ratio” column, as shown below.

Sharpe Ratio Image 3

Step 5: Change the filter setting to “Less Than Or Equal To”, input “15”, and click “OK”. This filters for S&P 500 stocks with forward P/E ratios less than or equal to 15.

Sharpe Ratio Image 4

The remaining stocks in this Excel document are S&P 500 stocks with Sharpe Ratios higher than 1 and forward price-to-earnings ratios less than 15.

You now have a solid fundamental understanding of how to use the Sharpe Ratios list to find investment ideas.

The remainder of this article will provide more information on how to analyze stocks using the Sharpe Ratio.

What Is The Sharpe Ratio?

The Sharpe ratio is the financial industry’s favorite measure of risk-adjusted returns. It tells investors whether they are being appropriately rewarded for the risks they’re assuming in their investments.

The Sharpe ratio is calculated with the following formula:

Sharpe Ratio Formula

There are three components to the Sharpe Ratio calculation:

Investment return and investment standard deviation are relatively straightforward and require no explanation.

The risk free rate of return can be different depending on your use case. For most investors, a suitable risk free rate of return is the current yield on 10-year U.S. government bonds.

For this article, we have used a risk free rate of 0, as interest rates have declined significantly.

The Sharpe ratio is rarely calculated by hand in practice. Instead, investors generally use a tool such as Microsoft Excel for the purpose of Sharpe ratio calculations.

How To Manually Calculate Sharpe Ratios Using Yahoo! Finance

At Sure Dividend, we use YCharts for much of our data analytics. YCharts requires a paid subscription that many of our readers do not have. Accordingly, we want to show you how to manually calculate Sharpe Ratio for publicly-traded stocks over a given time period.

More specifically, this tutorial will show you how to calculate a 3-year Sharpe ratio for Apple, Inc (AAPL).

Step 1: Navigate to Yahoo! Finance. Type the ticker of your desired stock into the search bar at the top of the Yahoo! Finance bar. In our case, it’s Apple.

Step 2: Click on historical data, as shown below.

Step 3: Change the dates to the range of your choice, and then click “Apply.” After that, click “Download” (which is just below the Apply button).

Step 4: The Excel document that will download as a result of your process so far will have six columns: Open, High, Low, Close, Adjusted Close (or “Adj Close” in the top row of the spreadsheet), and Volume. It’s Adjusted Close that we’re interested in, as this accounts for stock splits and dividend payments.

Using the adjusted close column, calculate the stock’s annualized returns during the time period under investigation. In the example shown below, this is done by dividing the current price by the oldest price and then raising this to the inverse power of the number of years during the sample. The equation is shown below.

Step 5: Next, a time series of daily returns needs to be calculated. This is done in column I in the spreadsheet shown below.

Step 6: Calculate the standard deviation of daily price returns using the STDEV.P() function, and then convert this number to an annualized figure by multiplying by the square root of 252. We use 252 instead of 365 (the number of days in a year) because there are approximately 252 trading days in an average calendar year. The formula to calculate the annualized standard deviation figure is shown below.

Step 7: Use the annualized return and annualized standard deviation data to calculate a Sharpe ratio. An example of how to do this is shown below, using 0% as the risk free rate of return.

The resulting number is the Sharpe ratio of the investment in question. In this case, Apple had a 3-year Sharpe ratio of 1.38 at the time of this writing.

Final Thoughts

Looking for stocks with strong historical Sharpe ratios is a useful way to find investment ideas.

With that said, this strategy is not the only way to find high-quality investments. To conclude this article, we’ll provide additional resources that you can use for your investment due diligence.

If you are looking for high-quality dividend growth stocks suitable for long-term investment, the following databases will be useful:

You may also be looking for appealing stocks from a certain stock market sector to ensure appropriate diversification within your portfolio. If that is the case, you will find the following resources useful:

You may also wish to consider investments within the major market indices. Our downloadable lists of large- and small-cap U.S. stocks can be accessed below:

Thanks for reading this article. Please send any feedback, corrections, or questions to

More from sure dividend
The Sure Dividend Investing MethodMember's Area