← Back to Templates


Graham Defensive Investor (Non-Utility) Screen
Description

Applies the defensive investor tests associated with Benjamin Graham to non-utility stocks, scoring each candidate on adequate size by revenue, an uninterrupted dividend record, earnings history, moderate long term debt and an undemanding valuation.
Historical dividends per share and quarterly earnings per share drive the consistency checks, the database query formula supplies the starting universe, and sector labels let you exclude utilities as the original screen intended. Thresholds sit in editable cells, so each test can be tightened or relaxed to your own standard.
Template Screenshots

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work? Watch Demo
Similar Templates
No similar templates found