201
edits
Changes
Jump to navigation
Jump to search
[[Category:Work Log]]<onlyinclude>[[Jake Silberman]] [[Work Logs]] [[Jake Silberman (Work Log)|(log page)]]</onlyinclude> ===Summer 2016===
Jake Silberman (Work Log) (view source)
Revision as of 12:19, 2 November 2017
, 12:19, 2 November 2017no edit summary
06/01/2016 15:52 - Introduction/Wiki building
07/20/2016 14:00 - Joining new LBO deals in the 5000s to working data set
07/26/2016 15:52 - finished incorporating 5000s lbo deals into data set, now beginning reorganization of scripts and past work to make it simpler/easier to follow and execute
07/27/2016 11:25 - Reorganizing scripts and helping Ed/James Brander with [[Winner's Curse]].
07/28/2016 12:00 - Cleaning LBO SQL scripts
07/29/2016 13:45 - Cleaning LBO SQL scripts and helping Ed/James Brander a bit more with [[Winner's Curse]]
08/01/2016 13:57 - Examining corporate governance databases to solidify measures for [[Winner's Curse]]
====Fall 2016===
09/06/2016 13:00 - Getting reacquainted with the LBO Project
09/08/2016 13:10 - Continuing research into data for [[Winner's Curse]]
09/15/2016 15:04 - Finding variables/data sources for [[Winner's Curse]]
===Spring 2017===
02/13/2017 10:30 - Locating variables for [[Venture Capital (Data)]] in SDC
02/15/2017 10:08 - Trying to locate several more variables for [[Venture Capital (Data)]] in SDC, then begin work to make data sets in SQL
02/17/2017 12:18 - Running SDC pulls for Company Level, Main Round, and Round on One Line (if Main Round finishes up).
02/20/2017 10:22 - Normalizing Main Round, organizing data in folders
02/22/2017 10:00 - Pulling Round on One Line (and normalizing, as long as it doesn't crash), and creating database in SQL to import them into
03/06/2017 11:12 - Beginning work for Venture Capital Data Issue Brief
03/08/2017 11:42 - Did first SDC Pull for VC Data and began cleaning data/making graphs
[[Category:Work Log]]
03/22/2017 11:15 - Redid SDC Pulls with final variables, wrote research plan
03/27/2017 10:00 - Normalizing SDC data, cleaning data/making graphs, work in E:\McNair\Projects\VentureCapitalData\VCData Pull 2 Normalized
04/05/2017 11:30 - Normalized and loaded SDC pulls into 'vcdata' database
04/19/2017 11:20 - Completed SEL deal, investment, rounds, and IPO tables. Code found in E:\McNair\Projects\VentureCapitalData\SQL Scripts and tables in 'vcdata' database
04/25/2017 14:55 - Worked on adding extra IPO data to old IPO table, seemed that there were no new IPOs in the data.
Final tables so far found in 'vcdata' database. Names of final tables so far are sel3, investments3, rounds2,
and ipo2. Merger and acquistion data in table MA.
[[Category:Work Log]]
