Customized Stock Screening Strategies

The Advanced Benjamin Graham Stock Screener allows for customized combinations of the Value Investing parameters of Warren Buffett's mentor.

NCAV + Sales + Stability

For example, here is a partial list of stocks that completely meet Graham's NCAV criteria, and also have $250 Million in Sales and 5 years of uninterrupted positive earnings.

Note: Only two stocks are shown here due to limited screen space.

Open Preloaded Screener

NCAV + Enterprising

The Graham Number is 137% of the Serenity Number (for a stock with no intangibles in its Book Value).

Graham Number = Square Root of (15 x 1.5 x EPS x BVPS)

Graham Number = Square Root of (22.5 x EPS x BVPS)

Serenity Number = Square Root of (10 x 1.2 x EPS x TBVPS)

Serenity Number = Square Root of (12 x EPS x TBVPS)

Essentially, for a given EPS and BVPS, we pay 137% more for a Defensive grade stock since it is of higher quality than an Enterprising grade stock. Thus, the criteria for Enterprising grade stocks can be approximately replicated on the Advanced Graham Screener using the values — Assets / Liabilities: 75%, Assets / Debt: 90%, Earnings Stability: 50%, Dividend Record: 5% and Graham Number(%): 137%.

Note: This is just an example. If the reported BVPS includes intangibles, Graham Number(%) would need to be higher than 137%. True Enterprising grade stocks also need to have an EPS higher than they did 5 years ago.

Example

Shown below is a list of stocks that completely meet Graham's NCAV criteria, and additionally clear all the above criteria.

Note: GN÷PC (now called Graham Number(%)) shows 135 instead of 137 because the slider for that particular filter moves in steps of 5.

Open Preloaded Screener

Each one of these stocks already clears Graham's NCAV criteria completely, in addition to clearing most of the criteria for Enterprising investors.

The Advanced Graham Screener can also be used to select stocks of Public-Utilities and Financial Enterprises.

Excel Export + API

GrahamValue is designed on the belief that since Graham spent nearly his whole life developing his framework for maximum efficiency and that's what it comes so highly recommended; any additions to the framework would actually reduce its effectiveness rather than increase it.

Finnhub

GrahamValue's data provider — Finnhub — provides 30+ years of financials and hundreds of metrics for every stock. But GrahamValue is designed to restrict itself to the most authentic Graham analysis possible.

Each additional metric that's not mentioned in Graham's stock selection chapters would not only add to the complexity of an already advanced system; but could also potentially reduce performance of the database, and incur additional data costs as well.

For those with coding experience, Finnhub too has a Free Tier which allows one to build one's own personal tools around its API.

Finsheet

Both of GrahamValue's screeners have supported Excel Exports since inception.

Technically, one could integrate the exported data with Finnhub's API; either using Google Sheets or using Microsoft Excel.

But Finnhub's documentation indicates that they already provide direct integration for Microsoft Excel and Google Sheets through Finsheet; their official partner for Spreadsheet plugins, which too — like Finnhub and GrahamValuehas a Free Tier.

Buffett about Graham

Son named after Graham

"Absolutely" valid in 2018

In the 2018 Balance of Power interview for Bloomberg Markets, Warren Buffett says yet again:

"The principles [of investing] haven't changed at all... It's exactly what Ben Graham wrote in 1949."

Warren Buffett, Bloomberg Markets: Balance of Power (2018).

Comments

‏Customized Stock Screening Strategies
‏NCAV + Sales + Stability
‏1-How much should the sales volume be today?
2-How much should the profits be stable today?

Dear Omar_H,

Thank you for your comment!

The above were simply some examples of how to apply additional requirements to Graham's framework. GrahamValue does not actually recommend anything apart from Graham's requirements.

Thank you again for your comment!