Error handling retrieving SERIES (Python)

the.swiss01

I probably miss something very simple, but ...

I am retrieving historic financial data by calling .get_data("list_of_rics" , "list_of_Data_Item_Codes")

woks fine UNLESS there is an error in one (or more) of the Data_Item_Codes (a definition in this case)

In that case, no data is returned ... not just for the item with the false definition, but for ALL Codes and ALL RICS

Very short Example:

dfLocal, err = ek.get_data("VIE.PA" , "TR.FwdPE(SDate=0, EDate=-10, Period=NTM, Frq=FY), TR.TOTALDEBTTOEV(SDATE=0, EDATE=-10, FRQ=FY)", parameters=None, field_name=True)

works fine:

dfLocal

Instrument TR.FWDPE(SDATE=0, EDATE=-10, PERIOD=NTM, FRQ=FY) TR.TOTALDEBTTOEV(SDATE=0, EDATE=-10, FRQ=FY)
0 VIE.PA 20.39913 54.602213
1 VIE.PA 15.952721 82.312945
2 VIE.PA 17.118452 62.831281
3 VIE.PA 13.942937 64.641305
4 VIE.PA 17.498481 64.443232
5 VIE.PA 14.068652 66.671251
6 VIE.PA 21.074012 49.891322
7 VIE.PA 19.921223 67.977642
8 VIE.PA 22.737711 85.523073
9 VIE.PA 13.750912 89.49455
10 VIE.PA 10.386236 96.766925

but adding the non recognised Period=FY to TOTALDEBTTOEV not only returns an error for TOTALDEBTTOEV but gives no values for the still correctly defined FwdPE

ek.get_data("VIE.PA" , "TR.FwdPE(SDate=0, EDate=-10, Period=NTM, Frq=FY), TR.TOTALDEBTTOEV(SDATE=0, EDATE=-10, Period=FY, FRQ=FY)", parameters=None, field_name=True)

dfLocal

0 TR.FWDPE(SDATE=0, EDATE=-10, PERIOD=NTM, FRQ=FY), TR.TOTALDEBTTOEV(SDATE=0,Period=NTM, EDATE=-10, FRQ=FY)
0 VIE.PA <NA>

err

[{'code': 207, 'col': 1, 'message': "The 'Period' is unrecognized.", 'row': 0}]

Now, no doubt the codes should be correctly defined (in my DB), but ... how do I get stuff back for the codes that are and catch the errors?

cheers

Alfred

raksina.samasiri

Hi @the.swiss @the.swiss01 ,

Thank you for your patience, it can be handled by the Python code. For example,

def get_data_check_err(instrument, field):
    df, err = ek.get_data(instrument, field)
    if err is None:
        display(df)
    else:
        raise Exception(err)
    return df

this will return the dataframe as there's no error

df1 = get_data_check_err("VIE.PA", "TR.FwdPE(SDate=0, EDate=-10, Period=NTM, Frq=FY), TR.TOTALDEBTTOEV(SDATE=0, EDATE=-10, FRQ=FY)")

this will return an exception as there's an error returned

df2 = get_data_check_err("VIE.PA" , "TR.FwdPE(SDate=0, EDate=-10, Period=NTM, Frq=FY), TR.TOTALDEBTTOEV(SDATE=0, EDATE=-10, Period=FY, FRQ=FY)")

Below is the output of these codes

Hope this helps and please let me know in case you have any further questions