Eurozone bonds issued from 2016

josemaria.martin

Hi! I have two questions.

The sales rep showed us a Python environment embedded in workspace that looked very user friendly to download data. Can you help me to find this embedded Python environment within workspace.

I also need to download all bond issues in the eurozone from 2016 to 2023 (I send you a screenshot of how this information looks like on Workspace). Could you please help me with the code?

Thanks in advance.

aramyan.h

Hi @josemaria.martin,

The Python dev environment in Workspace you are referring to should be the Codebook.

As for getting the bonds data, you can leverage Search capabilities of LSEG Data Libraries for Python.

The easiest way to get started with search queries is to use the Advanced Search app in Workspace, build your search filters and extract the query as shown below:

The example query above will look like the following:

rd.discovery.search(
view = rd.discovery.Views.GOV_CORP_INSTRUMENTS,
top = 10000,
filter = "(DbType eq 'GOVT' and IsActive eq true and (RCSCountryGenealogy eq 'M:DQ\G:AL' and (IssueDate ge 2016-01-01 and IssueDate le 2023-12-31)))",
select = "RIC,EJVAssetID,DTSubjectName,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,DBSTicker,CouponRate,MaturityDate,IssueDate,ISIN,RCSCurrencyLeaf,RCSCountryLeaf,DbTypeDescription,InstrumentTypeDescription,RCSCouponTypeGenealogy,FaceIssuedUSD,RCSBondGradeLeaf,RCSCountryGenealogy"
)

You can also find this article about search useful - https://developers.lseg.com/en/article-catalog/article/building-search-into-your-application-workflow

Hope this helps.

Best regards,

Haykaz