Pull related RICs

Hello,
I am looking to use RDP's get data to pull all related RICs and contributor prices for a list of bonds. The documentation of get_data says you can use legacy TR_fields in the fields section, but when I query these bonds I get None as a result.
bond_list = ['XS2351304246','83368RBS0','683483AA9','30015DAA9','NO0011129579']
response_results = rd.content.get_data(universe=bond_list,fields ['TR.RICS','TR.RICSContributor','Isin'])
print(response_results)
Am I using the wrong fields?
Best Answer
-
You can use the following code to retrieve all available fields in the SearchAll view.
from refinitiv.data.content import search
response = search.metadata.Definition(
view = search.Views.SEARCH_ALL
).get_data()
response.data.dfI found the BidPrice and AskPrice fields but those fields are null for those items.
Another option is using the rd.content.pricing.Definition method to get the latest values of real-time fields.
response = rd.content.pricing.Definition(
df["RIC"].unique(),
fields=["BID_YIELD","ASK_YIELD", "BID", "ASK"]
).get_data()
response.data.dfHowever, from my test, most values are N/A.
These real-time fields are the same fields as displayed in the Quote App. You may need to contact the content support team directly via MyRefinitiv and ask for real-time fields which can be used to retrieve the required data.
0
Answers
-
Hi @david.blanco ,
Is this what you're looking for? In case you'd like to search for available fields, the video How to use the Data Item Browser in Refinitiv's Workspace can be used.
bond_list = ['XS2351304246','83368RBS0','683483AA9','30015DAA9','NO0011129579']
response_results = rd.get_data(universe=bond_list,fields=['TR.RICS','TR.RICSContributor','Isin'])
#print(response_results)
display(response_results)Plus, regarding the field name for getting ISIN data, the field 'Isin' seems not valid. 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 Refinitiv products. Such expertise is available
through Refinitiv Helpdesk, which can be reached via MyRefinitiv.I hope this helps and please let me know if you have any further questions.
0 -
I checked and tested with the rd.get_data method.
bond_list = ['XS2351304246','83368RBS0','683483AA9','30015DAA9','NO0011129579']
response_results = rd.get_data(universe=bond_list,fields=['TR.RICS','TR.RICSContributor','TR.Isin'])
#print(response_results)
display(response_results)The code works with the desktop session but it does not work with the platform.rdp session.
You can try the search endpoint instead.
df = rd.discovery.search(
view=rd.discovery.Views.SEARCH_ALL,
select="CUSIP, RIC, ContributorCommonName, IssueISIN",
filter="IssueISIN in ('NO0011129579') or CUSIP in ('XS2351304246' '83368RBS0' '683483AA9' '30015DAA9')",
top=10000
)
dfThe output is:
0 -
Hi Jiraponse,
Thank you so much for this answer! Works like a charm and is exactly what I needed. I greatly appreciate you taking the time to answer this question.
kind regards,
David
0 -
Jiraponse,
I am also looking to pull the Bid Quote for each contributor. I tried filling in the select lines with the following: Bid, Price, Quote Bid_price, Yield, Best_Bid, BestBid, to no avail. Is it possible to use this search function to also pull the bid and ask for specific RICs?
Thanks,
David
0 -
Hi Jirapose,
That's exactly what I'm looking for! Do you mind me asking what version of rdp do you have? I ask because my module is not recognizing pricing or definition as atributes of content. I have version 1.0.0a20 and I fear I have an outdated version.
0 -
You can try Refinitiv Data Library (refinitiv-data 1.1.0) instead. The examples are available on GitHub.
The latest version of the Refinitiv Data Platform library is 1.0.0a20.
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
- 685 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
- 252 ETA
- 556 WebSocket API
- 38 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
- 652 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
- 917 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 中文论坛