Duplicate reported date with different data points?

abhichikara
abhichikara Newcomer
in Eikon Data APIs

I requested historical data for the following fields

Required_fields = ['TR.EBIT', 'TR.ISOriginalAnnouncementDate', 'TR.EBIT.calcdate']

main_data,error = ek.get_data(['HDBK.NS'],Required_fields,{'SDate':str(0), 'EDate':str(-137), 'Frq':'M','Period':'FQ0','ConsolBasis':'Consolidated','ReportingState':'Orig'})


As in the given screenshot, there are duplicate ISOriginalAnnouncementDate with different data points.image

Tagged:

Best Answer

  • jason.ramchandani01
    jason.ramchandani01 admin
    Answer ✓

    Hi @abhichikara - please use the following code - this seems to work

    Required_fields = ['TR.F.EBIT', 'TR.F.OriginalAnnouncementDate', 'TR.F.EBIT.calcdate']
    main_data,error = ek.get_data(['HDBK.NS'],Required_fields,{'SDate':0, 'EDate':-137, 'Frq':'Q','Period':'FQ0','ConsolBasis':'Consolidated','ReportingState':'Orig'})
    main_data

    image

Answers

  • jason.ramchandani01
    jason.ramchandani01 admin

    Hi @abhichikara thanks for your question. Yes indeed the entries are repeated as you are asking for a quarterly figure on a monthly basis. The field you requested is an as reported field - so if the company only updates on a quarterly basis you are limited to that. However, if you want a field that represents estimates that change more often you could try TR.EBITMean or TR.EBITDAMean. Those should give you different monthly values of the quarterly forecast - as analysts update their estimates.

    I hope this can help.

  • abhichikara
    abhichikara Newcomer

    Hi @jason.ramchandani , thanks for the reply so i have requested the data again with the quarterly frequency yet it is again showing the two same dates with different values on 10/19/2019 of income statement original announce date.

    image

  • chavalit-jintamalit
    chavalit-jintamalit admin

    Hi @abhichikara

    First of all, these fields in your request are from the different databases so you cannot expected them to be aligned on the same date (but in this case, they just happen to be aligned).

    I also tried to retrieve the same set of data using Eikon Excel.

    image


    From your original question, I think this is the question.

    Why the TR.ISOriginalAnnouncementDate value is duplicate for different data periods as in the picture below:

    image


    This forum is not the best place to clarify content behaviors or is the datapoint is invalid?

    For an authoritative answer to any content questions, the best resource is the Refinitiv Content Helpdesk.

    The Refinitiv Content Helpdesk can be reached using Contact Us capability in your Eikon application.
    Or by calling the Helpdesk number in your country.
    Or at https://my.refinitiv.com/

  • abhichikara
    abhichikara Newcomer
    https://community.developers.refinitiv.com/discussion/comment/63052#Comment_63052

    jason.ramchandani Thanks it sure solves the problem of duplicate dates but what's the difference between using TR.EBIT' and TR.F.EBIT'. Is there any proper detailed documentation/definition for the fields which can be used with python API?

  • jason.ramchandani01
    jason.ramchandani01 admin
    https://community.developers.refinitiv.com/discussion/comment/63052#Comment_63052

    Hi @abhichikara - glad the code worked for you. So the TR.F.fields use our new Company Fundamentals service. You can find out details the new Refinitiv Co. Fundamentals by looking at the in- product service announcement - see below screenshot (What's new)

    image

    If you have any further queries or questions - as @chavalit-jintamalit says you can contact the content helpdesk who can give you authoritative explanations on content issues. I will speak with the product manager however and see if we can get some documentation around this as it is a little confusing.

Categories