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

ethellove.cacho
ethellove.cacho
in Eikon Data APIs

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

Tagged:

Best Answer

  • Jirapongse
    Jirapongse
    Answer ✓

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


Categories