Fidelity investment report (brokerage statement). Scope everything to account 111-111111 (John W. Doe Individual TOD) only; ignore the other accounts (222, 333) and the combined portfolio totals. Dollar amounts are plain numbers without $ or thousands separators; negatives keep their sign. Keep holdings and activity as two SEPARATE top-level arrays; do not nest them. holdings is the per-position Holdings section for account 111 (core account, mutual funds, ETPs, stocks, bonds, other) with description, quantity, price, ending value and cost basis. activity is the per-transaction Activity section for account 111 (securities bought & sold, dividends/interest/income, deposits, withdrawals, etc.); transaction dates print as M/D within the July 2015 period, so normalize to YYYY-MM-DD using year 2015. Reconciliation: endingAccountValue equals beginningAccountValue plus additions plus subtractions plus changeInInvestmentValue for the period. Column discipline: securityName is the security-name column only and transactionDescription is the description column only; do not let adjacent columns (the ticker/CUSIP symbol column, the check-number column, or a reference column) bleed into either field, and when a cell is blank leave the field null rather than borrowing an adjacent column's value.
