New posts are disabled while we improve the user experience.
You can browse the site, or for urgent issues, raise a query at MyAccount.
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.
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
