Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
5 0 0 3

How can we get all the associated RICs and corresponding ISINs for a list of over 4000 company names through Eikon API?

Is it possible to retrieve the RICs for a list of companies (4000+ company names) with different exchanges and then retrieve their corresponding ISINs using python?

We need something similar to =@TR("SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), Contains(TR.CommonName,"&A2&"), CURN=USD)","TR.CommonName;TR.ISIN","curn=USD RH=In CH=Fd") where A2 is Apple.

That formula pulls RICs for companies with "Apple" in the name but this won't work since what is required is to pull all RICs and ISINs associated with the specific company names on the list (i.e. Apple Inc). What is the best code to use?

eikon-data-api#technologyapi
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.

1 Answer

· Write an Answer
Upvotes
Accepted
78.1k 246 52 72

@catherine.osea

Thanks for reaching out to us.

Please refer to the answers in the previous discussions.

  1. [Python API] How to fuzzy search for companies by name ?
  2. Screening using name contains
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.