Skip to content

Help Centre

153 guides on importing trades, connecting brokers and everything else in RizeTrade.

Import trades from TradeStation

Import TradeStation trades into Rize Trade two ways: upload a Tax Center CSV for stocks and options, or paste filled orders from TradeManager for futures. For the general import flow (opening Add Trades, choosing a broker, and setting your time zone), see How to import your trades.

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

Method 1: File upload (stocks and options)

Export a Microsoft Excel CSV from TradeStation's Tax Center, then upload it on the TradeStation file upload screen in Rize Trade.

Warning: 6-month export limit: TradeStation only lets you download 6 months of data at a time. For a full year, run two exports and upload them separately.

Export from TradeStation

  1. Go to TradeStation's web client center.
  2. Click Accounts in the header panel.
  3. Click Equities Accounts in the left panel, then select Tax Center from the dropdown.
  4. In Download Tax Activity, set File Format to Microsoft Excel CSV, choose your date range (up to 6 months), and check Exclude Broken/Canceled Trades.
  5. Click Download to save the CSV.

Upload in Rize Trade

Upload the CSV from Add Trades with TradeStation and File upload selected. For the general upload flow, see How to import your trades. TradeStation-specific settings:

  • Time zone: match your TradeStation timestamps (required).
  • File: Microsoft Excel CSV from Tax Center, up to 50 MB. If yours is larger, break up your import file.

Columns this file must include

Your CSV needs these column headers. If any required column is missing, the import is rejected.

| Column | Required? | What Rize Trade uses it for | | --- | --- | --- | | Transaction | Required | Side of the trade. Trade rows are imported: Buy, Sell, Sell Short, Buy to Cover, and the to Open and to Close forms. Other values (dividends, transfers, blanks) are skipped. | | Quantity | Required | How many shares or contracts were traded. | | Symbol | Required | The ticker. For options without separate option columns, Rize Trade can read an OCC-style symbol here. | | Price | Required | Fill price. Rows with a zero or missing price are skipped. | | Activity Date | Required | Trade date. | | Activity Time | Optional | Trade time. If this field already holds a full date and time, that value is used. Otherwise it is combined with Activity Date. | | Commission | Optional | Commission on the fill. Treated as 0 when blank. | | CallPut | Optional | For options: CALL or PUT (or C or P). Marks the row as an option. | | UnderlyingSymbol | Optional | Option underlying when CallPut is set. | | ExpireDate | Optional | Option expiration when CallPut is set. | | StrikePrice | Optional | Option strike when CallPut is set. |

How dates and options are read

Date and time are resolved in this order:

  • Full datetime in Activity Time if it includes both date and time.
  • Otherwise, Activity Date + Activity Time.
  • Otherwise, Activity Date alone, but only if it already includes a time of day.

A row with no time of day is skipped rather than imported at midnight. Rows with invalid dates, or dates before 1990 or in the future, are also skipped. When CallPut is CALL or PUT, Rize Trade builds the option from UnderlyingSymbol, ExpireDate, and StrikePrice when those columns are filled, or from the Symbol value if they are not.

Why this file might be rejected:

Invalid TradeStation file: missing required columns

Message: Invalid TradeStation file: Missing required columns.

Cause: One or more of Transaction, Quantity, Symbol, Price, or Activity Date is missing.

Fix: Keep those headers exactly as named when exporting from Tax Center.

No valid trades found in the file

Message: No valid trades found in the file. When rows were skipped for missing times or bad dates, the message adds how many, for example that trade rows have no time of day in Activity Time.

Cause: Rows were present but none qualified. Common causes: Transaction is not a trade value such as Buy or Sell, rows have no time of day, dates are invalid, or every row was skipped.

Fix: Confirm Transaction values are trade values such as Buy or Sell, check that every row has a time, verify dates are valid, and re-export from Tax Center if needed.

Failed to parse TradeStation file

Message: Failed to parse TradeStation file: followed by detail.

Cause: The file could not be read as a TradeStation CSV.

Fix: Export again as Microsoft Excel CSV from Tax Center and retry.

Method 2: Paste from TradeManager (futures)

Copy filled orders from the TradeStation desktop TradeManager, then paste them into Option 2: Import Futures Trades (Copy & Paste) on the TradeStation upload screen.

Export from TradeStation desktop

  1. Open the TradeStation desktop application and log in.
  2. Go to TradeManager and open the Orders tab.
  3. In the Status dropdown, choose Filled Orders.
  4. Set columns in this exact order: Entered, Filled/Canceled, Symbol, Spread Type, Quantity, Qty Filled, Qty Left, Stop, Limit, Filled Price, Order Status, Route, Duration, Group Name, Triggered By, Advanced Order#, Account, Originator, Commission, Contract Exp Date. Make sure the Type column (Buy or Sell) is included, because Rize Trade reads the side from it.
  5. Set your date range and click Retrieve Orders.
  6. Sort by Filled/Canceled ascending (oldest first).
  7. Select all rows (upper-left square or Ctrl+A), then copy (right-click > Copy, or Ctrl+C). Include the column headers when you copy.

Paste in Rize Trade

From the TradeStation upload screen, set Time zone to match your TradeStation timestamps (required), then open Option 2: Import Futures Trades (Copy & Paste). For the general upload flow, see How to import your trades.

  1. Paste into the data box under Option 2 (placeholder: Paste your trades here...).
  2. Click Upload. The button stays disabled until the box has text.

Columns Rize Trade reads from the paste

With headers included, Rize Trade matches columns by name, whatever their position. If headers are missing, it assumes the default TradeManager Orders tab layout, and rows without a side, a fill time and a price are skipped, so always copy the headers.

| Column | How it is used | | --- | --- | | Symbol | Required. The contract or ticker. | | Type | Side of the order: Buy, Sell, Sell Short, Buy to Cover, and the to Open and to Close forms. Only when the paste has no type column is a negative quantity read as a sell. | | Qty Filled (or Quantity) | Size of the fill. When a Qty Filled column exists, only it is used. Quantity is used only when there is no filled-quantity column and the order status is filled. Rows with a filled quantity of 0 are skipped. | | Filled Price (or Price) | Fill price. | | Filled/Canceled | Date and time of the fill. A row with an empty fill time is skipped. | | Entered | Used for the time only when the paste has no fill time column at all. | | Order Status | Rows whose status contains reject are skipped. Orders that were partly filled and then cancelled or expired still import their filled quantity. | | Commission | Commission on the fill when present. | | Spread Type | Spread orders are skipped, because TradeManager shows one net price for the whole spread and no price for each leg. |

Symbols written as a root plus month code and year (for example MESH26) are stored as futures. Symbols in TradeStation's option format (for example SPY 260305P683) are stored as options. Anything else is stored as a stock.

Why the paste might be rejected:

No data found in paste

Message: No data found. Please paste your trades from TradeStation TradeManager.

Cause: The data box was empty or had no usable lines.

Fix: Paste the copied rows from TradeManager and try again.

Spread orders in the paste

Message: These rows are spread orders. TradeManager shows one net price for the whole spread and no price for each leg, so they can't be imported from a paste. Import the TradeStation account activity CSV instead, which prices each leg.

Cause: Every usable row was a spread order.

Fix: Import those trades with Method 1 (file upload) instead.

No valid trades in pasted data

Message: No valid trades found in the pasted data. Make sure to paste filled orders from the TradeStation TradeManager. When rows were skipped for a known reason, the message says so instead, for example that filled rows have no readable time in the Filled/Canceled column, or no Buy or Sell in the Type column.

Cause: Nothing qualified as a fill. Rows may be rejected orders, have a filled quantity of 0, or be missing the price, the fill time or the side.

Fix: Use Filled Orders in TradeManager, copy the Filled/Canceled and Type columns along with the trades, and confirm quantity and price values are present.

Failed to parse pasted TradeStation data

Message: Failed to parse pasted TradeStation data: followed by detail.

Cause: The pasted text could not be read.

Fix: Copy again from TradeManager as tab-separated rows with headers.

After import, confirm Status, Trades, and Duplicates under Settings > Import History. See the full Import History walkthrough. If status stays on Queued or shows failed, see Import queued or something went wrong. For generic import errors (file too large, wrong file type, empty file, missing account or time zone), see Fix any import problem.

Was this helpful?