Analyst estimates on semiannual basis.

vishnu01

I'm getting the correct data for quarterly estimates.

df,err = ek.get_data(
instruments = ['MSFT.O'],
fields = ['TR.EPSMean.periodenddate','TR.EPSMean','TR.EPSMean.date','TR.RevenueMean', 'TR.NetProfitMean'],
parameters={'SDate':'2023-01-01','EDate':'2023-10-23','Period':'FQ1'}
)
df

But for UK companies which are giving earnings on a semiannual basis I'm facing the issue. I Tried changing the period to FS0,FS1,ES0,ES1 as a period parameter and also changed the frequency parameter to FS.

But not getting the relevant data. How can I do that? Please assist with this

jonathan.legrand

Hi @vishnu01,

May I ask if the TR.F fields (that are somewhat new in LSEG's databases) fullfill your demand? I believe that they ought to provide semiannual data when it's released by companies:

e.g.:

import pandas as pd
import refinitiv.data as rd
rd.open_session()
df: pd.DataFrame = rd.get_history(
    universe = "LSEG.L",
    fields = ['TR.F.EPSBasicExclExordItemsNormTot(SDate=0,EDate=-3,Period=FS0,Frq=FS)'],
    # interval='tick',
    # start='2023-10-30T10:00:00Z',
    # end='2023-11-01T18:00:00Z'
    # parameters = {'SDate': '2021-10-01'}, # , 'EDate': 1
    )
display(df)
rd.close_session()