COmpany Identifiers

 

In the course of your research you may need to merge sets of data collected in one source, into another source. Unique identifiers can become useful. The tables below provide information for some selected company identifiers.

Downloading Identifiers from a database

DatabaseTickersCUSIPsISINsSEDOLsDS CodeOthersComments
BloombergYesYesYesYesNoBB Ticker 
Compustat Industrial (WRDS)YesYesNoNoNoCIK, GCKEY 
CRPS
(WRDS)
YesYesNoNoNoPERMCO,
PERMNO
 
Datastream (Static Queries)Yes*YesYesYesYesIBES ticker Tomson ticker*Modified Ticker; U: for NYSE and AMEX; @ for Nasdaq
Execucomp
(WRDS)
YesYesNoNoNoGVKEY 
I/B/E/S (WRDS)YesYes
(8 digit)
NoNoNoIBES ticker 
ORBISYesNoYes

Yes
No

NoBvD ID;
D & B Duns
(US & Canada only)
No more SEDOLs as of Oct. 2015
SDC Global New IssuesYesYesYesYesNo  
SDC
M&A
YesYesNoYesYes  
S&P Capital IQYesNoNoNoNoCIK, GVKEY 
Thomson One
(web + Excel addin)
YesYesYesYesYesIBES ticker, CIK (web), DS Mnemonic 

 


 

UPLOADING LISTS OF IDENTIFIERS IN A DATABASE

DatabaseTickersCUSIPsISINsSEDOLsDS CodeOthersComments
BloombergYesYesYesYesNoBloomberg unique identifier (BBGID) 
Compustat Industrial (WRDS)YesYesNoNoNoGCKEY 
CRPS
(WRDS)
YesYesNoNoNoPERMCO,
PERMNO
 
Datastream (Static Queries)YesYesYesYes*Yes *For SEDOLs starting with letters, add UK in front ie: for B020QX2 us UKB020QX2
Execucomp
(WRDS)
YesYesNoNoNoGVKEY 
I/B/E/S (WRDS)YesYes
(8 digit)
NoNoNoIBES ticker 
ORBISYesNoYes

Yes
No

NoD&B
(US & Canada firms only)
BvD ID
No more SEDOLs as of Oct. 2015
SDC Global New IssuesYesNoYesYesNo  
SDC
M&A
YesNoNoYesYes  
S&P Capital IQYesNoYes*NoNoS&P Capital IQ ID*Inconsistent, ISIN were uploaded using a different ID type
Thomson One
(web + Excel addin)
YesYesYesYesYesMany!*tested add-in only

Caution:
Tickers are not always reliable as they can be reused.
ISINs can identify a security but not the exchange on which it trades.
Some databases may have missing identifiers.

HOW TO UPLOAD A LIST

In Excel, paste your identifiers then use the following formula:
=BDP(A1&"isin","PX_Last") for instance where A1 is your first pasted ISIN number, and PX_Last is the item you are requesting.
For a list of mnemonic of items use FLDS <GO>.
If you upload a list of tickers, use this =BDP(A1&"US Equity","PX_last").

With an existing list of codes in Excel (ISIN, SEDOLs, Tickers, CUSIPs), open the PRTU <GO>, create a list.
Select your codes, click on the top right of the selection until you see a cross with four arrows then drag to the ‘Search’ box on the PRTU screen.
The codes will appear in the Cash column.
If the ISIN, SEDOL fields do not appear, go to Settings>User Display and select them, they will be populated automatically. Click on Export to export to and excel file.

Go to My Capital IQ>Watch List>Create.
Note: ISIN numbers can be uploaded by using the copy/pasting in the ‘search’ field vs actually uploading a file.

Step 1: Paste your identifiers in an Excel sheet and click Create List from Range> Fill the Give a List File Name (.LLT) box name click OK.
Step 2: Open a new Static or Time Series request and choose the List Picker icon (under Find Series), call up your list and proceed as usual.

Click on: Identification Numbers>stock and securities numbers.

Copy the identifiers from a text file or an excel file, launch a request and select ‘All Items’ when the ‘Search Items’ window appears.
Type in the type of identifier you wish to upload and double click on it.
In the pop up window right click to paste the identifiers (CTRL+V will not work). Click OK.

Add-in: paste your identifiers in a spreadsheet, from the Thomson menu click Report>Select identifier from range>Add items>export

USEFUL LINKS & TOOLS

STOCK IDENTIFIERS IN I/B/E/S

US Firms: Bloomberg (and other data sources) can be reconciled with I/B/E/S based on CUSIP.

European Firms: European firms do not have a CUSIP, unlike US Firms. I/B/E/S therefore attributes a composite CUSIP based on the SEDOL identifier of European firms, based on the following rule:

I/B/E/S CUSIP = [country identifier][6 character SEDOL]

where

[6 character SEDOL] is the firm’s 7 character SEDOL from which the last character is omitted
[country identifier] is as follows

 

 Countryprefix
 AustriaEA
 BelgiumEB
 CyprusEO
 DenmarkSD
 FinlandSF
 FranceEF
GreeceEH
GermanyED
IrelandEZ
ItalyEI
IcelandSI
LuxembourgEL
NetherlandsEN
NorwaySN
PortugalEP
SpainEE
SwedenSS
SwitzerlandES
UKEX

 

 

Beware of the following:

  • Irish stocks are often dual listed in the UK. Don’t mix the UK SEDOL with the Irish one.
  • Dual listings may mean that some I/B/E/S data may be associated with other identifiers while they relate to the same company. The data may be in other currencies than that of the main listing (e.g. Nordea).
  • SEDOLs change over time, e.g. as companies merge or take other corporate action, and companies relocate their headquarters.

Insead Personalised Experience

icon

Relevant

icon

Save & Manage

icon

Connect

It is easy, simply log in:

Via Social

  • icons
  • icons
  • icons

Or

Use your email address