Dealing with historical RICs for inactive stocks?

Hello,

I have a list of RICs for global stocks, originally from TRTH v1. I want to use the Eikon Python API to pull historical fundamentals data for these RICs. However, some of the companies are active and some are now inactive. I have discovered that Eikon adds a suffix beginning in ^ to inactive stocks. For example, Dell's RIC is DELL.O in TRTH, but in Eikon its RIC is now DELL.O^J13, indicating that Dell went private in October 2013. If I use the historical Dell RIC (DELL.O) in API requests, I get errors for most functions, e.g. get_data fails (even for periods before the company went private). Is it somehow possible to input the historical RICs from TRTH into get_data requests, perhaps using an option/parameter? Failing that, is it possible to programmatically convert the historical RICs to their new Eikon RICs for inactive stocks? I have a long list of companies, so doing this manually would be painful.

Thank you,

Mark

Find more posts tagged with

python

eikon

rics

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Zhenya Kovalyov

@mrkwlls try this:

tr.get_symbology(['DELL.O'], to_symbol_type='RIC')

All comments

Zhenya Kovalyov

@mrkwlls try this:

tr.get_symbology(['DELL.O'], to_symbol_type='RIC')

mrkwlls

Thanks Zhenya. Much appreciated. This works for many RICs. However, I am still getting an error 'No best match available' for some RICs. For example, AAG.AX fails with this error. I have tried using send_json_request with SymbologySearch and bestmatchonly=false, but it still fails. The problem appears to be that there are two potential candidates for AAG.AX (AAG.AX^E11 and AAG.AX^C96). Is there a way to specify the time period for a get_symbology request? E.g. if I could say what does AAG.AX map into in 2011?

EXPLORE OUR SITES