Hi @pfarrer.braun

I think you can open an overview page and go to Financials >> Income Statement

Then click on the "?" icon next to the data you want and see the data field.

So in this case the data field is TR.Revenue

You can do the same process on another sheet.

If you cannot find the data field you are looking for, please contact Helpdesk.

Sample code:

rics = ['0700.HK']
fields = ['TR.Revenue','TR.CashAndSTInvestments']
df3, err = ek.get_data(rics,fields ,{'SDate':'0','EDate':'-5','Period':'FQ0','Frq':'FQ'})
df3

Output:

0 0700.HK 125447000000 235968000000
1 0700.HK 114883000000 261550000000
2 0700.HK 108065000000 200298000000
3 0700.HK 105767000000 187016000000
4 0700.HK 97236000000 201328000000
5 0700.HK 88821000000 184534000000

Hi @pfarrer.braun

You need to know the data field carrying the information you are looking for.

For example: This screener finds inactive companies and retrieves "TR.RetireDate" field.

However, what data field is carrying the bankruptcy information (or if there is any) is a content question.

This forum is not the best place to ask about content questions.

For an authoritative answer to any content questions, the best resource is the Refinitiv Content Helpdesk.
The moderators here do not have deep expertise in every type of content available through Eikon.
The Refinitiv Content Helpdesk can be reached using Contact Us capability in your Eikon application.
Or by calling the Helpdesk number in your country.
Or at https://my.refinitiv.com/

To retrieve balance sheet, please try this sample code:

Hi @chavalit.jintamalit

Thank you for your answer!

Retire Date seems to be alright.

Your second code shows, to my understanding, the date and the source of the balance sheet and the income statement, thanks for that!. However, how can I retrieve the complete balance sheet/income statement of a company at a specific time?

Hi @chavalit.jintamalit

ah okay, thank you for your effort.

I am a bit disappointed that I can't retrieve a full balance sheet/income statement. However, thats not a technical problem :D

Thanks!

@pfarrer.braun to retrieve a standardised full income statement try the following - you can set the SDate parameter to whatever date you want.

df, err =ek.get_data(['VOD.L'],['TR.F.IncomeStatement.fieldname','TR.F.IncomeStatement.fielddescription','TR.F.IncomeStatement'], parameters = {'SDate':'2016-01-01','Period': 'FY0','reportingState':'Rsdt', 'curn':'Native', 'Scale':'6','SORTA':'LISeq'})
df

To get the balance sheet just replace TR.F.IncomeStatement with TR.F.BalanceSheet and to get cashflow statement its TR.F.CashflowStatement. I hope this can help.

@jason.ramchandani do you coincidentally know, how to retrieve when a company went bankrupt as asked above? I think retire Date can also include company fusions or when a compny is taken off an exchange. It is not a big deal but it would ease my work if I could know when and if a compny went bankrupt.