Import trades from E*TRADE

Import E*TRADE trades with File upload in Add Trades. Rize Trade accepts Power E*TRADE Orders and Executions exports as CSV or TXT up to 50 MB.

For the general import flow across all brokers, see How to import your trades.

Export from E*TRADE

Download your trade history from Power E*TRADE, then upload the file in Rize Trade.

1. Log in to E*TRADE, hover over Trading, and open Power E-Trade.
2. Open the Account tab and click Orders.
3. Set the date range you want to import.
4. Click the download button on the right side of the window and save the file.

Warning: E*TRADE PRO users: older trades may be missing execution times. E*TRADE PRO does not include that data in its exports.

Orders format

An Orders export must include these columns: Symbol, Status, Fill, Description, and Time.

| Column | Required | How Rize Trade uses it | | --- | --- | --- | | Symbol | Yes | Trade symbol (options can also be read from Description when needed) | | Status | Yes | Any order with a fill imports, including Filled, Executed and a partly filled order that was then cancelled. Rows whose status contains "rejected" are skipped | | Fill | Yes | Quantity and price in the shape 20 @ 0.72 (quantity, then @, then price) | | Description | Yes | Side: if Description starts with "buy" or "bought" (any capitalization), side is BUY; if it starts with "sell" or "sold", side is SELL. Any other description is skipped | | Time | Yes | Fill date and time for the execution |

Rows are skipped when:

• Any required column (Symbol, Status, Fill, Description, or Time) is empty
• The Status is rejected
• The Fill text is not in the quantity @ price shape
• The Description does not start with a buy or sell word
• The Time value is invalid

Executions format

An Executions export must include a symbol column (U/L Symbol or Symbol), plus Type, Qty, and Price.

| Column | Required | How Rize Trade uses it | | --- | --- | --- | | U/L Symbol or Symbol | Yes | Trade symbol | | Type | Yes | Side: if Type starts with "bought" or "buy" (any capitalization), side is BUY; if it starts with "sold" or "sell", side is SELL. Other types (such as Sweep, Exercised, Assigned or Expired) are skipped | | Qty | Yes | Fill quantity | | Price | Yes | Fill price | | Date | Optional | Combined with Execution Time when both are present | | Execution Time | Optional | Combined with Date when both are present | | Est. Fee | Optional | Transaction fees (treated as 0 when missing) | | Est. Comm | Optional | Commission (treated as 0 when missing) |

• If both Date and Execution Time are present, Rize Trade joins them into one timestamp
• If only one is present, that value is used, but it must hold both a date and a time
• If the row ends up with a date but no time, or no valid date and time at all, the row is skipped

Other columns that may appear in an Executions export (such as Description, Est. Amount, Order ID, Account, Account Name, or Open/Close) are not required for the import to succeed.

Other accepted file shapes

Rize Trade reads common E*TRADE export quirks without you editing the file first.

• An account header line at the top (for example a line with "as of", or one that includes both Account and Orders) is skipped automatically.
• Headerless Executions files are supported when rows start with a date in MM/DD/YYYY form and use tab or comma separators.

Upload in Rize Trade

After exporting, upload the file from Add Trades with broker set to E*TRADE. For the general upload flow, see How to import your trades. E*TRADE-specific settings:

• File types: CSV or TXT
• Size limit: 50 MB per file. If your file is larger, export a shorter date range and upload each piece separately (File too large)
• After upload, open Settings > Import History to confirm status and trade count

Tip: If dates look shifted after a successful import, check your time zone setting and re-upload. See Why are my entries and exits on the wrong dates?.

If the import fails

Fix the file or export path using the message you see, then upload again. For generic errors (file too large, wrong file type, empty file, missing account or time zone), see Fix any import problem. If an import is stuck or failed, check Import queued or something went wrong.

Missing required columns (Orders)

Symptom: Import fails with Invalid E*TRADE file: Missing required columns.

Cause: The file is treated as Orders format but is missing one or more of Symbol, Status, Fill, Description, or Time.

Fix: Export again from Power E*TRADE Orders so those columns are included. Do not remove or rename those headers before upload.

Missing required columns (Executions)

Symptom: Import fails with Invalid E*TRADE Executions file: Missing required columns (U/L Symbol, Type, Qty, Price).

Cause: The file is treated as Executions format but is missing the symbol column (U/L Symbol or Symbol), or missing Type, Qty, or Price.

Fix: Re-export so those columns are present with the original header names, then upload again.

No valid trades found

Symptom: Import fails with No valid trades found in the file. or No valid trades found in the E*TRADE Executions file.

Cause: Every row was skipped. Common reasons include only rejected orders in an Orders file, Fill values not in the quantity @ price shape, sides that are not a buy or sell, missing timestamps, or empty required fields.

Fix: Confirm the date range includes filled activity, and keep quantity and price in the expected columns (or Fill format). Upload the corrected export.

Failed to read E*TRADE file

Symptom: Import fails with a message that starts with Failed to parse E*TRADE file: followed by more detail.

Cause: The file could not be read as a supported E*TRADE Orders or Executions export.

Fix: Download a fresh export from Power E*TRADE without editing the file in a spreadsheet first, then try the upload again. If the problem continues, check Import History for the full error text.