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.

Find more posts tagged with

rics

permid-api

#content

#product

Accepted answers

Jirapongse

@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")

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.

All comments