Exporting Data

Download your trading data for external analysis, tax reporting, or record keeping.

What Can Be Exported

Exporting Trade History

Step-by-Step

1. Navigate to Positions → Closed
2. Apply filters (optional)
3. Click Export button
4. Select date range
5. Click Download CSV

CSV Fields

Example CSV Output

id,symbol,exchange,side,entry_time,exit_time,entry_price,exit_price,size,pnl,pnl_percent,fees,close_reason,bot_name,type
trd_001,BTC/USDT,Binance,long,2024-01-15T10:30:00Z,2024-01-15T14:45:00Z,50000.00,52000.00,0.1,200.00,4.00,10.50,take_profit,RSI Bot,live
trd_002,ETH/USDT,Binance,short,2024-01-15T12:00:00Z,2024-01-15T16:30:00Z,3000.00,2900.00,1.0,100.00,3.33,6.00,manual,MACD Bot,live

Filtering Before Export

Available Filters

Filter Tips

• Export only what you need
• Use date ranges for tax years
• Separate paper and live for clarity

Using Exported Data

In Excel/Google Sheets

1. Open CSV file in spreadsheet
2. Use pivot tables for analysis
3. Create custom charts
4. Calculate additional metrics

Example Formulas:

// Total PnL
=SUM(J:J)

// Win Rate
=COUNTIF(J:J,">0")/COUNTA(J:J)

// Average Win
=AVERAGEIF(J:J,">0")

// Average Loss
=AVERAGEIF(J:J,"<0")

// Profit Factor
=SUMIF(J:J,">0")/ABS(SUMIF(J:J,"<0"))

For Tax Reporting

Export includes all needed information:

Note: Consult a tax professional for your jurisdiction's requirements.

For Custom Analysis

Import into analysis tools:

Python Example:

import pandas as pd

# Load data
df = pd.read_csv('trades_export.csv')

# Parse dates
df['entry_time'] = pd.to_datetime(df['entry_time'])
df['exit_time'] = pd.to_datetime(df['exit_time'])

# Calculate metrics
total_pnl = df['pnl'].sum()
win_rate = (df['pnl'] > 0).mean()
avg_duration = (df['exit_time'] - df['entry_time']).mean()

print(f"Total PnL: ${total_pnl:.2f}")
print(f"Win Rate: {win_rate:.1%}")
print(f"Avg Duration: {avg_duration}")

Data Retention & Export Timing

Retention by Tier

Export Recommendations

Important: Export before data expires if you need long-term records.

Automated Exports

Scheduled Exports (Coming Soon)

Future feature will allow:

• Weekly automatic exports
• Email delivery of CSV
• Cloud storage integration

API Export

For developers, data can be accessed via API:

GET /api/trades/export?start=2024-01-01&end=2024-01-31
Authorization: Bearer {token}

Privacy & Security

Data Contents

Exported files contain:

• Trade details
• PnL information
• Timestamps
• Bot names

Does NOT contain:

• API keys
• Passwords
• Personal information
• Exchange credentials

Handling Exported Data

Troubleshooting Exports

"Export Failed"

Causes:

• Too much data
• Network timeout
• Server error

Solutions:

1. Reduce date range
2. Apply more filters
3. Try again later
4. Contact support

"No Data to Export"

Causes:

• Filters too restrictive
• No trades in period
• Wrong date range

Solutions:

1. Expand date range
2. Remove filters
3. Check correct account

CSV Formatting Issues

Problem: Data appears in one column

Solution:

1. Use "Import" function instead of opening directly
2. Set delimiter to comma
3. Enable text qualifier

Best Practices

Regular Backups

Naming Convention

trades_EXCHANGE_STARTDATE_ENDDATE.csv

Example:
trades_binance_20240101_20240131.csv

Storage Organization

trading_data/
├── 2024/
│   ├── Q1/
│   │   ├── trades_jan.csv
│   │   ├── trades_feb.csv
│   │   └── trades_mar.csv
│   └── Q2/
│       └── ...
└── backups/
    └── ...

Next Steps

• Trade History - Review your trades
• PnL Charts - Visualize data
• FAQ - Common questions