CW-301e · Module 1

Multi-Period Data Compilation

3 min read

Single-period financial data is a snapshot. Multi-period data is a trajectory. To analyze trends, you need consistent data across 4-8 quarters or 3-5 fiscal years. The challenge is consistency — companies restate prior periods, change segment definitions, adopt new accounting standards, and make acquisitions that distort comparisons. Claude can compile multi-period data, but you must instruct it to flag every restatement and structural change.

The compilation prompt: "Compile the following metrics across the last 8 quarters from these filings: [metric list]. Present as a time-series table. For any quarter where the metric definition changed, a restatement occurred, or an acquisition materially affected the number, add a footnote explaining the discontinuity. Calculate quarter-over-quarter and year-over-year growth rates for each metric." The footnotes transform a misleading trend line into an accurate one.