Changes
Jump to navigation
Jump to search
VC Acquisitions Paper (view source)
Revision as of 16:35, 22 February 2012
, 16:35, 22 February 2012→Processing the Acquisitions
All together, these constraints reduce us from 41,572 to 40,306 acquisitions. Constraints that had no bite included: Spinoff, TwoStepSpinOff, and Splitoff. Further restricting the data to completed transactions, and those with valid codes for when the transaction value was amended, reduces the data to 40,035.
Acquiror and Target names were keyed into unique names. The first acquisition of several was taken. 33 records had multiple entries, the correct one of which could not be determined. These were discarded.
===Retrieving CUSIPS===
The acquisitions data lists 6 digit CUSIPS, we need the 'correct' 8 or 9 digit CUSIP with which to search CRSP and COMPUSTAT. A full list of all CUSIPs was retrieved from COMPUSTAT for the period Jan 1978- Jan 2012 using the annual data.