How to get Gross Dividend Amount over a period in a Single value

Hi there,

I'm trying to compute the P/L value of a portfolio. I would need the "total dividend paid amount" for a security over a specific period.

For example, AAPL.O has paid dividends twice in 2021: $0.22/share and $0.205/share, so I will need the value "0.425" as an output.

So far I could only get the values in an array with this formula:

=@TR("AAPL.O","TR.DivDate;TR.DivUnadjustedGross","SDate=0D EDate=-1AY RH=IN")

Can anyone please help a struggling soul? T T

Find more posts tagged with

eikon

excel

data

eikon-com-api

You can use

=TR("AAPL.O","SUM(TR.DivUnadjustedGross)","SDate=0D EDate=-1AY")

You can use

=TR("AAPL.O","SUM(TR.DivUnadjustedGross)","SDate=0D EDate=-1AY")

Thanks a lot!