Can't get quaterly data

Unknown
Unknown
in Eikon Data APIs

Hello, Support team

I want to get quaterly data.But Can't get quaterly data.

Please attached file.thomson-reuters-api-question.png

Tagged:

Best Answer

  • Zhenya Kovalyov
    Zhenya Kovalyov LSEG
    Answer ✓

    Try using these parameters:

    Period=FQ0 Frq=FQ SDate=0 EDate=-20

    While designing a model it is a good practice to build what you need in Excel first, and then reuse the queries. For example, here is my Excel function:

    =TR("9984.T","TR.JPBALOriginalAnnouncementDate;TR.JPINCOriginalAnnouncementDate;TR.JPCASOriginalAnnouncementDate","Period=FQ0 Frq=FQ SDate=0 EDate=-20 CH=Fd RH=IN")

    Here you have your instruments, fields and parameters.

    You can also see which field is which and their correct usage in the Data Item Browser

    image

Answers

  • Unknown
    Unknown

    Hello, Kovalyov.

    This issue was resolved. Thank you very much.

    If you know, please teach me about other parameter list.

    (e.g. SDATE, EDATE, FRQ, Period, etc...)

    Best regards,

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    https://community.developers.refinitiv.com/discussion/comment/16120#Comment_16120

    The list of parameters available and applicable depends on the fields chosen. As mentioned by @Zhenya Kovalyov the best way to figure out what parameters you need to use is to follow Formula Builder wizard in Eikon Excel or Data Item Browser. If you use Formula Builder wizard in Eikon Excel you also have an added advantage of being able to play with different parameter values and seeing their effect on data returned.

Categories