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
-
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.
0
Answers
-
hi @student17 ,
Could you please provide the code you're using for further investigation.
0 -
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)
0 -
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.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 37 Alpha
- 167 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 707 Datastream
- 1.5K DSS
- 633 Eikon COM
- 5.2K Eikon Data APIs
- 15 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 7 Trading API
- 3K Elektron
- 1.5K EMA
- 259 ETA
- 572 WebSocket API
- 41 FX Venues
- 16 FX Market Data
- 2 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 26 Messenger Bot
- 4 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 284 Open PermID
- 47 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 25 RDMS
- 2.2K Refinitiv Data Platform
- 12 CFS Bulk File/TM3
- 903 Refinitiv Data Platform Libraries
- 5 LSEG Due Diligence
- 1 LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 126 Open DACS
- 1.1K RFA
- 108 UPA
- 197 TREP Infrastructure
- 232 TRKD
- 921 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 106 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛