Downloading historical time-series dividend data using Eikon Excel Add-In

Question

Question by alistair.s.grant · Feb 14, 2019 at 06:20 AM · eikon excel historical time series dividend

Downloading historical time-series dividend data using Eikon Excel Add-In

Hi everyone, I am trying to download historical dividend data for equities using the Eikon Add-In for Excel. However, using the Eikon Add-In, when selecting 'Time Series' data there seems to be no field for 'dividends'.

The code I'm using (for example) is =RHistory("AAPL.O",".Timestamp;.Close","START:01-Jan-1988 END:28-Dec-2018 INTERVAL:1D",,"TSREPEAT:NO CH:Fd",C3)

This allows me to see historical daily closing prices. I also want to add daily dividend values, allowing me to calculate daily total return.

Thanks in advance.

0

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2019-02-14T10:43:48Z

REFINITIV

Best Answer

Answer by Zhenya Kovalyov · Feb 14, 2019 at 10:43 AM

@alistair.s.grant you can use TR function as this data is served though the reference database (Data Items > Corporate Actions > Dividend History).

For example,

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

For further info I suggest you contact your local Refinitiv support desk, as this community is used for API questions.

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Downloading historical time-series dividend data using Eikon Excel Add-In

1 Reply

Watch this question

Related Questions