list of bankrupt companies & balance sheet/ income statements of a specific year

Options
Statistik Dude
Statistik Dude Explorer
in Eikon Data APIs

Hello,

I must compare KPIs of companies which went bankrupt against companies which didn’t go bankrupt. The companies have to be listed on a stock exchange.

I am able to retrieve a list of companies, which are listed on exchanges of a specific country as follows:

exp = 'SCREEN(U(IN(Equity(active,public,primary))), IN(TR.ExchangeCountryCode, COUNTRY CODE))'

df, e = ek.get_data(exp, ['TR.RIC', 'TR.PrimaryQuote', 'TR.InstrumentType', 'TR.ExchangeTicker',

'TR.ShortExchangeName', 'TR.ExchangeName', 'TR.CommonName',

'TR.HeadquartersCountry', 'TR.TRBCIndustryGroup', 'TR.GICSSector',

'TR.LegalAddressCity','TR.LegalAddressLine1','TR.Employees', 'CF_CURR' ])

I get the industry, the primary RIC, Headquarters Country etc. without a problem.

However, how can I manipulate the formula, to also get the name and RIC of companies which went bankrupt and also the date when they went bankrupt? The formula above only shows me active companies.

Furthermore, I wonder how to retrieve the balance sheets and income statements of specific RICs in a specific year? Is it possible to see, which standard (US-GAAP, IFRS etc.) was used to create the balance sheet/income statement or is it even possible to specify the standard when retrieving the balance sheet?


I want to thank you guys in advance for your help in this awesome forum! It is enjoyable to work with the eikon API!

Tagged:

Best Answer

  • chavalit-jintamalit
    chavalit-jintamalit admin
    Answer ✓

    Hi @Statistik Dude

    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.

    image

    So in this case the data field is TR.Revenue

    You can do the same process on another sheet.

    image

    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

Answers

  • chavalit-jintamalit
    chavalit-jintamalit admin

    Hi @Statistik Dude

    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.

    image


    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:

    image

  • Statistik Dude
    Statistik Dude Explorer

    Hi @chavalit-jintamalitchavalit.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?

  • Statistik Dude
    Statistik Dude Explorer

    Hi @chavalit-jintamalitchavalit.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!

  • jason.ramchandani01
    jason.ramchandani01 admin

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

  • Statistik Dude
    Statistik Dude Explorer
    https://community.developers.refinitiv.com/discussion/comment/69444#Comment_69444

    Thanks a lot man!!!!


  • Statistik Dude
    Statistik Dude Explorer

    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.

Categories