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

ethellove.cacho

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

Jirapongse

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

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.