How to Export Filtered Trade Data from TradeLyser
Tax filing, coach reviews, and spreadsheet backtests all need subset exports—not a blind dump of every trade since account creation. TradeLyser’s export filtered data flow respects whatever filters are active on the trades log: date range, symbol, tags, win/loss, and broker account. You get a CSV or Excel file containing exactly those rows, with columns for prices, fees, P&L, tags, ratings, and notes where enabled.
This guide walks through filter → export → verify, common export scenarios for Indian traders, file handling best practices, and fixes when exports are empty or too large.
Export vs full account backup
| Goal | Approach |
|---|---|
| March Nifty trades for CA | Filter month + symbol → export CSV |
| All FY trades | Filter financial year dates → export |
| Selected coaching set | Checkbox select → bulk export (bulk operations) |
| Strategy tag analysis in Excel | Filter tag → export Excel |
Full-history exports on slow networks may timeout—chunk by quarter.
Step 1: Open Trades Log
- Sidebar → Trades / Trades Log.
- Confirm correct account in header (switch accounts).
- If list empty, fix data first: Missing Trades, Trades Not Syncing.
Reference: View Trades Log.
Step 2: Apply filters
Set every criterion before export—the file contains only matching rows.
Date range
- Use presets or custom range (filter by date).
- FY example: 1 Apr 2025 – 31 Mar 2026 for Indian FY reporting (adjust to your CA’s guidance).
Symbol
- Filter Nifty, Bank Nifty, or single stock (filter by symbol).
Tags
- e.g., only
swing-deliveryor excludepaper.
Win / loss / breakeven
- Profitable month audit: winners only.
Search
- Search trades for note keywords then export visible set.
Account
- Single Zerodha vs combined—critical for multi-broker books.
Verify summary count at top matches expectation.
Step 3: Click Export
- With filters active, click Export (toolbar or ⋮ menu).
- If using selection checkboxes, choose Export selected vs Export filtered—read dialog text carefully.
- Pick format:
| Format | Best for |
|---|---|
| CSV | Universal import, scripts, CA tools |
| Excel (.xlsx) | Formulas, pivot tables, formatting |
| Read-only sharing, print snapshots |
- File downloads to browser Downloads folder (desktop) or mobile Files app.
Step 4: Verify the file
Open first and last rows:
- Row count ≈ summary count (header rows may add 1).
- Dates inside filter range only.
- P&L sane vs TradeLyser UI—if not, see Incorrect P&L.
- Fees/taxes columns present if you need net figures for tax.
- Tags and ratings populated if you rely on them for coaching.
Name files descriptively: TradeLyser_NIFTY_2025-03.csv.
Common export scenarios
Monthly performance archive
Filter calendar month → CSV → store in cloud folder with broker contract notes.
Symbol deep dive
Filter RELIANCE → Excel → pivot average hold time and win rate.
Tagged strategy export
Filter tag opening-drive → send to mentor without sharing entire journal.
Loss review packet
Filter losses + date week → PDF for discipline review.
Post-import reconciliation
After CSV import, export same date range and diff against broker statement.
Export with bulk selection
When you need arbitrary non-contiguous trades:
- Filter loosely to include all candidates.
- Checkbox specific rows.
- Bulk Actions → Export (bulk operations).
Useful when exporting “these twelve trades” across different symbols.
Excel and Google Sheets tips
- Set date column to date format, not text.
- Use PivotTable on tags for win rate.
- Join with broker contract note export on trade ID or datetime if available.
- Do not share sheets publicly with API keys in notes columns.
Compliance and privacy
- Exports may contain account identifiers—encrypt zip files emailed to CA.
- Delete local copies from shared PCs after upload.
- Mentee exports should respect coaching agreements.
Secure device: Secure Account.
Column reference (typical export)
Exports vary slightly by broker source, but you commonly receive:
| Column | Use in analysis |
|---|---|
| Symbol / Instrument | Pivot by ticker |
| Entry & exit datetime | Hold time, session bucket |
| Quantity | Size consistency |
| Entry / exit price | Slippage review |
| Gross P&L | Before some adjustments |
| Fees / charges | Net realism |
| Net P&L | Matches TradeLyser list |
| Tags | Strategy breakdown |
| Rating | Execution quality |
| Notes | Qualitative context |
| Account label | Multi-broker books |
Map columns once in a master Excel template and reuse monthly—saves an hour of formatting each quarter.
Automating reconciliation with broker CSV
- Export same date range from TradeLyser (filtered).
- Export broker tradebook CSV.
- Match on datetime + symbol + qty (tolerance for seconds).
- Flag rows only in one file—investigate Missing Trades or duplicate import.
- Resolve fee differences via Incorrect P&L.
This ritual after each sync broker trades week builds trust in your journal before tax season.
Troubleshooting
Export contains all trades, not filtered
- Filters not applied—check active filter chips.
- Clicked Export all instead of Export filtered—retry.
- Selection mode ignored filter—clear selection.
Empty file or headers only
- Filter too tight—widen dates.
- Wrong account selected with zero trades.
- Missing Trades underlying issue.
File too large / download fails
- Narrow date range; export quarterly.
- Drop PDF for huge sets; use CSV.
- Try desktop on stable Wi‑Fi.
Garbled characters in Excel
- Open CSV via Data → From Text/CSV with UTF-8 encoding.
- Or use Excel export format directly.
P&L mismatch in Excel
- Compare calculation method FIFO vs WA.
- Fees columns missing in import source—Incorrect P&L.
Mobile export not appearing
- Check Downloads / Files app; allow browser storage permission.
Duplicate rows in export
- Duplicate imports—dedupe via support; avoid double CSV import (CSV Import Errors).
Frequently asked questions
Does export include open positions?
Depends on filter status—include “open” if status filter allows.
Can I schedule automatic exports?
Not typically—manual or API per plan; check release notes.
Are charges in INR?
Yes for Indian broker imports; verify currency column if multi-currency added later.
Export for ITR filing?
Use as supplementary schedule; CA may require broker-approved forms—confirm professionally.
Will export delete trades?
No—read-only operation.
Include notes column?
Usually yes when notes exist—verify one trade with long note.
Can mentees export my trades?
Only with permissions you granted.
Difference vs report PDF?
Reports aggregate; export is row-level trade data.
Password-protect exports?
Zip files yourself before email—TradeLyser does not password CSV by default.
Scheduled tax export reminder?
Use personal calendar quarterly; export FY slice with account filter per broker.
Exporting filtered trades for CA review and coaching
Indian traders often share filtered CSV exports with a chartered accountant or mentor—not full account dumps. Filter Financial year (April–March), one broker at a time via switch accounts, and include tags that map to strategies you discuss in strategy board. Before emailing, open the file locally: confirm charges, STT, and net P&L columns match what you expect from configure fees tax.
For coaching under Pro, export only the mentee-visible date range you agreed in manage mentee permissions; revocation stops live access but not files already sent—see revoke mentee access. Pair exports with generate reports PDFs when the mentor needs charts, not row-level edits. After import CSV corrections, re-export the corrected month so your offline archive matches TradeLyser. Zip files with a password before sending over WhatsApp or personal Gmail; TradeLyser exports are plain CSV by default.
When reconciling with a broker contract note, sort the CSV by trade date and compare daily net totals to the broker’s daily P&L statement—discrepancies often trace to unsettled tags or missing charges, not export bugs. Re-run sync broker trades before exporting tax months so the file includes the latest adjustments.
Store exports in a dated folder (FY25-Zerodha-Apr-export.csv) so you never overwrite last year’s file during a hurried April weekend. If row counts differ from the on-screen filter badge by more than one or two, refresh the trades log, re-apply filters, and export again before sending to a CA.
Related guides
- Bulk Operations
- View Trades Log
- Filter by Date
- Sort Trades
- Generate Reports
- P&L Analysis
- CSV Import Errors
- Connection Failed
- Contact Support
Quick reference
Rule: Filter → verify count → Export → open file → validate rows