Build a Corporate Bond Universe for UK

Ruiqing

Hi, I'm trying to build a UK corporate bond universe via the following two methods. The first is that I use the LSEG workspace. I click on the 'Search Tools' and then choose 'Bonds'. I filter as follows and get the results, as shown in the screenshot. I get around 2,000 bonds.

The second is that I use the search.Definition() function in lseg.data API, shown in the next screenshot. After applying the two main filters I need (i.e., issuer country = UK and bond type = corp), I get more than 1,800,000 observations, which doesn't seem about right.

Could tell me the difference between the two methods, and where I might did wrong? Most importantly, if I want to build a comprehensive UK corporate bond universe, what is the appropriate way to that? Thanks!

raksina.samasiri

Hi @Ruiqing ,

You can export the filters applied in Advanced Search application by following along this article https://developers.lseg.com/en/article-catalog/article/Find-content-and-functionality-using-Refinitiv-Data-Library-with-Eikon-Advanced-Search

I tried and got the result properly as below.

ld.discovery.search(

	view = ld.discovery.Views.GOV_CORP_INSTRUMENTS,

	top = 10000,

	filter = "(DbType eq 'CORP' and RCSAssetCategory eq 'A:J' and (RCSCountryGenealogy in ('G:7J')))",

	select = "RIC,EJVAssetID,DTSubjectName,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,DBSTicker,CouponRate,MaturityDate,IssueDate,ISIN,RCSCurrencyLeaf,RCSCountryLeaf,DbTypeDescription,InstrumentTypeDescription,RCSCouponTypeGenealogy,FaceIssuedUSD,RCSBondGradeLeaf,RCSCountryGenealogy"

)