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

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

screenshot-2024-09-25-at-100445.png


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

screenshot-2024-09-25-at-101836.png


Many thanks your quick response

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

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


Answers