Importing Trades Using Generic Import Format

If your broker is not directly supported by Tradervue, you can use our generic import format to import your trades.

Your data should be formatted like this:

Date,Time,Symbol,Quantity,Price,Side

1/17/2011,11:35:05,SPY,100,125.52,Buy

1/17/2011,14:41:15,SPY,100,125.89,Sell

or:

Steps to Import Trades

A great way to get started is to generate the necessary data in the format using Excel. You can start this simple sample template:

Click on the first dropdown and select Generic Import Format as your Broker/Platform

Option 1: Click on “Choose File” and select your Generic Import Format .CSV file, then click “Open”
Option 2: Copy the data from your .CSV file and paste it into the “Data” box at the bottom (keep the header)

Verify Imported Trades

Notes About the Data Format

Date: Highly recommended. If omitted, the import date will be used for each execution. Must be in one of the following formats: mm/dd/yyyy, mm-dd-yyyy, yyyy/mm/dd, yyyy-mm-dd, yyyymmdd.
Time: Highly recommended. If omitted, 12:00:00 will be used as the execution time. Must be in HH:MM
format in 24-hour time. The time zone can be selected during import.
Symbol: Required. For futures, symbols can be in various formats such as ESZ1, ES Dec 11, or ES 12.11. For forex, use symbols like EURUSD.
Quantity: Required.
Price: Required.
Side: Optional. If omitted, the quantity should be negative to indicate a sell. If present, needs to start with a "B" or "S" for buy or sell (e.g., Buy, Sell, Short).

Additional Details:

Delimiters: Either commas or tabs are acceptable.
Header Row: Recommended but optional if columns are in the exact order shown. If columns are in a different order, include the header.

Add columns titled "Commission", "TransFee", and "ECNFee" for trade commission, transaction fees, and ECN fees/rebates respectively. Positive numbers are charges, and negative numbers are credits.

Add a column titled "Option" with the specific contract name (e.g., "JAN 12 125 CALL"). Ensure the symbol column specifies the symbol.

Example Data with Options:

Time,Date,Quantity,Symbol,Side,Price,Option

09:35:05,1/5/2012,1,SPY,Buy,1.75,JAN 12 125 CALL

09:39:34,1/5/2012,100,SPY,Sell,121.50,

09:41:22,1/5/2012,100,SPY,Buy,120.50,

09:52:54,1/5/2012,1,SPY,Sell,1.50,JAN 12 125 CALL

For option assignment and expiration, add rows to reflect these events, e.g., buy back a short option contract on expiration.

Common Index Options:

Mini Options:

Need Help?

If you have questions or encounter issues importing data, please reach out to support@tradervue.com or use the "Contact Us" link below.