Difference between revisions of "VC Policy Report"
BenBaldazo (talk | contribs) |
|||
| Line 12: | Line 12: | ||
company name, exchange, ticket, sales, mkt value, naics, cusip, state, year | company name, exchange, ticket, sales, mkt value, naics, cusip, state, year | ||
| + | |||
| + | ==VC Policy Report Database== | ||
| + | |||
| + | DataBase in the Z: Drive under | ||
| + | vcpolicy | ||
| + | Database documentation in | ||
| + | Z:\bulk\VCPolicy | ||
| + | Including all code in | ||
| + | Z:\bulk\VCPolicy\VCPolicyReport.sql | ||
| + | |||
| + | ===Tables in Database=== | ||
| + | |||
| + | '''allacquis''' | ||
| + | '''allipo''' | ||
| + | '''allvc''' | ||
| + | '''roundinfo''' | ||
| + | '''salesmktval''' | ||
Revision as of 18:59, 15 November 2016
General
The purpose of this report is to demonstrate the increased market share of VC-backed, publicly-traded companies.
Contents
1. VC into US portfolio companies (round amount) big year (in Hubs database. psql vc policy) + Match List (Ben has this)
2. Acquisitions (100%, complete) of US firms by US firms - transaction value -> match to VC
3. IPOs (completed) - enterprise value and gross proceeds of US firms on Nasdaq, Amex, NYSE -> match to VC
4. (from compstat) Sales and market value of publicly traded (nasdaq, nyse, amex) US firms (shrout*price) -> match to VC
company name, exchange, ticket, sales, mkt value, naics, cusip, state, year
VC Policy Report Database
DataBase in the Z: Drive under
vcpolicy
Database documentation in
Z:\bulk\VCPolicy
Including all code in
Z:\bulk\VCPolicy\VCPolicyReport.sql
Tables in Database
allacquis allipo allvc roundinfo salesmktval
