Importing Trades¶

Web Portal Export¶

1. Log into Lightspeed.com website
2. Navigate to My Account → Reports
3. From the Reports dropdown, select Account List
4. From the STATEMENTS dropdown, select your account number
5. From the reports menu, select Blotter
6. Select your desired date range
7. Click Apply to display trades
8. Click the CSV button to download
9. Extract the ZIP file (downloads as ZIP format)

Required Columns: - Symbol - Trade Date - Execution Time - Price - Qty (Quantity) - Side (Buy/Sell) - Commission Amount

Method 1: Export Realized Gains/Losses (For Closed Positions)¶

1. Log into Schwab.com
2. Click Accounts tab (upper left)
3. Select History from dropdown
4. Click the Realized Gain/Loss tab
5. Select specific account from dropdown (if multiple accounts)
6. Choose appropriate date range/tax year
7. Click Export button (upper right)
8. Save the CSV file to your computer

Method 2: Export Transaction History¶

1. Log into Schwab.com
2. Click Accounts → Transaction History
3. Select desired account from dropdown (if multiple)
4. Select date range or choose Custom for specific dates
5. Click Search
6. Click Export (top right)
7. Select CSV as export type
8. Click Export again to download

Required Columns: - Symbol - Opened Date - Closed Date - Quantity - Cost Per Share - Proceeds Per Share - Gain/Loss ($)

Desktop Platform Export¶

1. Open ThinkorSwim desktop platform
2. Go to Monitor tab
3. Open Account Statement page
4. Adjust time frame selector at top of page (default shows past day)
5. Verify correct account is selected
6. Click the menu icon (three lines) in upper right corner
7. Select "Export to file" from dropdown
8. CSV file saves to your computer as AccountStatement.csv

Required Columns (Account Statement export includes these): - DESCRIPTION or Description - Contains trade details (e.g., "BOT +1,000 AAPL @150.00") - TYPE or Type - Must be "TRD" for trade rows - DATE or Date - Trade date - TIME or Time - Trade time - Misc Fees - Optional fees - Commissions & Fees - Optional commission

Creating an Activity Flex Query¶

Step 1: Access Flex Queries

1. Log into IBKR Client Portal
2. Navigate to Performance & Reports → Flex Queries
3. Alternative: Menu (top-left) → Reporting → Flex Queries

Step 2: Create New Query

1. Click the "+" icon in top-right corner of Activity Flex Query panel
2. Enter descriptive Query Name (e.g., "Export" or "Trade History")

Step 3: Select Sections (Click each section, Select All, then Save)

• ✅ Cash Transactions
• ✅ Corporate Actions
• ✅ Financial Instrument Information
• ✅ Grant Activity
• ✅ Incoming/Outgoing Trade Transfers
• ✅ Option Exercises, Assignments and Expirations
• ✅ Trades (most important)
• ✅ Transaction Fees
• ✅ Transfers

Step 4: Configure Delivery Settings

• Accounts: Click Add/Edit Accounts (important if multiple/migrated accounts)
• Format: Select CSV (TradeTally does not support XML)
• Period: Choose from Last 365 Calendar Days, Custom Date Range, etc.

Step 5: Configure General Settings (OPTIONAL - default works fine)

TradeTally supports multiple IBKR date formats automatically. The default settings work for most users.

For Trade Confirmation format, you can optionally set: - Date Format: yyyyMMdd (e.g., 20241225) - Time Format: HHmmss (e.g., 093000) - Date/Time Separator: semicolon (;)

For Activity Statement format (most common), dates are in MM-DD-YY format (e.g., 12-25-24) and work automatically.

Step 6: Finalize and Run

1. Click Continue to review
2. Click Create, then OK
3. Select all relevant accounts
4. Click the arrow icon next to your query name
5. Choose your time period (max 1 year)
6. Select CSV format
7. Click Run and download the file

Required Columns (Activity Statement): - Symbol - Ticker symbol - DateTime OR Date/Time - Both column names supported - Quantity - Signed value (positive = buy, negative = sell) - Price - Execution price - Commission - Optional (negative values in IBKR CSVs) - Conid - Contract ID (CRITICAL for options - see below)

Expected Date Formats: - Activity Statement: DD-MM-YY (e.g., 16-02-24) or DD-MM-YY HH:MM - also supports MM-DD-YY automatically - Trade Confirmation: YYYYMMDD;HHMMSS (e.g., 20241225;093000)

Method 1: Power E*TRADE Platform¶

1. Open Power E*TRADE platform
2. Navigate to Account tab → Orders page
3. Locate time frame selector at top:
4. Predefined: "Today," "This Week," "This Month," "Year-to-Date"
5. Custom: Use calendar icons for specific start/end dates
6. Click download icon (upper right corner)
7. CSV file automatically downloads as "DownloadTxnHistory.csv"

Method 2: E*TRADE Website¶

1. Log into E*TRADE.com
2. Click Accounts tab
3. Select Transactions from dropdown
4. Choose "Custom Time Period" from dropdown
5. Enter From and To dates
6. Click Search
7. After report loads, click Download icon (upper right)
8. Verify account and time frame are correct
9. Select "Spreadsheet Format including Microsoft Excel Details"
10. Click Download button (lower right)

Required Columns: - Symbol - Transaction Date - Price - Quantity - Transaction Type - Commission

Export from Trades Tab¶

1. Log into your ProjectX prop firm account
2. Navigate to the "Trades" tab
3. Locate "EXPORT" button in bottom right corner
4. Click the EXPORT button
5. Select desired date range for trades
6. Click Export to confirm
7. CSV file saves to your desktop

Required Columns (ProjectX CSV export includes): - Id - Trade ID (may have BOM character prefix) - ContractName - Futures contract name - EnteredAt - Entry timestamp (format: "10/01/2025 21:13:23 +02:00") - ExitedAt - Exit timestamp - EntryPrice - Entry price - ExitPrice - Exit price - Fees - Trading fees - PnL - Profit/Loss - Size - Position size - Type - Long/Short - TradeDay - Optional - TradeDuration - Optional - Commissions - Optional

Supported Prop Firms:

This works for all ProjectX-backed prop firms including:

• Topstep
• Alpha Futures
• TickTickTrader
• Bulenox
• TradeDay
• Blusky
• Goat Futures
• The Futures Desk
• DayTraders
• E8 Futures
• Blue Guardian Futures
• FuturesElite
• FXIFY
• Hola Prime
• Top One Futures
• Funding Futures
• TX3 Funding

Export from Questrade Edge Application¶

Step 1: Open Account Window

1. Launch Questrade Edge desktop application
2. Click Tools in the top menu bar
3. Select Account from the dropdown

Step 2: Configure Columns

1. Click the Executions tab in the Account window
2. Right-click on the column headers
3. Select "Edit columns"
4. Click "Restore Defaults" in the bottom left
5. Scroll through the list and check the following columns:
6. Currency
7. Exec time
8. Option
9. Strategy
10. Commission
11. Click OK to save your column configuration

Step 3: Export Trades

1. Right-click on the column headers again
2. Click "Export..."
3. Choose a location (e.g., Desktop)
4. Save the file with a descriptive name
5. File will be saved as CSV format

Required Columns (automatically included in Questrade Edge export):

• Symbol - Stock ticker or options symbol (e.g., ECHI.TO or SLV20Feb26C55.00)
• Action - Trade action (Buy, Sell, BTO, STC, BTC, STO)
• Fill qty - Number of shares or contracts filled
• Fill price - Execution price per share/contract
• Currency - Trading currency (CAD or USD)
• Exec time - Execution timestamp
• Option - Option type (Call/Put) or empty for stocks
• Commission - Trading commission

Sample CSV Format:

"Symbol","Action","Fill qty","Fill price","Currency","Exec time","Total value","Time placed","Option","Strategy","Commission","Account"
"ECHI.TO","Buy","700","11.26","CAD","16 Dec 2025 11:15:58 AM","7,882.00","16 Dec 2025 11:15:58 AM","","","0.00","12345678 - Margin +"
"SLV20Feb26C55.00","BTO","4","6.95","USD","17 Dec 2025 09:38:14 AM","2,780.00","17 Dec 2025 09:38:14 AM","Call","","3.96","23456789 - TFSA (+)"
"SLV20Feb26C55.00","STC","4","10.30","USD","24 Dec 2025 10:47:11 AM","4,120.00","24 Dec 2025 10:47:11 AM","Call","","3.96","23456789 - TFSA (+)"