Lightspeed provides detailed execution reports through its Lightspeed Trader desktop platform. To get the most accurate import into Trandence, export your trade data directly from the desktop application.
Exporting from Lightspeed Trader
- Open the Lightspeed Trader desktop application and log in to your account.
- Navigate to the Account section or the Trade History window.
- Set the desired Date Range for the trades you want to export.
- Ensure all relevant columns are visible (Account Number, Side, Symbol, Price, Qty, Commission Amount, Execution Time, etc.).
- Click the Export or Save button to download the file as a
.csvto your computer.
Importing to Trandence
- Open Trandence and navigate to the Trades page.
- Click the Import Trades button in the top right corner and select Upload CSV.
- Choose Lightspeed and match your CSV’s timezone.
- Upload your saved file.
- Important: On the Review screen, use the Batch Tags field to assign a custom tag (e.g., “LS Main”). This is crucial if you track multiple brokerage accounts within Trandence.
- Click Import & Review Summary to finish.
Need Help?
If your file fails to upload, or if the broker has recently updated their export format, please reach out to us at help@trandence.com. We’ll help you get your data synced smoothly!