Difference between revisions of "James Chen (Work Log)"

From edegan.com
Jump to navigation Jump to search
 
(12 intermediate revisions by 4 users not shown)
Line 1: Line 1:
[[Category:Work Log]]
+
==Summer 2018==
[[James Chen]] [[Work Logs]] [[James Chen (Work Log)|(log page)]]
 
  
07/15/2016 - Refining hazard model: revising variables used, comparing Cox Proportional Hazard and Lognormal Accelerated Failure Time models
+
06/11/2018 - Worked with Wei to get him set up with system
  
07/18/2016 - Cataloged SQL tables, revised STATA script (STATAdatasetup2.do) to include ratios, replace cashflow with ebitda, and filter out firms smaller than $50 million
+
===Fall 2017===
 +
<onlyinclude>
  
07/19/2016 - Investigated baseline hazard of Cox Proportional Hazard model. Compared to Lognormal and Loglogistic Accelerated Failure Time models to try to predict hazard rate (not just hazard ratio)
+
[[James Chen]] [[Work Logs]] [[James Chen (Work Log)|(log page)]]
  
07/20/2016 - Adjusted dataset to filter out firms that are small (<$40m) or not listed in major exchanges (AMEX, NYSE, NASDAQ). Consulted Brian on descriptive statistics of dataset.
+
</onlyinclude>
  
07/21/2016 - Investigated negative ebitda ratios.
+
===Spring 2017===
  
07/22/2016 - Performed further testing of hazard model. Ran preliminary matching analysis using patent flow data.
+
02/02/2017 - Planned immediate next steps for LBO project; fixed bug in matching code (matchpair indices not being stored correctly)
  
07/25/2016 - Cleaned data setup do file. Organized list of data problems to consult with Ed.
+
===Fall 2016===
  
 
09/06/2016 - Discussed workload for the week, plan for project going forward with Ed and Jake.
 
09/06/2016 - Discussed workload for the week, plan for project going forward with Ed and Jake.
Line 24: Line 24:
 
10/13/2016 - Met with Ed and Brian to discuss results and future work for LBO Innovation project. Began rebuild/redocumentation of dataset.
 
10/13/2016 - Met with Ed and Brian to discuss results and future work for LBO Innovation project. Began rebuild/redocumentation of dataset.
  
10/14/2016 - Continuing rebuild, documentation at [[Leverage_Buyout_Innovation_(Clean)]]. COMPUSTAT data is now standardized for linking.
+
10/14/2016 - Continuing rebuild, documentation at [[Leveraged_Buyout_Innovation_(Academic_Paper)#New_Version]]. COMPUSTAT data is now standardized for linking.
  
 
10/18/2016 - Began importing Brian's SDC data into SQL database
 
10/18/2016 - Began importing Brian's SDC data into SQL database
Line 33: Line 33:
  
 
10/27/2016 - Reorganized SQL script for better readability. Tried to bugfix SDC join (still WIP)
 
10/27/2016 - Reorganized SQL script for better readability. Tried to bugfix SDC join (still WIP)
 +
 +
10/28/2016 - Completed initial SDC join. Adding additional matches using name-based matching.
 +
 +
11/03/2016 - Continued working on name-based matching.
 +
 +
11/04/2016 - Completed name-based matching for SDC data/LBOs.
 +
 +
11/10/2016 - Finalized documentation for LBO side of project. Minor bugfixes for name-based matching from last week.
 +
 +
11/11/2016 - Worked on matching in patent flows and stocks, basically finished up to name-based matching
 +
 +
11/17/2016 - Finished matching in patent flows and stocks, contingent on having a completed active patent start/end table from Napas
 +
 +
11/18/2016 - Minor bugfixes for STATA code (got winsorized variables working consistently); began working on patent start/end table
 +
 +
===Summer 2016===
 +
 +
07/15/2016 - Refining hazard model: revising variables used, comparing Cox Proportional Hazard and Lognormal Accelerated Failure Time models
 +
 +
07/18/2016 - Cataloged SQL tables, revised STATA script (STATAdatasetup2.do) to include ratios, replace cashflow with ebitda, and filter out firms smaller than $50 million
 +
 +
07/19/2016 - Investigated baseline hazard of Cox Proportional Hazard model. Compared to Lognormal and Loglogistic Accelerated Failure Time models to try to predict hazard rate (not just hazard ratio)
 +
 +
07/20/2016 - Adjusted dataset to filter out firms that are small (<$40m) or not listed in major exchanges (AMEX, NYSE, NASDAQ). Consulted Brian on descriptive statistics of dataset.
 +
 +
07/21/2016 - Investigated negative ebitda ratios.
 +
 +
07/22/2016 - Performed further testing of hazard model. Ran preliminary matching analysis using patent flow data.
 +
 +
07/25/2016 - Cleaned data setup do file. Organized list of data problems to consult with Ed.
 +
 +
[[Category:Work Log]]

Latest revision as of 13:32, 11 June 2018

Summer 2018

06/11/2018 - Worked with Wei to get him set up with system

Fall 2017

James Chen Work Logs (log page)


Spring 2017

02/02/2017 - Planned immediate next steps for LBO project; fixed bug in matching code (matchpair indices not being stored correctly)

Fall 2016

09/06/2016 - Discussed workload for the week, plan for project going forward with Ed and Jake.

09/08/2016 - Reread Lerner article, compiled notes on article and state of the project

09/09/2016 - Completed some ad hoc analyses of STATA dataset to diagnose problems with propensity score matching.

10/13/2016 - Met with Ed and Brian to discuss results and future work for LBO Innovation project. Began rebuild/redocumentation of dataset.

10/14/2016 - Continuing rebuild, documentation at Leveraged_Buyout_Innovation_(Academic_Paper)#New_Version. COMPUSTAT data is now standardized for linking.

10/18/2016 - Began importing Brian's SDC data into SQL database

10/20/2016 - Completed importing SDC data

10/21/2016 - Matched SDC data to COMPUSTAT data for LBO entry flags.

10/27/2016 - Reorganized SQL script for better readability. Tried to bugfix SDC join (still WIP)

10/28/2016 - Completed initial SDC join. Adding additional matches using name-based matching.

11/03/2016 - Continued working on name-based matching.

11/04/2016 - Completed name-based matching for SDC data/LBOs.

11/10/2016 - Finalized documentation for LBO side of project. Minor bugfixes for name-based matching from last week.

11/11/2016 - Worked on matching in patent flows and stocks, basically finished up to name-based matching

11/17/2016 - Finished matching in patent flows and stocks, contingent on having a completed active patent start/end table from Napas

11/18/2016 - Minor bugfixes for STATA code (got winsorized variables working consistently); began working on patent start/end table

Summer 2016

07/15/2016 - Refining hazard model: revising variables used, comparing Cox Proportional Hazard and Lognormal Accelerated Failure Time models

07/18/2016 - Cataloged SQL tables, revised STATA script (STATAdatasetup2.do) to include ratios, replace cashflow with ebitda, and filter out firms smaller than $50 million

07/19/2016 - Investigated baseline hazard of Cox Proportional Hazard model. Compared to Lognormal and Loglogistic Accelerated Failure Time models to try to predict hazard rate (not just hazard ratio)

07/20/2016 - Adjusted dataset to filter out firms that are small (<$40m) or not listed in major exchanges (AMEX, NYSE, NASDAQ). Consulted Brian on descriptive statistics of dataset.

07/21/2016 - Investigated negative ebitda ratios.

07/22/2016 - Performed further testing of hazard model. Ran preliminary matching analysis using patent flow data.

07/25/2016 - Cleaned data setup do file. Organized list of data problems to consult with Ed.