I would like to merge two data sources with companies headquartered in Germany between 1980-2000, but listed in Germany and the US. One source identifies "German companies" by their CUSIP, the other one by their WKN. There are names in both data sets, so I can approximately match on name (+ record link on other features). But I thought I could improve on that by matching exactly on (6dig) WKNs and (6dig) CUSIPs?! I guess I would need a resource which has linked stocks of the same company traded in different exchanges? For instance, I am looking for this correspondence

Volkswagen AG | WKN = 766400 | CUSIP = 928662

Academia no-cost solution required. :/ Thanks.


There is OPEN FIGI. But they seem to do poorly on CUSIPs of companies not based in the US (adding 10 or 30 + check digit to CUSIP).

curl 'https://api.openfigi.com/v2/mapping' \
--request POST \
--header 'Content-Type: application/json' \
--data '[{"idType":"ID_CUSIP","idValue":"928662303"}]'

Returns [{"error":"No identifier found."}]

But --data '[{"idType":"ID_WERTPAPIER","idValue":"766400"}]' returns an ID, company name and ticker useful for the matching:

[{"data":[{"figi":"BBG000BCH458","name":"VOLKSWAGEN AG","ticker":"VOW","exchCode":"GR","compositeFIGI":"BBG000BCH458","uniqueID":"EQ0011575700001000","securityType":"Common Stock","marketSector":"Equity","shareClassFIGI":"BBG001S67CB7","uniqueIDFutOpt":null,"securityType2":"Common Stock","securityDescription":"VOW"},{"figi":"BBG000BCH4V9","name":"VOLKSWAGEN AG",

Any other DB which can identify multinationals (not headquartered in the US) by their CUSIP?



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.