{"id":153582,"date":"2024-05-02T11:14:00","date_gmt":"2024-05-02T15:14:00","guid":{"rendered":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/?p=153582"},"modified":"2025-05-02T15:02:52","modified_gmt":"2025-05-02T19:02:52","slug":"using-large-language-models-to-derive-alternative-esg-rankings","status":"publish","type":"post","link":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/using-large-language-models-to-derive-alternative-esg-rankings\/","title":{"rendered":"Using Large Language Models to Derive Alternative ESG Rankings"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Author<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ben Noe<\/li>\n\n\n\n<li>Charlie Krakauer<\/li>\n\n\n\n<li>Sam Arnts<\/li>\n\n\n\n<li>Nick Jiang<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Mentor<\/h2>\n\n\n\n<p>Professor Anand<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Abstract<\/h2>\n\n\n\n<p>Investors and the public alike are becoming increasingly interested in companies\u2019 Environmental, Social, and Governance (ESG) policies. Companies that perform well in ESG tend to be less risky and perform better financially, attracting socially conscious investors and avoiding public disapproval. Currently, company ESG performance is difficult to assess due to a lack of high quality, easy to digest data. We look to use LLMs to create a tool that investors can use to easily and reliably gauge the ESG performance of companies of interest. Retrieval Augmented Generation techniques were used to collect accurate and difficult to obtain ESG statistics for companies of interest. These statistics were fed into a second layer LLM that provided relative ESG ranks among companies. We determined that our custom RAG-solution\u00a0 for deriving ESG indicators performs better than the leading LLMs available today.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"768\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2024\/05\/Poster-Presentation-1-1024x768.png\" alt=\"\" class=\"wp-image-171422\" srcset=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2024\/05\/Poster-Presentation-1-1024x768.png 1024w, https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2024\/05\/Poster-Presentation-1-300x225.png 300w, https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2024\/05\/Poster-Presentation-1-768x576.png 768w, https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2024\/05\/Poster-Presentation-1-1536x1152.png 1536w, https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2024\/05\/Poster-Presentation-1-2048x1536.png 2048w, https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2024\/05\/Poster-Presentation-1-1920x1440.png 1920w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Author Mentor Professor Anand Abstract Investors and the public alike are becoming increasingly interested in companies\u2019 Environmental, Social, and Governance (ESG) policies. Companies that perform well in ESG tend to&hellip;<\/p>\n","protected":false},"author":6242,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[4442,106],"tags":[],"coauthors":[8612],"class_list":["post-153582","post","type-post","status-publish","format-standard","hentry","category-archive","category-dsc-archive"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Using Large Language Models to Derive Alternative ESG Rankings - Senior Design Day<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/using-large-language-models-to-derive-alternative-esg-rankings\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Large Language Models to Derive Alternative ESG Rankings - Senior Design Day\" \/>\n<meta property=\"og:description\" content=\"Author Mentor Professor Anand Abstract Investors and the public alike are becoming increasingly interested in companies\u2019 Environmental, Social, and Governance (ESG) policies. Companies that perform well in ESG tend to&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/using-large-language-models-to-derive-alternative-esg-rankings\/\" \/>\n<meta property=\"og:site_name\" content=\"Senior Design Day\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-02T15:14:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-02T19:02:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2024\/05\/Poster-Presentation-1-1200x630.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/using-large-language-models-to-derive-alternative-esg-rankings\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/using-large-language-models-to-derive-alternative-esg-rankings\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/#\\\/schema\\\/person\\\/351018fbcf84ed8cac6d8072ba5b347c\"},\"headline\":\"Using Large Language Models to Derive Alternative ESG Rankings\",\"datePublished\":\"2024-05-02T15:14:00+00:00\",\"dateModified\":\"2025-05-02T19:02:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/using-large-language-models-to-derive-alternative-esg-rankings\\\/\"},\"wordCount\":159,\"image\":{\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/using-large-language-models-to-derive-alternative-esg-rankings\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/Poster-Presentation-1-1024x768.png\",\"articleSection\":[\"3. Programs Archive\",\"DSC Archive\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/using-large-language-models-to-derive-alternative-esg-rankings\\\/\",\"url\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/using-large-language-models-to-derive-alternative-esg-rankings\\\/\",\"name\":\"Using Large Language Models to Derive Alternative ESG Rankings - Senior Design Day\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/using-large-language-models-to-derive-alternative-esg-rankings\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/using-large-language-models-to-derive-alternative-esg-rankings\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/Poster-Presentation-1-1024x768.png\",\"datePublished\":\"2024-05-02T15:14:00+00:00\",\"dateModified\":\"2025-05-02T19:02:52+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/#\\\/schema\\\/person\\\/351018fbcf84ed8cac6d8072ba5b347c\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/using-large-language-models-to-derive-alternative-esg-rankings\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/using-large-language-models-to-derive-alternative-esg-rankings\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/using-large-language-models-to-derive-alternative-esg-rankings\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/Poster-Presentation-1.png\",\"contentUrl\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/Poster-Presentation-1.png\",\"width\":2500,\"height\":1875},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/using-large-language-models-to-derive-alternative-esg-rankings\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Large Language Models to Derive Alternative ESG Rankings\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/#website\",\"url\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/\",\"name\":\"Senior Design Day\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/#\\\/schema\\\/person\\\/351018fbcf84ed8cac6d8072ba5b347c\",\"name\":\"admin\",\"url\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/author\\\/seniordesign\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using Large Language Models to Derive Alternative ESG Rankings - Senior Design Day","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/using-large-language-models-to-derive-alternative-esg-rankings\/","og_locale":"en_US","og_type":"article","og_title":"Using Large Language Models to Derive Alternative ESG Rankings - Senior Design Day","og_description":"Author Mentor Professor Anand Abstract Investors and the public alike are becoming increasingly interested in companies\u2019 Environmental, Social, and Governance (ESG) policies. Companies that perform well in ESG tend to&hellip;","og_url":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/using-large-language-models-to-derive-alternative-esg-rankings\/","og_site_name":"Senior Design Day","article_published_time":"2024-05-02T15:14:00+00:00","article_modified_time":"2025-05-02T19:02:52+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2024\/05\/Poster-Presentation-1-1200x630.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/using-large-language-models-to-derive-alternative-esg-rankings\/#article","isPartOf":{"@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/using-large-language-models-to-derive-alternative-esg-rankings\/"},"author":{"name":"admin","@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/#\/schema\/person\/351018fbcf84ed8cac6d8072ba5b347c"},"headline":"Using Large Language Models to Derive Alternative ESG Rankings","datePublished":"2024-05-02T15:14:00+00:00","dateModified":"2025-05-02T19:02:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/using-large-language-models-to-derive-alternative-esg-rankings\/"},"wordCount":159,"image":{"@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/using-large-language-models-to-derive-alternative-esg-rankings\/#primaryimage"},"thumbnailUrl":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2024\/05\/Poster-Presentation-1-1024x768.png","articleSection":["3. Programs Archive","DSC Archive"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/using-large-language-models-to-derive-alternative-esg-rankings\/","url":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/using-large-language-models-to-derive-alternative-esg-rankings\/","name":"Using Large Language Models to Derive Alternative ESG Rankings - Senior Design Day","isPartOf":{"@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/using-large-language-models-to-derive-alternative-esg-rankings\/#primaryimage"},"image":{"@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/using-large-language-models-to-derive-alternative-esg-rankings\/#primaryimage"},"thumbnailUrl":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2024\/05\/Poster-Presentation-1-1024x768.png","datePublished":"2024-05-02T15:14:00+00:00","dateModified":"2025-05-02T19:02:52+00:00","author":{"@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/#\/schema\/person\/351018fbcf84ed8cac6d8072ba5b347c"},"breadcrumb":{"@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/using-large-language-models-to-derive-alternative-esg-rankings\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hajim.rochester.edu\/senior-design-day\/using-large-language-models-to-derive-alternative-esg-rankings\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/using-large-language-models-to-derive-alternative-esg-rankings\/#primaryimage","url":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2024\/05\/Poster-Presentation-1.png","contentUrl":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2024\/05\/Poster-Presentation-1.png","width":2500,"height":1875},{"@type":"BreadcrumbList","@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/using-large-language-models-to-derive-alternative-esg-rankings\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/"},{"@type":"ListItem","position":2,"name":"Using Large Language Models to Derive Alternative ESG Rankings"}]},{"@type":"WebSite","@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/#website","url":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/","name":"Senior Design Day","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/#\/schema\/person\/351018fbcf84ed8cac6d8072ba5b347c","name":"admin","url":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/author\/seniordesign\/"}]}},"_links":{"self":[{"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/posts\/153582","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/users\/6242"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/comments?post=153582"}],"version-history":[{"count":2,"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/posts\/153582\/revisions"}],"predecessor-version":[{"id":171432,"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/posts\/153582\/revisions\/171432"}],"wp:attachment":[{"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/media?parent=153582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/categories?post=153582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/tags?post=153582"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/coauthors?post=153582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}