Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

O’Shaughnessy: Growth Market Leaders Screen (Using Excel Template)

Written by  Shubham Shah on 
Thu Apr 08 2021
 about Guru functionsScreenersValuation Models
O’Shaughnessy: Growth Market Leaders Screen (Using Excel Template) - MarketXLS

Meet The Ultimate Excel Solution for Investors

  • Live Streaming Prices Prices in your Excel
  • All historical (intraday) data in your Excel
  • Real time option greeks and analytics in your Excel
  • Leading data in Excel service for Investment Managers, RIAs, Asset Managers, Financial Analysts, and Individual Investors.
  • Easy to use with formulas and pre-made sheets
O’Shaughnessy: Growth Market Leaders Screen (Using Excel Template) - MarketXLS

James Patrick O’Shaughnessy is a portfolio manager and principal at O’Shaughnessy Asset Management. He is considered to be an expert in the field of investor behaviour and investing strategies. The O’Shaughnessy Market Leaders Value Strategy seeks to provide long-term growth through investments in capitalised domestic equities. Large and prominent companies, usually market leaders and meet the O’Shaughnessy quality criteria, have high valuations and high shareholder yields, which combines a company’s annual dividend and its annual rate of stock buybacks. Stocks are selected and weighted based on conviction and are broadly constrained by sector and industry.

Finding the Right Stocks

O’Shaughnessy argues that investors can predict where the markets are going by simply looking at long-term historical trends. O’Shaughnessy developed four stock selection approaches for individual investors that attempt to take maximum advantage of market trends through an examination of stock market history. He focuses on finding stocks among the various market capitalisations that are most likely to do well based on his research.

O'Shaughnessy template Link to the Template: https://marketxls.com/template/oshaughnessy-growth-market-leaders-screen

O’Shaughnessy’s Criteria:

• Market capitalisation should be greater than the market average

• The number of shares outstanding should be greater than the market average

• The cash flow per share should be greater than the market average

• The sales should be greater than 1.5 times the market average

• The price to sales ratio for the stock should be lower than the market average

• The EPS growth over the last 12 months should be greater than zero

• The stock should have a high 12-month price appreciation. For the last criteria, the 52-week relative strength is adjusted until only ten stocks pass the test.

Using MarketXLS

In the template, enter the stock ticker. In this example, we have considered Microsoft Corp. (MSFT). The price to sales ratio is 0.0472, which means that it matches O’Shaughnessy’s criteria. However, the stock doesn’t fulfill the other criteria. Thus, the stock MSFT doesn’t pass O’Shaughnessy’s Growth Market Leader’s Screen.

O'Shaughnessy template

Analysing the Screener

We now look at the performance of the O’Shaughnessy screen since its inception in 2001.

The fund has consistently performed well, churning out returns more than or at par with the Russell 1000 Value Index.

returns on O'Shaughnessy template

O’Shaughnessy’s Market Leaders Growth Screen emphasises diversification, but the sector allocations are not equal. We see that around 31.1% has been allocated to financial stocks and 16.1% to IT stocks. On the other hand, only 0.2% has been allocated to the energy sector. All this information is as of 31/12/2020 and is subject to change.

sector allocation on O'Shaughnessy template

The Bottom Line

While building a portfolio, O’Shaughnessy advises that the stocks should have the following characteristics.

  • • Pay dividends, buy back shares, and have other shareholder-friendly characteristics.
  • • Provide investors with solid and consistent returns
  • • It should be attractively priced
  • • Show momentum or have favourable uptrends

O’Shaughnessy believes: “Investing success is incredibly simple: spend less than you earn, make consistent investments in the global market and wait. If you do these three things, you cannot help but get rich as compounding works for you over time. But simple doesn’t mean easy. That last step (wait) is incredibly hard to do in practice. Controlling your behaviourw matters more than anything.”

Disclaimer

None of the content published on marketxls.com constitutes a recommendation that any particular security, portfolio of securities, transaction, or investment strategy is suitable for any specific person.

The author is not offering any professional advice of any kind. The reader should consult a professional financial advisor to determine their suitability for any strategies discussed herein.

The article is written for helping users collect the required information from various sources deemed to be an authority in their content. The images, copyrights, and trademarks if any are the property of their owners, and no further representations are made.

References

https://www.osam.com/Strategies/Market-Leaders-Value

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord