Difference between revisions of "VC Policy Report"

From edegan.com
Jump to navigation Jump to search
Line 50: Line 50:
  
 
Now that the data we need has been uploaded into the database:
 
Now that the data we need has been uploaded into the database:
#REDUCE data to US companies and completed IPO/Acquisitions
+
'''#REDUCE'' data to US companies and completed IPO/Acquisitions
#MATCH data with VC backed companies (Also in the database) to filter companies to only those that have been VC backed
+
'''#MATCH''' data with VC backed companies (Also in the database) to filter companies to only those that have been VC backed
#AGGREGATE '''yearly''' numbers to diagram the following variables over time for VC backed companies
+
'''#AGGREGATE''' '''yearly''' numbers to diagram the following variables over time for VC backed companies
 
##Number of each (IPO, Acquisitions, VC backed...)
 
##Number of each (IPO, Acquisitions, VC backed...)
 
##Total Value of all of the transactions (IPO, Acquisitions, VC, Sales and Mkt...)
 
##Total Value of all of the transactions (IPO, Acquisitions, VC, Sales and Mkt...)

Revision as of 19:17, 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

All Acquisitions based on SDC Data documented in

E:\McNair\Projects\MoneyIN_MoneyOUT

allipo

All Acquisitions based on SDC Data documented in

E:\McNair\Projects\MoneyIN_MoneyOUT

allvc

All Acquisitions based on SDC Data documented in

E:\McNair\Projects\MoneyIN_MoneyOUT

roundinfo

From roundinfoclean table from Hubs database

salesmktval

From Compustat data in table "vc4.txt" in the database documentation folder (detailed earlier)

To Do

Now that the data we need has been uploaded into the database: '#REDUCE data to US companies and completed IPO/Acquisitions #MATCH data with VC backed companies (Also in the database) to filter companies to only those that have been VC backed #AGGREGATE yearly numbers to diagram the following variables over time for VC backed companies

    1. Number of each (IPO, Acquisitions, VC backed...)
    2. Total Value of all of the transactions (IPO, Acquisitions, VC, Sales and Mkt...)

Note: in order to reduce we may need to reference:

E:\McNair\Projects\Winner's Curse\Data\SQL       ExampleCode.sql
  • This will replace "np" values in columns like ValTransactionmil from AllAcquis with null values