Home > Business Databases, News & Feedback > CUSIP – 6 digit cusip to 9 digit cusip / permno / gvkey

CUSIP – 6 digit cusip to 9 digit cusip / permno / gvkey

Following a few queries about having a 6 digit cusip and requiring a 9 digit cusip.

CUSIP identifiers are made up of up to 3 parts:

  1. Cusip issuer number – 6 digits
  2. Cusip issue number – 2 digits
  3. Cusip check digit – 1 digit

If you have 6-digit cusips for US companies and want to translate to 8 or 9 for use with CRSP and Compustat you can use WRDS.

WRDS CRST

WRDS

CRSP – Tools

Translate to PERMCO/PERMNO

This accepts 6-digit cusip as input

and will produce

PERMNO (or PERMCO), Company Name, Ticker, Exchange, and NCUSIP ( 8-digit cusip )

Now that you have a PERMNO (or PERMCO) you can use this to access CRSP.

CRSP – CRSP/COMPUSTAT Merged – Linking Table can be used to convert a PERMNO into a GVKEY (S&P identifier) and a 9-digit cusip. You can choose “Use Unique link…”  in the linking options, and “Historical CRSP PERMNO Link to Compustat Record” and all the identifying information.

An alternative for getting the 9th check digit is to use the WRDS CUSIP database.

CUSIP – Issuer query : provide 8 digit cusips, ask for “cusip check digit” and concatenate to convert 8 to 9 digit.

The CUSIP – ISSUER query can be used to convert 6 – 9 digit cusips by getting the issue number, finding the one with “Description 1” as “COM” and concatenating the issuer no, the issue no (almost always 10) and the check digit.

If this doesn’t work the 6 digit CUSIP is probably not for a quoted company covered by WRDS – try their code lookup facility (on most search pages).

Advertisements
  1. markgreenwood
    12 March 2013 at 10:33 pm

    This blog is a free wordpress.com blog – hosted by wordpress – hence the occasional adverts on the most popular posts.

  2. markgreenwood
    8 October 2013 at 11:19 pm

    To convert/transfer GVKEY (S&P identifier) to CUSIP you can use WRDS Compustat North America Fundamentals Annual – choose GVKEY as the format for your company codes and select CUSIP (from Identifying Information) to be included in the results.

  3. Denada
    22 October 2013 at 5:24 am

    what if the CUSIP is a 5-digits number?

    • markgreenwood
      22 October 2013 at 10:17 pm

      If you have a CUSIP that is a 5 digit number the most likely explanation is that a leading 0 has been dropped. (This seems to happen quite a lot in Excel.)

  4. zach
    26 March 2014 at 12:01 am

    I link SDC to CRSP as follows: (1) sdc issuer’s 6 digit cusip = first 6 digits from CRSP ncusip and sdc ticker — crsip ticker and date = date; (2) sdc issuer’s 6 digit cusip = first 6 digits from CRSP ncusip and date=date plus name check; (3) sdc ticker — crsip ticker and date = date plus name check;

    I find this approach is more efficient than crsp cusip tool.

    • 14 August 2014 at 4:54 pm

      Could you further explain this approach? Thanks!

  5. xzldreamer
    5 July 2014 at 2:34 pm

    May I ask why for the same permco, there has two or more different ‘cusip6+cusip2’ numbers? I trace back to their corresponding returns (from CRSP) for each ‘cusip6+cusip2’, and find the returns are different for the same day for the same permco. I thought that for the same company the stock returns should be the same on the same date.

    • markgreenwood
      7 July 2014 at 10:57 am

      It is possible for there to be more than one “cusip6+cusip2” numbers for the same company (same permco), for example if the company has more than one type of shares. Strictly the stock returns are for the company stock (or issue) rather than the company but this distinction can be safely ignored when there is only one stock issue for the company. To investigate further I’d have to have a specific example.

  6. Jojo
    5 September 2014 at 3:13 am

    i have the data from SDC, where different firm names have same 6-digit cusip number. So does this mean the same firm?

    • markgreenwood
      8 September 2014 at 5:01 pm

      There are certainly cases where a firm changes it name but keeps the same 6-digit cusip number. Where there is a merger there will often be a change of name but the cusip will remain the same. (There are times when a merger is considered to produce a new company significantly different from the old ones and a new 6-digit cusip is assigned – normally this would also have a new name.)

      • Jojo
        17 September 2014 at 3:38 pm

        Thanks. i also have another question.Does all the 6-digit cusip can be changed to a gvkey using above way? i input about 600 6-digit cusip in, but only get about 200 gvkey. How can i get the remaining. Thanks.

      • markgreenwood
        19 September 2014 at 12:10 pm

        You could use WRDS – CRSP/Compustat Merged (CCM) – Linking table to download a spreadsheet containing gvkey (S&P identifier), cusip, permno, and ticker. Then write a program to match your 600 6-digit cusips with the first 6 digits of the downloaded 9-digit cusips. Of course this only works if your companies are covered by CCM – all listed NYSE, Amex and NASDAQ common stocks.

  1. 25 June 2014 at 11:01 pm
  2. 16 December 2015 at 1:46 pm

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