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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 2

Redundant rows/returns when pulling data

We are curious why the following function returns numerous duplicate rows in Excel:

=TR("SHIP.O","TR.EPSEstValue.date;TR.EPSEstValue;TR.EPSEstValue.analystname;TR.EPSEstValue.origdate;TR.EPSEstValue.confirmdate;TR.EPSEstValue.periodenddate","SDate=2017-01-01 EDate=2018-01-01 Period=3FQ2019 CH=Fd")

This example uses a stock with only one public analyst, and yet we are seeing row after row of what appear to be duplicate returns. The issue is magnified when looking at stocks covered by more than one analyst. Thank you!

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonequities
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.

1 Answer

Upvote
Accepted
39.2k 75 11 27

@sean25
This forum is dedicated to software developers using Refinitiv APIs. The moderators on this forum do not have deep expertise in every type of content available from Refinitiv products. This question would be best directed to Refinitiv Helpdesk, which has access to content expertise required to answer your question.
I raised case 07465434 on your behalf with Refinitiv Helpdesk. The Helpdesk will contact you to address the issue you reported here.

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.

The resolution provided by the Helpdesk:
The reason is that you use both a start date and an end date, which makes it a time series request. It returns a row with EPS estimates for every trading day between two dates. Since for these dates and this period there are no EPS estimates from brokers, you are just getting NULLs.

If we remove the EDate we get just one NULL row. If we change the value of Sdate to 0D:

=TR("SHIP.O","TR.EPSEstValue.analystname;TR.EPSEstValue.date;TR.EPSEstValue;TR.EPSEstValue.origdate;TR.EPSEstValue.confirmdate;TR.EPSEstValue.periodenddate","SDate=0D Period=3FQ2019 CH=Fd")
we we get two analysts.

And if we then put back the EDate set to 1 year ago:

=TR("SHIP.O","TR.EPSEstValue.analystname;TR.EPSEstValue.date;TR.EPSEstValue;TR.EPSEstValue.origdate;TR.EPSEstValue.confirmdate;TR.EPSEstValue.periodenddate","SDate=0D EDate=-1AY Period=3FQ2019 CH=Fd")
the values returned repeat for every day between the two dates.
Click below to post an Idea Post Idea