Extracting loan tearsheet data via Python LSEG get_data API results in "Unable to resolve all req...

r.fernandez

...uested identifiers "

When downloading a loan by the PermID I get the error "Unable to resolve all requested identifiers". What can I do?

Using Python LSEG I have a two step API approach setup.

Initiation:

import lseg.data as ld
from lseg.data.content import search
from lseg.data.content._header_type import HeaderType

# opens session with refinitiv-data.config.json
ld.open_session()

Step 1, via search I extract all instruments in the loan space

response = search.Definition(
        view = search.Views.LOAN_INSTRUMENTS,
        filter = "IssuerCountryName eq 'Netherlands'",
        top=10000
).get_data()

From this I receive loan information:

                  BusinessEntity                            DocumentTitle PermID                  
0    INSTRUMENTxFIXEDINCOMExLOAN  EUROMAX TERMINAL CV, ...  45133381694  45133381694
1    INSTRUMENTxFIXEDINCOMExLOAN  INFRASPEED BV, Loan, ...  45133381428  45133381428
2    INSTRUMENTxFIXEDINCOMExLOAN  INFRASPEED BV, Loan, ...  45133381427  45133381427
3    INSTRUMENTxFIXEDINCOMExLOAN  DELFLUENT BV, Loan,  ...  45133402520  45133402520

Step 2, using the PermID's I would like to retrieve detailed loan tearsheet data.

fields = [
    "TR.LNDealFacilityId",
    "TR.LNDealId",
    "TR.LNIssuer",
    "TR.LNIssuerPermId",
    "TR.LNIssuerShortBusDesc",
    "TR.LNIssuerNation",
    "TR.LNAnnouncementDate",
    "TR.LNFinancialCloseDate",
    "TR.LNTotalFacilityAmount",
    "TR.LNUseOfProceeds(Concat='|')",
    "TR.LNTrancheType",
    "TR.LNYieldType",
    "TR.LNMaturityDate",
    "TR.LNBookRunner(Concat='|')",
    "TR.LNPrincipalAmountPerBookRunnerThisMarket",
    "TR.LNMandatedArranger(Concat='|')",
    "TR.LNIntCoManager(Concat='|')",
    "TR.LNNumberOfTranchesInFacility",
    "TR.LNSdcLoanFacilityNum",
    "TR.LNIssuerParentNationOfInc"
]

data = ld.get_data(
    universe=["45133381694"],
    fields=fields,
    header_type=HeaderType.NAME
)

However, this shows the following error:

lseg.data._errors.LDError: Unable to resolve all requested identifiers in ['45133381694'].

Can you help out?

Addendum:

a. The tearsheet that I am after is the one that you can navigate through in the Refinitiv Workspace App, an example of a revolving loan data I am after can be found via the link: https://emea1-apps.platform.refinitiv.com/web/Apps/DealTearsheet?dealno=5402526116#/Details

This shows the following information:

b. The field selection (TR.LN...) is made via the deals screener, for example:

Many thanks your quick response

Jirapongse

@r.fernandez

Thank you for reaching out to us.

I tested this permID (45133381694) on Workspace Excel. The formula builder on Workspace Excel is also unable to resolve this PermID. Therefore, this could be a content issue.

Please contact the helpdesk team directly via MyAccount to verify this PermID.

r.fernandez

@Jirapongse

The permID I wrote was an EXAMPLE. This is the case for all permID's I receive. EVERY loan that I query via this method returns this error.

I'm thus looking for a generic method to search for loan data if the load ID's are present, via Python.

An example of the answer that I am looking for:

- In case of querying bonds we must request ISIN codes (see answer https://community.developers.refinitiv.com/questions/121297/which-python-api-can-be-used-to-retrieve-all-under.html).

- In case of querying Deals you must query <<permID>>@dealid (see answer https://community.developers.refinitiv.com/questions/48409/can-users-retrieve-deals-data-from-eikon-api.html)

What equivalent is there for the loan's? How can I retrieve loan data?