ISIN-codes and Cusips of American companies

The ISIN-codes of American companies consist of:

  • US –  indicating the country
  • 9-digit Cusip-code
  • a check digit

So if you have the ISIN-code: delete US (in excel you can use the function =RIGHT(x;10) & the check digit (in excel you can use the function =LEFT(x;9). If you need the 8-digit cusip-code, you need to use =LEFT(x,8).

When you have identifiers like SEDOL-codes, DS-codes or EntityKeys, easily to change into ISIN-codes, you also have the CUSIP-codes for CompuStat North America or Eventus.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s