New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
Accepted
JIAN.DU avatar image
39 ●5 ●7 ●7

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-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-api
icon clock
10 |1500

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

2 Answers

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
87.8k ●294 ●53 ●79

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 512.0 KiB each and 1.0 MiB total.

Upvotes
JIAN.DU avatar image
39 ●5 ●7 ●7

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 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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