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()
