Parent Issuer Bond Rating

we need to monitor credit rating for any new trades timely with Excel/Python API. We would also like to check how to get the credit rating of its immediate parent for a bond position by Excel API. Can you please advice?
For example, the issuer of the bond (ISIN: XS3081762828) is ICBC (London Branch) and its immediate parent is ICBC. How can we get the credit rating of ICBC based on the ISIN (XS3081762828)?

Find more posts tagged with

python

excel

bonds

#content

Accepted answers

All comments

Jirapongse

@Edwin Kwan

Thank you for reaching out to us.

This forum is dedicated to software developers using LSEG APIs. The moderators on this forum do not have deep expertise in every bit of content available through LSEG products, which is required to answer content questions such as this one.

The best resource for content questions is the Helpdesk support team, which can be reached by submitting queries through LSEG Support. The support team will either have the required content expertise ready available or can reach out to relevant content experts to get the answer for you.

You need to ask for the Excel formula, such as =RDP.Data, that can be used to retrieve the required data. Then, we can help you converting that formula to Python code.

Edwin Kwan

Hi Team,

We have sort up some data items to use in Excel, please find attached file for your suggestion.

Thank you.

Issuer Rating for ultimate parent company.xlsx

Jirapongse

Thank you for the file. I use the LSEG Data Library for Python and the examples are on GitHub.

The code could be like this:

df = ld.get_data(
    universe = ['XS3081762828'],
    fields = ['TR.FiIssuerName','TR.UltimateParentID','TR.UltimateParent','TR.ImmediateParentID','TR.ImmediateParent'])
display(df)
ultimate_id = df['Ultimate Parent Id'][0]
immediate_id = df['Immediate Parent Id'][0]

ultimate_df = ld.get_data(
    universe = [ultimate_id],
    fields = ['TR.IssuerRating','TR.IssuerRating.RatingSourceDescription'],
    parameters = {'IssuerRatingSrc':'FDL:MIS:SPI'})
display(ultimate_df)

immediate_df = ld.get_data(
    universe = [immediate_id],
    fields = ['TR.IssuerRating','TR.IssuerRating.RatingSourceDescription'],
    parameters = {'IssuerRatingSrc':'FDL:MIS:SPI'})
display(immediate_df)

However, I got the following error when running the Excel file.

It is better to inform the client to run the Excel file to make sure that the client has permission to access the data.

EXPLORE OUR SITES