{"id":633,"date":"2020-10-29T10:42:50","date_gmt":"2020-10-29T09:42:50","guid":{"rendered":"https:\/\/blog.iese.edu\/newsletter-library\/?p=633"},"modified":"2020-10-29T10:38:59","modified_gmt":"2020-10-29T09:38:59","slug":"86-resources-tip","status":"publish","type":"post","link":"https:\/\/blog.iese.edu\/newsletter-library\/86-resources-tip\/","title":{"rendered":"How to Pull Up the CGSCORE for a Country?"},"content":{"rendered":"<p style=\"text-align: justify\"><strong><em><span style=\"color: #999999\">&gt;\u00a0<\/span><a href=\"https:\/\/prdt.iese.edu\/library\/library-newsletter-86\" target=\"_blank\" rel=\"noopener noreferrer\"><span style=\"color: #ff0000\"><span style=\"color: #999999\">Return to the #86 Newsletter<\/span><\/span><\/a><\/em><\/strong><\/p>\n<hr \/>\n<p style=\"text-align: justify\">Go to <strong>Eikon<\/strong> and open the Screener App.<br \/>\nOnce on the Screener app, set the following filters:<\/p>\n<p style=\"text-align: justify;padding-left: 40px\"><strong>1. <\/strong>Set &#8220;Universe&#8221; to &#8220;Public Companies&#8221;.<br \/>\n<strong>2.<\/strong> Insert the designated filter for &#8220;Country of Headquarters&#8221; and set it to any country of your choice.<br \/>\n<strong>3.<\/strong> Click on the 3-line bar data item tab in the middle of the screen.<br \/>\n<strong>4.<\/strong> Once you have the Data Item Library open, key in &#8220;Governance Pillar&#8221; as your key word search and select &#8220;Governance Pillar Score&#8221; as it displays on the auto suggest.<br \/>\n<strong>5.<\/strong>\u00a0Tick on the &#8220;Series&#8221; tick box to pull up historical data.<br \/>\n<strong>6.<\/strong> Set your time range.<br \/>\n<strong>7.<\/strong> Click OK to get the results. You may export them to excel by clicking the drop down box of the excel icon in the top right-hand corner. You can select &#8220;Export as values&#8221; or &#8220;Export as formulas&#8221;.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&gt;\u00a0Return to the #86 Newsletter Go to Eikon and open the Screener App. Once on the Screener app, set the following filters: 1. Set &#8220;Universe&#8221; to &#8220;Public Companies&#8221;. 2. Insert the designated filter for &#8220;Country of Headquarters&#8221; and set it to any country of your choice. 3. Click on the 3-line bar data item tab in the middle of the screen. 4. Once you have the Data Item Library open,&#8230; <\/p>\n<div class=\"more-link-container\"><a class=\"continue-reading-link\" href=\"https:\/\/blog.iese.edu\/newsletter-library\/86-resources-tip\/\">Read More<\/a><\/div>\n","protected":false},"author":168,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[94996,94970],"tags":[],"class_list":["post-633","post","type-post","status-publish","format-standard","hentry","category-86-october-2020","category-resources-tip"],"_links":{"self":[{"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/posts\/633","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/users\/168"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/comments?post=633"}],"version-history":[{"count":2,"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/posts\/633\/revisions"}],"predecessor-version":[{"id":635,"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/posts\/633\/revisions\/635"}],"wp:attachment":[{"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/media?parent=633"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/categories?post=633"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/tags?post=633"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}