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.
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
1
●0 ●1 ●1
How to get Company PermID from Company Name?
Hi @library02 ,
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.
Thanks,
AHS
Hi,
Please be informed that a reply has been verified as correct in answering the question, and marked as such.
Thanks,
AHS
79.2k
●251 ●52 ●74
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.
