How to get Company PermID from Company Name?

library02
library02
in Eikon Data APIs

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.

Tagged:

Best Answer

  • Jirapongse
    Jirapongse
    Answer ✓

    @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.

Categories