Identifiers while retrieving issuer curve information using Python

Question

I am interested in retrieving issuer curve information using Python.

Currently I have the following working example:

df = ld.discovery.search(

view = search.Views.FIXED_INCOME_QUOTES,

query = "BASF SE",

select = "BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,DTSubjectName,RCSCurveTypeLeaf,RIC,ContributorCommonName,RCSTermMaturityLeaf,RCSCurveForwardPeriodLeaf,RCSFirstCurrencyLeaf,RCSCurveCountryLeaf,CurveRating,RCSCurveIndustryLeaf,RCSCurveRateTypeLeaf,IsCurveorConstituent,CurvePermId,Leg2UnderlyingRIC,RCSCurveType,RCSFirstCurrency"

)

I would feel more comfortable to used identifiers (like PermId = 4295869198 in the case of BASF) instead of strings "BASF SE" for querying or filtering in order to avoid errors. Is there a way to achieve thisest wishes

Jirapongse · Answer

@avinash.sonde

Filters and queries have different purposes. Queries support unstructured, end-user search by matching text across searchable or composite fields. Filters provide structured, programmatic constraints using boolean predicate expressions to include or exclude documents based on their attributes. In short, queries determine relevance, while filters determine eligibility.

To verify the content and filter string, please contact the product support team directly via LSEG Support.

avinash.sonde · Answer

@Jirapongse

Thank you very much!

However if I further tighten the filters like

t = ld.discovery.search(

view = search.Views.FIXED_INCOME_QUOTES,

#select = "_debugall",

filter = f"((IssuerOAPermID eq '4295869198') and (IsCurveorConstituent eq false) and (RCSCurveType ne null or IsCurveorConstituent ne null) and (RCSFirstCurrency xeq 'C:3'))",

top=10000,

select = "IssuerOAPermID,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,DTSubjectName,RCSCurveTypeLeaf,RIC,ContributorCommonName,RCSTermMaturityLeaf,RCSCurveForwardPeriodLeaf,RCSFirstCurrencyLeaf,RCSCurveCountryLeaf,CurveRating,RCSCurveIndustryLeaf,RCSCurveRateTypeLeaf,IsCurveorConstituent,CurvePermId,Leg2UnderlyingRIC,RCSCurveType,RCSFirstCurrency"

)

I get not result

On the other hand, with the same filters but using company name instead of permit:

t = ld.discovery.search(

view = search.Views.FIXED_INCOME_QUOTES,

query = "BASF SE",

filter = f"((IsCurveorConstituent eq false) and (RCSCurveType ne null or IsCurveorConstituent ne null) and (RCSFirstCurrency xeq 'C:3'))",

top=10000,

select = "IssuerOAPermID,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,DTSubjectName,RCSCurveTypeLeaf,RIC,ContributorCommonName,RCSTermMaturityLeaf,RCSCurveForwardPeriodLeaf,RCSFirstCurrencyLeaf,RCSCurveCountryLeaf,CurveRating,RCSCurveIndustryLeaf,RCSCurveRateTypeLeaf,IsCurveorConstituent,CurvePermId,Leg2UnderlyingRIC,RCSCurveType,RCSFirstCurrency"

)

I do get the desired result.

Why is that? I expected that the results are the very same.

Jirapongse · Answer

@avinash.sonde

Thank you for reaching out to us.

It could be like this:

df = ld.discovery.search(
    view = ld.discovery.Views.FIXED_INCOME_QUOTES,
    filter = "IssuerOAPermID eq '4295869198'",
    top = 10000,
    select = "BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,DTSubjectName,RCSCurveTypeLeaf,RIC,ContributorCommonName,RCSTermMaturityLeaf,RCSCurveForwardPeriodLeaf,RCSFirstCurrencyLeaf,RCSCurveCountryLeaf,CurveRating,RCSCurveIndustryLeaf,RCSCurveRateTypeLeaf,IsCurveorConstituent,CurvePermId,Leg2UnderlyingRIC,RCSCurveType,RCSFirstCurrency"
)
df

However, for content related questions, please contact the helpdesk support team directly via LSEG Support to confirm it.

EXPLORE OUR SITES