Redundant rows/returns when pulling data

sean25

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!

Alex Putkov.1

@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.

Alex Putkov.1

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.

Alex Putkov.1

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.

Alex Putkov.1

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.