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
3 1 1 2

Finding associated ADR/GDR for instruments

Is it possible to obtain information about associated ADRs or GDRs, given a particular security? For example, given ABI.BR (ANHEUSER BUSCH INBEV NV), if I navigate to "Price & Charts", click on "All Quotes", under the DR section, I can see the related ADRs such as BUD.A, BUD.B, etc. Is it possible to obtain the same information programatically via the APIs?

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apisymbology
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.

Upvote
Accepted
39.4k 77 11 27

Try

ek.get_data('SCREEN(U(IN(Equity(active,public))/*UNV:Public*/),Contains(TR.DRUnderlyingQuoteRic,"ABI.BR"))',['TR.InstrumentDescription'])
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.

Upvotes
3 1 1 2

Thanks Alex, this works well, I tried a few securities.

As a corollary, is it possible to perform a "back reference lookup"? So in other words, if I have BUD.N, can I back out into ABI.BR?

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.

Yes, you can:

ek.get_data('BUD.N',['TR.DRUnderlyingQuoteRic'])
Upvotes
3 1 1 2

Thanks that works also!

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.