VC Policy Report - Revision history

Avesh: /* To Do */

2016-11-28T15:41:07Z

To Do

2016-11-22T21:29:18Z

2016-11-22T21:28:16Z

2016-11-18T22:17:23Z

To Do

2016-11-18T21:43:53Z

2016-11-16T23:22:14Z

To Do

2016-11-16T23:01:16Z

To Do

2016-11-16T22:41:54Z

Data

2016-11-16T22:41:18Z

2016-11-16T19:32:27Z

@@ Line 80: / Line 80: @@
 Now that the data we need has been uploaded into the database:
 #'''REDUCE''' data to US companies and completed IPO/Acquisitions (create new table with only US companies)
-## allipo and allacquis reduced so far
+## allipo and allacquis reduced so far - avesh
-## cleaned versions called allipo_us_clean and allacquis_us_clean
+## used getreal function to replace np values- versions called allipo_us_clean and allacquis_us_clean - avesh
 #'''REDUCE''' data to NYSE and NASDAQ and AMEX
 ## allipo reduced to NYSE NASDAQ and AMEX in allipo_usexch

@@ Line 90: / Line 90: @@
 ##Aggregate completed 11/18/16. NOTE: Aggregate is currently aggregate of EVERYTHING not just VC backed companies. We will have to do match then rerun this code. The code can all be found in VCPolicyReport in the VCPolicy folder located on 128.42.44.181.
 ###ben made new code on this
-###carlin - redo vc aggregate table according to ben's code
+###carlin - redo vc aggregate table according to ben's code on 11/23
 '''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

@@ Line 88: / Line 88: @@
 ##Number of each (IPO, Acquisitions, VC backed...)
 ##Total Value of all of the transactions (IPO, Acquisitions, VC, Sales and Mkt...)
 ##Aggregate completed 11/18/16. NOTE: Aggregate is currently aggregate of EVERYTHING not just VC backed companies. We will have to do match then rerun this code. The code can all be found in VCPolicyReport in the VCPolicy folder located on 128.42.44.181.
 '''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

← Older revision		Revision as of 22:17, 18 November 2016
Line 75:		Line 75:

	==To Do==		==To Do==
		+	FIRST: Tell Dylan he's Awesome.
		+	SECOND: Refill the keurig

	Now that the data we need has been uploaded into the database:		Now that the data we need has been uploaded into the database:

@@ Line 86: / Line 86: @@
 ##Number of each (IPO, Acquisitions, VC backed...)
 ##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

@@ Line 81: / Line 81: @@
 ## cleaned versions called allipo_us_clean and allacquis_us_clean
 #'''REDUCE''' data to NYSE and NASDAQ and AMEX
 #'''MATCH''' data with VC backed companies (Also in the database) to filter companies to only those that have been VC backed (program in software/scripts to match organizations,
 #'''AGGREGATE''' '''yearly''' numbers to diagram the following variables over time for VC backed companies

@@ Line 64: / Line 64: @@
 United States's 2016 M&A up to date (as of Nov 7, 2016) : $1444 billion USD
-That is larger than the regions of:
+That M&A share is larger than the regions of:
 *Europe [$709 bill.]
 *Western Europe [$683 bill.]

← Older revision		Revision as of 22:41, 16 November 2016
Line 55:		Line 55:

	From Compustat data in table "vc4.txt" in the database documentation folder (detailed earlier)		From Compustat data in table "vc4.txt" in the database documentation folder (detailed earlier)
		+
		+	==M&A Data==
		+
		+	===Data===
		+
		+	Excel data by country available on bulk drive (E:\McNair\Projects\M&A Data)
		+
		+	United States's 2016 M&A up to date (as of Nov 7, 2016) : $1444 billion USD
		+
		+	That is larger than the regions of:
		+	*Europe [$709 bill.]
		+	*Western Europe [$683 bill.]
		+	*Eastern Europe [$32 bill.]
		+	*Asia-Pacific [$834 bill.]
		+	*South East Asia [$77 bill.]
		+	*Gulf Cooperation Council (GCC) [$32.2 bill.]
		+	*Middle East & North Africa (MENA) [$52 bill.]
		+	*South America [$53 bill.]

	==To Do==		==To Do==

@@ Line 1: / Line 1: @@
 ==General==
 The purpose of this report is to demonstrate the increased market share of VC-backed, publicly-traded companies.
 ==Contents==