Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
vishnu01 avatar image
3 ●0 ●3 ●8

Analyst estimates on semiannual basis.

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

#product#contentdeveloper-communitysupporthelpdesk
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

raksina.samasiri avatar image   raksina.samasiri

Hi @vishnu01 ,

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,
AHS

Jirapongse avatar image   Jirapongse

@vishnu01

Hi,

Please be informed that a reply has been verified as correct in answering the question, and marked as such.

Thanks,

AHS

1 Answer

· Write an Answer
Upvotes
Accepted
jonathan.legrand avatar image
5.8k ●21 ●2 ●6

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:


1699267293647.png

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

1699267546520.png



1699267293647.png (258.4 KiB)
1699267546520.png (20.2 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

vishnu01 avatar image vishnu01
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,
jonathan.legrand avatar image jonathan.legrand vishnu01

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 avatar image vishnu01 jonathan.legrand

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 ?

Show more comments

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.