Value screen

Magic Formula

Greenblatt's idea: good businesses at cheap prices. High earnings yield, high returns.

RulesEarnings yield above 8% (P/E under 12.5)ROE above 20%Market cap above ₹500 crTweak in SQL

The original uses return on capital (ROCE), which the data source does not provide, so ROE stands in.

–stocks

Try another angle

Cheap on earnings, modest debt and a high return on equity.

Profitable companies the market values at less than their net assets.

Companies whose cash pile is larger than everything they owe.