Difference between revisions of "Winner's Curse in Acquisitions (Academic Paper)"
| Line 155: | Line 155: | ||
List of variables in the CRSP-oct10.txt | List of variables in the CRSP-oct10.txt | ||
| − | + | * PERMNO | |
| − | + | * date | |
| − | + | * EXCHCD | |
| + | * SICCD | ||
| + | NCUSIP | ||
| + | TICKER | ||
| + | COMNAM | ||
| + | NAICS | ||
| + | PRIMEXCH | ||
| + | PERMCO | ||
| + | CUSIP | ||
| + | PRC | ||
| + | VOL | ||
| + | RET | ||
| + | SHR | ||
| + | OUT | ||
| + | NUMTRD | ||
| + | vwretdPE | ||
| + | ewretd | ||
| + | |||
==Previous Papers== | ==Previous Papers== | ||
Revision as of 16:09, 12 October 2016
| Winner's Curse in Acquisitions (Academic Paper) | |
|---|---|
| Project Information | |
| Project Title | |
| Start Date | |
| Deadline | |
| Primary Billing | |
| Notes | |
| Has project status | |
| Copyright © 2016 edegan.com. All Rights Reserved. | |
Contents
- 1 Mini task 1, SDC Data Pull, preferably Jake
- 2 Mini task 2, COMPUSTAT and CRSP Data Pull, preferably Will
- 3 Mini task 3, Governance Measures
- 4 To do list
- 5 Governance Variables
- 6 Paper Discussion
- 7 Importing the CRISP data into the `winner' database (Amir)
- 8 Previous Papers
- 9 Related Pages
- 10 Resources
Mini task 1, SDC Data Pull, preferably Jake
Pull the following list of variables: 1985 to present. If you think there should be another variable included feel free to add them to the following list. Import them into a SQL table. Make sure to document every step including the SQL codes. If possible save the data pull session.
- CUSIP
- Exchange and ticker
- Company name
- Acq transaction value
- Acq announcement date
- Number of bidders
- NAICS codes for target and Acq.
- Addresses
Mini task 2, COMPUSTAT and CRSP Data Pull, preferably Will
The same as task 1 for the following variables.
- Variables for CRISP(daily)
- Stock price
- Returns
- Variable for COMPUSTAT ( Everything 1980 to present)
- Acq market value of assets
- NAICS codes
- Sales
- GVKEY
- intangible assets
- TOBIN's Q
Mini task 3, Governance Measures
Projects --> Winner's Curse --> Data
Open the GovernanceVARS.txt
These are
- staggered boards
- limits to shareholder bylaw amendments
- limits to shareholder charter amendments
- supermajority requirements for mergers
- poison pills
- golden parachutes
To do list
- Including public acquisitions
- Find SIC codes for the old data, also for the public firms that are now included.
- Data from SDC
- Social criteria acquisitions announcement dates 1985 - present
- Acquirer publicly traded ( must be AMEX, NASDAQ, or NYSE)
- Target status is public or private
- Acquirer and target are U.S. firms.
- Acq of 100 percent of the firm and Acq. completed
- GVKEY
- Variable list for SDC
- CUSIP
- Exchange and ticker
- Company name
- Acq transaction value
- Acq announcement date
- Number of bidders
- NAICS codes for target and Acq.
- Addresses
- T
- Variables for CRISP(daily)
- Stock price
- Returns
- Variable for COMPUSTAT ( Everything 1980 to present)
- Acq market value of assets
- NAICS codes
- Sales
- GVKEY
- intangible assets
- TOBIN's Q
Magic with CUSIPs : CUSIP is a nine digit number (possibly ten, ) Seven issuer, two issue, one check
CRSP processing notes: estimation window 250 days ending 30 days before the Acq. must be at least 50 continuous days before the 30 days window. See page 9 of the paper for data processing notes. FROM
http://www.edegan.com/repository/DD-ThomsonSDCMA.txt
Governance Variables
A list of governance variables can be found in: E:\McNair\Projects\Winner's Curse\Data\GovernanceVARS
Paper Discussion
Variables & Where to Find Them:
| Variable | Location |
| Actual Return | CRSP |
| Abnormal Return | CRSP |
| Average Return | CRSP |
| Weighted Average Return | CRSP |
| Cumulative Ab. Return | CRSP |
| Boom | SDC |
| Competition | Compustat |
| Distance | SDC + google maps |
| IT Fixed Effect | SDC |
| Idiosyncratic Volatility | CRSP (Calculated) |
| Industry Fixed Effect | SDC |
| Momentum | CRSP (Calculated) |
| Private Financial Data | CRSP |
| Percent Cash | SDC |
| Previous Acquisitions | SDC |
| Sales | Compustat |
| Tobin's Q | Compustat |
| Turnover | CRSP |
| VC Fixed Event | SDC & VentureXpert |
| Governance | Compustat |
| Friendly vs. Hostile | SDC |
Importing the CRISP data into the `winner' database (Amir)
Data file is located in: E:\McNair\Projects\Winner's Curse\Data\CRSP-Oct10-c30cc89e52b70545-1.txt
Issue 1: The text file is 8 GB large and there's no way to open it in Textpad. I'll try to read the file in LogExpert which seems to do a neat job in in opening large files. Otherwise, I'll try to read the first few lines in the terminal. Update: I managed to open the file in LogExpert. However, extremely inefficient to scroll over the file.
I copied the file to Z:\WinnersCurse\CRSP-oct10
Entered the following command in the terminal to read the header: head -1 CRSP-oct10.txt
List of variables in the CRSP-oct10.txt
- PERMNO
- date
- EXCHCD
- SICCD
NCUSIP TICKER COMNAM NAICS PRIMEXCH PERMCO CUSIP PRC VOL RET SHR OUT NUMTRD vwretdPE ewretd
Previous Papers
From the old wiki
