125
edits
Changes
Jump to navigation
Jump to search
Winner's Curse in Acquisitions (Academic Paper) (view source)
Revision as of 17:58, 13 October 2016
, 17:58, 13 October 2016→Importing SDC Data into Winner Database
==Importing SDC Data into Winner Database==
Session DetailsCreate Table SDC as ( --------------- Date_Announced date, Request Hits Request Description Date_Effective date 0 - DATABASES: Domestic Mergers, Tgt_Name varchar1979-Present (80)MA, Tgt_Industry varchar(50OMA), Tgt_Nation varchar( 1 - Date Announced: 1/1/1985 to 10), Acq_Name varchar(10), Acq_Ind varchar/11/2016 (10Custom), Acq_Nation varchar(10Calendar), Pc_Shares_Acq float, 2 300400 Target Nation : US Pc_Owned_After_Transaction float, 3 257952 Acquiror Nation : US Value_Transaction_mil float, 4 127865 Acquiror Public Status : P 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) 5 98108 Target Public Status : V,P Acq_Ultimate_prnt_NAIC varchar(10), Tgt_Primary_NAIC varchar(10), Tgt_Ultimate_prnt_Primary_NAIC varchar(10), Number_Bidders varchar(10), 6 63732 Deal 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),: C 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), 7 52746 Percent of Shares Owned after Transaction: 100 to 100 Tgt_Ultimate_prnt_Street_Address_1 varchar 8 Custom Report: SDC_MA_Oct10v4 (50Columnar),- Save As: Tgt_Ultimate_prnt_Street_Address_2 varchar(50), E:\McNair\Projects\Winner's Curse\Data\SDC_MA_Oct10v4.txt Acq_stockEx varchar(10),� Tgt_stockEx varchar(10), Billing Ref # : 1962461 Tgt_Net_Sales_LTM varchar(10), Capture File : riceuniv.1962461 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)) Session Name : SDC_MA_Oct10v4.ssh
==Previous Papers==
