Difference between revisions of "Will Cleland (Work Log)"

From edegan.com
Jump to navigation Jump to search
Line 7: Line 7:
 
* 9/1/2016 - Make Wiki Pages for "Winner's Curse," familiarize self with new wiki and plan with team working on "Winner's Curse" if they are in.
 
* 9/1/2016 - Make Wiki Pages for "Winner's Curse," familiarize self with new wiki and plan with team working on "Winner's Curse" if they are in.
 
* 9/6/2016 - Work on Malmendier & Tate variables and finish wiki pages
 
* 9/6/2016 - Work on Malmendier & Tate variables and finish wiki pages
* 9/8/2016 - Met with Amir to go over paper and required variables for measuring CEO over confidence, familiarized myself with Ed's SQL code
+
* 9/8/2016 - Met with Amir to go over paper and required variables for measuring CEO overconfidence, familiarized myself with Ed's SQL code
 
* 9/9/2016 - Talked with Jake and went over Malmendier & Tate paper to find overconfidence measures
 
* 9/9/2016 - Talked with Jake and went over Malmendier & Tate paper to find overconfidence measures
 
* 9/13/2016 - Absent
 
* 9/13/2016 - Absent
* 9/15/2016 - Met with Amir to see which variables to use as proxys for Malmedier & Tate
+
* 9/15/2016 - Met with Amir to see which variables to use as proxies for Malmedier & Tate
 
* 9/20/2016 - Work with Jake to build database (experienced technical difficulties, shout out Harsh)
 
* 9/20/2016 - Work with Jake to build database (experienced technical difficulties, shout out Harsh)
 
* 9/22/2016 - Develop data necessary to measure CEO overconfidence
 
* 9/22/2016 - Develop data necessary to measure CEO overconfidence
 
* 9/23/2016 - Absent
 
* 9/23/2016 - Absent
 
* 9/27/2016 - Potentially upload to Stata to find which CEOs are overconfident and develop a cutoff point
 
* 9/27/2016 - Potentially upload to Stata to find which CEOs are overconfident and develop a cutoff point
* 9/30/2016 - Pull all necessary data and put it in winnerscurse data base
+
* 9/30/2016 - Pull all necessary data and put it in winnerscurse database
 
* 10/1/2016 - Came in with Jake to pull data
 
* 10/1/2016 - Came in with Jake to pull data
* 10/4/2016 - Load data in to database
+
* 10/4/2016 - Load data into database
 
* 10/6/2016 - Load data
 
* 10/6/2016 - Load data
 
* 10/11/2016 - Worked with SDC data from Amir
 
* 10/11/2016 - Worked with SDC data from Amir
Line 34: Line 34:
 
* 11/11/2016 - Narrowed everything down to three tables and narrowed SDC data, all three tables are ready for Join
 
* 11/11/2016 - Narrowed everything down to three tables and narrowed SDC data, all three tables are ready for Join
 
* 11/16/2016- Continued focusing in on the three main tables and explained work to Ed
 
* 11/16/2016- Continued focusing in on the three main tables and explained work to Ed
* 11/18/2016- Ready to Join CRSP data and SDC data, in addition need to work on Malmendier Tate measure which displayed a flaw on second download
+
* 11/18/2016- Ready to Join CRSP data and SDC data, in addition need to work on Malmendier Tate measure which displayed a flaw upon second download
 
* 11/19/2016- Submit final data output still missing distance
 
* 11/19/2016- Submit final data output still missing distance
* 11/29/2016 - Do 20 whatevers
+
* 11/29/2016 - Do 20 whatever's
  
  
 
* 1/25/2017 - Lit Review for potential project
 
* 1/25/2017 - Lit Review for potential project
 
* 1/27/2017 - Help Eliza with SDC and continue lit review
 
* 1/27/2017 - Help Eliza with SDC and continue lit review
 +
* 1/31/2017 - Lit review/discussion with Ed about topic of paper to be published
 +
* 2/1/2017 - Came in to discuss paper and recommendation with Ed
 +
* 2/2/2017 - Begin pulling data from every source 'hard and fast'

Revision as of 11:24, 2 February 2017


Will Cleland Work Logs (log page)

  • 9/1/2016 - Make Wiki Pages for "Winner's Curse," familiarize self with new wiki and plan with team working on "Winner's Curse" if they are in.
  • 9/6/2016 - Work on Malmendier & Tate variables and finish wiki pages
  • 9/8/2016 - Met with Amir to go over paper and required variables for measuring CEO overconfidence, familiarized myself with Ed's SQL code
  • 9/9/2016 - Talked with Jake and went over Malmendier & Tate paper to find overconfidence measures
  • 9/13/2016 - Absent
  • 9/15/2016 - Met with Amir to see which variables to use as proxies for Malmedier & Tate
  • 9/20/2016 - Work with Jake to build database (experienced technical difficulties, shout out Harsh)
  • 9/22/2016 - Develop data necessary to measure CEO overconfidence
  • 9/23/2016 - Absent
  • 9/27/2016 - Potentially upload to Stata to find which CEOs are overconfident and develop a cutoff point
  • 9/30/2016 - Pull all necessary data and put it in winnerscurse database
  • 10/1/2016 - Came in with Jake to pull data
  • 10/4/2016 - Load data into database
  • 10/6/2016 - Load data
  • 10/11/2016 - Worked with SDC data from Amir
  • 10/13/2016 - Absent
  • 10/14/2016 - Meet with Ed, see what needs doing
  • 10/18/2016 - Upload options DB, determine next steps for joining DBs
  • 10/21/2016 - Create new SDC Table, see what Jake and Amir think are next steps
  • 10/25/2016 - Upload new SDC Table, and create other variables
  • 10/27/2016 - Created flattened return table for all acquisitions
  • 10/28/2016 - Created abnormal return for all acquisitions, database space ran out before turnover could be created
  • 11/1/2016 - Continue creating variables for paper (Turnover & Momentum & public/private + discussion)
  • 11/3/2016 - Update wiki page with tasks and create IT Fixed Effect
  • 11/4/2016 - Continue Variable Creation
  • 11/8/2016 - ABSENT
  • 11/10/2016 - Merge my variables and Malmendier & Tate
  • 11/11/2016 - Narrowed everything down to three tables and narrowed SDC data, all three tables are ready for Join
  • 11/16/2016- Continued focusing in on the three main tables and explained work to Ed
  • 11/18/2016- Ready to Join CRSP data and SDC data, in addition need to work on Malmendier Tate measure which displayed a flaw upon second download
  • 11/19/2016- Submit final data output still missing distance
  • 11/29/2016 - Do 20 whatever's


  • 1/25/2017 - Lit Review for potential project
  • 1/27/2017 - Help Eliza with SDC and continue lit review
  • 1/31/2017 - Lit review/discussion with Ed about topic of paper to be published
  • 2/1/2017 - Came in to discuss paper and recommendation with Ed
  • 2/2/2017 - Begin pulling data from every source 'hard and fast'