Sterling Trader

Sterling Trader Pro exports trade data as a .txt file rather than a .csv. Trandence fully supports this format - simply upload the .txt file as you would a CSV.

Exporting from Sterling Trader Pro

Trandence reads the executions from the Trading Monitor (or Position Manager) window, saved as text.

1. In Sterling Trader Pro, open View → Settings → Columns for that window.
2. Show these columns, in this order, dragging them into place if needed: Date, Time, Symbol, Shares (Qty), Exe Price, Side. The file has no header row, so the order is what tells Trandence which value is which.
3. Choose Actions → Save to write the window to a .txt file.

Import To Trandence

1. Open Trandence and go to the Trades page.
2. Click Import Trades and select Upload CSV/TXT.
3. Choose Sterling Trader 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 TXT 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 Sterling Main or Sterling Prop.
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 expects the Sterling comma-separated TXT execution format without a header row. The importer reads date, time, symbol, quantity, price, and side: BOT (buy), SLD (sell) and SLD SHRT (short sale), plus SHRT and COV. Sterling Trader Pro saves the file as UTF-16 text; upload it as it is, there is no need to convert it.

Stocks only. Options from Sterling are not imported yet. To bring your option trades into Trandence, convert them with Trandence CSV.

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.

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 Sterling Trader TXT 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 help@trandence.com. We will help you get the data imported smoothly.