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

From edegan.com
Jump to navigation Jump to search
imported>WillC
 
(42 intermediate revisions by 4 users not shown)
Line 1: Line 1:
[[Will Cleland]] [[Work Logs]] [[Will Cleland (Work Log)|(log page)]]
+
<onlyinclude>[[Will Cleland]] [[Work Logs]] [[Will Cleland (Work Log)|(log page)]]</onlyinclude>
  
20160210 (Wed) 2:30 - Finish reading NHL paper, determine necessary variables for paper, find variables in SQL code
+
===Fall 2016===
  
20160210 (Wed) 5:30 - Read paper, and created list of necessary variables and where to find them
+
* 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
  
20160211 (Thur) 2:30 - Update NHL page with all work done so far created new dropbox with necessary files and variables and where to find them
+
===Spring 2017===
  
20160211 (Thur) 5:30 - Updated page and dropbox worked with Ed to determine create final list of necessary information in order to begin downloads
+
* 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
  
20160216 (Tue) 2:30 - Download all of the databases in order to begin creating master table and get as far as possible on master table
+
[[Category:Work Log]]
 
 
20160216 (Tue) 5:30 - Downloaded databases and found distinct player-seasons to help begin join
 
 
 
20160217 (Wed) 2:30 - Continue working on the master table, today we want to count unique data entries in each table to facilitate the join and whatever else is needed.
 
 
 
20160217 (Wed) 5:30 - Created new tables for each of the original tables where all player-seasons are unique.
 
 
 
20160219 (Fri) 2:00 - Join tables
 
 
 
20160219 (Fri) 6:00 - Joined everything except the  Cap Geek Table
 
 
 
20160222 (Mon) 2:00 - Join the CapGeek Table to the other tables
 
 
 
20160222 (Mon) 5:45 - Reformatted date of birth, team, and season entries in order to begin fuzzy matching
 
 
 
20160224 (Wed) 2:10 - Set up Fuzzy Match and do it
 
 
 
20160224 (Wed) 5:19 - Fuzzy Matched
 
 
 
20160226 (Fri) 2:00 - Sort through fuzzy matched and determine exceptions so that we can join tables
 
 
 
20160226 (Fri) 5:00 - Refined fuzzy match search and began search
 
 
 
20160307 (Mon) 2:00 - Sort through Fuzzy Match
 
 
 
20160307 (Mon) 6:00 - Found path and set up terminal, fixed date of birth issue, learned how to join bios and historical table with bios data
 
 
 
20160308 (Tue) 2:30 - join bios and historical table
 
 
 
20160308 (Tue) 5:30 - joined tables and cleaned up previous work, ready to begin fuzzy match again
 
 
 
20160309 (Wed) 2:10 - fuzzy match or pull new NHL data
 
 
 
20160309 (Wed) 5:25 - Pulled all the new NHL for the 2014 season and added this data to the NHL database
 
 
 
20160314 (Mon) 1:59 - Continue pulling NHL data and see where Sahil is on Fanager webcrawler
 
 
 
20160314 (Mon) 5:13 - Pulled all of NHL 2015 season data and wrote SQL to join tables to create comprehensive data on NHL statistics
 
 
 
20160316 (Wed) 2:00 - Finish compiling NHL data and if Sahil is done fuzzy match Fanager data
 
 
 
20160316 (Wed) 3:45 - Finished compiling all of the NHL data and am now waiting for the Fanager info
 
 
 
20160318 (Fri) 2:00 - Check to see how far Sahil is on the crawler and decide what I do today
 
 
 
20160318 (Fri) 5:00 - Finished uploading Fanager data to NHL database and had the team meeting
 
 
 
20160321 (Mon) 2:00 - Fuzzy Match Fanager to NHL data
 
 
 
20160321 (Mon) 5:00 - Cleaned fanager data and now ready to match with capgeek data
 
 
 
20160323 (Wed) 2:00 - Join fanager data with capgeek data and fuzzy match if there is time
 
 
 
20160323 (Wed) 5:20 - Fuzzy matching fanager data with capgeek data
 
 
 
20160325 (Fri) 2:00 - Finish Fuzzy Matching fanager and capgeek data
 
 
 
20160325 (Fri) 5:00 - Rewrote lost code and  began fuzzy matching again
 
 
 
20160328 (Mon) 2:00 - Continue match fanager and capgeek
 
 
 
20160328 (Mon) 4:30 - Almost done with the match
 
 
 
20160330 (Wed) 2:00 - Fuzzy match capgeek and fanager data
 
 
 
20160330 (Wed) 5:30 - FUZZY MATCHED
 
 
 
20160406 (Wed) 2:00 - Fuzzy match nhl and salary data
 
 
 
20160406 (Wed) 5:07 - Fuzzy matched em
 
 
 
20160407 (Thu) 2:27 - Work on finalizing data set and getting a finished project to Jim
 
 
 
20160407 (Thu) 6:48 - added some variables need others
 
 
 
20160408 (Fri) 2:00 - finalize the data and put it in stata for Jim
 
 
 
20160408 (Fri) 5:00 - Helped Kunal set up matching, cleaned up data and found additional potential variables and info
 
 
 
20160411 (Mon) 2:00 - Work on adding 2015 data and Kunals code for contract type
 
 
 
20160411 (Mon) 5:45 -  Added 2015 data and contract type next step is CPI and tenure
 
 
 
20160412 (Tue) 2:30 - Finish NHL data set
 
 
 
20160412 (Tue) 6:40 - Everything done except the contract type which CS guys will fix tomorrow
 
 
 
20160413 (Wed) 2:00 - Work through final problem and submit dataset
 
 
 
20160413 (Wed) 6:40 - Almost done except for the contract type is still incorrect
 
 
 
20160414 (Thu) 2:35 - Finish NHL dataset
 
 
 
20160414 (Thu) 6:50 - Finished NHL dataset and submitted to Jim
 

Latest revision as of 12: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