ISIN Code Formatter

What is an ISIN Code?

An ISIN (International Securities Identification Number) is a 12-character alphanumeric code that uniquely identifies a specific securities issuance. ISINs are used globally to identify stocks, bonds, derivatives, and other financial instruments across international markets.

ISIN Structure

Every ISIN follows a strict format:

• Characters 1-2: Country code (ISO 3166-1 alpha-2)
• Characters 3-11: National Security Identifier (NSIN) - 9 alphanumeric characters
• Character 12: Check digit calculated using the Luhn algorithm

Examples

Common Country Codes

Why ISINs Matter

Regulatory Compliance

ISINs are required for:

• MiFID II transaction reporting in Europe
• Form 13F filings with the SEC
• Cross-border securities transactions
• Regulatory reporting to financial authorities

Trade Confirmation

ISINs ensure accurate trade confirmation across:

• Multiple trading venues
• Different clearinghouses
• International custodians
• Portfolio management systems

ISIN vs CUSIP vs SEDOL

Note: US ISINs incorporate the CUSIP as the NSIN portion (characters 3-11).

Validation Rules

Format Check

1. Must be exactly 12 characters
2. First 2 characters must be uppercase letters (country code)
3. Characters 3-11 are alphanumeric (A-Z, 0-9)
4. Last character must be a valid check digit (0-9)

Check Digit Calculation

The check digit uses the Luhn algorithm:

1. Convert letters to numbers (A=10, B=11, ..., Z=35)
2. Double every second digit from right to left
3. Sum all digits
4. Check digit makes the total divisible by 10

Common ISIN Errors

Incorrect Length

❌ US037833100 (11 characters - missing check digit)

✓ US0378331005 (12 characters)

Wrong Country Code

❌ USA378331005 (3-character code)

✓ US0378331005 (2-character ISO code)

Invalid Characters

❌ US037833-005 (contains hyphen)

✓ US0378331005 (alphanumeric only)

Using ISINs in Systems

Database Storage

-- SQL table design
CREATE TABLE securities (
    isin CHAR(12) PRIMARY KEY,
    name VARCHAR(255),
    country_code CHAR(2),
    CHECK (isin ~ '^[A-Z]{2}[A-Z0-9]{9}[0-9]$')
);

Excel Import

When importing ISINs to Excel:

• Format cells as Text (not General) to preserve leading zeros
• Use apostrophe prefix: 'US0378331005
• Or import as CSV with text formatting

API Integration

// Example ISIN lookup
const response = await fetch(
  `https://api.openfigi.com/v3/mapping`,
  {
    method: 'POST',
    body: JSON.stringify([{
      idType: 'ID_ISIN',
      idValue: 'US0378331005'
    }])
  }
);

Best Practices

• Always validate ISINs before submitting regulatory reports
• Store ISINs as text, not numbers (preserves leading zeros)
• Use ISINs as primary keys in securities databases
• Implement check digit validation in your applications
• Keep ISIN reference data updated (securities can be delisted)