How to Analyze Your ThinkOrSwim CSV Export (Step-by-Step)
February 2025 · 8 min read
ThinkOrSwim records every fill you make. But raw fills aren't insights — they're noise. This guide shows you how to export your TOS account statement and turn it into clear, actionable analytics in minutes.
Step 1: Export Your TOS Account Statement
ThinkOrSwim stores your full trade history in the Account Statement — accessible from the Monitor tab.
1Open ThinkOrSwim → click the Monitor tab at the top
2Select Account Statement from the sub-tabs
3Set your date range (we recommend at least 90 days for meaningful analytics)
4Click Export to File in the top right → choose CSV format
5Save the file to your desktop
Tip: Make sure the exported file includes the "Account Trade History" section. This is the section with individual fills — it's what analytics tools use for reconstruction.
Step 2: What's Actually in the CSV?
The TOS Account Statement CSV contains several sections. The most important for analytics is Account Trade History, which includes:
→ Exec time (date + time of fill)
→ Spread (strategy type hint)
→ Side (BUY_TO_OPEN, SELL_TO_CLOSE, etc.)
→ Quantity filled
→ Position (underlying + contract details)
→ Price (fill price)
→ Commissions + fees
Raw, these look like dozens of disconnected rows for a single spread trade. The magic happens when you reconstruct them into complete strategies.
Step 3: Upload to InsightTrader
Rather than building your own spreadsheet logic (which takes hours and breaks constantly), upload your CSV directly to InsightTrader. The platform automatically:
✓ Parses every fill from your TOS export
✓ Groups fills into complete trades (spreads, condors, single legs)
✓ Calculates true net P&L including all commissions and fees
✓ Computes your win rate, profit factor, and drawdown automatically
✓ Flags trading patterns like revenge trading and overtrading
Step 4: Interpret Your Key Metrics
Once your trades are imported, InsightTrader calculates dozens of performance metrics. Here are the most important ones to understand:
→Win rate: Percentage of profitable trades. See our guide on win rate vs profit factor to understand why this metric alone can be misleading.
→Profit factor: Ratio of gross profit to gross loss. A profit factor above 1.5 is generally considered strong. Learn more about options trading metrics to track.
→Expectancy: Average profit per trade. This tells you if your strategy is profitable over time. Read our expectancy calculation guide.
→Max drawdown: Largest peak-to-trough decline. Critical for understanding your risk exposure.
Once your TOS data is loaded, here's what to look at first:
Win Rate
What it is: The % of trades that closed profitable.
Key insight: If it's below 50%, focus on trade selection. If it's above 70% but P&L is flat, your losers are too large.
Profit Factor
What it is: Gross profit ÷ gross loss.
Key insight: Anything above 1.5 is solid. Below 1.0 means you're losing money regardless of win rate.
P&L by Day of Week
What it is: Your net profitability on each weekday.
Key insight: Most traders have 1–2 bad days per week. If Monday is always negative, that's a pattern worth acting on.
Max Drawdown
What it is: The largest peak-to-trough loss in your account.
Key insight: This tells you how much capital you need to weather your worst stretch. If it surprises you, position sizing needs adjustment.
⚠Revenge trading: Did you immediately open a new trade after a loss, and lose again?
⚠Overtrading windows: Are there 1–2 hour windows where most of your losses concentrate?
⚠Winner cutting: Do you close profitable trades too early, leaving premium on the table?
⚠Sizing inconsistency: Do you trade larger after losses, trying to recover quickly?
Common TOS Export Issues (and Fixes)
❓ Export only shows recent 90 days
Fix: TOS limits the date picker in the UI. Try exporting in 3-month batches and uploading multiple files.
❓ Some fills are missing
Fix: Make sure "Account Trade History" is included in the export. In some TOS versions you need to expand this section before exporting.
❓ Spreads show as individual legs
Fix: This is normal — TOS always records individual fills. InsightTrader automatically groups them back into complete strategies.
The Bottom Line
Your TOS data contains everything you need to become a significantly better trader. The raw CSV is a starting point — what matters is reconstruction, aggregation, and edge analysis. Manual spreadsheets can do it, but they take days to build and break with every export format change.
InsightTrader does all of it automatically. Import once, analyze indefinitely.
Try It With Your Own TOS Data
Free plan includes 30 days of history and 5 imports. No credit card required.
