{"id":41914,"date":"2026-07-29T12:27:23","date_gmt":"2026-07-29T10:27:23","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/i-built-an-api-that-turns-messy-sec-filings-insider-trades-13f-activist-stakes-into-clean-json-the-month-one-reality-was-ugly\/"},"modified":"2026-07-29T12:27:23","modified_gmt":"2026-07-29T10:27:23","slug":"i-built-an-api-that-turns-messy-sec-filings-insider-trades-13f-activist-stakes-into-clean-json-the-month-one-reality-was-ugly","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/i-built-an-api-that-turns-messy-sec-filings-insider-trades-13f-activist-stakes-into-clean-json-the-month-one-reality-was-ugly\/","title":{"rendered":"I Built An API That Turns Messy SEC Filings (insider Trades, 13F, Activist Stakes) Into Clean JSON. The Month-one Reality Was Ugly."},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>Quick background: public companies have to file everything with the SEC. Who&#8217;s buying their own stock, what hedge funds hold, who just crossed 5% with an activist stake. It&#8217;s all public and free on sec.gov. It&#8217;s also served as XML that makes you want to quit programming, and every filer formats it differently.<\/p>\n<p>Edgrapi does that parsing once and hands it back as clean JSON. One call, one URL. That&#8217;s the product.<\/p>\n<p>Month one taught me things I didn&#8217;t expect.<\/p>\n<p><strong>The data lies if you read it literally.<\/strong> Michael Burry&#8217;s latest fund filing is 66% Palantir and Nvidia. Except they&#8217;re puts, bearish bets. A naive parser reports him as massively long two stocks he&#8217;s actually betting against. Half the fund-tracker tools out there get this wrong, and getting it right turned out to be most of the value.<\/p>\n<p><strong>Postgres quietly broke every login for a week.<\/strong> Worked perfectly on my laptop, failed in production. A floating-point column was rounding my 10-digit timestamps, so every login token was born already expired by about three hours. SQLite stored it fine, Postgres didn&#8217;t. I only caught it because I logged the raw stored value instead of the error message.<\/p>\n<p><strong>Every API call took 2.6 seconds, no matter what.<\/strong> Cheap call, heavy call, same 2.6s. That flatness was the tell: it wasn&#8217;t the work, it was nine database round-trips to a server in another region. Collapsed it to two. It&#8217;s 0.7s now.<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/Capedcrusader1923\"> \/u\/Capedcrusader1923 <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1v9rugz\/i_built_an_api_that_turns_messy_sec_filings\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1v9rugz\/i_built_an_api_that_turns_messy_sec_filings\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-41914 jlk' href='javascript:void(0)' data-task='like' data-post_id='41914' data-nonce='ddd07821da' 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-41914 lc'>0<\/span><\/a><\/div><\/div> <div class='status-41914 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Quick background: public companies have to file everything with the SEC. Who&#8217;s buying their own stock, what&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-41914","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\/41914","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"}],"author":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=41914"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/41914\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=41914"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=41914"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=41914"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}