Retrieving Bond Rating Data Based on Tickers

I'm trying to retrieve the most recent bond ratings from Moody's, S&P, and Fitch from a list of tickers.

I convert the list of tickers to both ISIN and RICs with this code that seems to work:

image.png

I tried throwing the whole list of codes as either RICa rics = codes['RIC'].tolist() or ISIN as isin = codes['IssueISIN'].tolist() but got an exception that it was "Unable to resolve all requested identifiers". So I tried looping through each code individually but I'm still getting the same exception.

Using the ISIN, the code looks like this:

image.png image.png

Any ideas? Same results with RICs. Is the conversion off? Am I requesting the ratings incorrectly? At a loss here. Thanks.

Answers

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    @leckieje

    Thank you for reaching out to us.

    I tested some tickers and found that symbol_conversion can convert those tickers to the following RICs and ISINs.

    image.png

    However, the API can't retrieve the TR.GR.Rating values of those RICs and ISINs.

    image.png

    This could be a content issue. You need to contact the helpdesk team to verify those RICs or ISINs and the TR.GR.Rating fields.

    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 the 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.