Importing Historical Trades
Learn how to import your past trading history into Ascentia for comprehensive analysis.
Importing your historical trades allows Ascentio AI to analyze your complete trading history, providing more accurate insights and recommendations. The more data the AI has, the better it can identify patterns and help you improve.
- Get immediate AI insights based on your complete trading history
- Identify long-term patterns and trends
- Compare current performance with historical data
- Build a comprehensive trading record in one place
CSV Files
The most common format. Export your trades from your broker as CSV and import them directly. Ascentia supports standard CSV formats from major brokers.
Excel Files (.xlsx)
Import trades from Excel spreadsheets. Make sure your data includes columns for date, symbol, entry/exit prices, and profit/loss.
Broker-Specific Formats
Direct integration with popular brokers allows automatic import of your trading history. See "Connecting Trading Platforms" for more details.
- Prepare your file: Export your trading history from your broker or trading platform. Ensure the file includes essential fields like date, symbol, entry/exit prices, and P&L.
- Navigate to Import: Go to Journal → Import Trades or click the import button on your dashboard.
- Select file type: Choose the format of your file (CSV, Excel, or broker-specific).
- Upload file: Drag and drop your file or click to browse and select it.
- Map columns: Match the columns in your file to Ascentia's fields. The system will auto-detect common formats.
- Preview and confirm: Review a sample of your trades to ensure they're mapped correctly, then click "Import".
- Wait for processing: Large imports may take a few minutes. You'll receive a notification when complete.
Your import file must include these fields:
- Date/Time: When the trade was opened and closed
- Symbol/Instrument: What you traded (e.g., AAPL, EUR/USD)
- Direction: Long or Short
- Entry Price: Price at which you entered the trade
- Exit Price: Price at which you exited the trade
- Quantity/Size: Number of shares, contracts, or lots
- Profit/Loss: Net result of the trade
Optional but recommended: fees/commissions, stop loss, take profit, trade notes
Import Failed
Check that your file format is correct and all required fields are present. Remove any special characters or formatting from your spreadsheet.
Duplicate Trades
Ascentia automatically detects and skips duplicate trades based on date, symbol, and prices. You can safely re-import files without creating duplicates.
Incorrect Data
If trades are imported with wrong values, you can delete the import batch and try again with corrected column mapping.
- Import trades in chronological order for better AI analysis
- Include as much detail as possible (notes, screenshots, tags)
- Verify a small sample import before importing large datasets
- Keep your original files as backup
- Import regularly to keep your journal up to date