Balance sheet item download with API, incorrect values, maybe currency problem?

Giulio.nicoletti

I download balance sheet data for listed companies ('Fundamentals') using this screening. Somehow however, the values of balance sheet data are not the same as in other databases and do not 'look correct' (slightly different from what they should be). Can it be the currency is not set correctly (not the filtering one, but the reporting one?), thanks a lot, best, G

syntax = 'SCREEN(U(IN(Equity(active,public,primary))), IN(TR.RegCountryCode, DE, ES, FR, IT, NL, AT, BE, PT, FI, IE, LU, GR, SI, SK, LV, LT, EE, MT, CY), DOES_NOT_CONTAIN(TR.TRBCEconomicSector,Financials), CURN=EUR)'

Attach rest of the code below:

names, e = ek.get_data(syntax, ['TR.CommonName', 'TR.RegCountryCode'])

del syntax, e

# Find ISIN codes and add them to the dataset

isin = ek.get_symbology(names.Instrument.to_list(), from_symbol_type='RIC', to_symbol_type='ISIN')

names['ISIN'] = isin['ISIN'].to_list()

del isin

quarters = []

for i in range (2001,2022):

for j in range (1,5):

quarters.append(str(j) + 'CQ' + str(i))

del i, j

quarters.remove('4CQ2021')

quarters.remove('3CQ2021')

quarters.remove('2CQ2021')

fields = ['TR.NetDebt'] # there were many, I reduced to one, maybe is without []

b_sheet = pd.DataFrame()

for q in quarters:

data, e = ek.get_data(names.Instrument.to_list(), fields, parameters={'Period': q})

data['Date'] = q

b_sheet = b_sheet.append(data, ignore_index=True)

del fields, e, q, quarters

Alex Putkov.1

@Giulio.nicoletti

To provide any comments on the discrepancies you see, I would need a specific example of the discrepancies. Right now all I can say is that in your code you request quarterly net debt for calendar quarters (which may be different from fiscal quarters) in the reporting currency (i.e. in whatever currency the company provides financial reports). Does this description correspond to what you're getting from other sources?