ISIN to WKN (Wertpapier)?

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!

Find more posts tagged with

excel

isin

rdp-api

#technology

Accepted answers

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.

All comments

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

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.

EXPLORE OUR SITES