finding the underlying RIC for a convertible bond
Hello,
I am trying to find the underlying RIC(Equity) for a convertible bond. The underlying RIC is available in GovCorp but "Views.GOV_CORP_INSTRUMENTS" does not output the expected RIC using "UnderlyingAssetRIC" which exists in the metadata of the view. Other Convertibles' CUSIPs with the same outcome : 78015V548, 06748F803 and 90278V198. I might be mistaken but cannot think of any other other scenarios where bonds have an underlying RIC so in case and the equity RIC is not expected to show in the above cases, can you please share any CUSIPs where the "UnderlyingAssetRIC" is populated. Also, I appreciate if there is any other suggested way to extract the underlying equity RIC for a convertible.
Many Thanks
Moti
Best Answer
-
Hi @Moti.Konak
In the search you can request an additional field 'ConversionSymbol' that gives you a 2 digit country code and the ticker which in fact is something called 'DsQuotationMnemonic'. Combining those two (right after converting 2 digit country code into 3 digit) you would need to do a second search and all of that might be a cumbersome task. Instead of that you can do the below:
import refinitiv.data as rd
rd.open_session()
from refinitiv.data.content import fundamental_and_reference
response = fundamental_and_reference.Definition(
["48128Q579","78015V548","06748F803","90278V198","22550MNC9=FINR"],
["TR.CD.UnderlAssetRIC"]).get_data()
response.data.df0
Answers
-
Thank you for reaching out to us.
I can use the get_data method to retrieve the underlying asset RICs.
rd.get_data(["06748F803","78015V548","48128Q579"],["TR.CD.UnderlAssetRIC"])
0 -
Thanks Jirapongse!
I am getting the following error:
Exception thrown: Error code -1 | The access to field(s) denied. Requested universes: ['06748F803', '78015V548', '48128Q579']. Requested fields: ['TR.CD.UNDERLASSETRIC']
see attached my code.convrt.txt
0 -
Thanks m! I am getting the following error:
RDError: Error code 221 | The access to field(s) denied. Requested universes: ['48128Q579', '78015V548', '06748F803', '90278V198', '22550MNC9=FINR']. Requested fields: ['TR.CD.UnderlAssetRIC']
0 -
I got the same error when using the RDP session.
You may need to contact the Refinitiv Data Platform support team to check for the pemission.
0 -
Hi @Moti.Konak ,
This error indicates that you don't have an access to this data, please contact your Refinitiv account representative to check this.
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛