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!