How to get historical bond price of matured expired bonds from ISIN to RRPS RIC?

dianne.palmario

How can I obtain historical prices for expired bonds in an automated way? Obviously, it works if I do it manually (by looking up the RIC in Refinitiv Workspace’s user interface)

Using script below, it does not get the RRPS RIC of these matured expired ISINs:

import refinitiv.data as rd

from refinitiv.data.content import symbol_conversion

rd.open_session()

response = symbol_conversion.Definition(

symbols=["DE000A13SHV1", "AT0000A1EZR1", "AT0000332853", "DE000HSH40E5", "US459200HU86"],

from_symbol_type=symbol_conversion.SymbolTypes.ISIN,

to_symbol_types=[

symbol_conversion.SymbolTypes.RIC

],

).get_data()

response.data.df

What the client wanted to achieve is by using the ISINs of these matured expired bonds, he wants to get the RRPS RICs then eventually use them in another script similar to below to get the historical data. Can you please advise the best way to do this? Or if this is even doable? Thank you.

import refinitiv.data as rd

rd.open_session()

df = rd.get_history(

universe = ['DEHSH40E=RRPS'],

start = "2021-12-15",

end = "2021-12-31"

)

df[::-1]

aramyan.h

Hi @dianne.palmario ,

Thank you for your question. I would suggest using Search capabilities of RD Library. Please see below:

df = rd.discovery.search(
    view = rd.discovery.Views.GOV_CORP_INSTRUMENTS,
    filter = "SnSISIN in ('DE000A13SHV1' 'AT0000A1EZR1' 'AT0000332853' 'DE000HSH40E5' 'US459200HU86')",
    select = "SnSISIN, RRPSRic"
)
df

Hope this helps.

Best regards,

Haykaz

JxL

@aramyan.h I was unable to obtain historical prices of matured/expired bonds even if RRPSRic is available. Are there other ways to obtain historical prices of bonds that have expired/matured?