question

Upvotes
Accepted
1 0 0 1

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!

#technologyrdp-apiexcelisin
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Accepted
78.6k 248 52 74

@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.


1703565909072.png (32.5 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvote
4.8k 13 2 7

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


icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.