668
edits
Changes
Jump to navigation
Jump to search
Winner's Curse in Acquisitions (Academic Paper) (view source)
Revision as of 14:14, 13 October 2016
, 14:14, 13 October 2016no edit summary
10000 | 1986-01-17 | 3 | 3990 | 68391610 | OMFGA | OPTIMUM MANUFACTURING INC | | Q | 7952 | 68391610 | -3.00000 | 8470 | 0.000000 | 3680 | | -0.001741 | 0.003297
(10 rows)
==Importing SDC Data into Winner Database==
Create Table SDC as (
Date_Announced date,
Date_Effective date,
Tgt_Name varchar(80),
Tgt_Industry varchar(50),
Tgt_Nation varchar(10),
Acq_Name varchar(10),
Acq_Ind varchar(10),
Acq_Nation varchar(10),
Pc_Shares_Acq float,
Pc_Owned_After_Transaction float,
Value_Transaction_mil float,
Enterprise_Value_mil float,
Equity_Value_mil float,
Acq_CUSIP varchar(10),
Acq_Imm_prnt_CUSIP varchar(10),
Acq_Ultimate_prnt_CUSIP varchar(10),
Tgt_Immediate_prnt_CUSIP varchar(10),
Tgt_Ultimate_prnt_CUSIP varchar(10),
Tgt_CUSIP varchar(10),
Acq_Primary_Ticker_Symbol varchar(10),
Acq_Ultimate_prnt_Ticker varchar(10),
Tgt_Primary_Ticker_Symbol varchar(10),
Tgt_Ultimate_prnt_Ticker varchar(10),
Tgt_Ultimate_prnt_Ticker varchar(10),
Acq_Primary_NAIC varchar(10),
Acq_Ultimate_prnt_NAIC varchar(10),
Tgt_Primary_NAIC varchar(10),
Tgt_Ultimate_prnt_Primary_NAIC varchar(10),
Number_Bidders varchar(10),
Status varchar(10),
Value_Est varchar(10),
Value_Amended_Flag varchar(10),
Date_Announced_is_Estimated varchar(10),
Consideration_Structure varchar(10),
Number_Considerationsfered varchar(10),
Number_Considerations_Sought varchar(10),
Consid_Structure_Description varchar(10),
Pc_Cash varchar(10),
Pc_Other varchar(10),
Pc_Stock varchar(10),
Pc_Unknown varchar(10),
Acq_Full_Name 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_FlagY_N 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_prnt_Street_Address_1 varchar(50),
Acq_Ultimate_prnt_Street_Address_2 varchar(50),
Tgt_Ultimate_prnt_Street_Address_1 varchar(50),
Tgt_Ultimate_prnt_Street_Address_2 varchar(50),
Acq_stockEx varchar(10),
Tgt_stockEx varchar(10),
Tgt_Net_Sales_LTM 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_R_D_One_Year_Prior varchar(10),
Tgt_Total_Liabilities varchar(10))
==Previous Papers==
