Answered By: Barbara Coffey Last Updated: Sep 17, 2019 Views: 21394
Many financial data packages use CUSIP as the identifier. The first 6 digits of a CUSIP identify the company, digits 7-8 describe the security and the 9th is check digit.
Converting from 8 or 9 digit CUSIPS to 6,8 or 9 digits can be done with:
- The CUSIP Converter on WRDS enables you to convert 8 or 9 digit CUSIPs into 6, 8 or 9 digits.
- The CRSP Stock Events - Historical Descriptive Information file on WRDS is useful for looking at the history of companies and their changes over time.
- If you prefer Excel, you can download the document Converting Company Level CUSIPs to CRSP CUSIPs for instructions on how to convert 6-digit CUSIPs to 8-digit CUSIPs.
- For more information about CUSIP, go to CUSIP Service Bureau and select "What's CUSIP?".
Converting from 6 digits to 8 or 9 is harder, as the information in the first 6 digits relates only to the company not the security. The first equity security issued by a company issues receives the digits 10, additional issues increment by 10. In most cases, for companies that have publicly traded equity adding 10 to the 6 digit company identifier will return the common stock and the underlying company data. If this does not yield positive results, try adding 20 instead of 10. If adding increments of 10 does not work, the last resort is looking up the company by name.
If a company has bonds the first 6 numbers again designate the company and bonds are identified with letters.
For instance - Apple's common stock CUSIP is 03783310 and a CUSIP for one of Apple's outstanding bonds is 037833AK. The company identifier is 037833 and the security identifiers are 10 for the common stock and AK for that specific bond.
Chat with a Librarian
Text a Librarian
Text (609) 277-3245 to get live help on your mobile phone (available the same hours as the Chat service)
Email a Librarian
Call a Librarian
Call (609) 258-5964 to speak to a reference librarian during most open hours of the Libraries.