For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
claudiu avatar image
89 ●7 ●9 ●13

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

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythontime-seriesreikon-data-api-r
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

4 Answers

Upvotes
Accepted
Alex Putkov.1 avatar image
39.2k ●75 ●11 ●27

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

claudiu avatar image claudiu

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

Upvotes
claudiu avatar image
89 ●7 ●9 ●13

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Alex Putkov.1 avatar image 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?

Upvotes
nick.zincone avatar image
9.7k ●49 ●38 ●60

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.


ahs.png (15.8 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
claudiu avatar image
89 ●7 ●9 ●13

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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea