How to obtain list of Outstanding Loans via RDP API

Giorgio Cozzolino
Giorgio Cozzolino Newcomer
in Refinitiv Data Platform

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!

Tagged:

Best Answer

  • nick.zincone
    nick.zincone admin
    Answer ✓

    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)
    )

Answers

Categories