{"id":30216,"date":"2024-08-29T20:28:11","date_gmt":"2024-08-29T18:28:11","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/data-set-for-all-sp-500-company-ratios-from-2020-2023\/"},"modified":"2024-08-29T20:28:11","modified_gmt":"2024-08-29T18:28:11","slug":"data-set-for-all-sp-500-company-ratios-from-2020-2023","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/data-set-for-all-sp-500-company-ratios-from-2020-2023\/","title":{"rendered":"Data Set For All S&amp;P 500 Company Ratios From 2020-2023"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>Not sure if I am in the right place but I\u2019m hoping someone can lead me in the right direction atleast. <\/p>\n<p>I am a masters student looking to do a research paper on how data science can be used to find undervalued stocks. <\/p>\n<p>The specific ratios I am looking for is P\/E Ratio P\/B Ratio PEG ratio Dividend yield Debt to equity Return on assets Return on equity EPS EV\/EBITDA Free cash flow <\/p>\n<p>Would also be nice to know the stock price and ticker symbol <\/p>\n<p>An example AAPL 2020 PRICE: X P\/E Ratio: x P\/B Ratio: X PEG ratio: x Dividend yield: x Debt to equity: x Return on assets: x Return on equity: x EPS: x EV\/EBITDA: x Free cash flow: x<\/p>\n<p>Then the next year after:<\/p>\n<p>AAPL 2021 PRICE: X P\/E Ratio: x P\/B Ratio: X PEG ratio: x Dividend yield: x Debt to equity: x Return on assets: x Return on equity: x EPS: x EV\/EBITDA: x Free cash flow: x<\/p>\n<p>Then 2022 and so on till the year 2023.<\/p>\n<p>I am not a cider but I have tried extensively to make a program using Chatgpt and Gemini to scrape the data from multiple sources\u2026.I was able to get a list of everything that I was looking for, For the year 2024 using Yfinance on python but was not able to get the historical data using yfinance. I have tried my hand at trying to scrape the data from EDGAR as well but as I said I am not a coder and could not figure it out. Would be willing to pay 10-50$ for the dataset from a website too but could not find one that was easy to use\/had all the info I was looking for. (I did find one I believe but they wanted $1800 for it) willing to get on a phone call or discord call if that helps. <\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/SadPhone8067\"> \/u\/SadPhone8067 <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1f48v6h\/data_set_for_all_sp_500_company_ratios_from\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1f48v6h\/data_set_for_all_sp_500_company_ratios_from\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-30216 jlk' href='javascript:void(0)' data-task='like' data-post_id='30216' data-nonce='614a020375' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-30216 lc'>0<\/span><\/a><\/div><\/div> <div class='status-30216 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Not sure if I am in the right place but I\u2019m hoping someone can lead me in&#8230;<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-30216","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/30216","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=30216"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/30216\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=30216"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=30216"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=30216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}