{"id":47,"date":"2017-09-30T11:55:51","date_gmt":"2017-09-30T09:55:51","guid":{"rendered":"https:\/\/www.pschatzmann.ch\/home\/?p=47"},"modified":"2020-11-21T22:22:53","modified_gmt":"2020-11-21T21:22:53","slug":"edgar","status":"publish","type":"post","link":"https:\/\/www.pschatzmann.ch\/home\/2017\/09\/30\/edgar\/","title":{"rendered":"EDGAR Filings"},"content":{"rendered":"<p>I was curious about the usefulness of the <a href=\"https:\/\/www.sec.gov\/edgar.shtml\">Edgar<\/a> Database:<\/p>\n<ul>\n<li><em>Is is possible to predict the development of the stock price using the company filings?<\/em><\/li>\n<li><em>Can we predict the total yearly profits for the current year based on the filings of the current months?<\/em><\/li>\n<li><em>Is the overall profitability changing over time: e.g. are companies more profitable because of e.g. Trump?<\/em><\/li>\n<li>Which sectors are making money and which are loosing ?<\/li>\n<li><em>Is there a relationship between profits and losses?<\/em><\/li>\n<li><em>What are the most profitable countries which file in the US?<\/em><\/li>\n<li><em>How good is the quality of the data?<\/em><\/li>\n<li><em>What are the most profitable states?<\/em><\/li>\n<\/ul>\n<p>It is impressive that the US government makes this data available free to use. However the data format and the quantity of information makes it very difficult and the SEC completely fails in providing any reporting functionality which could give some useful insights.<\/p>\n<p><a href=\"http:\/\/rankandfiled.com\/#\/\">http:\/\/rankandfiled.com\/#\/<\/a>\u00a0has some cool overviews but to get an easy access to the content of the quarterly and annual filings we still have to rely on commercial solutions.<\/p>\n<p><span style=\"font-size: 1rem;\">To overcome this obstacle I have made my own free Java Library &#8220;Smart Edgar&#8221; which makes the hard things a little bit easier.<\/span><\/p>\n<p><span style=\"font-size: 1rem;\"> it provides the following functionality:<\/span><\/p>\n<ul>\n<li>Download of XBRL Edgar Filings<\/li>\n<li>Parsing of Filings<\/li>\n<li>Loading of Filings into a SQL Database<\/li>\n<li>A simple but powerful Java API for querying data<\/li>\n<li><a href=\"https:\/\/pschatzmann.ch\/edgar\">A REST service<\/a><\/li>\n<\/ul>\n<p>In order to simplify the task:<\/p>\n<ul>\n<li>I am only loading numeric parameters into the database. So all e.g. html input is skipped<\/li>\n<li>I am updating the database only once per hour with new filings. So there is a delay!<\/li>\n<li>For the time being I am only loading yearly filings. I might decide to load quarterly filings in the future as well<\/li>\n<\/ul>\n<p>Now that I have the data and the <a href=\"https:\/\/www.pschatzmann.ch\/home\/2017\/09\/28\/data-science\/\">toolbox<\/a>, I am ready to answer the questions above.<\/p>\n<p>So stay tuned&#8230;.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I was curious about the usefulness of the Edgar Database: Is is possible to predict the development of the stock price using the company filings? Can we predict the total yearly profits for the current year based on the filings of the current months? Is the overall profitability changing over [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":123,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[4,12],"tags":[],"class_list":["post-47","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-science","category-edgar"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>EDGAR Filings - Phil Schatzmann<\/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.pschatzmann.ch\/home\/2017\/09\/30\/edgar\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"EDGAR Filings - Phil Schatzmann\" \/>\n<meta property=\"og:description\" content=\"I was curious about the usefulness of the Edgar Database: Is is possible to predict the development of the stock price using the company filings? Can we predict the total yearly profits for the current year based on the filings of the current months? Is the overall profitability changing over [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pschatzmann.ch\/home\/2017\/09\/30\/edgar\/\" \/>\n<meta property=\"og:site_name\" content=\"Phil Schatzmann\" \/>\n<meta property=\"article:published_time\" content=\"2017-09-30T09:55:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-11-21T21:22:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.pschatzmann.ch\/wp-content\/uploads\/2017\/09\/wall-street-sign-1475047230WaT.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"225\" \/>\n\t<meta property=\"og:image:height\" content=\"150\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"pschatzmann\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"pschatzmann\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.pschatzmann.ch\\\/home\\\/2017\\\/09\\\/30\\\/edgar\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pschatzmann.ch\\\/home\\\/2017\\\/09\\\/30\\\/edgar\\\/\"},\"author\":{\"name\":\"pschatzmann\",\"@id\":\"https:\\\/\\\/www.pschatzmann.ch\\\/home\\\/#\\\/schema\\\/person\\\/73a53638a4e34e8373405fd737dac9b1\"},\"headline\":\"EDGAR Filings\",\"datePublished\":\"2017-09-30T09:55:51+00:00\",\"dateModified\":\"2020-11-21T21:22:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.pschatzmann.ch\\\/home\\\/2017\\\/09\\\/30\\\/edgar\\\/\"},\"wordCount\":316,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.pschatzmann.ch\\\/home\\\/#\\\/schema\\\/person\\\/73a53638a4e34e8373405fd737dac9b1\"},\"image\":{\"@id\":\"https:\\\/\\\/www.pschatzmann.ch\\\/home\\\/2017\\\/09\\\/30\\\/edgar\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pschatzmann.ch\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/wall-street-sign-1475047230WaT.jpg\",\"articleSection\":[\"Data Science\",\"EDGAR\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.pschatzmann.ch\\\/home\\\/2017\\\/09\\\/30\\\/edgar\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.pschatzmann.ch\\\/home\\\/2017\\\/09\\\/30\\\/edgar\\\/\",\"url\":\"https:\\\/\\\/www.pschatzmann.ch\\\/home\\\/2017\\\/09\\\/30\\\/edgar\\\/\",\"name\":\"EDGAR Filings - Phil Schatzmann\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pschatzmann.ch\\\/home\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.pschatzmann.ch\\\/home\\\/2017\\\/09\\\/30\\\/edgar\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.pschatzmann.ch\\\/home\\\/2017\\\/09\\\/30\\\/edgar\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pschatzmann.ch\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/wall-street-sign-1475047230WaT.jpg\",\"datePublished\":\"2017-09-30T09:55:51+00:00\",\"dateModified\":\"2020-11-21T21:22:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.pschatzmann.ch\\\/home\\\/2017\\\/09\\\/30\\\/edgar\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.pschatzmann.ch\\\/home\\\/2017\\\/09\\\/30\\\/edgar\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.pschatzmann.ch\\\/home\\\/2017\\\/09\\\/30\\\/edgar\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.pschatzmann.ch\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/wall-street-sign-1475047230WaT.jpg\",\"contentUrl\":\"https:\\\/\\\/www.pschatzmann.ch\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/wall-street-sign-1475047230WaT.jpg\",\"width\":225,\"height\":150},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.pschatzmann.ch\\\/home\\\/2017\\\/09\\\/30\\\/edgar\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.pschatzmann.ch\\\/home\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"EDGAR Filings\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.pschatzmann.ch\\\/home\\\/#website\",\"url\":\"https:\\\/\\\/www.pschatzmann.ch\\\/home\\\/\",\"name\":\"Phil Schatzmann Consulting\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.pschatzmann.ch\\\/home\\\/#\\\/schema\\\/person\\\/73a53638a4e34e8373405fd737dac9b1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.pschatzmann.ch\\\/home\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.pschatzmann.ch\\\/home\\\/#\\\/schema\\\/person\\\/73a53638a4e34e8373405fd737dac9b1\",\"name\":\"pschatzmann\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.pschatzmann.ch\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/pschatzmann.png\",\"url\":\"https:\\\/\\\/www.pschatzmann.ch\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/pschatzmann.png\",\"contentUrl\":\"https:\\\/\\\/www.pschatzmann.ch\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/pschatzmann.png\",\"width\":305,\"height\":305,\"caption\":\"pschatzmann\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.pschatzmann.ch\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/pschatzmann.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"EDGAR Filings - Phil Schatzmann","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.pschatzmann.ch\/home\/2017\/09\/30\/edgar\/","og_locale":"en_US","og_type":"article","og_title":"EDGAR Filings - Phil Schatzmann","og_description":"I was curious about the usefulness of the Edgar Database: Is is possible to predict the development of the stock price using the company filings? Can we predict the total yearly profits for the current year based on the filings of the current months? Is the overall profitability changing over [&hellip;]","og_url":"https:\/\/www.pschatzmann.ch\/home\/2017\/09\/30\/edgar\/","og_site_name":"Phil Schatzmann","article_published_time":"2017-09-30T09:55:51+00:00","article_modified_time":"2020-11-21T21:22:53+00:00","og_image":[{"width":225,"height":150,"url":"https:\/\/www.pschatzmann.ch\/wp-content\/uploads\/2017\/09\/wall-street-sign-1475047230WaT.jpg","type":"image\/jpeg"}],"author":"pschatzmann","twitter_card":"summary_large_image","twitter_misc":{"Written by":"pschatzmann","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pschatzmann.ch\/home\/2017\/09\/30\/edgar\/#article","isPartOf":{"@id":"https:\/\/www.pschatzmann.ch\/home\/2017\/09\/30\/edgar\/"},"author":{"name":"pschatzmann","@id":"https:\/\/www.pschatzmann.ch\/home\/#\/schema\/person\/73a53638a4e34e8373405fd737dac9b1"},"headline":"EDGAR Filings","datePublished":"2017-09-30T09:55:51+00:00","dateModified":"2020-11-21T21:22:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pschatzmann.ch\/home\/2017\/09\/30\/edgar\/"},"wordCount":316,"commentCount":0,"publisher":{"@id":"https:\/\/www.pschatzmann.ch\/home\/#\/schema\/person\/73a53638a4e34e8373405fd737dac9b1"},"image":{"@id":"https:\/\/www.pschatzmann.ch\/home\/2017\/09\/30\/edgar\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pschatzmann.ch\/wp-content\/uploads\/2017\/09\/wall-street-sign-1475047230WaT.jpg","articleSection":["Data Science","EDGAR"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.pschatzmann.ch\/home\/2017\/09\/30\/edgar\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.pschatzmann.ch\/home\/2017\/09\/30\/edgar\/","url":"https:\/\/www.pschatzmann.ch\/home\/2017\/09\/30\/edgar\/","name":"EDGAR Filings - Phil Schatzmann","isPartOf":{"@id":"https:\/\/www.pschatzmann.ch\/home\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pschatzmann.ch\/home\/2017\/09\/30\/edgar\/#primaryimage"},"image":{"@id":"https:\/\/www.pschatzmann.ch\/home\/2017\/09\/30\/edgar\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pschatzmann.ch\/wp-content\/uploads\/2017\/09\/wall-street-sign-1475047230WaT.jpg","datePublished":"2017-09-30T09:55:51+00:00","dateModified":"2020-11-21T21:22:53+00:00","breadcrumb":{"@id":"https:\/\/www.pschatzmann.ch\/home\/2017\/09\/30\/edgar\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pschatzmann.ch\/home\/2017\/09\/30\/edgar\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pschatzmann.ch\/home\/2017\/09\/30\/edgar\/#primaryimage","url":"https:\/\/www.pschatzmann.ch\/wp-content\/uploads\/2017\/09\/wall-street-sign-1475047230WaT.jpg","contentUrl":"https:\/\/www.pschatzmann.ch\/wp-content\/uploads\/2017\/09\/wall-street-sign-1475047230WaT.jpg","width":225,"height":150},{"@type":"BreadcrumbList","@id":"https:\/\/www.pschatzmann.ch\/home\/2017\/09\/30\/edgar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pschatzmann.ch\/home\/"},{"@type":"ListItem","position":2,"name":"EDGAR Filings"}]},{"@type":"WebSite","@id":"https:\/\/www.pschatzmann.ch\/home\/#website","url":"https:\/\/www.pschatzmann.ch\/home\/","name":"Phil Schatzmann Consulting","description":"","publisher":{"@id":"https:\/\/www.pschatzmann.ch\/home\/#\/schema\/person\/73a53638a4e34e8373405fd737dac9b1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pschatzmann.ch\/home\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.pschatzmann.ch\/home\/#\/schema\/person\/73a53638a4e34e8373405fd737dac9b1","name":"pschatzmann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pschatzmann.ch\/wp-content\/uploads\/2022\/08\/pschatzmann.png","url":"https:\/\/www.pschatzmann.ch\/wp-content\/uploads\/2022\/08\/pschatzmann.png","contentUrl":"https:\/\/www.pschatzmann.ch\/wp-content\/uploads\/2022\/08\/pschatzmann.png","width":305,"height":305,"caption":"pschatzmann"},"logo":{"@id":"https:\/\/www.pschatzmann.ch\/wp-content\/uploads\/2022\/08\/pschatzmann.png"}}]}},"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/www.pschatzmann.ch\/home\/wp-json\/wp\/v2\/posts\/47","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pschatzmann.ch\/home\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pschatzmann.ch\/home\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pschatzmann.ch\/home\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pschatzmann.ch\/home\/wp-json\/wp\/v2\/comments?post=47"}],"version-history":[{"count":1,"href":"https:\/\/www.pschatzmann.ch\/home\/wp-json\/wp\/v2\/posts\/47\/revisions"}],"predecessor-version":[{"id":2240,"href":"https:\/\/www.pschatzmann.ch\/home\/wp-json\/wp\/v2\/posts\/47\/revisions\/2240"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pschatzmann.ch\/home\/wp-json\/wp\/v2\/media\/123"}],"wp:attachment":[{"href":"https:\/\/www.pschatzmann.ch\/home\/wp-json\/wp\/v2\/media?parent=47"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pschatzmann.ch\/home\/wp-json\/wp\/v2\/categories?post=47"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pschatzmann.ch\/home\/wp-json\/wp\/v2\/tags?post=47"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}