How to Import Binance Futures Trades for Analysis (3 Methods)

Binance Futures is the largest derivatives exchange by volume, and most active crypto traders have at least some of their history there. Getting that data into a trading journal is the first step toward understanding your performance — but the process isn’t always obvious.

There are three ways to import Binance Futures trades, each with different tradeoffs. This guide covers all three: CSV trade history, CSV income history, and live API sync.

Method 1: Trade History CSV Export

This is the most straightforward method and works with any trading journal.

How to Export

1. Log into Binance → go to Orders → Futures Order History
2. Click Trade History (not Order History — you want fills, not orders)
3. Select your date range (max 3 months per export)
4. Click Export → choose CSV format
5. Save the file

What You Get

The trade history CSV contains one row per execution fill with these columns:

Column	Example
time	2026-01-15 14:23:45
symbol	BTCUSDT
side	BUY
qty	0.05
price	42350.50
commission	0.85
commissionAsset	USDT
realizedPnl	0

Key Details

• Fills, not trades: Each row is an execution fill. A single order that partially fills at different prices will appear as multiple rows.
• Side indicates execution direction: BUY/SELL, not LONG/SHORT. Whether a BUY opens or closes a position depends on your existing position.
• realizedPnl is per-fill: It’s the P&L realized by that specific fill, not the total position P&L.
• Commission is always positive: Even though it’s a cost, the number is positive. Your journal should treat it as a deduction.

Limitations

• Maximum 3 months per export
• Need to do multiple exports for longer history
• Side inference is needed to determine LONG/SHORT direction
• Position reconstruction is required to match opens to closes

Importing into TraderDynamiq

TraderDynamiq auto-detects Binance Futures trade history CSV format. Just drag and drop the file — the platform identifies the format, maps the columns, and normalizes the data automatically. Side inference and position reconstruction happen in the background.

Method 2: Income History CSV Export

The income CSV is an alternative export that some traders find more useful because it explicitly separates realized P&L, funding fees, and commissions.

How to Export

1. Log into Binance → go to Wallet → Futures
2. Click Income History
3. Select your date range and income types (REALIZED_PNL, COMMISSION, FUNDING_FEE)
4. Click Export

What You Get

Column	Example
time	2026-01-15 14:23:45
symbol	BTCUSDT
incomeType	REALIZED_PNL
income	125.30
asset	USDT
info	{“tradeId”:”123456789”}

Income Types Explained

Type	Meaning
REALIZED_PNL	Profit or loss from closing a position
COMMISSION	Trading fee (negative value = cost)
FUNDING_FEE	Periodic funding rate payment (positive = received, negative = paid)
TRANSFER	Account transfers (ignore for analysis)
INTERNAL_TRANSFER	Internal movements (ignore for analysis)

Key Differences from Trade History

• No position data: No qty, price, side, or leverage
• Separated cost components: Commissions and funding are separate rows, not columns
• Trade ID linking: The info column contains tradeId which can link back to fills
• Simpler but less detailed: Good for P&L accounting, less useful for execution analysis

Importing into TraderDynamiq

TraderDynamiq handles income CSV with a specialized reconstruction engine. It groups REALIZED_PNL, COMMISSION, and FUNDING_FEE entries by symbol and time window to reconstruct complete trade records. The system handles edge cases like multiple concurrent positions and missing fills.

Method 3: API Sync (Automated)

For ongoing trade tracking, API sync eliminates manual exports entirely.

Setup

1. Go to Binance → API Management
2. Create a new API key
3. CRITICAL: Enable only “Can Read” permission
4. Do NOT enable trading, withdrawal, or futures permissions
5. Copy the API key and secret

Security Best Practices

• Read-only keys only: Never give a trading journal write/trade permissions
• IP restriction: Restrict the API key to specific IP addresses
• Dedicated key: Create a separate key for your journal — don’t reuse your trading bot key
• Regular rotation: Rotate API keys every 3-6 months

How API Sync Works in TraderDynamiq

TraderDynamiq uses Binance’s async trade download endpoints to fetch complete futures history:

1. Discovery: Scans for all symbols you’ve traded (up to 10 years lookback)
2. Download: Fetches trade history in batches, respecting Binance’s rate limits
3. Normalization: Converts raw API data to canonical trade records
4. Deduplication: Hash-based dedup ensures no duplicate trades from overlapping syncs
5. Background processing: All sync work happens asynchronously — you don’t need to wait

The sync runs automatically on schedule once configured, keeping your journal up to date without any manual work.

Rate Limits to Know

Binance enforces strict rate limits on trade data endpoints:
- Weight budget: ~2,000 per minute
- Export limits: 5 async exports per month on certain endpoints
- If you hit limits, TraderDynamiq automatically backs off and retries

Which Method Should You Use?

Factor	Trade CSV	Income CSV	API Sync
Setup difficulty	Easy	Easy	Medium
Data completeness	High	Medium	Highest
Ongoing effort	Manual	Manual	None
History length	3mo chunks	3mo chunks	Up to 10 years
Position details	Yes	No	Yes
Real-time updates	No	No	Yes
Best for	One-time import	P&L accounting	Ongoing tracking

Our recommendation:
- Start with Trade History CSV for your initial import — it’s the fastest way to get started
- Set up API sync for ongoing tracking — once configured, it runs automatically
- Use Income CSV if you specifically need P&L + funding breakdown

Common Issues and Fixes

“0 trades imported” after CSV upload

Cause: Usually means the CSV format wasn’t recognized or all rows were filtered out.
Fix: Check that you exported Trade History (not Order History). Order History doesn’t contain fill data.

Missing trades from certain periods

Cause: Binance limits CSV exports to 3 months per download.
Fix: Do multiple exports in 3-month chunks and import each one. Deduplication prevents duplicates if date ranges overlap.

Side showing as BUY/SELL instead of LONG/SHORT

Expected behavior: Binance exports execution direction (BUY/SELL), not position direction. TraderDynamiq’s side inference engine determines LONG/SHORT based on position state tracking.

Funding fees not showing

Cause: Trade History CSV doesn’t include funding fees.
Fix: Either use Income History CSV (which separates funding fees) or API sync (which captures all income types).

Duplicate trades after re-importing

Not a problem: TraderDynamiq uses deterministic hash-based deduplication. Re-importing the same data won’t create duplicates. Import freely.

After Import: What to Do Next

Once your Binance trades are imported:

1. Check the import summary — verify trade count, date range, and any warnings
2. Review your Dashboard — see your overall P&L, equity curve, and top verdicts
3. Check Verdicts — find your biggest behavioral leaks ranked by dollar impact
4. Set up Playbook rules — define trading rules based on what the verdicts reveal
5. Schedule regular imports (or set up API sync) to keep your analysis current

---

Want to see the same analysis run on your own trade history? Analyse your trades free — drop your Binance, Bybit or TradingView export and get your own repeating patterns ranked by measured P&L. No account, no email, no card, and your file is never stored. Not ready to upload? Read a real report first.

Import your Binance Futures trades in seconds. Start your free 14-day trial — just drag and drop your CSV file.

---

Related Reading

• What Is Revenge Trading and How Much Is It Really Costing You?
• The Hidden Cost of Overtrading
• Best Trading Journal Software 2026
• How to Find Your Worst Trading Hours
• Trading Psychology: A Data-Driven Approach