

{"id":49,"date":"2014-05-07T10:09:26","date_gmt":"2014-05-07T14:09:26","guid":{"rendered":"https:\/\/sites.temple.edu\/lnaveen\/?page_id=49"},"modified":"2024-09-24T13:27:35","modified_gmt":"2024-09-24T17:27:35","slug":"data","status":"publish","type":"page","link":"https:\/\/sites.temple.edu\/lnaveen\/data\/","title":{"rendered":"Data"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-neve-link-color-color has-text-color\">Click on the links below to get the data\/programs<\/h4>\n\n\n\n<p><em>I cannot guarantee the data are error free, although I have spent a ton of time cleaning the data and checking for errors.&nbsp;&nbsp;<\/em><br><em>If you do spot any errors, I would appreciate you letting me know.<\/em><\/p>\n\n\n\n<h3 class=\"wp-block-heading has-neve-link-color-color has-text-color\" style=\"font-style:normal;font-weight:600\">1. Data on CEO Luck and Skill<\/h3>\n\n\n\n<div class=\"wp-block-columns has-nv-text-dark-bg-background-color has-background is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:60%\">\n<h5 class=\"wp-block-heading\">The data span 1992-2014. <\/h5>\n\n\n\n<p><strong>If you use this data, please cite our paper on symmetry in pay for luck:<\/strong><\/p>\n\n\n\n<p><em>Daniel, N.D., Li, Y., and Naveen, L., 2020. Symmetry in Pay for Luck. Review of Financial Studies <\/em>33, 3174\u20133204<em>.<\/em><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p>(i) <a href=\"https:\/\/sites.temple.edu\/lnaveen\/files\/2021\/11\/RFS_payforluck_2020.pdf\">Data Description<\/a>: These are the main luck and skill measures used in our paper (described in the legend to Table 2). Please refer to Daniel, Li, and Naveen (2020) for details on construction.<\/p>\n\n\n\n<p>(ii) <a href=\"https:\/\/sites.temple.edu\/lnaveen\/files\/2023\/07\/luckskill.csv\">Luck and Skill Data<\/a>: Unique identifier is Execucomp variable CO_PER_ROL. The columns correspond to CO_PER_ROL, YEAR, LUCK, SKILL.<\/p>\n<\/div>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading has-neve-link-color-color has-text-color\" style=\"font-style:normal;font-weight:600\">2.Data on Compensation Incentives<\/h3>\n\n\n\n<div class=\"wp-block-columns has-nv-text-dark-bg-background-color has-background is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:60%\">\n<h5 class=\"wp-block-heading\"><strong>The data span 1992-2022. <\/strong><\/h5>\n\n\n\n<p><strong>If you use this data, please cite our incentives&nbsp;paper:<\/strong><\/p>\n\n\n\n<p><em>Coles, J.L., Daniel, N.D., and Naveen, L., 2006. Managerial Incentives and Risk-Taking. &nbsp;Journal of Financial Economics 79, 431-468<\/em><br><br><strong>Also please cite Core and Guay (2002) as our calculations are based on their paper&#8217;s methodology<\/strong>:<\/p>\n\n\n\n<p><em>Core, J., Guay, W., 2002<\/em>. Estimating the value of employee stock option portfolios and their sensitivities to price and volatility. Journal of Accounting Research 40, 613-630. <\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p>(i) &nbsp;<a title=\"Note\" rel=\"noopener noreferrer\" href=\"http:\/\/papers.ssrn.com\/sol3\/papers.cfm?abstract_id=2296381\" target=\"_blank\">Note<\/a><\/p>\n\n\n\n<p>(ii)&nbsp;<a href=\"https:\/\/sites.temple.edu\/lnaveen\/files\/2024\/09\/deltavega2023_for_posting.xlsx\">Compensation&nbsp;Data&nbsp;<\/a>(gvkey, year, co_per_rol, delta, vega, firm-related wealth)<\/p>\n\n\n\n<p>(iii) <a href=\"https:\/\/sites.temple.edu\/lnaveen\/files\/2024\/09\/deltavega_2013.txt\">SAS Program <\/a>(saved as text file since SAS program file not permitted to be posted)<\/p>\n<\/div>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading has-neve-link-color-color has-text-color\" style=\"font-style:normal;font-weight:600\">3. Data on Co-opted Boards<\/h3>\n\n\n\n<div class=\"wp-block-columns has-nv-text-dark-bg-background-color has-background is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:60%\">\n<h5 class=\"wp-block-heading\">The data have been updated and span 1996-2022. <\/h5>\n\n\n\n<p><strong><strong>If you use any of this data, please cite our&nbsp;Co-opted Boards paper:<\/strong><\/strong><\/p>\n\n\n\n<p><strong><em>Coles, J.L., Daniel, N.D., and Naveen, L., 2014.&nbsp; Co-opted Boards.&nbsp; Review of Financial Studies 27, 1751-1796.<\/em><\/strong><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p>(i) <a href=\"https:\/\/sites.temple.edu\/lnaveen\/files\/2020\/11\/co-option_RFS_2014.pdf\">Data description<\/a>:&nbsp;&nbsp;See Appendix of our paper above&nbsp;for &nbsp;working with Riskmetrics data on boards.&nbsp;The appendix also provides a more detailed explanation of these variables.<\/p>\n\n\n\n<p>(ii) <a href=\"https:\/\/sites.temple.edu\/lnaveen\/files\/2023\/07\/cooption2023_for_sharing.xlsx\">Co-Option Data:<\/a>&nbsp;has GVKEY, YEAR, FRACDIRAFTER, FRACDIRAFTERINDEP, TWFRACDIRAFTER, TWFRACDIRAFTERINDEP<br><br>(FRACDIRAFTER, and FRACDIRAFTERINDEP represent co-opted directors and co-opted independent directors as a fraction of the total board; TWFRACDIRAFTER, and TWFRACDIRAFTERINDEP represent the &nbsp;corresponding tenure-weighted measures as defined in our paper)<br><br>(iii) <a href=\"https:\/\/sites.temple.edu\/lnaveen\/files\/2024\/09\/dirid_combinations_2023.xlsx\">Link Data:<\/a> for merging the Riskmetrics data with Compustat.<\/p>\n<\/div>\n<\/div>\n\n\n\n<h5 class=\"wp-block-heading has-neve-link-hover-color-color has-text-color\">The link dataset contains the following variables:<\/h5>\n\n\n\n<ol class=\"wp-block-list has-neve-text-color-color has-nv-text-dark-bg-background-color has-text-color has-background has-medium-font-size\">\n<li>MTGDATE: the date of the annual meeting, in SAS date format (as mentioned in our 2014 paper, we assign directors on the slate at the annual meeting in a given fiscal year as the directors for that year).<\/li>\n\n\n\n<li>PERMNO: CRSP identifier<\/li>\n\n\n\n<li>GVKEY: Compustat identifier<\/li>\n\n\n\n<li>YEAR: fiscal year of data<\/li>\n\n\n\n<li>CUSIP6: six-digit Cusip identifier from ISS\/Riskmetrics in legacy file or first six-digits from ISS\/Riskmetrics directors file<\/li>\n\n\n\n<li>CUSIP8: first eight digits of 9-digit Cusip identifier from ISS\/Riskmetrics<\/li>\n\n\n\n<li>DIDOWN: the director ID created by us as in Coles, Daniel, and Naveen.&nbsp; This should be unique for a given director in the dataset.<\/li>\n\n\n\n<li>LEGACY_DIRECTOR_ID: director ID from ISS\/Riskmetrics directors legacy file<\/li>\n\n\n\n<li>DIRECTOR_DETAIL_ID: director ID from ISS\/Riskmetrics directors file<\/li>\n<\/ol>\n\n\n\n<p class=\"has-neve-text-color-color has-nv-text-dark-bg-background-color has-text-color has-background\">To merge the data with ISS Directors data, match by MEETINGDATE, CUSIP8, and DIRECTOR_DETAIL_ID.<\/p>\n\n\n\n<p class=\"has-neve-text-color-color has-nv-text-dark-bg-background-color has-text-color has-background\">To merge with ISS Directors Legacy data, &nbsp;match by MEETINGDATE, CUSIP6,&nbsp; and LEGACY_DIRECTOR_ID.<\/p>\n\n\n\n<p class=\"has-neve-text-color-color has-nv-text-dark-bg-background-color has-text-color has-background\">There are some filters applied to the data. For example, we start with the CRSP-Compustat merged database from WRDS, so we only have firms that have a match on both CRSP and Compustat.&nbsp; We keep only share codes 10 and 11.&nbsp; There are some other steps during the program where observations get dropped because of additional filters (see appendix of our RFS paper for more details).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Click on the links below to get the data\/programs I cannot guarantee the data are error free, although I have spent a ton of time cleaning the data and checking for errors.&nbsp;&nbsp;If you do spot any errors, I would appreciate you letting me know. 1. Data on CEO Luck and Skill The data span 1992-2014.&hellip;&nbsp;<a href=\"https:\/\/sites.temple.edu\/lnaveen\/data\/\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">Data<\/span><\/a><\/p>\n","protected":false},"author":3049,"featured_media":0,"parent":0,"menu_order":4,"comment_status":"closed","ping_status":"closed","template":"","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"off","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"class_list":["post-49","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/sites.temple.edu\/lnaveen\/wp-json\/wp\/v2\/pages\/49","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sites.temple.edu\/lnaveen\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sites.temple.edu\/lnaveen\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sites.temple.edu\/lnaveen\/wp-json\/wp\/v2\/users\/3049"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.temple.edu\/lnaveen\/wp-json\/wp\/v2\/comments?post=49"}],"version-history":[{"count":11,"href":"https:\/\/sites.temple.edu\/lnaveen\/wp-json\/wp\/v2\/pages\/49\/revisions"}],"predecessor-version":[{"id":677,"href":"https:\/\/sites.temple.edu\/lnaveen\/wp-json\/wp\/v2\/pages\/49\/revisions\/677"}],"wp:attachment":[{"href":"https:\/\/sites.temple.edu\/lnaveen\/wp-json\/wp\/v2\/media?parent=49"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}