619
edits
Changes
Jump to navigation
Jump to search
Innovation in the Oil and Gas Industry (view source)
Revision as of 17:13, 24 January 2017
, 17:13, 24 January 2017no 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 $)
####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)
**need help with search terms
*still also to do: get R&D spending data from compustat
==Notes from Ed==
Let's start by pulling some basic data on the S&P 500 over time. COMPUSTAT can provide you with financials and NAICS codes. We can do some industry groupings from there. But you'll need an S&P 500 indicator from somewhere in WRDS, or we'll have to put together a list from other sources.
==S&P Industry group==
