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