EPS Estimates Don't Align with Analyst Name or Analyst Code

rita.gunn

Hi. I am trying to pull the EPS estimates, associated Broker Name, Analyst Name, Analyst Code, and Estimate Date for a variety of tickers and variety of dates that span between 1989 and the present. I have provided sample code below for pulling for a single ticker from 1989. Some of the values are <NA> for the EPS estimate, Broker Name, Analyst Name and so on. The problem I am having is that the <NA> values are being sorted to the bottom of the output misaligning the data across the rows (i.e. the EPS Estimate does not line up with the right Broker name which doesn't match the right Analyst Name, which doesn't match the right Analyst Code,...). Is there an additional parameter I am missing to make these align? I am using the refinitiv API with python on Windows.

import refinitiv.data as rd

print("Opening Refinitiv session...")

rd.open_session()

data = rd.get_data( ['AXXN.O^J92'], ['TR.EPSEstValue','TR.EPSEstValue.BrokerName','TR.EPSEstValue.analystname','TR.EPSEstValue.Analystcode','TR.EPSEstValue.date'], parameters={'frq': 'FQ', 'Period': '1FQ1989', 'CURN':'USD', 'Sdate':'1987-01-01', 'Edate':'1990-12-31'} )

print(data)

rd.close_session()

Jirapongse

@rita.gunn

Thank you for reaching out to us.

I got the following output when using the platform.rdp session.

However, the output is correct when using the desktop.workspace session.

Please confirm that you are using the platform.rdp session.

Otherwise, please also check the version of RD library.

rd.__version__

I am using 1.3.1.