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
1 0 0 0

date and fperiod in TR.NetprofitEstValue

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?

refinitiv-dataplatform-eikon#contentdataestimates
estimate-question.png (374.7 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.

Upvote
Accepted
9.8k 17 6 9

@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.

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.

Upvotes
13.8k 28 5 10

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.


1678260069321.png (143.6 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.

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.