How to Export Your ThinkorSwim Trades to a Journal
ThinkorSwim's Account Statement has all your data. Here's exactly how to get it out and into a journal that actually organizes your options strategies.
No credit card · Import your first CSV in seconds
The problem
Why this is harder than it looks
ThinkorSwim stores your complete trade history, but getting it into a usable format is surprisingly painful. The Account Statement CSV includes cash transactions, dividends, fees, and trades all mixed together. Options trades show up as individual fills — your iron condor appears as four separate lines with no connection between them. Most journaling tools can't parse the TOS format natively, leaving you to manually clean the data in Excel.
Using the ThinkorSwim web app for export — the CSV format differs from the desktop app and may miss fields
Selecting too narrow a date range, missing the opening fills for open positions
Trying to manually clean the CSV before importing — OptionsEdge handles TOS formatting natively
Importing the same date range twice without checking for duplicates — OptionsEdge dedupes automatically, but it's good to know
Step by step
Here's how to do it
Open ThinkorSwim Account Statement
In the ThinkorSwim desktop app, go to the Monitor tab and select Account Statement. This view shows all your account activity organized by date.
Use the desktop app, not the web version — the desktop app's CSV export is more complete and consistent.
Set your date range
Select the date range you want to export. For a complete journal, choose a range that covers all positions you want to track — including any that are still open. You can always re-import later to add new activity.
If you have open positions, make sure your start date goes back to when they were opened so all fills are captured.
Export as CSV
Click the export button (top-right area of the Account Statement). Save the file as CSV. The exported file will contain all trades, cash transactions, and account activity for your selected range.
Import into OptionsEdge
Go to the OptionsEdge Import page and upload your TOS CSV. OptionsEdge recognizes the ThinkorSwim format automatically — it filters out non-trade rows (fees, dividends, cash movements) and parses option symbols from the OCC format.
Review grouped positions
After import, OptionsEdge auto-groups your fills into strategy positions. Vertical spreads, iron condors, strangles, and other multi-leg trades appear as single positions. Check the Positions page to verify everything looks correct.
If you see any positions that seem split incorrectly, you can manually merge them from the position detail page.
Watch out
Common mistakes to avoid
Using the ThinkorSwim web app for export — the CSV format differs from the desktop app and may miss fields
Selecting too narrow a date range, missing the opening fills for open positions
Trying to manually clean the CSV before importing — OptionsEdge handles TOS formatting natively
Importing the same date range twice without checking for duplicates — OptionsEdge dedupes automatically, but it's good to know
The easier way
How OptionsEdge handles this for you
Native ThinkorSwim CSV parser — no manual data cleaning or column mapping needed
Automatically filters out non-trade rows like dividends, fees, and cash movements
Parses OCC option symbols to extract underlying, strike, expiration, and type
Deduplicates fills on re-import — safe to upload overlapping date ranges
Auto-groups fills into multi-leg strategy positions after import
Keep reading
Related guides
Your TOS trades, organized automatically.
Upload your ThinkorSwim CSV and see every multi-leg strategy grouped into clean positions. Free to start.
Import Your First CSV Free