RDP Inactive corporate Bonds

grigorios.mamalis

Hi,

Happy New Year!

I am trying to capture, using RDP query in Python, the inactive bonds for a given ParentOAPermID. Can you please confirm that the following (upper) snippet does what I am looking for.

A couple of more questions:

a. I see that there are quite few bonds without ISIN. Why is that?

b. I see that my query reached the 10000 limit, so I guess I will have to introduce additional filters to get all the bonds, right?

c. is it correct to say that bonds which are not any more active, do not have a RIC? If so, would a better approach be the 2nd one shown below, which is based on the RIC?

Many thanks

Kind regards

Grigorios

sBankID = '5043337560'
GroupSize = 10000
filterStrINACTIVE = "  ParentOAPermID  eq '{0}'   " \
                " and ( ( AssetStatus eq 'CLD') or ( AssetStatus eq 'MAT') )  ".format(sBankID)

srchfields = "RIC,ISIN, FullName, AssetStatus, ParentOAPermID, IssuerName, IssuerLegalName,IssuerOAPermID, Currency,IssueDate, MaturityDate, CouponRate"

dataINACT = rdp.search(view=rdp.SearchViews.GovCorpInstruments, filter=filterStrINACTIVE, top=GroupSize, select=srchfields)
dataINACTvalidISIN = dataINACT[ dataINACT["ISIN"].isnull()==False]
dataINACT.shape
# --> (10000, 10)
dataINACTvalidISIN.shape
# --> (9683, 10)

Approach based on RIC:

filterStrINACTIVEviaRIC = "  ParentOAPermID  eq '{0}'   " \
                " and RIC eq null  ".format(sBankID)

srchfields = "RIC,ISIN, FullName, AssetStatus, ParentOAPermID, IssuerName, IssuerLegalName,IssuerOAPermID, Currency,IssueDate, MaturityDate, CouponRate"

dataINACTviaRIC = rdp.search(view=rdp.SearchViews.GovCorpInstruments, filter=filterStrINACTIVEviaRIC, top=GroupSize, select=srchfields)

nick.zincone

Hi @grigorios.mamalis

The first thing I would suggest you do is to confirm exactly what you consider as "Inactive". For example, based on the bond you specified and looking at the status of the asset, I see this distribution:

From here, you can see some potential candidates that you may consider as 'inactive'. There is a specific status indicator 'Not Active' you can use with a total of 17 hits. However, if you also want to lump in those bonds that have matured (or any others), you can clearly see the total hits you would have to consider, i.e Matured has over 120,000. If you only want to look at the 'Not Active', you can clearly retrieve this. However, if you want to include others, such as those that have matured, you will need to figure out if you want to filter out some of them. Or, if you need to retrieve every 'matured' bond as well, then you would have to apply some techniques I outlined within Search - limits.

As for missing 'ISIN's, there may be a category of matured bonds or some condition that may explain why certain matured bonds don't have an ISIN - I would suggest you raise content questions within the Refinitiv Helpdesk.

As for the alternative approach to retrieve the bonds based on a RIC filter, this may be applicable if you understand why some bonds don't have RICs and if the reasons make sense for your use case - again, a content specialist would be your best source for this.