Redundant rows/returns when pulling data

sean25
sean25 Newcomer
in Eikon Data APIs

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!

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    Answer ✓

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

Answers

Categories