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
kengo_takahashi_deprecated_0 avatar image
18 ●2 ●2 ●5

Can't get quaterly data

Hello, Support team

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

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

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apiapierrorfundamentals
thomson-reuters-api-question.png (84.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.

veerapath.rungruengrayubkul avatar image   veerapath.rungruengrayubkul

@kengo_takahashi

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

Nipat Kunvutipongsak avatar image   Nipat Kunvutipongsak

Hello again,

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question.

Thanks,

AHS

Jirapongse avatar image   Jirapongse

@kengo_takahashi

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

Thanks,

AHS

2 Answers

· Write an Answer
Upvote
Accepted
Zhenya Kovalyov avatar image
4.6k ●26 ●7 ●22

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


screen-shot-2017-07-07-at-093818.png (216.3 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.

Upvotes
kengo_takahashi_deprecated_0 avatar image
18 ●2 ●2 ●5

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,

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.

Alex Putkov.1 avatar image Alex Putkov.1

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.

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.