104
edits
Changes
Jump to navigation
Jump to search
Winner's Curse in Acquisitions (Academic Paper) (view source)
Revision as of 17:25, 14 October 2016
, 17:25, 14 October 2016→COMPUSTAT
Note: TobinsQ is Market over book so MKVALT/AT (also pulled common stock and price)
DROP TABLE compustatpull;
CREATE TABLE compustatpull (
gvkey int,
datadate date,
Fyear int,
industry_format varchar(5),
consol varchar(20),
popsrc varchar(20),
datafmt varchar(5),
tic varchar(20),
cusip varchar(20),
conm varchar(50),
curcd varchar(3),
curncd varchar(3),
fyr int,
act float,
ceq varchar(20),
ebitda float,
intan float,
revt float,
sale float,
exchg varchar(20),
costat varchar(5),
naicsh float,
sich varchar(20),
mkvalt varchar(20),
prcc_f varchar(20),
county varchar(50),
naics varchar(10),
sic int,
states varchar(2),
ipodate date);
\COPY compustatpull FROM 'CSTAT-10Oct-ff1feb81b9f166ad.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--464894
All loaded up
===CRSP===
