Difference between revisions of "Will Cleland (Work Log)"
Jump to navigation
Jump to search
| (34 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | <onlyinclude>[[Will Cleland]] [[Work Logs]] [[Will Cleland (Work Log)|(log page)]]</onlyinclude> | |
| − | [[Will Cleland]] [[Work Logs]] [[Will Cleland (Work Log)|(log page)]] | + | |
| + | ===Fall 2016=== | ||
* 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 | + | * 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 | + | * 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 | + | * 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 | + | * 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 20: | Line 21: | ||
* 10/14/2016 - Meet with Ed, see what needs doing | * 10/14/2016 - Meet with Ed, see what needs doing | ||
* 10/18/2016 - Upload options DB, determine next steps for joining DBs | * 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 | ||
| + | |||
| + | ===Spring 2017=== | ||
| + | |||
| + | * 1/26/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' | ||
| + | * 2/3/2017 - Created basic IPO birth rate graph, now will create others and pull SDC if time allows | ||
| + | * 2/7/2017 - Met with Ed to get a better direction for paper | ||
| + | * 2/14/2017 - Absent | ||
| + | * 2/16/2017 - Absent | ||
| + | * 2/17/2017 - Work towards goals established after meeting with Ed and pull more data | ||
| + | * 2/21/2017 - Work towards goals established after meeting with Ed and pull more data Pt.2 | ||
| + | * 2/24/2017 - Data does not look like what other papers have so I will take a CRSP approach today | ||
| + | * 2/28/2017 - I will contact Ed and get his view on the CRSP data I have compiled then see how to proceed | ||
| + | * 3/2/2017 - Rework project page and work on new to do list starting at graph of financial companies | ||
| + | * 3/3/2017 - Find delisting rates and add delisting code to my work to break out delistings, pull acquisition data from SDC, help others with SQL | ||
| + | * 3/7/2017 - Track IPOs using CRSP, finish SDC pull from yesterday | ||
| + | * 3/9/2017 - Find source of error in delisting codes from CRSP versus SQL method of finding delistings | ||
| + | * 3/21/2017 - Determine source of error in delisting codes | ||
| + | * 3/23/2017 - Redo bankruptcy codes and merge CRSP and Compustat data | ||
| + | * 3/24/2017 - Merge CRSP + Compustat | ||
| + | * 3/28/2017 - Meet with Ed to discuss the next steps, try to redo SDC pull, look at returns of stocks over time to compare to # of companies | ||
| + | * 3/30/2017 - Redo SDC Pull | ||
| + | * 4/4/2017 - CRSP work to fix some graphs | ||
| + | * 4/6/2017 - Attempt SDC Pull -- spoiler it didn't work | ||
| + | * 4/7/2017 - SDC Pull for real this time and data cleaning | ||
| + | * 4/14/2017 - Work with SDC again | ||
| + | |||
| + | [[Category:Work Log]] | ||
Latest revision as of 11:20, 2 November 2017
Will Cleland Work Logs (log page)
Fall 2016
- 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
Spring 2017
- 1/26/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'
- 2/3/2017 - Created basic IPO birth rate graph, now will create others and pull SDC if time allows
- 2/7/2017 - Met with Ed to get a better direction for paper
- 2/14/2017 - Absent
- 2/16/2017 - Absent
- 2/17/2017 - Work towards goals established after meeting with Ed and pull more data
- 2/21/2017 - Work towards goals established after meeting with Ed and pull more data Pt.2
- 2/24/2017 - Data does not look like what other papers have so I will take a CRSP approach today
- 2/28/2017 - I will contact Ed and get his view on the CRSP data I have compiled then see how to proceed
- 3/2/2017 - Rework project page and work on new to do list starting at graph of financial companies
- 3/3/2017 - Find delisting rates and add delisting code to my work to break out delistings, pull acquisition data from SDC, help others with SQL
- 3/7/2017 - Track IPOs using CRSP, finish SDC pull from yesterday
- 3/9/2017 - Find source of error in delisting codes from CRSP versus SQL method of finding delistings
- 3/21/2017 - Determine source of error in delisting codes
- 3/23/2017 - Redo bankruptcy codes and merge CRSP and Compustat data
- 3/24/2017 - Merge CRSP + Compustat
- 3/28/2017 - Meet with Ed to discuss the next steps, try to redo SDC pull, look at returns of stocks over time to compare to # of companies
- 3/30/2017 - Redo SDC Pull
- 4/4/2017 - CRSP work to fix some graphs
- 4/6/2017 - Attempt SDC Pull -- spoiler it didn't work
- 4/7/2017 - SDC Pull for real this time and data cleaning
- 4/14/2017 - Work with SDC again
