question

Upvotes
25 0 1 5

Extracting loan tearsheet data via Python LSEG get_data API results in "Unable to resolve all requested 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

python#technologypython apilseg-data-library
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.