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