Home > Business Databases > FAQ: CUSIPs in WRDS output

FAQ: CUSIPs in WRDS output

Using CUSIP codes can cause headaches in Excel. They can be confused with numbers expressed in scientific format or leading zeroes can be lost. The blog post below, written by EDSC, offers some assistance on the subject.

EDSC manuals, tips & tricks

When you download data from WRDS to an Excel spreadsheet and include CUSIPs in your file, you often have CUSIPs that that look weird. See this example from CompuStat North America Index Constituents, the column Company Cusip should contain 9-digit CUSIPs:

cusips with E

The E’s in the CUSIPs of Dun & Bradstreet and Dr Pepper are recognized by Excel as a mathematical constant (2,718) and the CUSIPs of Amazon.com and Apple are incomplete (they start with zero’s, but these are not visible). This can very unhandy if you use these codes as input in other databases.

You can solve this by downloading the data from WRDS in another output format (comma-delimited text or tab-delimited text) and then:

  • Open a new Excel sheet
  • Open the ribbon Data
  • Choose From Text
  • Browse to the CSV or txt file and click Import
  • In the Text Import Wizard, mark Delimited and click Next
  • In step 2…

View original post 98 more words

Advertisements
Categories: Business Databases Tags: , ,
  1. No comments yet.
  1. No trackbacks yet.

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