how to use eikon api to get bond info via bond Shenzhen code?

xuke

Shenzhen Code: 133275;

Bond info: Bond name, ISIN, Current Coupon, Coupon Type, Maturity Date and etc.

Find more posts tagged with

python api

#technology

Accepted answers

Jirapongse

@xuke

Thank you for reaching out to us.

For this code, you can also use Refinitiv Data Library to search for RIC of this code.

df = rd.discovery.search(
    view = rd.discovery.Views.FIXED_INCOME_INSTRUMENTS,
    top = 10,
    filter = "LocalCodesLocalScheme  eq 'SHZ:133275'",
    select = "BusinessEntity,DocumentTitle, RIC, ISIN, MaturityDate,CouponType"
)
df

You can use the following code to get the list of fields in the FIXED_INCOME_INSTRUMENTS view.

from refinitiv.data.content import search
response = search.metadata.Definition(
    view = search.Views.FIXED_INCOME_INSTRUMENTS  
).get_data()


response.data.df

All comments

Jirapongse

@xuke

Thank you for reaching out to us.

For this code, you can also use Refinitiv Data Library to search for RIC of this code.

df = rd.discovery.search(
    view = rd.discovery.Views.FIXED_INCOME_INSTRUMENTS,
    top = 10,
    filter = "LocalCodesLocalScheme  eq 'SHZ:133275'",
    select = "BusinessEntity,DocumentTitle, RIC, ISIN, MaturityDate,CouponType"
)
df

You can use the following code to get the list of fields in the FIXED_INCOME_INSTRUMENTS view.

from refinitiv.data.content import search
response = search.metadata.Definition(
    view = search.Views.FIXED_INCOME_INSTRUMENTS  
).get_data()


response.data.df

xuke

@Jirapongse Thanks for your reply.

I found that the filter "filter = "LocalCodesLocalScheme eq 'SHZ:133275'"" is different from "filter = "(LocalCode eq '175143')"". Is there a common filter to search for and is suitable for all different regions in the world?

Jirapongse

@xuke

My colleague @marcin.bunkowski found out that we can use these codes directly with the get_data method to get bond information. For example:

rd.get_data(['133275','175143'],['TR.FIIssuerName','TR.FIMaturityDate','TR.FICouponType','TR.FICouponTypeDescription'])

The output is:

You can use the Data Item Browser tool to search for availble fields.

xuke

@Jirapongse we tried the bond code="123205", and we cannot use rd.get_data method to get the RIC code. it returns empty. Please help to find the reason, thank you.

Jirapongse

@xuke

I tired several fields that can provide RICs.

rd.get_data(['133275','175143','123205','006038','301048'],
            ['TR.FIIssuerName','TR.FIMaturityDate','TR.FICouponType','TR.FICouponTypeDescription',
             'TR.PreferredRIC','TR.RIC','TR.LipperRICCode','TR.PrimaryIssueRICCode','TR.FundHoldingRIC'])

The output is:

You can contact the Eikon Excel support team directly via MyRefinitiv and ask for fields that can provide the required data. Typically, the fields used with the TR function in Eikon Excel can also be used with the get_data method.

xuke

@Jirapongse sorry to bother you again. Since we don't have the license to retrieve the real time data, we cannot use the TR function.

And I find that the result of the fond asset "006038" is not the asset we want. TR.FundName should be 'Dacheng JingHeng Mixed Fund C'.

Does this mean we cannot use '006038' code to retrieve data?

EXPLORE OUR SITES