← Back to Templates


Lakonishok Screen
Description

Ranks names on four value multiples at once, price to book, price to cash flow, price to sales and price to earnings, in the manner of Josef Lakonishok's research on value against glamour stocks. Using four measures together is the point, since any single one can be distorted by accounting treatment or by an unusual year. Sector labels keep the comparison inside peer groups where these ratios carry the same meaning. Set your own cut offs in the input cells, re-sort the list, and the multiples refill from MarketXLS on refresh.
Template Screenshots

Market data in your Excel sheets
1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.
See plans
▶
How does MarketXLS work? Watch Demo
Similar Templates
No similar templates found