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
1 0 0 1

How to get Company PermID from Company Name?

I am using GOVSRCH for bond issuance data. I want to get the Company PermID to get unique identifier of all companies (RIC is specific to public companies). I have a list of name of the companies and I want to retrieve the PermID. Is there any code/syntax available for retrieving in excel.

#product#contentricspermid-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.

1 Answer

· Write an Answer
Upvotes
Accepted
76.5k 238 52 72

@library02

Thank you for reaching out to us.

You can use Screener to retrieve RICs and PermIDs from company names.

For example:

=TR("SCREEN(U(IN(Equity(active,public,primary))), Contains(TR.CommonName,'"&A1&"'))","TR.OrganizationID","RH=In")

1693910258881.png

Otherwise, you can contact the Eikon Excel support team directly via MyRefinitiv to verify if there is another method in Eikon Excel to retrieve this information.


1693910258881.png (22.8 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.

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.