DIB does not work to extract a Bond's Coupon Rate

catolica_user27

I am trying to extract the coupon rate of the bond presented on the picture above. From the DIB, i can see that it has a coupon rate but when I run the following code:

d_cr_ISIN, e = ek.get_data(ISIN, ['COUPN_RATE(SDate=0).date','COUPN_RATE(SDate=0)'])

I get the following output:

chavalit-jintamalit

Hi @catolica_user27

The first issue is that different field supports different parameters.

You have to click on the parameter tab and check what parameter is supported.

The second issue is that field from realtime database does not support ISIN instrument.

You can try to map ISIN to RIC first:

ISIN = ['XS0213101073','US912828YC87']
df,e = ek.get_data(ISIN, 'TR.RIC')

rics = df['RIC'].tolist()

d_cr_ISIN, e = ek.get_data(rics, ['COUPN_RATE','COUPN_DATE'])
d_cr_ISIN