question

Upvotes
Accepted
roman.wang01 avatar image
5 ●2 ●2 ●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

· Write an Answer
Upvotes
Accepted
Alex Putkov.1 avatar image
39.4k ●77 ●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.

roman.wang01 avatar image roman.wang01

Thanks a lot!

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.