finding the underlying RIC for a convertible bond

Moti.Konak

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

m.bunkowski

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.df