question

Upvotes
Accepted
Moti.Konak avatar image
3 ●0 ●0 ●4

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


1703027049321.png

#product#contentbondsreference-data
1703027049321.png (61.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Jirapongse avatar image   Jirapongse

@Moti.Konak

Hi,

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

wasin.w avatar image   wasin.w

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,


AHS


2 Answers

· Write an Answer
Upvotes
Accepted
m.bunkowski avatar image
1.4k ●5 ●3 ●6

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
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Moti.Konak avatar image Moti.Konak

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']

raksina.samasiri avatar image raksina.samasiri Moti.Konak
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.

raksina.samasiri avatar image   raksina.samasiri Moti.Konak

<private comment>

Hi @Moti.Konak ,

As you're internal user, please contact Refinitiv Data Platform support team

Upvotes
Jirapongse avatar image
79.2k ●251 ●52 ●74

@Moti.Konak

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"])

1703065891869.png



1703065891869.png (5.6 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Moti.Konak avatar image Moti.Konak

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

convrt.txt (902 B)
Jirapongse avatar image Jirapongse Moti.Konak

I got the same error when using the RDP session.

1703137037869.png

You may need to contact the Refinitiv Data Platform support team to check for the pemission.


1703137037869.png (32.6 KiB)

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.