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!
1
●0 ●0 ●1
ISIN to WKN (Wertpapier)?
Hi,
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
79.2k
●251 ●52 ●74
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.
5k
●16 ●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
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
