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
ethellove.cacho avatar image
1 ●0 ●1 ●2

I am in the process of writing code for working with Eikon Data Api.

The important part is getting the right input data.

For Example, simple fragment of code: 

df, err = ek.get_data([‘MGP’], ['TR.PriceClose', 'TR.CompanyMarketCapitalization'])

Some data I want to check, and some data I can't find through Data Item Browser in Refinitiv Eikon, please tell me correct parameter names to write after “TR.” for:

1) Buyback/stock purchase

2) P/S for 2020, 2021, 2022, current, 5YR average (5 parameters)

3) P/E for 2020, 2021, 2022, current, 5YR average (5 parameters)

4) EV/EBITDA for 2020, 2021, 2022, current, 5YR average (5 parameters)

5) PEG

6) Dividend yield

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

1 Answer

· Write an Answer
Upvote
Accepted
Jirapongse avatar image
80k ●257 ●52 ●75

@ethellove.cacho

You can also check the TR fields from the overview page of MGP.

Click on the question mark to get the formula and fields used to get the values.

1643701767637.png

1643701786094.png

Otherwise, you can contact the Eikon Excel support team directly via MyRefinitiv and ask for the =TR formula which can be used in the Eikon excel to retrieve required data.



1643701767637.png (21.8 KiB)
1643701786094.png (91.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.

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.