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

Options
catolica_user27
catolica_user27 Newcomer
in Eikon Data APIs

imageI 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:

image

Tagged:

Best Answer

  • chavalit-jintamalit
    chavalit-jintamalit admin
    Answer ✓

    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.

    image


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

    image


    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

Categories