E*Trade

E*Trade (Power E*Trade) allows you to export your filled orders directly from the web platform. For the best results, use the Power E*Trade interface. Trandence imports stocks and options from the same file.

Exporting from Power E*Trade

The file Trandence reads is the Orders list in Power E*Trade.

1. Sign in on the E*Trade website and open Power E*Trade (it sits under Trading in the top menu).
2. In Power E*Trade, go to Account → Orders.
3. Pick the period you want, then use the download button at the right of the list. The file saves as a CSV.

Older data: files from the retired E*Trade PRO platform can be missing the time of each execution. Trandence then cannot tell the order of trades within a day.

Import To Trandence

1. Open Trandence and go to the Trades page.
2. Click Import Trades and select Upload CSV/TXT.
3. Choose E*Trade as the broker.
4. Set CSV Timezone to the timezone used by the broker export. For most US equities workflows, this is America/New_York.
5. Optionally apply an import preset if you use saved defaults for this account.
6. Select or drop the exported CSV file.
7. Review the parsed trades before saving. Confirm symbols, side, open/close times, quantity, prices, commissions, and the session date range.
8. Use Batch Tags to label the import, for example ETrade Main or ETrade Swing.
9. Click Import & Review Summary to save the import and open the post-import summary.

For the full import workflow, including presets, preview validation, multi-session progress, and conflict review, see Importing Trades.

What Trandence Reads

Trandence reads filled order rows with Symbol, Description, Fill, Time, and related execution fields. The side is inferred from the order description, and the selected CSV Timezone is applied to the timestamp.

Trandence keeps supported US equity symbols, including common share-class formats such as BRK.A and BRK.B, and organizes the imported executions into completed trades for review.

• Filled orders only. Canceled and rejected orders are skipped.
• Stocks and ETFs: Buy, Sell, Sell Short and Buy To Cover orders.
• Stock and index options: the contract is read from the order description, for example Sell 20 May-01-24 504 Puts @ Market to Close (SPY, 1 May 2024, 504 put). Symbol gives the underlying, and the trade is filed under it and priced at 100 shares per contract. to Open and to Close decide whether an order opens or closes a position, so selling to open is recorded as a short.
• Adjusted options (a root ending in a digit, after a split or merger) and option orders whose description is in another shape, such as a multi-leg order in one line, are skipped.
• Fees: the Orders export has no commission column, so trades are imported with zero commission.

The Orders export lists orders, not expirations, assignments or exercises. An option that expired or was assigned stays open after its expiry date, and Trandence lists it under Expired options to resolve on the Trades page, where you choose what happened. Choosing Assigned or Exercised also adds the shares that were delivered.

Conflict Handling

If imported rows overlap with trades already in Trandence, use Review Conflicts to compare them before saving. The safest default is Keep Existing, which preserves the trade already in your account.

If you need to replace existing data, delete or correct the existing trades first, then import the file again intentionally. You can review completed imports from Import History.

Sample file: Download a sample E*Trade CSV file to see the expected format.

---

Need Help?

If your file cannot be uploaded, or if the broker has recently changed its export format, contact us at [email protected]. We will help you get the data imported smoothly.