For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
JIAN.DU avatar image
39 ●3 ●6 ●5

get_symbology doesn't support CUSIP lookup for CUSIP (CINs) (Extended)

Hi,

For US listed stocks we have a database of CUSIPs... this includes stocks listed on the NASDAQ Global Select market.

It seems when using get_symbology from='CUSIP', it will return no results. An example is MHLD US Maiden Holdings which has a CUSIP (International Number, CIN): G5753U112.

The security does pop up in Eikon search. Looking using DIB function within Eikon, it seems G5753U112 is not in the TR.CUSIP field, but rather CUSIP (Extended/CIN) (TR.CUSIPExtended or TR.CinCUSIPCode).

I am able to get MHLD using CUSIP G5753U112 from send_json_request instead, but it may be worth supporting CUSIP CINs in get_symbology?

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

2 Answers

Upvotes
Accepted
Jirapongse avatar image
38.1k ●71 ●35 ●53

I can get the result with this statement.

data = ek.get_symbology(["G5753U112"], from_symbol_type="CUSIP", bestMatch=False, raw_output=True)

You need to set bestMatch to False.


symbology.png (17.5 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
JIAN.DU avatar image
39 ●3 ●6 ●5

Ah yes. Apologies did not read the comments in symbology.py, only the documentation, indeed bestMatch is one of the parameters.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea