question

Upvotes
Accepted
5 0 0 4

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

@Zhenya Kovalyov

eikoneikon-com-apidataexcel
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.

1 Answer

Upvotes
Accepted
39.3k 76 11 27

@roman.wang01

You can use

=TR("AAPL.O","SUM(TR.DivUnadjustedGross)","SDate=0D EDate=-1AY")
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.

Thanks a lot!