ISIN to WKN (Wertpapier)?

dataroom01

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!

Jirapongse

@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

Other examples are available on GitHub.

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

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

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