MarketXLS

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)

Syntax

=hf_Dividends_paid_per_share_year_to_date(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

Dividends paid per share YTD

Examples

=hf_Dividends_paid_per_share_year_to_date("AAPL", 2023, 4)
Full year dividends
=hf_Dividends_paid_per_share_year_to_date("JNJ", "ly", 2)
Last year through Q2
=hf_Dividends_paid_per_share_year_to_date(A1, B1, C1)
Cell references

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

Why is dividend showing 0?

The company may not pay dividends. Check if it's a dividend-paying stock.

Related Formulas

More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Dividends Paid Per Share Year To Date (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions