how can I retrieve sedol from isin using eikon data api

Find more posts tagged with

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.

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:

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.

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:

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")

I edited the previous answer. Try to use the get_data call instead.

perfect, that worked - thanks