Trade records and reconciliation
thinkorswim Trading Journal
Use thinkorswim’s account records to reconstruct what actually executed before reviewing performance. This guide separates filled trades, simulated paperMoney activity and Strategy Report signals, then shows how to reconcile partial fills without counting them twice.
Prepare the records for your review
- 1
Open the intended account and environment
In thinkorswim desktop, open Monitor → Account Statement. Confirm the account and whether you are reviewing live activity or paperMoney. Record that context with your notes.
- 2
Set the period deliberately
Check the date range and symbol filter. The Account Statement defaults to the last 24 hours. Include earlier opening activity when it is needed to explain a sale in the period.
- 3
Inspect the executions
Expand Trade History to review filled orders and their execution details. For partial fills, distinguish the collapsed order summary from the individual executions beneath it.
- 4
Map only to supported journal fields
Retain the original records and verify a small sample before entering it. For any third-party import, use that journal’s current report and format instructions; this guide does not assert a universal CSV schema. Pineify currently supports manual entry.
Read each statement section on its own terms
thinkorswim distinguishes Order History from filled Trade History and separates cash activity from open positions. The selected date window does not change the year-to-date scope of Commissions YTD. Keep those definitions with your comparison.
Use execution detail for trade matching and cash records for cost reconciliation. Do not append a cash summary as another fill. A deposit or withdrawal is an account cash flow, not a trade win or loss. Missing entry history is a gap to resolve, not permission to assume zero cost.
An average fill and its components describe the same purchase
Fictional stock example in USD: start flat, buy 4 shares at 100 and another 6 at 102, then sell all 10 at 103. Assume no other activity and 2.00 of total transaction costs. The average entry price is 101.20: 1,012 of entry value divided by 10 shares.
The gross result is 1,030 minus 1,012, or 18.00. Net after the assumed costs is 16.00, and the remaining position is zero. Counting a 10-share order summary in addition to the two buy fills would double the purchased quantity.
Choose one detail level for calculation while keeping the other as a cross-check. If only part of a position closes, document the matching method and leave the remaining units open. A rounded display average may not reproduce the exact cash total; retain source precision.
| Execution | Side | Quantity | Price | Gross cash (USD) | Position afterward |
|---|---|---|---|---|---|
| Entry fill 1 | Buy | 4 | 100.00 | −400.00 | 4 |
| Entry fill 2 | Buy | 6 | 102.00 | −612.00 | 10 |
| Exit fill | Sell | 10 | 103.00 | +1030.00 | 0 |
Strategy Report lists suggested trades
The thinkorswim Strategy Report evaluates signals from chart strategies and estimates their P/L. It includes suggested orders, trade results, cumulative P/L and position information. These are model outputs rather than confirmations of trades executed in a brokerage account.
Keep the strategy version, settings, chart interval, data window, sizing and cost assumptions with the report. A difference from live results does not, by itself, identify slippage, missed signals or trader behavior as the cause. Compare the underlying events before assigning an explanation.
paperMoney remains a separate sample
Schwab describes paperMoney as a trading simulation and cautions that it differs from a live account. Use it to practice a process while keeping its records separate from real executions.
Label the environment on every review. Simulated fills do not establish the queue position, liquidity or prices a live order would receive. Combining simulated and real results into one win rate hides this difference.
Compare the same population before comparing results
Use the checklist below for your own reconciliation. It is not a promise that every field exists in a particular export or that Pineify performs the comparison automatically.
Keep old TD Ameritrade records and current Schwab records traceable to their original account, period and format. Check any overlap, transferred position and missing entry history instead of assuming identical schemas or an uninterrupted import.
For multi-leg options, preserve exact contract identities and define the review grouping. A strategy name does not supply missing expiration, strike, multiplier, fees or leg matches. Do not infer options sensitivities or execution-routing quality from a file that lacks the needed observations.
| Comparison item | What to hold consistent | What a mismatch can change |
|---|---|---|
| Environment | Live, paperMoney or historical strategy report | Which results represent actual executions. |
| Population | Account, instruments, dates and opening inventory | Which entries and exits can be matched. |
| Quantity and units | Sizing, exact contracts and multipliers | Cash exposure and calculated P/L. |
| Time | Execution versus signal timestamps and time zone | Which events appear to match. |
| Costs and grouping | Fees, currency treatment and leg or campaign definition | Net results and the number of trades in a win-rate denominator. |
Frequently asked questions
Can I import thinkorswim trades directly into Pineify?
Not currently. Pineify Trading Journal supports manual entry and marks Import History as Coming Soon. This guide provides no thinkorswim CSV parser, paperMoney importer or Strategy Report integration.
Should I use orders or fills to calculate a position?
Use actual executed quantities. An order request, its summary and its component fills are not separate purchases. The worked example reconciles two buy fills and one sell fill without duplication.
Can I combine Strategy Report and live trades in one result?
Keep them separate. Strategy Report evaluates suggested trades from a model; live records describe actual account activity. Compare assumptions and matched events before interpreting a difference.
Can paperMoney predict how my live trades will perform?
It is a simulation and can differ from real execution. It can support process practice, but its results are not proof of future profitability. Do not combine its trades with live-account statistics.
Do older TD Ameritrade files have the same format as current Schwab files?
Do not assume identical fields or coverage. Inspect the original files, account transitions and overlapping dates. Verify a reconciled sample against the destination’s current instructions before any third-party import.
Continue with a reconciled sample
For a manual review, use the Pineify Trading Journal after checking its current fields. For a separate spreadsheet, inspect the Excel journal template and its calculation assumptions. Neither path adds automatic broker import.
Check the general trade-import mapping guide
Published by Pineify, which sells trading software. Instructions use the linked official documentation; examples are fictional reconciliation exercises. No live broker account or third-party import was used to validate this guide. A matching sample tests data handling, not future trading performance.