Dividends Paid Per Share Year To Date (Historical)
Returns the cumulative dividends paid per share from the beginning of the fiscal year through the specified quarter.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol |
| Year | Yes | Fiscal year or period code |
| Quarter | No | Calendar quarter 1-4 |
| TTM | No | Set to "TTM" for trailing twelve months |
Notes
- Values are per share amounts
- Includes regular dividends only (not special dividends in some cases)
Examples
=hf_Dividends_paid_per_share_year_to_date("AAPL", 2023, 4)=hf_Dividends_paid_per_share_year_to_date("JNJ", "ly", 2)=hf_Dividends_paid_per_share_year_to_date(A1, B1, C1)When to Use
- Tracking cumulative dividend payments
- Income portfolio analysis
- Year-over-year dividend comparisons
- Dividend growth tracking
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need dividend yield | DividendYield() |
| Need next ex-dividend date | ExDividendDate() |
| Need quarterly dividend | hf_Dividends_per_share() |
Common Issues & FAQ
Q: Why is dividend showing 0? A: The company may not pay dividends. Check if it's a dividend-paying stock.
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?