7,649
edits
Changes
Jump to navigation
Jump to search
→SDC files
I also re-did the M&A queries, pulling more info from 1980 to 2020H1 in four goes. I removed the 100pc owned constraint from the search, as I'm concerned that when it isn't reported, observations are omitted. It can be added back later. I also included completed vs. withdrawn, pc cash and stock, and some other useful measures. Then I pulled all the non-private acquisitions in two goes as well.
After these changes, there are only two constraintsin the SDC requests (see [[SDC Platinum]] for how to make requests using this really buggy tool):
*Deals from 1/1/1980 to 07/20/2020
*US companies (also targets and issuers)
USMAPublic80-20H1-normal.txt
Normalizing the files is generally straight-forward. Use NormalizeFixedWidth.pl (see [[Normalizer Documentation]]) and only copy down the missing keys (e.g., coname, statecode, datefirst, etc.). For most files there is nothing to fix, just select the last header row and go. For fund fix the header first, so that the capital under management header entry has some space after it. For RoundOnOneLine, remove the footer, run NormalizeFixedWidth.pl first then RoundOnOneLine.pl, and then fix the header. For fund, fund execs, and portco, remove double quotes after normalization.
For PortCoLongDescription (see [[Vcdb4#Long_Description]]):
