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
Syntax
=ConsecutivePeriodOfUninterruptedDividendPayout(Symbol, Periods)Parameters
Returns
TRUE if dividend has been paid uninterrupted for specified periods, FALSE otherwise
Examples
=ConsecutivePeriodOfUninterruptedDividendPayout("PG", 100)=ConsecutivePeriodOfUninterruptedDividendPayout("JNJ", 25)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
| Scenario | Use Instead |
|---|---|
| Check for consecutive increases | ConsecutivePeriodOfIncreasingDividendPayout() |
| Get current dividend amount | DividendPerShare() |
| Get dividend yield | DividendYield() |
| Get next dividend date | Ex_DividendDate() |
Common Issues & FAQ
What's the difference between uninterrupted and increasing?
Uninterrupted = dividend was paid every period (amount can vary). Increasing = dividend amount grew each period (stricter requirement).
What breaks an uninterrupted streak?
A period with zero dividend payment (suspension or elimination). Dividend cuts that still pay something don't break the streak.
How far back does the data go?
Data availability varies by company. Most US stocks have 20+ years of dividend history.
Excel Templates Using Consecutive Period of Uninterrupted Dividend
These ready-made MarketXLS templates call ConsecutivePeriodOfUninterruptedDividendPayout() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Dividends formulas you can use in the same worksheet:
- Dividend Date
- Dividend Frequency
- Dividend Per Share 5 Year CAGR
- Dividend Rate (Forward)
- Ex-Dividend Date
- Forward Annual Dividend Rate
- Forward Annual Dividend Yield
- Total Dividends Between Two Dates
See ConsecutivePeriodOfUninterruptedDividendPayout used in a complete workbook: Dividend Safety Screener Excel: Payout Coverage and Recession Risk in May 2026
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today