How to obtain list of Outstanding Loans via RDP API

I am currently trying to source a full list of Loans currently outstanding for a given entity - essentially to match what is being displayed on the 'Debt Structure' function on the Eikon terminal. I am currently using the following to source a list of Active Bonds, mirroring what's in Debt Structure/Bonds:

org = 4295912121

fi_fields = ['BondRatingLatest', 'IssuerOAPermid','IssuerOrgid','IssuerID','IssuerCommonName','ParentIssuerName', 'ParentOAPermID','IssueRating','IssueRatingSourceCode','BondRatingLatestSourceCode','AssetTypeDescription','DebtTypeDescription','ISIN','MainSuperRIC','DBSTicker','IsGreenBond','IssueDate', 'Currency', 'RCSCurrencyLeaf','FaceIssuedTotal', 'EOMAmountOutstanding', 'NextCallDate','CouponRate','IsPerpetualSecurity','MaturityDate','CdsSeniorityEquivalentDescription','Price']

query = "ParentOAPermID eq '" + str(org) + "' and IsActive eq true and not(AssetStatus in ('MAT'))"
        df = rdp.search(view = rdp.SearchViews.GovCorpInstruments, 
                     filter = query,
                     top = 10000,
                     select = ','.join(fi_fields),
                     navigators = "Currency")

I was wondering if there was an equivalent way to source similar information on Loans? I understand there is a 'LoanInstruments' view available but wouldn't know what criteria it would use.

Thanks!

Find more posts tagged with

rdp-api

refinitiv-data-platform

Accepted answers

nick.zincone

Hi @Giorgio Cozzolino,

I would recommend you contact the Refinitv Helpdesk and confirm if the data you are looking for is available within the RDP Search service. Below is a request that will search against the 'LoanInstruments' view and may give you a start on whether it provides the details you were expecting.

org = 4295912121
 
fi_fields = ['SPIssuerRating', 'IssuerOAPermID','IssuerOrgid','IssuerCommonName',
             'AssetCategoryName','SPSeniorDebtDescription','Ticker','TranchIssueDate', 
             'RCSCurrencyLeaf', 'BaseRate','LoanSeniorityDescription']

response = rdp.Search.search(
    view = rdp.SearchViews.LoanInstruments, 
    filter = f"IssuerOAPermID eq '{org}' and IsActive eq true and not(AssetStatus in ('MAT'))",
    top = 20,
    select = ','.join(fi_fields)
)

All comments

nick.zincone

Hi @Giorgio Cozzolino,

org = 4295912121
 
fi_fields = ['SPIssuerRating', 'IssuerOAPermID','IssuerOrgid','IssuerCommonName',
             'AssetCategoryName','SPSeniorDebtDescription','Ticker','TranchIssueDate', 
             'RCSCurrencyLeaf', 'BaseRate','LoanSeniorityDescription']

response = rdp.Search.search(
    view = rdp.SearchViews.LoanInstruments, 
    filter = f"IssuerOAPermID eq '{org}' and IsActive eq true and not(AssetStatus in ('MAT'))",
    top = 20,
    select = ','.join(fi_fields)
)

Giorgio Cozzolino

Hi @nick.zincone,

thanks for the above. I have filed a request to the HelpDesk to understand whether this is available at all. In any case I have tried to run the code above in the meantime and it seems like I am getting no hits for the orgID mentioned (while in truth I should at least get one, according to 'Debt Structure').

Would you mind checking on your end? Thanks!

nick.zincone

Hi @Giorgio Cozzolino,

I suspect your permission settings may be affecting what you can search for. I would reach out to your account manager and inquire about this. This is what I get:

EXPLORE OUR SITES