125
edits
Changes
Jump to navigation
Jump to search
Winner's Curse in Acquisitions (Academic Paper) (view source)
Revision as of 11:45, 14 October 2016
, 11:45, 14 October 2016→Normalizing SDC data
(c)Ed Egan, 2010. Enjoy. (US dollars preferred.)
##########################################################
The output is now stored in the same directory: E:\McNair\Projects\Winner's Curse\Data\SDC_MA_Oct10v4-normal.txt
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 in \McNair\Projects\Winner's Curse\Data\SQL\SDC_TABLE.
Create Table SDC(
Date_Announced date,
Date_Effective date,
Tgt_Name varchar(80),
Tgt_Industry varchar(50),
Tgt_Nation varchar(10),
Acq_Name varchar(80),
Acq_Ind varchar(10),
Acq_Nation varchar(10),
Pc_Shares_Acq float,
Pc_Owned_After_Transaction float,
Value_Transaction float,
Enterprise_Value float,
Equity_Value float,
Acq_CUSIP varchar(10),
Acq_prnt_CUSIP varchar(10),
Acq_Ultimate_CUSIP varchar(10),
Tgt_prnt_CUSIP varchar(10),
Tgt_Ultimate_CUSIP varchar(10),
Tgt_CUSIP varchar(10),
Acq_Primary_Ticker varchar(10),
Acq_Ultimate_Ticker varchar(10),
Tgt_Primary_Ticker varchar(10),
Tgt_Ultimate_Ticker varchar(10),
Tgt_Ultimate_Ticker varchar(10),
Acq_NAIC varchar(10),
Acq_Ultimate_NAIC varchar(10),
Tgt_Primary_NAIC varchar(10),
Tgt_Ultimate_NAIC varchar(10),
NBid varchar(10),
Status varchar(10),
Value_Est varchar(10),
Value_Amended_Flag varchar(10),
Date_Announced_Estimated varchar(10),
Consideration_Structure varchar(10),
NConsid_off varchar(10),
NConsid_Sought varchar(10),
Consid_Structure varchar(10),
Pc_Cash varchar(10),
Pc_Other varchar(10),
Pc_Stock varchar(10),
Pc_Unknown varchar(10),
Acq_FullName varchar(10),
Tgt_Name varchar(30),
Acq_City varchar(30),
Tgt_City varchar(30),
Acq_Zip varchar(10),
Tgt_Zip varchar(10),
Acq_St varchar(10),
Tgt_St varchar(10),
Currency varchar(10),
Tgt_Bankrupt varchar(10),
Chlng_Deal varchar(10),
Debt_Restructuring varchar(10),
RecapDefense varchar(10),
Government_Owned_Involvement_Flag varchar(10),
Joint_Venture varchar(10),
Restructuring varchar(10),
Acq_LBO_firm varchar(10),
LBO varchar(10),
IPO_Flag varchar(10),
Tgt_LBO_firm varchar(10),
Merger_Equals varchar(10),
Reverse_Takeover varchar(10),
Deal_was_Rumor varchar(10),
Acq_is_a_White_Knight varchar(10),
White_Knight_Defense varchar(10),
Back_End_Defense varchar(10),
FlipOver_Defense varchar(10),
Voting_Plan_Defense varchar(10),
Poison_Pill varchar(10),
Creeping_Acquisition varchar(10),
Repurchase_Defense varchar(10),
Pacman_Defense varchar(10),
Lockup_FlagY_N varchar(10),
Tgt_Lockup varchar(10),
Greenmail varchar(10),
Asset_Lockup varchar(10),
Scorched_Earth_Defense varchar(10),
SelfTender_Defense varchar(10),
Stock_Lockup varchar(10),
Defense varchar(10),
White_Squire varchar(10),
Acq_Includes_Employees varchar(10),
Acq_Includes_an_ESOP varchar(10),
Sig_Family_Ownership_Tgt varchar(10),
Acq_Lockup varchar(10),
Financial_Acq varchar(10),
2_Step_Spinoff varchar(10),
Acq_Includes_Mgmt varchar(10),
Open_Market_Purchases varchar(10),
Proxy_Fight varchar(10),
Purpose_Code varchar(10),
Related_Deals varchar(10),
Foreign_Provider_Funds varchar(10),
Stock_Swap varchar(10),
Asset_Swap_Flag varchar(10),
Sweep_the_Street varchar(10),
SelfTender varchar(10),
Tender_offer varchar(10),
Unsolicited varchar(10),
Acq_TermFee varchar(10),
Tgt_TermFee varchar(10),
Forced_vote_provisions_FlagY_N varchar(10),
Walkaway varchar(10),
Acq_Ultimate_Add1 varchar(50),
Acq_Ultimate_Add2 varchar(50),
Tgt_Ultimate_Add1 varchar(50),
Tgt_Ultimate_Add2 varchar(50),
Acq_stockEx varchar(10),
Tgt_stockEx varchar(10),
Tgt_Net_Sales varchar(10),
Tgt_Net_Assets varchar(10),
Tgt_Total_Assets varchar(10),
Tgt_Common_Equity varchar(10),
Tgt_BVpersh_LTMUS varchar(10),
Tgt_IntangibleA varchar(10),
Tgt_RD varchar(10),
Tgt_Tot_liab varchar(10)
);
==Previous Papers==
