eikonapir: how to get timeseries data for dividends field?

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

Find more posts tagged with

python

eikon

time-series

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

eikon-data-api-r

Accepted answers

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

All comments

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

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

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.

EXPLORE OUR SITES