Dividend functions enable quick access to a comprehensive set of functions such as Dividend Payments, Dividend Yield, DPS, and Dividend Payout Ratio.
You can reach dividend functions list on the Function selection screen by choosing Data from Category -> Dividend from Data Type -> Dividend Function List from Field.
Below you can find a list of dividend functions with descriptions and calculations.
Dividend
Dividend returns different data for specified various fields such as Announcement Date, Description, Currency, Gross or Net DPS, # of shares, period start and end dates,
gross and net dividend of dividend payments.
Dividend Payment Count
Dividend Payment Count returns dividend payment year count within specified period.
Total Dividend
Total Dividend returns total gross or net dividend payment value for specified date range.
Dividend Yield
Dividend Yield returns dividend yield of the security in the specified period. Dividend Yield data is an important indicator especially for the long-term investors which is calculated by dividing the total dividend amount by the market capitalization value.
Calculation:
Dividend Yield = Total Gross Dividend Amount/ MCap (for specified date)
Dividend Yield Average
Dividend Yield Average returns the average dividend yield of the selected security with respect to the specified market capitalization day interval.
Calculation:
Dividend Yield Average (for date range) = Sum (Gross Dividend Amount)/ MCAP (rt)
MCAP (rt) = Average market capitalization of the security on the reference date interval
Dividend Yield Average (for one specified date) = Sum (Gross Dividend Amount)/ MCAP (t-1)
MCAP (t-1) = Market capitalization of the security on the previous date of the dividend payment
Dividend Yield per Year Average
Dividend Yield per Year Average returns the annual average dividend yield of the selected security within the selected time period. You can specified the number of years to go backwards from the given year.
Calculation:
Dividend Yield per Year Average = (DividendYieldAvg (1) + DividendYieldAvg (2) + ……+ DividendYieldAvg (n))/n
n = number of years
Annual Dividend Yield with Avg. Weighted Price
Annual Dividend Yield with Average Weighted Price returns the result of average weighted close price multiplied by annual dividend yield.
Dividend Count
Dividend Count returns dividend payment count within specified period.
Sum Dividend Gross
Sum Dividend Gross returns the total amount of the gross dividend payment of the selected security for the specified date interval in terms of the selected currency.
Sum Dividend Net
Sum Dividend Net returns the total amount of the net dividend payment of the selected security for the specified date interval in terms of the selected currency.
DPS
DPS returns the dividend per share for selected security.
DPS-TTM
DPS-TTM returns the yearly dividend per share of selected security for specified date.
Calculation:
Yearly dividend per share is calculated as a sum of dividends per share for the interval:
If Dividend Payment Frequency for specified date=0, between specified Date and (the year of selected date -1)
If Dividend Payment Frequency for specified date<previous year, between specified Date and (the year of selected date-1)
If Dividend Payment Frequency for specified date>previous year, between specified Date and (the year of selected date -1)
Dividend Yield –TTM
Dividend Yield –TTM returns the yearly dividend yield of selected security for specified date.
Calculation:
Dividend Yield –TTM = Adj. DPSTTM/Close (Raw)*100
Dividend Future
Dividend Future returns the future dividend payment value.
Dividend Future Security List
Dividend Future Security List returns the Securities which have the future dividend payments for the selected source and number.
Dividend Payout Ratio
Dividend Payout Ratio returns the rate of total gross dividend for specified date to the end of previous year net income of the selected security.
Calculation:
Dividend Payout Ratio =Total Gross Dividend/ Net Earnings (Previous Year End)