Templeton Screen

Value criteria inspired by John Templeton's bargain hunting drive this screen: a modest trailing price to earnings ratio, net income from continuing operations tracked across years rather than a single good quarter, gross margin at the last reported quarter, and a share count that has not quietly expanded.

Candidates arrive through a MarketXLS database query, and each row carries the company name, quarterly earnings per share and the current consensus estimate trend, so you can see whether analysts are revising up or down. With the add-in installed, every cell refills from current fundamentals when the sheet recalculates.