How do I get RICs with specific ending from ISIN?

Aleksandra.Krasilnikova

Hi, I am trying to retrieve RICs with specific ending (*=RRPS) from ISINs.

Input:

df = pd.DataFrame()

df = rd.get_data(

universe=['US20717MAB90'],

fields=['TR.RIC']

)

Output:

Instrument RIC

US20717MAB90 20717MAB9=

But I need to be able to find the 20717MAB9=RRPS via workspace's API. Is there a way to do it?

m.bunkowski

Hi @Aleksandra.Krasilnikova

Try:

rd.get_data(universe=['US20717MAB90'],fields=['TR.RICS(Contributor=RRPS)'])