how can I retrieve sedol from isin using eikon data api

vishal.kak
vishal.kak
in Eikon Data APIs
how can I retrieve sedol from isin using eikon data api
Tagged:

Best Answer

  • Gurpreet
    Gurpreet
    Answer ✓

    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


Answers

  • vishal.kak
    vishal.kak

    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")
  • Gurpreet
    Gurpreet
    I edited the previous answer. Try to use the get_data call instead.
  • vishal.kak
    vishal.kak

    perfect, that worked - thanks

Categories