Thinkorswim Trade History Cleaner
Upload your Thinkorswim trade history export and automatically extract ticker symbols for easier trade journaling. The tool adds a Ticker column so you can filter and summarize trades more easily.
Your file stays on your device
Your file is processed locally in your browser. It is not uploaded to our server, stored, or shared.
Works with Thinkorswim .csv and .xlsx exports, up to 10 MB. Everything runs in your browser.
What this tool does
Thinkorswim exports bury the useful ticker symbol inside a longer transaction description, which makes
the data hard to sort, filter, and summarize. This tool reads the description column, extracts the
underlying ticker, and inserts a new Ticker column right after it - so a row like
BOT +1 ORCL 100 19 JUL 24 140 CALL gets a clean
ORCL next to it. It is conservative on purpose:
cash, interest, dividend, and transfer rows are left blank rather than guessed.
| Transaction description | Extracted ticker |
|---|---|
BOT +1 ORCL 100 19 JUL 24 140 CALL | ORCL |
SOLD -1 VERTICAL QQQ 100 20 SEP 24 470/475 CALL | QQQ |
BOT +1 DIAGONAL AAPL 100 19 JUL 24 200 CALL | AAPL |
ASG 100 TSLA | TSLA |
INTEREST ADJUSTMENT | (left blank) |
Why extract ticker symbols from Thinkorswim exports?
A clean ticker column makes it far easier to:
- Filter and sort your trades by symbol
- Summarize profit and loss per ticker
- Import the data into a spreadsheet or trade journal
- Review your options strategies by underlying
Notes & limitations
- The tool looks for a Description column by header name, and falls back to column F if it cannot find one. It works whether or not your export has a header row - if the first row is already a trade, every row gets a ticker.
- The new column is inserted right after the description column; your original file is never modified.
- If a Ticker column already exists, the tool adds an Extracted Ticker column instead, so nothing is overwritten.
- Extraction is conservative - unusual or non-standard descriptions may be left blank rather than guessed wrong.
- Works with .csv and .xlsx. For Excel, the Ticker column is inserted into the first sheet of your original workbook - other sheets, cell values and number/date formats are kept (the new column is plain text; complex cell styling may not carry over). CSV files are preserved exactly.
Cleaning your export is step one of a journaling routine - see the weekly options income routine, and browse the rest of the calculators & tools.
Educational utility only - not financial advice, and not affiliated with or endorsed by Thinkorswim or Charles Schwab. "Thinkorswim" is a trademark of its owner, used here only to describe file compatibility. Always keep your own backup of the original export.