← Back to Templates


Weiss Blue Chip Div Yield Screen
Description

Screens larger, established dividend payers on the yield and quality logic associated with Geraldine Weiss, whose approach treats a stock as undervalued when its dividend yield is high relative to its own history. Dividend yield and historical dividends per share sit alongside quarterly earnings per share, current ratio and share count, so payout coverage and balance sheet strength are verified rather than assumed. The database query formula builds the starting universe and sector labels group the survivors. Each threshold stays in an editable cell so the bar is yours to set.
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