How to retrieve the RICs using the bond ISINs?

Janice

Hello Team,

I hope all is well.

I'm seeking for your help, (for example) Apple, Microsoft and Tesla have bonds going 10 years and each of these bonds have a specific ISIN, unfortunately the ISIN doesn’t map directly to the company’s RIC but to the bond’s RIC. My goal is to sort of input an ISIN of a bond and return a company’s RIC.

So let’s say I input an ISIN of an Apple bond “USThisIsAnExample2025” => it returns “AAPL.OQ” or “AAPL.O”

Also could you provide the Python code instead of the Excel formula? Thank you a lot in advance!

 

Janice

The only data item we have for ISINs or Bond RICs for that matter is TR.FiIssuerOrganization, which produces numerical value, but we're having problems in constructing codes. As per specialist team, we need to get the data of TR.FiIssuerOrganization first before we can retrieve the RICs. Could you please check and advise the accurate codes? Thank you in advance