- Before
- Types thirty-odd numbers per filing into the analyst's models and checks them by hand, six to ten filings a night in season, when the real job is finding the three that are wrong.
- Now
- Opens each model with the column already filled, footed and linked to its pages, decides the few things the agents could not settle and accepts.
Financial data extraction overnight: a 10-Q modeled by the morning meeting
A large accelerated filer with three segments (Flow Control, Motion Systems and Aerospace Components) files its third-quarter 10-Q at 4:12 PM on a Tuesday. The analyst who covers it has a morning meeting at 9:30. Here is how the people work with the agents, screen by screen, in the working solution.
A worked example on sample data. Names, IDs and figures on the screens and in this section come from the demo.
- 014:12 PM, Tuesday
Seven agents fill the new column in 40 seconds
The agentsThe Filing Watcher picks up the 10-Q from EDGAR, matches CIK and ISIN to the issuer and links the 4:05 PM release (8-K Exhibit 99.1) and the deck. The Table Reader reads 84 pages and 63 tables. Units & Periods turns thousands into millions and the deck's “$2.31 billion” into 2,310.0, and derives the quarter's cash flow from nine months: 301.7 − 182.8 = 118.9. The Mapper fills 31 line names, Footing runs 46 checks, Restatement compares history with the last version, and the Model Writer cross-checks the estimates and writes the column.
“Seven agents, 40 seconds, each step on the record. They propose; people decide.”
- 028:06 AM, Wednesday
Good morning: what needs the associate, and what the agents found
Research associateNine of the analyst's 46 names filed since yesterday; eight models are refreshed and one is being read now. Eight decisions wait, the nearest due at 9:30 AM. Overnight findings each carry their page: the industrial's $1.7M segment gap on p.22, a German filer's two units on p.4 and p.9, a Japanese filer's rounded English summary. Asked what could miss its deadline, the Filing Watcher names two models.
Filing Watcher: “Two models: the industrial (3 decisions) and the German drives maker (1 mapping). If they are not accepted by 9:00 AM I escalate to the senior analyst, per the SLA rule.”
- 03In the analyst's model
The new quarter, in the analyst's own grid and line names
Research associateThe new column sits in the analyst's own workbook, beside four quarters of history, the estimate and the difference. Revenue is $814.1M, 1.1% above the $805.0M estimate; Adj. EBITDA ex-SBC is 177.0 against 171.5. A colored corner on each cell says whether it footed, needs the associate, was derived or converted, or is restated history.
“Two decisions need you before 9:30 AM, then you accept the column. Start with the footing: it changes total revenue.”
- 04One click
Each cell carries its lineage back to the page
Research associateThe associate clicks Adj. EBITDA ex-SBC. The lineage shows the filing (8-K Exhibit 99.1, filed 4:05 PM), page 9 with the reconciliation of non-GAAP measures, the table row printed 177.0, no conversion, and the mapping rule learned from 214 of the analyst's decisions. The check ties 136.9 + 27.1 + 9.8 + 3.2 = 177.0. The vendor dataset shows 173.8 because it excludes restructuring; the analyst's definition is kept.
Lineage: filing → page → table row → units and period → mapping → checks → cell.
- 05The amber cell
Segments don't foot, so the agent finds the line instead of plugging
FootingThe three segments add to $812.4M (318.6 + 276.9 + 216.9); consolidated net sales are $814.1M. The Footing agent searched all 48 pages and found “Corporate, other and eliminations” of $1,711 thousand in Note 14, “Segment information”, on page 22, a line missing from the analyst's model. The four prior quarters were short by 1.2, 1.9, 1.4 and 1.6 for the same reason. It proposes a new row, back-filled for four quarters.
Footing: “I found the $1.7M … I will not plug it.” One click opens page 22 with the line highlighted.
- 068:09 to 8:14 AM
A relabel would break the series, so the Mapper asks first
Research associateThe associate adds “Corp & elims rev” and total revenue foots in all five columns. Then the Mapper's question, at 0.91: the deck's “Aftermarket revenue” is now “Aftermarket & services revenue” of $289.0M, including $11.2M of field services previously in equipment revenue (deck p.6, footnote 2). Taking $289.0M as reported would break the analyst's series. The associate keeps it comparable at 277.8 with a new “Field services rev” row, then accepts the column: 33 values, 46 of 46 checks footing, the associate recorded as the maker.
The two choices on screen: “Keep comparable · 277.8, plus a new row ‘Field services rev’ 11.2” or “Take as reported · 289.0, mark a series break”.
- 071:00 AM, in German
A German quarterly beside its English values, each pinned to its page
Units & Periods and MapperA German drives maker's Quartalsmitteilung reports in Tsd. € on page 4 and Mio. € on page 9, with comma decimals; both are converted and revenue ties at €412.4M. “EBIT bereinigt” is a new label: its definition on page 11 excludes restructuring and purchase price allocation, matching the analyst's Adj. EBIT at €42.6M. At 0.89, below the 0.92 threshold, the Mapper asks instead of mapping. For a Japanese precision maker's kessan tanshin, Q2 is derived from the half: ¥48,612M − ¥23,904M = ¥24,708M.
“The English summary rounds revenue to ¥48.6 billion; the agents used the Japanese original, ¥48,612M.”
- 08All morning
What the agents could not settle, each with a proposal and its page
Research associateThe analyst's names show eight exceptions, five still open, and 143 are open across all teams: unmapped lines, failed footings, restatements, units and currency, low scan confidence, period derivations. A small-cap pump maker outside vendor datasets shows a new $1,384K tariff surcharge line the Mapper proposes to keep in revenue with a memo row. A private issuer's scanned 144A noteholder report read at 0.83, 0.61 and 0.82, and is held for a person with the crops.
Table Reader: “I don't guess a digit: type what you see and the Footing agent re-checks it against the covenant table on p.9.”
- 098:31 AM
A different person checks the recast and the footing
Senior analystA bearings business moved from Motion Systems to Flow Control, and an earlier 8-K recast four quarters: last year's third-quarter Flow Control revenue goes from 287.4 to 300.2 and Motion Systems from 262.0 to 249.2. The senior analyst confirms the 16 cells match Exhibit 99.2, that the new row is the reconciling line on p.22 and no plug, that the Aftermarket decision keeps the series comparable, and that there were no overrides. The associate could not have checked their own column.
“You accepted this column, so you cannot check it. A different person checks: the senior analyst.”
- 108:42 AM · published
The new version published, 48 minutes before the morning meeting
Equity research analystBefore the analyst can publish, the restricted list is checked (the issuer is clear in the compliance control room at 8:40 AM), with entitlements and maker-checker: the associate made it, the senior analyst checked it, the analyst publishes. Version 14 goes to the research management system and the workbook, and the portfolio managers who follow the name are notified.
“Publishing writes the new version to the research management system and the workbook. Subscribed portfolio managers are notified.”