How to upload trades using generic CSV (Manual)
Quick Start
- Go to Settings → Accounts
- Select your account → Click Upload CSV
- Choose your properly formatted CSV file
- Review and confirm the import
CSV Format Requirements
Required Columns
| Column | Description | Example |
|---|---|---|
symbol | Ticker symbol | AAPL, NQ, SPY |
side | Buy or sell | buy, sell, long, short |
qty | Quantity/contracts | 100, 2, 5 |
price | Execution price | 150.50, 17500.25 |
timestamp | Date and time | 2024-01-15 09:30:00 |
Optional Columns
| Column | Description | Default |
|---|---|---|
asset_class | Type of instrument | Auto-detected |
fees | Commission/fees | 0 |
option_type | call or put | — |
strike_price | Option strike | — |
expiration_date | Option expiry | — |
multiplier | Contract multiplier | Auto-detected |
account | Account identifier | — |
Sample CSV Files
Stocks Example
symbol,side,qty,price,timestamp,asset_class,fees AAPL,buy,100,150.50,2024-01-15 09:30:00,equity,1.00 AAPL,sell,100,155.25,2024-01-15 14:30:00,equity,1.00 NVDA,buy,50,480.00,2024-01-15 10:00:00,equity,0.50 NVDA,sell,50,485.75,2024-01-15 15:45:00,equity,0.50
Futures Example
symbol,side,qty,price,timestamp,asset_class,fees,multiplier NQ,buy,2,17500.25,2024-01-15 09:31:00,future,4.50,20 NQ,sell,2,17525.50,2024-01-15 10:15:00,future,4.50,20 ES,buy,1,4850.00,2024-01-15 09:35:00,future,2.25,50 ES,sell,1,4855.25,2024-01-15 11:00:00,future,2.25,50
Options Example
symbol,side,qty,price,timestamp,asset_class,fees,option_type,strike_price,expiration_date,multiplier SPY,buy,5,2.50,2024-01-15 09:32:00,option,3.25,call,500,2024-01-19,100 SPY,sell,5,3.75,2024-01-15 14:00:00,option,3.25,call,500,2024-01-19,100
Important Notes
Date/Time Format
Supported formats:
YYYY-MM-DD HH:MM:SS(recommended)MM/DD/YYYY HH:MM:SS- ISO 8601 format
Tip: Use UTC times for best consistency, or your local timezone.
Side Values
The following values are accepted for the side column:
| Buy Values | Sell Values |
|---|---|
buy, long, b | sell, short, s |
Asset Class Detection
If you don't specify asset_class, TradeRonin will auto-detect:
- Symbols starting with
/→ Futures - Symbols containing
USD,EUR,GBP→ Forex - Symbols containing
BTC,ETH→ Crypto - Everything else → Equity
Multipliers
Multipliers are automatically detected for common futures and all options. You can override by including the multiplier column.
Column Name Flexibility
TradeRonin accepts multiple column name variations:
| Standard | Also Accepted |
|---|---|
symbol | Symbol, instrument, ticker |
side | Side, action, buy_sell |
qty | quantity, size, contracts, shares |
price | Price, avg_price, execution_price |
timestamp | time, datetime, date |
fees | commission, fee, cost |
account | Account, account_id, account_number |
Troubleshooting
"Missing required fields" Error
Make sure your CSV has all 5 required columns: symbol, side, qty, price, timestamp
"Invalid side" Error
Check that your side values are one of: buy, sell, long, short, b, s
"Invalid timestamp" Error
Ensure dates are in a supported format like 2024-01-15 09:30:00
Duplicate Entries
TradeRonin automatically deduplicates based on the combination of symbol, side, quantity, price, and timestamp. Re-uploading the same CSV won't create duplicates.
Best Practices
✅ Use headers — Always include a header row
✅ One execution per row — Each buy or sell is a separate row
✅ UTF-8 encoding — Save your CSV with UTF-8 encoding
✅ Include fees — Add commission column for accurate P&L
✅ Test small — Upload a few rows first to verify format
Need Help?
If you have trouble with your CSV format, contact support with:
- A sample of your CSV (first 5-10 rows)
- The error message you're seeing
- The broker/platform your data came from
