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.

raksina.samasiri avatar image   raksina.samasiri

@ethellove.cacho

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question or could you provide the information required for further investigation, please?

Thanks,
AHS

Shadab Hussain avatar image   Shadab Hussain

Hi @ethellove.cacho,

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


Thanks,

AHS

1 Answer

· Write an Answer
Upvote
Accepted
Jirapongse avatar image
78.9k ●250 ●52 ●74

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