Overview
If your broker is not directly integrated with RR Metrics, you can import trades using the generic CSV format. Prepare a spreadsheet with the columns described below, export it as a .csv file, then upload it via Trades → Import → Generic CSV.
Required Columns
Every row must include these columns. Rows with missing required values will be skipped during import.
ticker
The symbol you traded. Use the base symbol without expiry — e.g., NQ, ES, AAPL, EURUSD.
direction
Trade direction. Accepted values: long or short (case-insensitive). Also accepts buy / sell.
entry_price
Average fill price on entry. Use a decimal number — e.g., 19825.50. Do not include currency symbols or commas.
exit_price
Average fill price on exit. Same format as entry_price.
quantity
Number of contracts or shares traded. Must be a positive integer — e.g., 2.
entry_time
Date and time of entry. Accepted formats: YYYY-MM-DD HH:MM:SS, YYYY-MM-DDTHH:MM:SS, or MM/DD/YYYY HH:MM. Include time — date-only values will default to 00:00:00.
exit_time
Date and time of exit. Same format as entry_time. Must be after entry_time.
Optional Columns
Include any of these to enrich your trade records. Columns with empty values in a row are silently ignored for that row.
pnl
Override the auto-calculated P&L with your broker's reported value. Useful when commissions or tick multipliers differ. Positive for profit, negative for loss — e.g., 425.00 or -187.50.
tags
Comma-separated list of tags to attach — e.g., breakout,morning session. Tags must already exist in your RR Metrics account (create them under Settings → Tags) or they will be created automatically on import.
notes
Free-text notes for the trade. If your notes contain commas, wrap the entire field in double quotes — e.g., "Entered on breakout, stopped out at LOD".
strategy
Name of the strategy to assign the trade to. Must match an existing strategy name in your RR Metrics account exactly (case-sensitive).
Example File
A minimal valid CSV looks like this:
ticker,direction,entry_price,exit_price,quantity,entry_time,exit_time,pnl,tags,notes NQ,long,19825.50,19887.25,2,2026-02-18 09:32:00,2026-02-18 09:51:00,2430.00,"breakout","Textbook open drive" ES,short,5050.00,5038.00,1,2026-02-18 14:10:00,2026-02-18 14:22:00,600.00,, AAPL,long,182.30,180.10,100,2026-02-18 10:05:00,2026-02-18 11:15:00,-220.00,reversal,"Reversal failed at VWAP"
Common Issues
- Rows skipped during import — Open the import result summary to see which rows were skipped and why. Common causes are missing required fields, invalid date formats, or non-numeric price values.
- Dates imported as wrong day — Ensure your spreadsheet app is not reformatting dates when you save as CSV. Open the CSV in a plain text editor to verify the raw date strings before importing.
- Extra columns in the file — Unrecognized column names are ignored. You do not need to remove extra columns from broker exports — just make sure the required columns are present with the correct header names.
- Encoding issues with special characters — Save your CSV as UTF-8 (without BOM). In Excel, use "CSV UTF-8 (Comma delimited)" when exporting. In Google Sheets, use File → Download → CSV.