Home

Trade Export Guide
































Aurora Trading Journal Import


The first step is exporting trade history from Aurora. For United Traders, you can download your report from this link.

If the link does not work:

  1. Scroll to the bottom of the page and select the trading platforms tab from under the trading column.
  2. Select the trading analytics tab.
  3. Select the transactions report tab.
  4. Select the time frame (last 7 days or 30 days etc.)
  5. Click on the download report button.
  6. Here on the import page, click "Choose file", choose the file you created above, and click "Upload".

Binance Trading Journal Import


The first step is exporting trade history from Binance. For Binance, please use these instructions:

If the link does not work:

  1. Login in to your Binance account here: Binance Account.
  2. Click on the "Orders" menu option, and then click "Order History" (not to be confused with order history).
  3. Near the top right hand side of the screen, click on the link that says "Export Complete Trade History".
  4. Select the date range you want to download.
  5. Click on the "Export" button and save the file.
  6. Here on the import page, click "Choose file", choose the file you downloaded in the step above, and click "Upload".

CMEG Trading Journal Import


The first step is exporting trade history from CMEG. For Capital Markets Elite Group, please use the DAS Trader export/import instructions.

For Sterling Trader Pro users, please use the Sterling Trader Pro export/import instructions.


Colmex Pro Trading Journal Import


The first step is exporting trade history from Colmex Pro. To import data from Colmex Pro, follow these steps:

  1. Log into your MTS account.
  2. Click Trade History, then select a date range you wish to export trades for.
  3. Click "Excel", and download the CSV file. Save the file anywhere you want – just remember where you put it!
  4. Here on the import page, click "Choose file", choose the file you created above, and click "Upload".

DAS Trader Trading Journal Import


The first step is exporting trade history from DAS Trader Pro. To import trade data from DAS Trader Pro, follow these steps:

  1. Select Trade Log from the Trade menu.
  2. Right-click in the list of executions and select Export, and save the file to your desktop (or anywhere else - just remember where you put it).
  3. Here on the import page, click in the Trade Date box and select the date of the trades you are importing (e.g. if you're importing today's trades, select today). You must select a date because the data exported from DAS Trader Pro does not include the trade dates.
  4. Click "Choose file", choose the file you created above, and click "Upload".

NOTE: Since DAS Trader resets the trades executed each day, be sure to perform these steps to export your trades as soon as you are done trading for the day.


E*Trade Trading Journal Import


The first step is exporting trade history from E-Trade. To import trade data from E-Trade, follow these steps:

  1. From the E-Trade web site, click "Alerts" to open a separate Alerts window.
  2. By clicking and dragging, select the rows of data you wish to import, and press Ctrl+C (or Cmd+C) to copy.
  3. Here on the import page, click in the "Data" box, and press Ctrl+V (Cmd+V) to paste the data into the box, then click Upload.

iFund + FUSION Trading Journal Import


The first step is exporting trade history from iFund = FUSION. To import trade data from iFun + FUSION for the first time, follow these steps:

  1. Go to your control panel at https://ifund.fusionts.com/Main.aspx
  2. Click "Demo Reports" on the left side of the page
  3. Click on "Demo Trade History".
  4. Select the time period you would like to export
  5. Click "View Report"
  6. Once that has been generated, click on the CSV icon near the top right hand side of the page
  7. Save the CSV and go upload the CSV file on TradeInsights.net.

To import trade data from iFun + FUSION for returning users, follow these steps:

  1. Go to your control panel at https://ifund.fusionts.com/Main.aspx
  2. Click "Demo Reports" on the left side of the page
  3. Click "Today's Demo Executions"
  4. Once that has been generated, click on the CSV icon near the top right hand side of the page
  5. Save the CSV and go upload the CSV file on TradeInsights.net.

Generic Import Format


Do you track your trades manually in a csv or in Excel? If so, the generic import is for you! Your file must have one row per order. That means we need a row for a buy and a row for a sell. The import will match them up to calculate your P&L.

This import looks for various column names to find the fields we need to calculate your P&L.

*Blue columns are required.

Expected ColumnAccepted Column Names
TradeDatetrade date, tradedate, date, t/d
ExecTimeexectime, exec time, execution time, time
Symbolsymb, sym, symbol, ticker
Quantityqty, shares, quantity, size, noshares, numshares, share cnt, share count, quant, position
Priceprice, prc, cost
BuySellbuysell, side, b/s, b / s, bot/sld, action
SecurityTypesecuritytype, sectype. Required for options and futures. Acceptable values are stock, option, opt, future, and fut. Defaults to stock.
Accountaccount, acct, acct#, acctno, account number, account id, acct #, acct no, acct no.
Commissioncommission, comm, com
Currencycurrency, currency code
Fee1fee 1, fee1, fee
Fee2fee 2, fee2
Fee3fee 3, fee3
Fee4fee 4, fee4
SECFeesec fee, secfee, sec
TAFFeetaf, taffee, taf fee
ECNFeeecnfee, ecn fee
OrderNumberorder number, order num, order no, ordernumber, ordernum, orderno, order#, order #, order id, orderid


Here is an exmple of what a simple generic file would look like:

Generic Example style=


Interactive Brokers Trading Journal Import


The first step is exporting trade history from Interactive Brokers. To import data from Interactive Brokers, follow these steps:

  1. Open your Interactive Brokers account web site, go to Reports, then click Statements.
  2. If you have multiple IB accounts, the Account Selector opens. Search for and select an account.
  3. In the "Run a Statement" panel, select Third-Party Downloads as the statement type.
  4. Choose the TradeLog format from the Format drop-down.
  5. Select the period and date using the drop-downs provided.
  6. Click Run Statement to create the TradeLog report.
  7. When the data appears, select all of the text by pressing ctrl+A (cmd+A on a Mac), or choosing "Select All" from your browser's Edit menu.
  8. Copy the selected data by pressing ctrl+C (cmd+C), or choosing "Copy" from your browser's Edit menu.
  9. Paste the data into the "Data" box on the left side of this page, and click "Upload".

LightSpeed Trading Journal Import


The first step is exporting trade history from Lightspeed. To import trade data from Lightspeed, follow these steps:

  1. Log into the Lightspeed web site, and navigate to My Accounts / Trading Reports / Account View.
  2. Click on your account number to choose the account to view.
  3. Click "Blotter", and select the date range you wish to export.
  4. Click the CSV button, and download the CSV file to your desktop (or anywhere else - just remember where you put it).
  5. Here on the import page, click "Choose file", choose the file you created above, and click "Upload".

MyQuesTrade website Trading Journal Import


The first step is exporting trade history from QuesTrade. To import data from MyQuesTrade website, follow these steps:

  1. On the left side of this page, select the date format your data uses (e.g. month-first, or day-first).
  2. Open the MyQuestrade web site.
  3. Select Account from the drop-down menu.
  4. Select the date range you want to export from the dropdown, or the start and end date boxes, and then select "View Report".
  5. If you have the option to export to CSV:
    • Export the report to a CSV file. Save the file to your desktop (or anywhere else - just remember where you put it).
    • Here on the import page, click "Choose file", choose the file you created above, and click "Upload".
  6. If you have the option to export to Excel:
    • Export to Excel, and open the spreadsheet. Copy the entire contents of the spreadsheet to the clipboard (Edit/Select All, then Edit/Copy).
    • Paste the data into the "Data" box on the left side of this page and click "Upload".

QuesTrade IQ Edge Trading Journal Import


The first step is exporting trade history from QuesTrade. To import data from Questrade IQ Edge, follow these steps:

  1. Open IQ Edge, click Tools (at the top), then click Account.
  2. Click the Executions Tab in the Account window.
  3. Right click on the column headers and choose "edit columns".
  4. In the bottom left, click "Restore Defaults", then Scroll through the list and click the box beside "Exec time", making sure that it's checked. Click OK to save the columns.
  5. Right-click the column headers again, and click "Export..."
  6. Save the file to your desktop (or anywhere else - just remember where you put it).
  7. Here on the import page, click "Choose file", choose the file you created above, and click "Upload".

RobinHood Trading Journal Import


The first step is getting trade history from RobinHood. To import trade data from RobinHood, follow these steps:

  1. Open the RobinHood Application
  2. Go to the profile tab
  3. Scroll down to and click on "Help"
  4. Click on "Contact Us"
  5. Click on "Documents and Taxes"
  6. Scroll down and click on "Something Else"
  7. Fill out the form with verbiage similar to this: "I'd like an exported csv file that contains all of my trades. Thank you!"
  8. They will email you a link where you can download the export. Download the document to your computer.
  9. Go to the import trades page and select "RobinHood" as your broker, and select the new file to upload.

R | Trader / Rithmic Trading Journal Import


The first step is exporting trade history from Rithmic R | Trader. To import data from Rithmic R | Trader, follow these steps:

Important: You must select the time zone R | Trader is using.
  1. On the left side of this page, select the time zone R | Trader is using.
  2. In R | Trader, go to Order History.
  3. Choose the account you want to export, and select a date.
  4. Export as a CSV file. Save the file to your computer.
  5. Import the file here on the "Import Trades" page.

Sterling Trader Pro Trading Journal Import


The first step is exporting trade history from Sterling Pro. To import data from Sterling Pro and Sterling Pro Simulator, follow these steps:

  1. Go to the Position Manager (or the Trading Monitor) in the platform, and include these (and only these) columns, in exactly this order:

    Date Time Symbol Shares Price Side

    For the "Price" column, be sure to use the execution price, not the order price.
  2. Export the data to a text file.
  3. Import the file here on the "Import Trades" page.

Sterling Trader Pro Demo Trading Journal Import


The first step is exporting trade history from the Sterling Pro Demo. To import data from Sterling Pro and Sterling Pro Simulator, follow these steps:

  1. Go to the Position Manager (or the Trading Monitor) in the platform, and include these (and only these) columns, in exactly this order:

    Date Time Symbol Shares Price Side

    For the "Price" column, be sure to use the execution price, not the order price.
  2. Export the data to a text file.
  3. Import the file here on the "Import Trades" page.

SureTrader Trading Journal Import


The first step is exporting trade history from SureTrader. To import data from SureTrader, follow these steps:

  1. Visit https://app.suretrader.com/tradehistory, and login using your SureTrader registered email address and password.
  2. Choose the date range you'd like to export, and click Detail.
  3. Click ‘CSV’ button at the top of the table (CSV download launched).
  4. Save the CSV file to your desktop (or anywhere else - just remember where you put it).
  5. Here on the import page, click "Choose file", choose the file you created above, and click "Upload".

Tastyworks Trading Journal Import


The first step is exporting trade history from TD Amertrade. To import data from Tastyworks, follow these steps:

  1. Open the Tastyworks desktop application.
  2. Click on the History tab.
  3. Click the Transactions button on the left side of the screen to select your transactions; be sure the year to date button is not selected.
  4. Select the time period that you wish to export.
  5. On the right side, click the CSV button.
  6. Save the CSV file to your desktop (or anywhere else - just remember where you put it).
  7. Here on the import page, click "Choose file", choose the file you created above, and click "Upload", OR drag and drop the file to the upload area.

TD Ameritrade Trading Journal Import


The first step is exporting trade history from TD Amertrade (if you're using ThinkOrSwim ignore these instructions and click here). To import data from TD Ameritrade, follow these steps:

  1. From the TD Ameritrade web site, go to My Account, then History & Statements. Click the Transactions tab.
  2. Choose the date range you wish to import, and click View.
  3. Click and drag to select the rows of data you wish to import from the Search Results table, and press Ctrl+C (or Cmd+C) to copy.
  4. Here on the import page, click in the "Data" box, and press Ctrl+V (Cmd+V) to paste the data into the box
  5. Looking at the TD Ameritrade web page you copied from, determine the time zone the trades are displaying in, and select it in the Time Zone dropdown box. Be sure to check this, as we've seen data show up in different timezones including GMT.
  6. Click the Upload button to upload your trades.

TEFS Trading Journal Import


The first step is exporting trade history from TEFS. To import data from TEFS, follow these steps:

  1. Log into your MTS account.
  2. Click Trade History, then select a date range you wish to export trades for.
  3. Click "Excel", and download the CSV file. Save the file anywhere you want – just remember where you put it!
  4. Here on the import page, click "Choose file", choose the file you created above, and click "Upload".

ThinkOrSwim Trading Journal Import


The first step is exporting trade history from ThinkOrSwim. To import trade data from Thinkorswim, follow these steps:

  1. Open the Thinkorswim desktop application, go to the "Monitor" tab, and choose "Account Statement" from the options at the top.
  2. Click the dropdown at the top of the Account Statement and select the date range you wish to import. Wait for the "Trade History" section to fill in with your trades from that range; note that if you are looking for data far in the past this may take a while.
  3. The TradeInsights import process expects these columns in the Account Trade History section: Exec Time,Spread,Side,Qty,Pos Effect,Symbol,Exp,Strike,Type,Price,Net Price,Order Type If you do not have these columns, then (in TOS when exporting) you can restore these defaults by clicking the circle to the left of the column headers under trade history, select "Customize", then click Load Defaults and OK.
  4. Make sure the Trade History section is sorted by Exec Time, with the oldest first.
  5. Click the actions menu at the top right of the window, and select "Export to file" from the menu that displays.
  6. Change the file type to "CSV", and save the file to your desktop (or anywhere else - just remember where you put it).
  7. Here on the import page, click "Choose file", choose the file you created above, and click "Upload".

TradeNet Trading Journal Import


The first step is exporting trade history from TradeNet. To import data from TradeNet, follow these steps:

  1. Log into your MTS account.
  2. Click Trade History, then select a date range you wish to export trades for.
  3. Click "Excel", and download the CSV file. Save the file anywhere you want – just remember where you put it!
  4. Here on the import page, click "Choose file", choose the file you created above, and click "Upload".

TradeStation Trading Journal Import


The first step is exporting trade history from TradeStation. To import data from TradeStation, do the following:

  1. Select the timezone you're trading from.
  2. In TradeStation, go to the TradeManager and select the "Orders" tab on the bottom of the screen.
  3. From the "Status" drop-down at the top of the screen, select "Filled Orders".
  4. Enter the date range you want to import into TradeInsights and press the "Retrieve Orders" button.
  5. Change the sort order to sort by Filled/Cancelled orders in ascending order (e.g. oldest first).
  6. Press Ctrl+A to select all, then Ctrl+C to copy the data.
  7. Paste the data into the "Data" box on the import page, and click "Next".

TradeZero Trading Journal Import


The first step is exporting trade history from TradeZero. To import data from TradeZero, follow these steps:

  1. Sign into the TradeZero.co customer portal, and click Check My Account.
  2. Once into account stats, click on the History tab.
  3. Below the History tab, click "Trading". Set the start and end dates you wish to export, then click Update.
  4. Just above the list of trades, click the Excel icon, and save the CSV file to your desktop (or anywhere else - just remember where you put it).
  5. Here on the import page, click "Choose file", choose the file you created above, and click "Upload".

Warrior Trading Simulator Trading Journal Import


The first step is exporting trade history from the Warrior Trading Simulator. To import data from the Warrior Trading simulator, follow these steps:

  1. Go to the Position Manager (or the Trading Monitor) in the simulator, and include these (and only these) columns, in exactly this order:

    Date Time Symbol Shares Price Side

    For the "Price" column, be sure to use the execution price, not the order price.
  2. Export the data to a text file.
  3. Import the file here on the "Import Trades" page.













































Follow Us on Social Media
YouTube - FaceBook - Twitter - Instagram - LinkedIn