Annual Single Value for Dividend Paid per Share

i´m looking for a way for the "annual total dividend paid per share". I used the "Gross Dividend Amount" as well as the "Adjusted Gross Dividend Amount". Both look in general good BUT I want to see a single value per FY from FY2014 until FY2021.

If I sort by Period End Date it shows duplicated because of the Dividend Type (Final, Interim, Special, Extra).

Is there a way to sum up all these Types into one single value per year. So that I have one Dividend Value for the 8 different FY?

I have tried the sum function on this, but this sums up the dividend for all 8 years.

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @student17

    For questions regarding Eikon Excel's formula (=@TR function), please get in touch with the Eikon support team directly via MyRefinitiv. The support team can verify the formula or provide the correct one that may be used to retrieve the required data.

Answers