Changes

Winner's Curse in Acquisitions (Academic Paper) (view source)

2 bytes added , 12:50, 14 October 2016

To import the data into winner database, I'll copy the above file to the /bulk directory.

The code to create the SDC table is ~~store~~ stored in \McNair\Projects\Winner's Curse\Data\SQL\SDC_TABLE.

Create Table SDC(

Date_Announced date,

Date_Effective date,

Tgt_Primary_Ticker varchar(10),

Tgt_Ultimate_Ticker varchar(10),

~~Tgt_Ultimate_Ticker~~ Tgt_Ultimate_Ticker2 varchar(10),

Acq_NAIC varchar(10),

Acq_Ultimate_NAIC varchar(10),

Pc_Unknown varchar(10),

Acq_FullName varchar(10),

~~Tgt_Name~~ Tgt_Name2 varchar(30),

Acq_City varchar(30),

Tgt_City varchar(30),

Acq_Lockup varchar(10),

Financial_Acq varchar(10),

~~2_Step_Spinoff~~ Step_Spinoff varchar(10),

Acq_Includes_Mgmt varchar(10),

Open_Market_Purchases varchar(10),

125

edits