Hi @adam.leroux ,
I believe this is a prime question for the Search API. Would you mind letting me know if it fits your need?
Get "related instruments" using the refintiv.data API

Hi all,
I'm looking into using the refintiv.data python API to calculate benchmarks for bonds.
Right now the process is very manual and not scalable, I'm searching the bond in the workspace and looking at the "Related Instruments" tab, then creating my query and looking at the results. (see screenshot)
I would like to use the python API to access these results, so i can automate this process for thousands of bonds, but i cannot find the api endpoint online, or any information on if this is possible.
Ideally there would be a query i can construct where i can give a RIC, and the filters and receive the table as displayed in the screenshot.
Is this something that's possible ?
Thanks for your help.
Adam
Best Answer
-
Hi @adam.leroux ,
I believe this is a prime question for the Search API. Would you mind letting me know if it fits your need?
0
Answers
-
Hi,
Thanks for your answer,
I've used the Searchbrowser object before, but there is not mention of a "related instruments" property when search up bonds with this.
I do find a "BenchmarkID" and "PricingBenchmarkID"n with values = 0x000386007dacd084 but not sure what do with that, if I try to search that Id i got no results.
0 -
Hi @adam.leroux, What is the `Searchbrowser`? I was referring to the Search API in the LSEG Data Library for Python. As an example, you could use something like this:
# pip install lseg.data
import lseg.data as ld
ld.open_session() # Need the Workspace Desktop App open on the same machine where this code runs
df0 = ld.discovery.search(
view = ld.discovery.Views.FIXED_INCOME_INSTRUMENTS,
query = 'CPI PROPERTY GROUP SA')
I would suggest using `SearchPropertyExplorer` to find the properties with which to filter:props = ld.discovery.SearchPropertyExplorer.get_properties_for(
view = ld.discovery.Views.FIXED_INCOME_INSTRUMENTS,
query="CPI PROPERTY GROUP SA")0 -
You can find the properties you are after with the `get_by_name` function:
props.get_by_name("country").df # try all your filters, e.g.: `country`, `coupon`, `curr`, `Issuer`, `grade`...
You can put it all together in something like:
df1 = ld.discovery.search(
view = ld.discovery.Views.SEARCH_ALL, # ld.discovery.Views.FIXED_INCOME_INSTRUMENTS
query = 'CPI PROPERTY GROUP SA',
filter="CurrentCouponClassDescription eq 'Fixed Coupon'", # RCSParentDomicileLeaf eq 'Luxembourg' and RCSBondGradeLeaf eq 'High Yield'
select="IssuerCommonName, BusinessEntity, DocumentTitle, PermID, PI, RIC, RCSParentDomicileLeaf, CurrentCouponClassDescription, RCSBondGradeLeaf",
top=100)
df1You will need to look through the properties and find the ones you are most happy with, using the Search API article.
0 -
Here is a screenshot of some of the 1st code cell results:
0 -
Here is a screenshot of some of the 2nd set of code cell results:
0 -
Here is a screenshot of some of the 3rd set of code cell results:
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 684 Datastream
- 1.4K DSS
- 615 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 251 ETA
- 555 WebSocket API
- 37 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 643 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 193 TREP Infrastructure
- 228 TRKD
- 916 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛