Blog2Blog Maak je eigen Blog2Blog | Gratis je eigen blog c.q weblog op internet
Financial Databases and Research - Using CUSIP to search in databases
Financial Databases and Research

Using CUSIP to search in databases

Posted in General

 

Some months ago I considered the CUSIP (Committee on Uniform Security Identification Procedures) identifier to be a fairly good identifier because it is a unique code for companies and has existed since it's introduction in 1968. Unfortunately only CUSIP 6 is more often available in databases as a search option. The extended identifier CUSIP 8 or 9 occurs a lot less as a search option and often can not be downloaded.

Example for the company Teleconnect:

 

CUSIP 6: 879292
CUSIP 8: 87929210
CUSIP 9: 879292100

 

The Cusip 8 is a stock/security identifier. CUSIP 9 has the extra check digit (which can also

be calculated) which is needed to be able to check whether the CUSIP identifier format is correct. For more information on CUSIP etc, you can look in the updated files below:

 

Company Identifiers.pdf

Company Identifiers-databases.pdf

 

It is possible to find the security type for some companies using CUSIP 6 if you use the

CUSIP Master File through the Wharton portal. Once you have the security type indicator, the check digit can be calculated. Depending on which part database of the Master File is used you can either download the CUSIP 8 or the security type indicator as a separate data item.

It is not possible to use a CUSIP identifier to directly find information on that security

through Datastream. In Datastream you should search for securities by name, ISIN, DS codes (or mnemonics) and Sedol codes. Using the WorldScope database through datastream you can, however, use the Cusip 9 to find codes like ISIN or a DS code. This search option can of course only be used for those companies which are available through WorldScope. For many companies you will probably not be able to get an alternative code this way.

 

Searching for a code in WorldScope using a CUSIP 9 code goes as follows:

  • In Excel select from the Menu: Datastream AFO > Static Request
  • Type in the CUSIP 9 code for Teleconnect in the field "Series/lists" as follows: WS:879292100
  • Add the Datatype you want to search for in the next field. When you look for more than 1 datatype you have to separate each datatype with a comma. Example: name,isin.
  • Click the Submit button to search.

The result for a search on WS:879292100 should be: Teleconnect and US8792921004.


Author information: LinkedIn


12:14 PM - 15 August 2008


Last Page
Next Page
Description
This weblog will deal with all kinds of tips and tricks on the use of several financial databases.

Home
User Profile
Sections
--- Amadeus
--- Company.Info
--- Datastream
--- Factiva.com
--- GMID
--- General
--- International Statistics
--- LexisNexis
--- SDC Platinum
--- S&P Indexes
--- Wharton
--- Zephyr
Recent Entries
- Announcement: New Blog
- International Human Development Indicators
- Global Reporting Initiative
- WorldScope company coverage update
- World Bank Commodity Prices - update November 2011



External Links:
--- NYSE Euronext
--- Finabase Blog
--- VU Law Blogspot