ISIN to WKN (Wertpapier)?

dataroom01
dataroom01
in Refinitiv Data Platform Libraries

Hello,

if I have a list of ISIN numbers in Excel, is it possible to get them as WKN (securities identification number in Germany)?

Thank you very much!

Tagged:

Best Answer

  • Jirapongse
    Jirapongse
    Answer ✓

    @dataroom01

    You can try the search.lookup function in the Refinitiv Data Library for Python. 

    response = search.lookup.Definition(
        view=search.Views.SEARCH_ALL,      
        scope="ISIN",
        terms="DE0007164600,DE0007236101",
        select="BusinessEntity,DocumentTitle,Wert",
    ).get_data()


    response.data.df

    1703565909072.png


    Other examples are available on GitHub.

Answers

  • aramyan.h
    aramyan.h

    Hi @dataroom01 ,


    I have tried to get the available symbols for SAP (DE0007164600) using RD Libraries for Python before, however we doesn't seem to have the WKN code there.

    import refinitiv.data as rd
    from refinitiv.data.discovery import convert_symbols
    rd.open_session()
    response = convert_symbols(
        symbols="DE0007164600", 
    )
    response

    screenshot-2023-12-15-at-140432.png

    Also I have tried to look for all possible values for to_symbol_types, however couldn't find the one you were after.

    screenshot-2023-12-15-at-140446.png

    As it comes to Excel part of the question, you can reach our helpdesk via https://my.refinitiv.com/, as they are better positioned to answer excel related question.


    Hope this helps.


    Best regards,

    Haykaz

Categories