Besides CodeCreator, is there an overview of all kinds of different data that can be accessed usi...

patrick.zimmermann.91

...ng the Eikon Data API with Python?

I'm a complete beginner in programming and I'm generally still struggling with Python and the programming environment, but I've been able to pull some data using the Get started guide. However, I still lack a complete overview of all possible data that I can query via Eikon. The CodeCreator in the Refinitiv Workspace is helpful, but not complete. For example, I could not find data such as "TR.TotalAssetsReported", "TR.TotalDebtOutstanding", "TR.TotalEquity", "TR.NetIncomeAfterTaxes" via the CodeCreator. I am currently looking for the data regarding Delisting Reason, the search in CodeCreator was unfortunately unsuccessful.

Another example is here in this forum post: https://community.developers.refinitiv.com/questions/63774/extracting-rics-of-lse-aim-companies.html 

Without this forum post, I would not have known that I could filter for the MIC_Code.

Can you help me with this?

Find more posts tagged with

python

eikon

data

jupyter

eikon-data-api

jupyter-notebook

codecreator

#technology

Accepted answers

wasin.w

Hello @patrick.zimmermann.91

I can browse the "TotalAssetsReported" and "TR.TotalEquity" fields description of the KINO.L RIC in the Data Item Browser App as follows:

Please be informed that the Data Item Browser App just shows all available fields with "current data" of the RIC only. You cannot query historical data values of the fields on the Data Item Browser app.

All comments

wasin.w

Hello @patrick.zimmermann.91

There is a Workspace/Eikon app name "Data Item Browser" (DIB) that lets you put your interested RIC name, then browse all available fields of that RIC.

You can open this App by typing "Data Item Browser" or just "DIB" in your Workspace/Eikon desktop.

There is also a video tutorial about this tool at https://developers.lseg.com/en/video-catalog/data-item-browser page.

I hope this information helps.

patrick.zimmermann.91

Hello @wasin.w,

first of all thanks for the quick response. However, the Data Item Browser doesn't help much, as I can't find the original data here either. For example, if I use

df, err = ek.get_data(
    instruments = ['KINO.L'],
    fields= [
        'TR.TotalAssetsReported(Frq=D,SDate = 2022-12-01,EDate=2022-12-13)',
        'TR.TotalEquity(Frq=D,SDate=2022-12-01,EDate=2022-12-13)'
    ]
)
display(df)

in Python, the data is displayed, but the Data Item Browser finds nothing. Can you help me with this?

wasin.w

Hello @patrick.zimmermann.91

I can browse the "TotalAssetsReported" and "TR.TotalEquity" fields description of the KINO.L RIC in the Data Item Browser App as follows:

wasin.w

Hello @patrick.zimmermann.91

Alternatively, you may contact the Workspace/Eikon support team directly to help you with the RIC fields data behavior and content questions (I and other forum admins are not the Content expert).

You can contact the Support team directly via https://my.refinitiv.com/content/mytr/en/helpandsupport.html website.

EXPLORE OUR SITES