Dividend Frequency
Returns how often a company pays dividends (e.g., Quarterly, Monthly, Semi-Annual, Annual).
Syntax
=DividendFrequency(Symbol)Examples
=DividendFrequency("AAPL")=DividendFrequency("O")When to Use
- Income portfolio planning
- Cash flow timing analysis
- Dividend strategy selection
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Dividend amount | DividendPerShare() |
| Next payment date | DividendPayDate() |
Common Issues & FAQ
What frequencies are possible?
Monthly, Quarterly, Semi-Annual, Annual, or Irregular.
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?