For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
7 1 0 3

how can I retrieve sedol from isin using eikon data api

eikon-data-api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
13k 32 12 18

Hi @vishal.kak ,

Ideally you can use the symbology call in the Eikon Aata API to get the symbol conversion. E.g:

ek.get_symbology(
    ['US5949181045', 'US02079K1079', 'US4592001014'], 
    from_symbol_type='ISIN', 
    to_symbol_type='RIC')

However, this might not work when using ISIN as a source, since there is a one to many mapping, and no best match.

1637942466123.png


I would recommend that you speak with Eikon content experts at my.refinitiv.com to see if there is another means to do this.


Update: You can use the get_data call to get the SEDOL using this call:

1637942714926.png



1637942466123.png (8.3 KiB)
1637942714926.png (6.8 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
7 1 0 3

Thanks for your response

Why am I getting "No best match available" error when I try to search for Microsft ISIN - US5949181045

df = ek.get_symbology("US5949181045", from_symbol_type="ISIN", to_symbol_type="SEDOL")
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

I edited the previous answer. Try to use the get_data call instead.
Upvotes
7 1 0 3

perfect, that worked - thanks

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea