7,625
edits
Changes
Jump to navigation
Jump to search
no edit summary
[[VCDB24]] is the 2024 and final iteration of my [[VentureXpert]] based '''V'''enture '''C'''apital '''D'''ata'''B'''ase. Thomson-Reuters discontinued access to VentureXpert through [[SDC Platinum]] on December 31st, 2023 (see also: [[SDC Normalizer]]). This iteration contains data up until then. Each VCDB includes investments, funds, startups, executives, exits, locations, and more. The previous build was [[VCDB23]], but the best previous instructions are from [[VCDB20]] or the [[McNair Center]] build, which was called [[VentureXpert Data]].
== Processing Steps ==
* There seems to have been duplicate issue records in the IPO data for vcdb2020 (and perhaps earlier). Some of the duplicates are often identical, except that the date is a day apart.
* The IPO records also contain listings on junior and foreign exchanges, as well as some OTC - I left these in and flagged them.
==Industry==
The industry coding is in IndustryCodes.txt. Note that:
* The code map had to be updated. The Excel file is in projects/vcdb24 but I didn't have the original counts to hand.
* The codes are not unique (576 out of 585 are unique) at the industry subgroup 3 level.
* The codes (code, code20, code100) should be joined using indclass, indminorgroup, indsubgroup
* The codes are 1,2,4 but not 3dg hierarchical.
* 1dg codes are IT, LS, and Other.
{| class="wikitable"
|-
! 2dg Code
! Minorcode
! No. of PortCos
|-
! 11
! Communications and Media
! 3930
|-
| 12
| Computer Hardware
| 3058
|-
| 13
| Computer Software and Services
| 21157
|-
| 14
| Internet Specific
| 14440
|-
| 15
| Semiconductors/Other Elect.
| 3145
|-
| 21
| Biotechnology
| 4251
|-
| 22
| Medical/Health
| 7138
|-
| 31
| Consumer Related
| 7459
|-
| 32
| Industrial/Energy
| 7028
|-
| 33
| Other Products
| 14246
|}
