Consecutive Period of Uninterrupted Dividend
Determines whether a company has maintained uninterrupted dividend payments for a specified number of consecutive periods (typically years). This metric is important for income investors seeking reliable dividend payers.
Understanding Dividend Continuity
- Uninterrupted means dividend was paid every period
- Amount may have fluctuated but was never zero
- Some companies have 100+ years of uninterrupted payments
- Dividend cuts or suspensions break the streak
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol |
| Periods | Yes | Number of consecutive periods to verify |
Notes
- Returns TRUE if dividend was paid each period
- Returns FALSE if any period had no dividend payment
- More lenient than checking for increases
- Useful for screening reliable dividend payers
Examples
Check 50-year payment history
=ConsecutivePeriodOfUninterruptedDividendPayout("PG", 100)=ConsecutivePeriodOfUninterruptedDividendPayout("JNJ", 25)Check 10-year history
Parameters from cells
When to Use
- Screening for reliable dividend payers
- Verifying dividend payment history
- Identifying stable income investments
- Building conservative income portfolios
- Checking for historical dividend cuts
When NOT to Use
Common Issues & FAQ
Q: What's the difference between uninterrupted and increasing? A: Uninterrupted = dividend was paid every period (amount can vary). Increasing = dividend amount grew each period (stricter requirement).
Q: What breaks an uninterrupted streak? A: A period with zero dividend payment (suspension or elimination). Dividend cuts that still pay something don't break the streak.
Q: How far back does the data go? A: Data availability varies by company. Most US stocks have 20+ years of dividend history.
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?