Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 1 1 1

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.

eikoneikon-data-apirefinitiv-dataplatform-eikonrefinitiv-realtime
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Accepted
82.7k 279 53 77

@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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvote
14.9k 32 5 10

hi @student17 ,

Could you please provide the code you're using for further investigation.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I have tried this one:

=@TR('UN Prime 20150101'!E2:E321;"TR.DivUnadjustedGross";"SDate=FY2014 EDate=FY2021 DateType=PED CH=Fd;dividendtype RH=IN;periodenddate NULL=ZERO";$A$3)


give me at least the different Dividend Types but still some duplicates in the Period End Year.


Something like this with SUM would be perfect, if it can show the sum of each FY seperate

=@TR('UN Prime 20150101'!E2:E321;"SUM(TR.DivUnadjustedGross)";"SDate=FY2014 EDate=FY2021 DateType=PED CH=Fd;dividendtype RH=IN;periodenddate NULL=ZERO";$A$3)

Here is the example with the dupe in Period End Date --> 2019 is shown twice

and also the different types just as a sum would be good.

1658409053842.png

1658409053842.png (17.8 KiB)

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.