All ideasMore in Money
Money

The AI cleaned SEC filing data for more than 600 companies after an audit found most split adjustments wrong

A man gave the AI strict tag research tasks and had it work through the whole ticker list again and again, searching and comparing XBRL tags in SEC filings. The pipeline now pulls 10-K and 10-Q filings for more than 600 companies, maps tags onto about 35 financial concepts, and produces cleaned data. Doing 3 tickers by hand had taken him about 3 weeks and still gave wrong data.

How it works

  1. He sets strict, no-regression tag research tasks
  2. The AI searches and compares XBRL tags across the full ticker list, company by company
  3. The pipeline pulls filings for more than 600 companies and maps tags onto about 35 concepts
  4. It works around filings that tag a full year as a quarter, cumulative cash flow, missing fourth quarters, changed tags, and stock splits
  5. It produces cleaned figures with prices added

Why it’s worth knowing

The audit behind the post found 82.7 percent of split adjustments in his old data were wrong, and the fix was an agent rechecking tags across hundreds of companies one by one.

Where it’s from

Summarized from a public post on news.ycombinator.com. See the original ↗

Upgraded prompt

A ready-to-use prompt for this idea, built from research on what makes AI agents do the job right: who the AI should be, the exact steps, and a check to make sure it was done the way you wanted.

1Who the AI should be
2The prompt, with the steps
3The check when it’s done
Upgraded prompts are coming soon.

Try next

MoneyFight every company that shorts me — refunds, appeals, warranties$12,000MoneyIt negotiated my AT&T internet bill down $25 a month, a permanent cut worth $300 a year$300 a yearMoneySign into AT&T, cancel two unused Apple Watch lines, and switch my plan$75 a monthMoneySwitch my car insurance: Liberty Mutual $5,183/yr to Progressive ~$1,488/yr$3,500 a year

Every idea is a real post from someone who tried it, summarized in our words, with a link to the original. App names are swapped for plain words.