Trandence

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

  1. Launch the Sterling Trader Pro desktop application and log in.
  2. Navigate to the Trading Monitor or Position Manager window.
  3. Configure the columns to include the following fields in this exact order: Date, Time, Symbol, Shares (Qty), Exe Price, Side.
    • Click View -> Settings from the dropdown menu.
    • In the popup, navigate to the Columns tab.
    • Select the required columns and click OK.
    • You can rearrange columns by dragging them into the correct order.
  4. Once your columns are configured, click on Actions -> Save to export the data as a .txt file.
  5. Save the file to your desktop.

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 values such as BOT, SLD, SHRT, and COV.

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 [email protected]. We will help you get the data imported smoothly.