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.

Importing to Trandence

  1. Open Trandence and navigate to the Trades page.
  2. Click the Import Trades button in the top right corner and select Upload CSV.
  3. Choose Sterling Trader and match your file’s timezone.
  4. Upload your saved .txt file.
  5. Important: On the Review screen, use the Batch Tags field to assign a custom tag (e.g., “Sterling Main”). This is crucial if you track multiple brokerage accounts within Trandence.
  6. Click Import & Review Summary to finish.

📎 Download a sample Sterling Trader TXT file to see the expected format.

Need Help?

If your file fails to upload, or if the broker has recently updated their export format, please reach out to us at [email protected]. We’ll help you get your data synced smoothly!