date and fperiod in TR.NetprofitEstValue

apple.tsai
apple.tsai
in Eikon Data APIs

I am trying to get data of field

TR.NetprofitEstValue(Period=FQ1)

I think FQ1 means it will get the next quarter's estimation.

But in the following data I got:

estimate-question.png

some 'date' is early than 'fperiod' more than 1 quarter.

Why will this occur when I get FQ1 data?

Or there are more examples or explain about FQ0/FQ1/FQ2/... and date/calcdate/fperiod?

Tagged:

Best Answer

  • jason.ramchandani01
    jason.ramchandani01
    Answer ✓

    @apple.tsai Thanks for your question - so the reason for the calc dates being before the Fiscal Period is that the values for Net Income - Broker Estimate are being forecasted by each broker - each line represents a forecast at a particular date (Date, Calc Date), for the value pertaining to the Financial Period Absolute. Here you are requesting individual broker estimates - which you might need. Obviously - some estimates may not have been updates in a while - particularly for not well covered companies.

    But you could also request IBES Consensus Estimates for the company as well. This would be one average forecasted number which encapsulates all relevant broker estimates. It updates whenever any of the underlying brokers update their individual forecasts. I have written an extensive article on Working with our Fundamentals & Estimates Data here. I hope this can help.

Answers

  • raksina.samasiri
    raksina.samasiri admin

    Hi @apple.tsai ,

    The meaning can be found in the Formula Builder in Eikon Excel add-on or CodeCreator application in Eikon Desktop or Refinitiv Workspace application > Parameters & Quick Functions tab at the right panel > Financial Period dropdown, here you can see the description of each financial period including

    • FQ0: Last Fiscal Quarter
    • FQ1: Current Fiscal Quarter
    • FQ2: Next Fiscal Quarter

    1678260069321.png

    Regarding the content explanation, the moderators on this forum are expertise on Refinitiv APIs usage.
    However, they do not have deep expertise in every type of content available
    through Refinitiv products. Such expertise is available through Refinitiv
    Helpdesk, which can be reached via MyRefinitiv.

    Hope this helps and please let me know in case you have any further questions.

Categories