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

alistair.s.grant
alistair.s.grant Newcomer
in Eikon COM

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.

Tagged:

Best Answer

  • Zhenya Kovalyov
    Zhenya Kovalyov LSEG
    Answer ✓

    @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.

Categories