API Not Returning Full Set of Results from Code

As part of a research project, I am tasked with pulling date, time, and event data (i.e. event type) for earnings calls put out by a number of different companies dating back to 2001. When I run a query within the regular Thomson Eikon application, I am able to retrieve the data fine. However, when I run the following code through the API, it only returns data dating back ~5 years:

ek.get_data('MMM.N',['TR.EventStartDate','TR.EventType','TR.EventTitle'], {'EventType':'ECall','SDate':'20000101','EDate':'20171001'})

The above is for 3M, but the idea is to be able to utilize a script to get this information as opposed to logging in to Thomson, inputting search criteria, waiting for an excel file to be generated, etc. I have also attached a screenshot of the results for reference. Any ideas or suggestions would be greatly appreciated, as this is my first time working with Python and the Eikon API.

Thanks,

-Chris

Find more posts tagged with

python

eikon

api

fields

workspace

api-limits

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Alex Putkov.1

The Web service that returns company events limits the response to a single request to the max timespan of 5 years. If you need events history for a longer period you need to split your request into multiple, each with SDate and EDate parameters no more than 5 years apart.

All comments

nick.zincone

Hi @brunett_chri,

I was able to replicate what you are seeing. As a test, I tried changing the end date to say: '20101001' and noticed the data set returned started at 2005 so it seems the data is there but what is returned is limited.

I will raise the question to the product group.

Alex Putkov.1

EXPLORE OUR SITES