1
●0 ●1 ●2
Is there a query to pull in a list of ADRs for a large list of companies using the RIC, ISIN, Sedol, or CUSIP
Hello @Alex Putkov., @chavalit.jintamalit, @jirapongse.phuriphanvichai
Could you look into this question?
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If yes, please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
39.4k
●77 ●11 ●27
You can use the following methodology. The examples below use Eikon Excel worksheet functions. If you're looking to replicate this process programmatically, you can use DEX2 and RSearch Eikon COM APIs libraries.
1. Retrieve issuer OrgidCode from RIC/ISIN/CUSIP/SEDOL
=TR("RU0007661625;VOD.L","TR.OrgidCode")
The above returns 81339 and 13625, which are Orgid codes for Gazprom PAO and Vodafone Group Plc respectively.
2. Then you can use Orgid codes to retrieve the list of ADRs for each company.
=RSearch("EQUITY","RawContextFilter:'AssetState ne \'DC\' and IssuerOrgid eq \'81339\' and RCSAssetCategoryGenealogy eq \'A:31\''")
The above returns GAZPq.L, GAZPqUSD.xbo, OGZDRPEU.MMV, GAZPy.DE etc.
