215
edits
Changes
Jump to navigation
Jump to search
→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:
#'''REDUCE''' data to US companies and completed IPO/Acquisitions (create new table with only US companies)
## allipo and allacquis reduced so far- avesh## cleaned 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
##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. ###ben made new code on this###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
