Changes

Jump to navigation Jump to search
no edit summary
=Spring 2017=
==Direct notes from Ed==
===Will's project===
*A note: Will's project has some overlap so we might borrow from his data, or he from ours, or we might research together or something
#U.S. Publicly-traded firms (1980-present) ##Industry Definitions in NAICS codes for O&G vs. IT vs. BT, etc. ###According to Ed, Will might not be doing these as much as us##Competition in markets ##Stocks and flows ##Branch offices ##Presence and size of Corp VC arms ##Joins to other data ###Flow and return of private equity deals ###Mean stock and flow of patents by year and industry ####Overlaps with us###Mean stock and flow of venture backed by year and industry (# and $) ####Overlaps with us###Mean flow of M&As by year and industry (# and $) ####Overlaps with us###Mean stock and flow of JVs by year and industry (# and $?) ###Mean flow of Spinoffs by year and industry (# and $)=Fall 2016=####Overlaps with us
===Our project===#Open Innovation and Competition (Avesh & Carlin previously worked on Oil & Gas) ##Oil vs. other sectors - Is there open innovation for Oil & Gas? ##Other interns: ??? ##Measures: M&A, spinoffs, patents, etc.###A note: these can be taken from Will's project
==General data we need to proceed==
*Patent data - knowledge of what we have & what we're looking for in the data
*M&As by year and industry (# and $) (do we pull this from SDC?)
*Spinoffs by year and industry (# and $) (do we pull this from SDC?)
*How to do industry classifications
**Did some work on this last semester but might want to revisit
*limiting the data to companies in the S&P 500? Or no?
 
==Skills we probably need to proceed==
*SQL technical skills - probably know basics but it might be good to know general ways we can manipulate the data once we get it
*COMPUSTAT, SDC for companies' industry groups
 
==Timeline==
*Should start off with a lit review
 
=Fall 2016=
==General project info==
*Avesh will be researching patents (counting patents for firms in each industry categorization in the s&p500)

Navigation menu