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

[Deleted User]

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

vishnu01

https://community.developers.refinitiv.com/discussion/comment/110829#Comment_110829

Hi,

Thank you for the response .
I'm not using the RD library I'm using the Refinitiv eikon.
And with EPS I also want to get the Net_income and Revenue like suppose the period end date is 2023-06-22 and earnings release date is 2023-08-24 .
So I want to fetch the revision of statistical average of all broker estimates on semiannual for UK listed companies.
for quarterly I'm using the above formula and getting relevant result.
please assist with that,

[Deleted User]

https://community.developers.refinitiv.com/discussion/comment/110860#Comment_110860

Hi @vishnu01, the RD library can be thought of as Refinitiv Eikon Data API (EDAPI) version 2; TR.F fields will work for both libraries. Your question is therefore a content question.
This Developer Q&A Forum is for technical LSEG API questions; for content quesitons, please reach out to my.refinitiv.com.

vishnu01

https://community.developers.refinitiv.com/discussion/comment/110934#Comment_110934

Hello @jonathan.legrand , thank you for the response but the code you provided not meeting my requirements. I want to fetch the statistical average of all broker estimates (Eps, Revenue, and Net Income ) and their revisions (in between the period end date and date before earnings release) from 2010-01-01 to 2023-11-07 for the UK listed stock like 'VMUK.L' or the companies which releases earnings on semiannual basis. How can I get them ?

Jirapongse

https://community.developers.refinitiv.com/discussion/comment/110938#Comment_110938

@vishnu01

Please reach out to the helpdesk support team directly via my.refinitiv.com.

The support team can provide you with the fields or formula that can be used to get the requried data.