get_symbology not returning data

reid

Hi -

I queried the following get_symbology:

ek.get_symbology(['EAT','LB','WSM'])

...and received the response

error lipperID

EAT NaN 71000219

LB No best match available NaN

WSM No best match available NaN

Which is weird because all 3 of those should be proper RICs (I looked them up in the platform, plus am able to call get_data with them).

Most other tickers behave as expected, for instance:

ek.get_symbology(['AEP','AEO','AEF'])

returns:

CUSIP ISIN OAPermID RIC lipperID ticker

AEP 025537101 US0255371017 4295903333 AEP NaN AEP

AEO 02553E106 US02553E1064 4295912473 AEO 68143943 AEO

AEF 00301W105 US00301W1053 4295901107 AEF 40003306 AEF

Is there a reason why the function call doesn't seem to be finding data for these RICs?

Thanks very much.

Find more posts tagged with

python

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Alex Putkov.1

@574c708d-6b25-445f-8303-2b495473ec99_deprecated_6f93d9f8-9d25-487c-91bf-b3a796f48f40
You're not doing anything wrong. The issue is with the backend service underlying get_symbology method. I have created service case #07204564 on your behalf with Refinitiv Helpdesk. The Helpdesk will get in touch with you regarding the progress on the case.
As an alternative I may suggest using get_data method with fields TR.ISIN, TR.CUSIP etc instead of get_symbology method.

All comments

m.bunkowski

Hi @574c708d-6b25-445f-8303-2b495473ec99_deprecated_6f93d9f8-9d25-487c-91bf-b3a796f48f40

You can try with:

ek.get_symbology((['EAT','LB','WSM']),from_symbol_type="ticker", to_symbol_type="RIC" , bestMatch=False)

reid

OK but then if I look at the output, those inputs that I put in the list should all be valid RICs right? So I still don't get why it is not working if I input the RICs as such and don't ask for all possible matches... I don't want a list of possible symbols I just want to know the values (tickers, cusips, sedols, etc) that match those literal RICs

reid

Maybe I'm not explaining clearly but I am entering what should be *unique* RICs. I want unique ids like CUSIPs from those (was using default params but I can specify if it helps get my point across). So for instance the below:

ek.get_symbology((['EAT','LB','WSM']), from_symbol_type="RIC", to_symbol_type="CUSIP")

Gives me nothing... To make it more pointed, the below should return the same as my input (converting a RIC into a RIC), yet it doesn't (?)

ek.get_symbology((['EAT','LB','WSM']), from_symbol_type="RIC", to_symbol_type="RIC")

(All works fine with many other tickers, just not these)

reid

@marcin.bunkowskido you see what I mean in that last comment/clarification? I believe it is working improperly for these RICs, but let me know if I am just doing something wrong

Alex Putkov.1

EXPLORE OUR SITES