Walter Schloss 'New Lows' Screen

Walter Schloss bought unpopular, asset cheap stocks, and this screen recreates the starting point he used: shares trading close to their fifty two week low, priced at or below book value per share, with total debt low enough that the balance sheet can wait out a recovery.

Book value per share, the fifty two week low, last price, total debt and market capitalization populate from MarketXLS formulas on each row, so the discount to book and the distance from the low are both computable inside the sheet. Schloss held such positions for years, and the screen is built for that horizon.