eikonapir: how to get timeseries data for dividends field?

claudiu

Hello,

I'm trying the R interface API using eikonrapi and I can successfully download timeseries of stock prices and volumes. I'd like to be able to get the dividend history of a stock but using the get_data() command gets me only the last instance and using the get_timeseries() only has these fields:

TIMESTAMP HIGH CLOSE LOW OPEN COUNT VOLUME N

as fields available (shown using "*"). How can I combine the 2 commands?

In Excel add-inn this is achieved through a TR commmand like:

=TR(XXX,"TR.DivExDate;TR.DivAdjustedGross;TR.DivCurr","DateType=XD
SDate=#XX EDate=XX",XX,XX,XX)

thanks,

Claudiu

Alex Putkov.1

Hi @claudiu

The following function retrieves dividends for IBM between 1-Jan-2016 and today's date:

get_data("IBM",list('TR.DivExDate','TR.DivAdjustedGross','TR.DivCurr'),list('DateType'='XD','SDate'='1D','EDate'='2016-01-01'))

I hope it helps.

Alex

claudiu

https://community.developers.refinitiv.com/discussion/comment/13529#Comment_13529

Thanks, works. Would be great if the documentation is updated to include these fields.

claudiu

The answer from Alex worked till lately. It doesn't seem to work anymore, see below. Something in the interface changed?

>get_data("IBM",list("TR.DivExDate","TR.DivAdjustedGross","TR.DivCurr"),list('DateType'='XD','SDate'='1D','EDate'='2016-01-01'))

data frame with 0 columns and 0 rows

nick.zincone

Hi @claudiu,

Within Python, using the equivalent call, I'm seeing this:

Are you able to confirm the same results using Python? Because the R implementation is not officially supported and is open source, you can verify if anything within this interface has changed.

Alex Putkov.1

https://community.developers.refinitiv.com/discussion/comment/23890#Comment_23890

I don't believe there's been any changes, and I have no problem executing this call on my end. You didn't by any chance forget to execute set_app_id method prior to calling get_data?

claudiu

Resolved. Today same program works. Yesterday the get_timeseries() commands worked (so the app_id was set correctly) while the get_data() ones failed. Maybe a temporary glitch with the Eikon server interface. Thanks for the responses.