Workspace API python:Retrieve EUR-denominated French government bonds

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

Find more posts tagged with

bonds

workspace-data-api

#content

python api

Accepted answers

All comments

kunitaka

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

Solved. Thanks.

raksina.samasiri

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.

EXPLORE OUR SITES