How to export E*TRADE trades into a journal

E*TRADE CSV export path step by step. What fields the CSV gives you, what is missing (setup tag), and how to backfill the gap fast without ruining your journal.

E*TRADE's trade journaling workflow has improved in the last 18 months — there's now a clean CSV export from Power E*TRADE and the legacy E*TRADE platform, but neither is documented well by E*TRADE themselves. Here is the exact step-by-step to get a clean CSV out of E*TRADE, what fields you actually get, what's missing, and how to backfill the gap without ruining your journal.

Quick answer: in Power E*TRADE go to Accounts → Transactions → set the date range → click Download → choose CSV. You get fill-level data: date, symbol, side, qty, price, commission, fees. You do NOT get setup tag, thesis, or screenshot. The 3 missing fields are what you backfill in your journal — keyboard-shortcut driven form makes this 10 seconds per trade.

Step-by-step CSV export from Power E*TRADE

Sign in to powerEtrade.com (the trading platform — not us.etrade.com which is the parent banking site).
Click 'Accounts' in the top nav.
Click 'Transactions' from the dropdown.
Set the date range. Default is 30 days; for full journaling you want at least 90 days or year-to-date.
Click the 'Download' button (icon, top right of the transactions table).
Choose 'CSV' format (the other options — PDF, Excel — are less useful for journal import).
Save the file. By default it lands in your Downloads folder with a name like Transactions_2026-06-14.csv.

What fields the CSV gives you

The E*TRADE CSV is fill-level — one row per execution, not one row per trade. The fields:

Transaction Date. Date of fill, sometimes with time depending on the report variant.
Transaction Type. 'Bought,' 'Sold,' 'Short Sold,' 'Bought to Cover,' or one of the option-specific types.
Symbol. Equity ticker or full option OCC symbol for options.
Quantity. Shares or contracts.
Amount. Net cash impact (negative for buys, positive for sells).
Price. Fill price per share or per contract.
Commission. Per-trade commission (usually $0 on equities, ~$0.65/contract on options).
Fees. SEC/TAF fees on sells, exchange fees on options.
Description. Free-text — usually echoes the order details.

What's missing

The CSV does NOT include:

Setup tag. Why you took the trade. VWAP reclaim, opening range breakout, oversold bounce — none of this is in the broker's system.
Thesis / plan. What you expected the trade to do.
Screenshots. Charts of the entry/exit setup.
Conviction rating. Your gut at entry.
Pre/post-trade notes. Anything reflective.

These are the fields that make a journal a journal rather than a trade ledger. The CSV gives you the ledger. The journal needs you to add the rest. (For the broader options-trading context if you trade options through E*TRADE, see the options journal comparison.)

Importing the CSV into TradeFlow Quantum

In TFQ, go to Settings → Connect Broker → Manual / CSV.
Select 'E*TRADE Power CSV' preset. The field mapping is pre-configured.
Upload your downloaded CSV.
TFQ groups fill-level rows into logical trades (open + close pairs). Net P&L is computed automatically from the Amount column. Commissions and fees roll up.
Review the trade list. Any rows that didn't auto-group cleanly are flagged for manual confirm.

First import on 90 days of E*TRADE history typically takes 30 seconds. The result: every trade you took in the last 3 months, with the mechanical fields populated and the journal fields (setup, thesis, conviction) blank and ready for backfill.

Backfilling the missing fields fast

Three options for backfilling setup + thesis on 90 days of historical trades:

One-by-one. Open each trade, type setup + thesis. 60-90 seconds per trade. For 100 historical trades, 2 hours of work.
Bulk tag by date range. Tag all trades from a specific week with the dominant setup (e.g., 'VWAP reclaim' for the week you traded that setup). Loses granularity but takes 5 minutes.
Keyboard walk-through. Open the bulk edit, fill setup/thesis fields per trade from memory using shortcuts. 20 seconds per trade vs 90 by mouse. For 100 trades, ~35 minutes.

For ongoing trades after the import, screenshot OCR at the time of the trade is the workflow that scales. The historical backfill is a one-time cost; the ongoing sub-30-second per-trade entry is the long-term experience. (For the broader Robinhood workflow that's similar in structure, see how to journal trades with Robinhood.)

Why no E*TRADE OAuth

TFQ has E*TRADE OAuth on the supported brokers list, and it pulls trades automatically — no CSV export required. The CSV path documented above is the fallback for users who haven't connected OAuth yet, or who only want to import historical data without granting live broker access. Both paths produce the same journal.

Honest disqualifier

If you only take 1-3 E*TRADE trades a month, CSV import is overkill. You'll spend more time configuring the import than just typing the 3 trades manually. The CSV path earns its keep at 10+ trades a month or when you want to backfill 90+ days of history at once.

Start your 7-day free trial — $17/mo →

E*TRADE OAuth + CSV preset on day one. 90 days of trades imported in 30 seconds. $17/mo. 7-day free trial.

See the imported-trades dashboard demo →

→ How to journal your Robinhood trades in 2026 (without copy-paste hell)→ Best trading journal for options traders in 2026 → How to import Webull trades into a real journal

Not financial advice. This post reflects the author’s opinion based on publicly-available information at the time of writing. Mention of third-party products is not an endorsement; product features and prices change over time. Past performance does not guarantee future results.