Stock fundamental ranking and screening with Greenblatt Magic Formula

In 2005, Joel Greenblatt published a book titled "The Little Book That Beats the Market" and introduced his Magic Formula value investing method to the world. The book was supposedly wrote to teach his own children, in his Jewish family, about investment. That book became a New York Times bestseller with over 300,000 copies in print.

In 2010, the books content was updated, and its new edition is now called "The Little Book That Still Beats the Market" which you can still find in bookstores (both physical and online) now.

Joel Greenblatt is a hedge fund manager running Gotham Asset Management (formerly known as Gotham Capital) which claimed to have achieved an impressive annualized return of 40% from 1985 to 2006. He is also an adjunct professor in Columbia Business School teaching the subject of "value and special situation investing".

Greenblatt operates the Value Investors Club website for value investors around the world to freely join and share investment ideas. Another website of him is Magic Formula Investing, which is a free online stock screener (for stocks listed in USA only) based on his Magic Formula.

In his book, Greenblatt explained that in order to get above-average returns, one should buy companies with above-average return on capital at below-average prices. To find those companies, he first filters the stocks by eliminating certain industries including Utilities and Financials, which he found not applicable to his Magic Formula.

After that, he narrows down the search by filtering the companies based on market capitalization. Greenblatt suggests to apply Magic Formula to companies with market capitalization of above US$50 million. You can adjust this filter to search between large caps, mid caps and small caps targets.

Then he ranks the remaining companies based on 2 ratios:

• Earnings Yield
• Return on Invested Capital (ROIC)

whereby...

Earnings Yield = EBIT / EV

which...

Enterprise Value (EV) = (Market Cap + Total Debt + Minority Interest + Preferred Stock − Cash & ST Investments)

and that:

ROIC = EBIT / (Net Fixed Assets + Net Working Capital)

whereby...

Net Fixed Assets = (Total Assets - Total Current Assets - Goodwill)

Net Working Capital = (Current Assets − Current Liabilities)

There are reasons why Greenblatt uses ROIC in his Magic Formula instead of ROE or ROA or other similar return ratios, and Hurricane Capital has written an article to explain about this.

At the time of writing, ValueSignals website ranked Sandridge Mississippian Trust II (NYSE:SDR) which operates in oil and natural gas sector at the top of Greenblatt Magic Formula screening.

However, SDR only scored a low 3 in Piotroski F-Score.

If you apply both the screeners of Greenblatt Magic Formula and Piotroski F-Score now, you will find magicJack VocalTec Ltd. (NASDAQ:CALL) on top of the list.

It ranks #4 in Magic Formula screening result, and scored a 7 in Piotroski F-Score test.

 

This combined screening is expected to produce better result than just using a single screening factor.

ValueSignals website provides a very handy and straightforward online service for systematic value investing to perform quantitative stock screening, stock comparison and stock information, currently covering as many as 33,600 stock counters listed in 44 countries around the world.

Beside Greenblatt's Magic Formula, ValueSignals website is also able to perform screening (including multifactor cross-screening) of:

• Piotroski's F-Score
• O'Shaughnessy Value Composites
• ERP5
• Altman's Z-Score
• Beneish’s M-Score
• Benjamin Graham's Net Current Asset Value (NCAV) to Market ratio
• EV/EBITDA
• Price index
• ... and many more

The screening can be performed across all stock counters, or limited to within certain regions,  countries, industries, etc.

As a user of ValueSignals, I recommend this website to all serious value investors and fund managers to boost your stock screening and selection process.

Stock fundamental ranking and screening with Piotroski F-Score

Piotroski F-Score was introduced by Professor Joseph D. Piotroski in his paper titled "Value Investing: The Use of Historical Financial Statement Information to Separate Winners from Losers" published in January 2002 while he was teaching as an assistant professor in University of Chicago. He is now teaching in Stanford University Graduate School of Business, and has just promoted from associate professor to professor in 2016.

You can click here to download that interesting 39-pages paper written by Piotroski on his F-Score.

Piotroski backtested his F-Score screening method in his paper and concluded that by investing in the low price-to-book ratio companies filtered by the F-Score, one could have generated a 23% average yearly return from 1976 to 1996.

Today, Piotroski F-Score is used by quite a number of fund managers as well as individual investors in their value investment stock screening process. The F-Score has also been applied in many other academic papers and has so far proven to be effective for stock screening, especially when combined with other fundamental stock screening methods, such as Greenblatt's magic formula, etc.

A backtest by Olivier Dambrine (owner of MFIE Capital which operates the ValueSignals global stock screening website) revealed that a European stock portfolio establised by their Piotroski price-to-book screener is able to achieve an impressive 525% return between June 1999 and August 2011, while at the same period of time the  S&P600 Europe including net dividends has a return of -15%. You can click here to read that article written by Olivier Dambrine on 1 September 2011.

The American Association of Individual Investors (AAII) also revealed in an article titled "2008 AAII Stock Screen Roundup: Piotroski Strategy Defeats the Bear" by Wayne A. Thorp that the F-Score was the only one of their 56 screening methodologies that had positive results in 2008 (up 32.6% on average across 5 stocks, versus -41.7% for all of the AAII strategies over the same period).

Piotroski F-Score is the sum of 9 binary (meaning, either 0 or 1) scores in 3 fundamental categories of the stock, as below:

Profitability:

• Did the company make a profit during the last 12 months?
• Did it generate any cash?
• Was it more profitable compared to the prior year?
• Did it make more cash than the reported profit?

Leverage, Liquidity and Source of Funds:

• Did the company increase its relative LT debt compared to the prior year?
• Did the company improve its ability to pay short-term liabilities  (debt and payables) with its short-term assets (cash, inventory, receivables)?
• Was the company not required to issue new shares to pay for its future obligations?

Operating Efficiency:

• Was the company able to improve its margins on sales?
• Was the company able to improve productivity?

The above 9 criterias are tested by the following financial conditions, comparing the current year with previous year:

• ROA > 0, EPS > 0
• Operating cash flow > 0
• ROA growth
• Operating cash flow > Net profit
• (Assets / LT Debt) increased
• Current Ratio increased
• Share Outstanding remains
• Gross Profit Margin increases
• Asset Turnover increases

An example of stock counter having full F-Score is Forrester Research Inc. (NASDAQ:FORR).

You might want to double check if the counter is consistently scoring high F-Score throughout the years, or has been improving from lower F-Score to higher F-Score across the period. Below is the historical Piotroski F-Score Scorecard of Forrester Research Inc. as presented by ValueSignals website.

The scorecard above shows that the F-Score of the stock counter improved from quarter to quarter, from 5 in 2013 eventually to 9 in mid-2016. It also indicates which out of the 9 criterias had passed or failed the test in each of the quarters.

ValueSignals website provides a very handy and straightforward online service for systematic value investing to perform quantitative stock screening, stock comparison and stock information, currently covering as many as 33,600 stock counters listed in 44 countries around the world.

Beside Piotroski F-Score, ValueSignals website is also able to perform screening (including multifactor cross-screening) of:

• Greenblatt's Magic Formula
• O'Shaughnessy Value Composites
• ERP5
• Altman's Z-Score
• Beneish’s M-Score
• Benjamin Graham's Net Current Asset Value (NCAV) to Market ratio
• EV/EBITDA
• Price index
• ... and many more

The screening can be performed across all stock counters, or limited to within certain regions,  countries, industries, etc.

As a user of ValueSignals, I recommend this website to all serious value investors and fund managers to boost your stock screening and selection process.

Mcdodo 2-in-1 USB type-c and micro USB fast charging data cable

If you bought a latest smartphone that uses USB type-c connector instead of the old style micro USB, you might probably want to search for some 3rd party fast charging and data sync cable for it.

If you still possess other smart mobile devices that use micro USB, a 2-in-1 cable that supports both USB type-c and micro USB will be very nice. If you also have Apple iPhone, perhaps a 3-in-1 cable that supports USB type-c, micro USB and lightning will be even better.

For this reason, I have recently bought some Mcdodo brand 2-in-1 USB cables. They have another 3-in-1 model as well with the Apple lightning connector.

This cable is 1 meter long, and supports fast charging with 2.1A current output. One end of it is normal USB connector, and the other end of it is a micro USB connector. What makes it special is it also comes together with an adapter that tied with it, which can be connected to its micro USB connector to convert it for USB type-c connection.

It also comes with a handy silicon belt that can be used to tie the cable up nicely in an organized manner for easy carriage.

Its cable is insulated with thermoplastic elastomer (TPE) material, which is robust, durable, anti-abrasion, anti-pull, anti-wrap and has high resistance to heat, oil, direct sunlight, flame, water, acid, alkali, alcohol, etc.