Workspace API python:Retrieve EUR-denominated French government bonds

Options
kunitaka
kunitaka LSEG
edited July 22 in Refinitiv Data Platform Libraries

Our client is currently working on the government bond curve for the European region. However, using the method below, He is unable to retrieve EUR-denominated French government bonds (while major countries such as Germany and Belgium are returned correctly).

If you happen to know a way to obtain them, I would greatly appreciate it if you could kindly share your insights.

———-

rd.open_session()

 

gov_bond_list = rd.discovery.search(

    view = rd.discovery.Views.GOV_CORP_INSTRUMENTS,

    filter = f"RCSCurrencyLeaf eq 'Euro' and RCSTRBC2012Leaf eq 'Government & Government Finance' and AssetState eq 'AC'",

    select = "DTSubjectName, RIC, ISIN, RCSAssetCategoryLeaf, AssetState, RCSCurrencyLeaf, DocumentTitle, MaturityDate, Identifier",

    top=10000,

)

———-Is it OK to add IssuerCountryName eq 'France' to this filter instead of

RCSTRBC2012Leaf eq 'Government & Government Finance'

?

※For example, when he query the following ISIN in Workspace, it appears to fall under the category specified in the Python code above:

ISIN
FR0000187635

Tagged:

Answers

  • kunitaka
    kunitaka LSEG

    rd.discovery.search(
    view = rd.discovery.Views.GOV_CORP_INSTRUMENTS,
    top = 10,
    filter = "(DbType eq 'GOVT' and IsActive eq true and (RCSDomicileGenealogy in ('G:5M')))",
    select = "RIC,EJVAssetID,DTSubjectName,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,DBSTicker,CouponRate,MaturityDate,IssueDate,ISIN,RCSCurrencyLeaf,RCSCountryLeaf,DbTypeDescription,InstrumentTypeDescription,RCSCouponTypeGenealogy,FaceIssuedUSD,RCSBondGradeLeaf,RCSDomicileGenealogy"
    )

  • kunitaka
    kunitaka LSEG

    Solved. Thanks.

  • raksina.samasiri
    raksina.samasiri admin

    Hi @kunitaka ,

    Thank you for posting the question in this forum. However, this forum is dedicated to an API usage question hence, the moderators on this forum do not have deep expertise in every type of content available through our products, such as which filters should be used to get specific set of data). Such expertise is available through the Helpdesk, which can be reached via MyAccount.

    Once you have filters used in the Advanced Search application in Workspace, you can follow article https://developers.lseg.com/en/article-catalog/article/Find-content-and-functionality-using-Refinitiv-Data-Library-with-Eikon-Advanced-Search for exporting the query as a Python code with the Data Library.

Categories