SDC CUSIP vs. CRSP CUSIP vs. Compustat CUSIP
Posted: 16 January 2014 05:31 AM   [ Ignore ]
Newbie
Rank
Total Posts:  28
Joined  2014-01-13

Hey guys,

I downloaded data from SDC including the CUSIPs. Some CUSIPs have six-digits, some have not. I added 0’s in front of the non-six-digits CUSIP.

Then, I added a “10” at the end of each CUSIP from SDC to get a 8-digit-CUSIP necessary to download the corresponding returns from CRSP.

Finally, I need some data from Compustat. However, Compustat requires 9-digit-CUSIP and apparently this last digit cannot be just “added” as the “10”, because this digit differs all the time. I am wondering now how I can get the Compustat data for the SDC data.

I thought about taking the PERMNOs from the CRSP data and use them in Compustat to identify the relevant SDC firms. Good way?

Thanks

Profile
 
 
Posted: 16 January 2014 07:59 PM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi,

I think the way to go here is to chop off the longest cusip to get the shorter. So, matching 9-digit cusip with 8-digit cusip works with chopping last character off the 9-digit cusip (the 9th character is a check digit).

The first 6 digits identify the issuer, positions 7 and 8 the equity/debt instrument, see here for structure of cusip: http://www.cusip.com/cusip/about-cgs-identifiers.htm

So, you can also chop off characters 7 and 8 and use the first 6 characters to match on firm.

best,

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile
 
 
Posted: 18 January 2014 02:59 AM   [ Ignore ]   [ # 2 ]
Newbie
Rank
Total Posts:  28
Joined  2014-01-13

Thanks Joost. I downloaded all firms from Compustat and then matched with 6-digits only.

Profile
 
 
Posted: 09 June 2014 08:17 AM   [ Ignore ]   [ # 3 ]
Newbie
Rank
Total Posts:  4
Joined  2014-06-09

Hi,

Do you guys have any suggestions on how to identify changes in a firm’s name and/or CUSIP after a merger? Also, is the CUSIP that SDC provides historical CUSIP or present CUSIP? What is a gendate of a CUSIP search result in SDC? Does a firm’s CUSIP get reused?

Another question, I used list management to export a list of target/acquirer CUSIP, however the software says the item number exceeded a maximum of 200 and have been saved to host, what does that mean? I ca see a lst file saved in the location I chose, but I can’t open it.

I’m really really new to SDC, thank you in advance for your patience and help!

Felix

Profile
 
 
Posted: 09 June 2014 11:24 AM   [ Ignore ]   [ # 4 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi Felix,

CRSP.dsenames may be helpful in ‘tracking’ firms’ names and cusips. http://wrds-web.wharton.upenn.edu/wrds/tools/variable.cfm?library_id=20&file_id=67400
(Variable ‘ncusip’ is historic cusip, so changes in cusip should pop up).

Compustat Funda (http://wrds-web.wharton.upenn.edu/wrds/tools/variable.cfm?library_id=129&file_id=65811) has header (current) cusip.

I am not sure if SDC reports historic or current cusips. Try matching with historic (dsenames) as well as current cusips (funda) to see what makes most sense. The cusip should not be ‘reused’ (as opposed to stock tickers). Nevertheless, it does seem to change for firms.

It has been a while since I used SDC and I don’t remember having trouble with a 200-record limit (I found SDC hard to use, though).

best regards,

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile
 
 
Posted: 09 June 2014 01:39 PM   [ Ignore ]   [ # 5 ]
Newbie
Rank
Total Posts:  4
Joined  2014-06-09

Hi, Joost

Thanks a lot! Do you know if the list files (lst) downloaded from SDC can be uploaded into other databases? Or turned into viewable txt files?

Thanks!

Felix

Profile
 
 
Posted: 09 June 2014 01:47 PM   [ Ignore ]   [ # 6 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi Felix,

I am afraid I don’t remember dealing with any lst files when I used SDC.

With some ‘fiddling’ (the interface is not easy/intuitive) I managed to export to .txt files from SDC.

best regards,

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile
 
 
Posted: 09 June 2014 02:53 PM   [ Ignore ]   [ # 7 ]
Newbie
Rank
Total Posts:  4
Joined  2014-06-09

Thanks, Joost.

I’ll try to find a way.

best,
Felix

Profile
 
 
Posted: 09 June 2014 04:52 PM   [ Ignore ]   [ # 8 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi Felix,

You’re welcome smile

If you could post your findings here, it may help other people solve the ‘lst mystery’ as well.

Thanks,

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile
 
 
Posted: 23 June 2014 05:48 AM   [ Ignore ]   [ # 9 ]
Newbie
Rank
Total Posts:  4
Joined  2014-06-09

Hi, Joost

I didn’t find a way to open the lst file outside of SDC platinum, but I realized that it’s possible to download both CUSIP, SEDOL and Datastream code in the reports. The options are not in the display panel but can be found by typing in a search. So it’s really not necessary to open a list file.

Best,
Felix

Profile
 
 
Posted: 23 June 2014 08:55 AM   [ Ignore ]   [ # 10 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi Felix,

I’m glad you found a way; thanks for following up!

best regards,

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile
 
 
Posted: 14 August 2014 10:34 AM   [ Ignore ]   [ # 11 ]
Newbie
Rank
Total Posts:  10
Joined  2014-07-11

Hi Stata_Crack,

I have a comment here. I am trying to use CUSIPs from SDC (which provides 6 and 9-digit CUSIPs) to get IBES data (which requires 8-digit CUSIP).

The issue is, for most cases (90% of the case as said in http://www.eur.nl/edsc/english/get_started/identifiers/cusips/), you can go from 6 to 8-digit by adding 10 at the end, as the Priceton’s tool does (http://firestone.princeton.edu/econlib/cusip/cusiper.htm).

But in my sample, for 1/3 of the sample you can’t go that way. Take for example, one transaction has 6-digit CUSIP to be 89901Q but 9-digit CUSIP is 89904P104. So you can’t add 10 to th 6-digit CUSIp to get 9-digit CUSIP, moreover, you can’t even truncate 104 from the 9-digit to get the 6-digit. Such issue happens to close to 1000 observations in my data. Therefore, I still struggle with this converting of 6 to 8 and of 9 to 6-digit CUSIP. And I would like to put a notice here to you when you convert 6 to 8-digit CUSIP by adding 10.

My question is: can we use ticker with a date to retrieve data and don’t have to worry about reuse of the ticker symbol? I think that because a ticker can be reused, but can’t be use for two companies at the same time, then combining a ticker and a date to retrieve data would make a unique record?

If you have any further suggestions I would love to know!

DN

Stata_Crack - 16 January 2014 05:31 AM

Hey guys,

I downloaded data from SDC including the CUSIPs. Some CUSIPs have six-digits, some have not. I added 0’s in front of the non-six-digits CUSIP.

Then, I added a “10” at the end of each CUSIP from SDC to get a 8-digit-CUSIP necessary to download the corresponding returns from CRSP.

Finally, I need some data from Compustat. However, Compustat requires 9-digit-CUSIP and apparently this last digit cannot be just “added” as the “10”, because this digit differs all the time. I am wondering now how I can get the Compustat data for the SDC data.

I thought about taking the PERMNOs from the CRSP data and use them in Compustat to identify the relevant SDC firms. Good way?

Thanks

Profile
 
 
Posted: 15 August 2014 01:55 PM   [ Ignore ]   [ # 12 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi DN,

I find it rather curious that the same entity has multiple 6-digit CUSIPs! I wasn’t aware of this, thanks for pointing it out.

Ticker - at a point in time - should be safe. I would expect some ‘trouble’ with variations of the symbol, for example the temporary adding of an ‘E’ to the symbol if it is late with filing, etc.

best regards,

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile
 
 
Posted: 14 April 2016 10:07 PM   [ Ignore ]   [ # 13 ]
Newbie
Rank
Total Posts:  1
Joined  2016-04-14

Hi. I’m new to CUSIP. So confused about current and historic CUSIP, whether CUSIP gets reused. Your post is helpful. But I can’t find 89904P104 in Compustat NA, 89904P10 or 89901Q10 in CRSP monthly security. Neither in ExecuComp nor IBES.

Do you have any update on your original issue?

tikitachi - 14 August 2014 10:34 AM

Hi Stata_Crack,

I have a comment here. I am trying to use CUSIPs from SDC (which provides 6 and 9-digit CUSIPs) to get IBES data (which requires 8-digit CUSIP).

The issue is, for most cases (90% of the case as said in http://www.eur.nl/edsc/english/get_started/identifiers/cusips/), you can go from 6 to 8-digit by adding 10 at the end, as the Priceton’s tool does (http://firestone.princeton.edu/econlib/cusip/cusiper.htm).

But in my sample, for 1/3 of the sample you can’t go that way. Take for example, one transaction has 6-digit CUSIP to be 89901Q but 9-digit CUSIP is 89904P104. So you can’t add 10 to th 6-digit CUSIp to get 9-digit CUSIP, moreover, you can’t even truncate 104 from the 9-digit to get the 6-digit. Such issue happens to close to 1000 observations in my data. Therefore, I still struggle with this converting of 6 to 8 and of 9 to 6-digit CUSIP. And I would like to put a notice here to you when you convert 6 to 8-digit CUSIP by adding 10.

My question is: can we use ticker with a date to retrieve data and don’t have to worry about reuse of the ticker symbol? I think that because a ticker can be reused, but can’t be use for two companies at the same time, then combining a ticker and a date to retrieve data would make a unique record?

If you have any further suggestions I would love to know!

DN

Stata_Crack - 16 January 2014 05:31 AM

Hey guys,

I downloaded data from SDC including the CUSIPs. Some CUSIPs have six-digits, some have not. I added 0’s in front of the non-six-digits CUSIP.

Then, I added a “10” at the end of each CUSIP from SDC to get a 8-digit-CUSIP necessary to download the corresponding returns from CRSP.

Finally, I need some data from Compustat. However, Compustat requires 9-digit-CUSIP and apparently this last digit cannot be just “added” as the “10”, because this digit differs all the time. I am wondering now how I can get the Compustat data for the SDC data.

I thought about taking the PERMNOs from the CRSP data and use them in Compustat to identify the relevant SDC firms. Good way?

Thanks

Profile
 
 
Posted: 15 April 2016 12:46 PM   [ Ignore ]   [ # 14 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi,

I can’t find those cusips either in Funda or CRSP (didn’t check IBES/Execucomp). (Should it be there?)

Best Regards,

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile
 
 
Posted: 15 April 2016 12:54 PM   [ Ignore ]   [ # 15 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

ok, the cusip belongs to tuffnell ltd; it is currently delisted (http://www.bloomberg.com/quote/TUFF:US) but used to be trading OTC (as far as I can tell). That would explain why it is not in Funda, CRSP, etc. To better understand how cusips change/not change it is probably better to take some listed companies that changed cusip (for example, using crsp.dsenames).

Best,

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile