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

Best Answer

Answers