Is there any option to filter unnecessary RICs while or before calling get_symbology?

Hi guys,

I'm coding an app to retrieve RICs and then prices of bonds.

The problem is that using function get_symbology i received 16k RICs for 340 ISINs (looks like it has stored all historical RICs).

Is there any method to filter received RICs before/while calling the function? Of course taking all these RICs and filtering later would last ages.

I know I can make up some RICs, but RICs for stock exchanges seem to have more complex rules and i couldnt find transformation algorithm on Eikon (only found for other asset classes and a META app that can transform it, but I'd prefer to transform it in my app or somehow filter results of the function to active or predetermined RICs.

Thank you in advance

Paweł

Find more posts tagged with

python

eikon

rics

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Alex Putkov.1

I see. To get the RICs from Berlin, Frankfurt and Munich exchanges for a given bond use

ek.get_data('US9128283J70', 'TR.RICS(Contributor=BE:F:MU)')

To get all exchange RICs for a given bond use

ek.get_data('US9128283J70', 'TR.RICS(PriceQuality=Exchange)')

To explore all criteria you can apply to this call see the Parameters tab for TR.RICs field in Formula Builder wizard in Eikon Excel or in DIB app in Eikon desktop application.

All comments

Alex Putkov.1

If you're only looking for the main RIC for each bond you can use the following call instead of get_symbology method.

ek.get_data(isin_list, 'TR.PreferredRIC')

Pawel.Kunicki1

Thank you for your response.

Unfortunately, we are not using TR Composite (which is 'TR.PreferredRIC') in our pricing.

Do you know if there is any documentation with all RIC-related parameters in get_data function?What would be perfect for me is a method that will find all RICs for provided contributor IDs (let's say, user input BE, F, WA, and method finds RICs for a given security from Frankfurt, Berlin and Warsaw stock exchanges.

Alex Putkov.1

I see. To get the RICs from Berlin, Frankfurt and Munich exchanges for a given bond use

ek.get_data('US9128283J70', 'TR.RICS(Contributor=BE:F:MU)')

To get all exchange RICs for a given bond use

ek.get_data('US9128283J70', 'TR.RICS(PriceQuality=Exchange)')

To explore all criteria you can apply to this call see the Parameters tab for TR.RICs field in Formula Builder wizard in Eikon Excel or in DIB app in Eikon desktop application.

Pawel.Kunicki1

Thank you so much Alex! this is exactly what i needed

EXPLORE OUR SITES