7,612
edits
Changes
Jump to navigation
Jump to search
We might also want An outline of a process to add:*IT target*VC backed target Candidate starting pointsdo this:*SDCv2 is the import with some simple exclusions and basic processing 49031 - but it was likely overwritten and became 40216*. A rebuild from SDCBase appears the replacement but this seems to have thrown out same day acqs. *We therefore need to go back to the raw import of SDC_MA_Oct10v4-fixed-normal.txt into table "SDC".*Load table prc from backup: SHOUT appears to have come from prc, which in turn came from CRSPRelNOInc. *Load table CRSPRelNOInc is : this a base table for both estimation and event window builds.*Recode some queries from the previous work:
**Run the estimation (using script ???.do) and build a new estimationtotal file and import it in estimationoutput*Recode some queries from the previous work:
**Finally join all of this mess back! to the data that we already have. We may need to recompute targetit and targetvc.
CEO Compensation and Returns to Public and Private Acquisitions: Testing the Shareholder Value Hypothesis (view source)
Revision as of 17:49, 12 August 2017
, 17:49, 12 August 2017→To do
==To do==
We want to add:
*A unique CEO-Firm key
*IT target - and sum through
*VC backed target - and sum through
===Same Day Acquisitions===
We need to solve the multiple acquisitions on a single day problem. The result needs the variables listed for acquisitions below (crucially including pub/priv indicator, CAR5, sameday indicator, sharesoutstanding, with a cusip-year key).
**We would need to calc day number again for SDC, which would mean bringing in the dayno table.
**Then we'd need to create new estimation data for the missing records: acq_cusip, date_announced, acqkey, dayno, avg(ret) as ret, primex, vret, eqret, reldayno, retdayno (see EstimationBase) - but maybe this time take SHOUT with you!
**Build a new EventBase, and everything in CRSP_TABLE.sql through to Flatter
**Join this to EstimationOutput, calculate the abnormal returns and then CARs.
==Variables==
