Brokers

Different brokers have different export options so on this page you will find instructions for some of the brokers supported by TradeNote.

Export instructions are written with the help other TradeNote users in the community. Contact me if you want to contribute as well.

You contact me via Discord if you wish to integrate your broker. Alternatively, you can use the template and adapt it to your export file.

Community members have also created custom scripts to convert export files to fit the template in custom scripts.

Template

If you wish to adapt your export file to the template, below is the explanation for each of the columns. Note : make sure to input one execution per line, not aggregated trade. So one line = one execution

• Account: your accound id or name
• T/D: trade date in MM/DD/YYYY format
• S/D: settlemennt date in MM/DD/YYYY format
• Currency: currency applied to the price of symbol
• Type: must be of type "stock", "future", "forex", "call" or "put"
• Side: side of the execution
  • B: Buy
  • S: Sell
  • SS: Short
  • BC: Buy cover
• Symbol: symbol
• Qty: number of shares executed
• Price: price of symbol
• Exec Time: trade time in HH:mm:ss format
• Comm: commissions. Must be a positive number
• SEC: SEC fees. Put 0 if not applicable
• TAF: TAF fees. Put 0 if not applicable
• NSCC: NSCC fees. Put 0 if not applicable.
• Nasdaq: Nasdaq fees. Put 0 if not applicable
• ECN Remove: not applicable. Put 0
• ECN Add: not applicable. Put 0
• Gross Proceeds
• Net Proceeds: gross proceeds minus commissions and fees
• Clr Broker: not applicable. Leave blank
• Liq: not applicable. Leave blank
• Note: not applicable. Leave blank

TradeZero

1. Ling to the portal and click My Account.
2. Click Account Overview from the dropdown.
3. Once into account stats, click on the Trades tab.
4. Set the start and end dates you wish to export, then click Search.
5. Just above the list of trades click and save the CSV

Interactive Brokers

1. Login to the Portal
2. Select the Performance & Reports tab (top of the page, under the Search Box)
3. Select Flex Queries
   1. There are 2 options available, Activity Flex Query and Trade Confirmation Flex Query.
   2. We are interested in the Trade Confirmation Flex Query
4. Under the Trade Confirmation Flex Query panel, click the Create, +, button.
5. At the Create Trade Confirmation Flex Query page, select the following options
   1. Trade Confirmation Flex Query Details: Provide a Query Name (ex. TradeNoteExport)
   2. Sections
      1. Click Trade Confirmation and only select Executions
      2. From there, you can either
         1. Check the following boxes manually: Account ID, Date/Time, Settle Date, Currency, Underlying Symbol, Symbol, Buy/Sell, Quantity, Price, Commission, Code, Broker Execution Commission, Broker Clearing Commission, Third-Party Execution Commission, Third-Party Clearing Commission, Other Commission, Proceeds, Net Cash, Trade ID, Order ID, Asset Class, Multiplier, Put/Call
         2. Or execute the following script using your browser's DevTools console:

         const fields=["Account ID","Date/Time","Settle Date","Currency","Underlying Symbol","Symbol","Buy/Sell","Quantity","Price","Commission", "Code", "Broker Execution Commission","Broker Clearing Commission","Third-Party Execution Commission","Third-Party Clearing Commission","Other Commission","Proceeds","Net Cash","Trade ID","Order ID","Asset Class","Multiplier","Put/Call"],container=document.querySelector('tbody[class="ui-sortable"]'),trs=container.querySelectorAll("tr");trs.forEach(e=>{let r=e.querySelectorAll("td"),t=r[1].childNodes[0].textContent;if(fields.includes(t)){let i=e.querySelector('input[type="checkbox"]');i.click()}});

      3. Scroll to the bottom of the dialog and select Save
   3. Delivery Configuration
      1. Models: Optional
      2. Format: CSV
      3. Include header and trailer records?: No
      4. Include column headers?: Yes
      5. Include section code and line descriptor? No
      6. Period: Today (or any other option)
   4. General Configuration
      1. Date Format: yyyyMMdd
      2. Time Format: HHMMSS
      3. Date/Time Separator: ;(semi-colon)
      4. Include Canceled Trades?: No
      5. Include Audit Trail Fields?: No
      6. Display Account Alias in Place of Account ID?: No
   5. Select Continue
6. On the Review Your Trade Confirmation Flex Query page, click Save Changes
7. On the Trade Confirm Flex Query Saved page, click Ok
8. Notice your new Flex Query is now available under the Trade Confirmation Flex Query panel
9. Use the Run (right arrow icon) to generate a new report
10. In the TradeNoteExport (name of your Flex Query) dialog, select
    1. Period: < Your desired date range >
    2. Format: CSV
    3. Click Run
11. At this point, your file should be downloaded and available to use

Cleanup before importing to TradeNote (optional) Before attempting to import data, there are a few things that may help.

• Remove any empty lines that may be present in your CSV file
• If multiple accounts are present, isolate them to 1 account at a time
• If trading options, futures, etc., ensure the Underlying Symbol exists
• May need to set the Underlying Symbol as the ticker from the Symbol column
• Sort the trades by Order Time
• Remove any Open Trades
• Add an Order Time to Expired Contracts rather than leaving the fields empty
• Format prices to 2 decimal places to prevent dealing with floating point precision errors

TD Ameritrade (thinkorswim)

Please use the standalone thinkorswim application and follow the steps below.

1. Navigate to the "Monitor" tab, then "Account Statement" tab.
2. From "days back from today" dropdown, filter the date range.
3. From "Transactions" dropdown, select "Trades" and deselect all others.
4. From the top right corner (underneath "OnDemand" button), click the Actions menu (3-dashes) and "Export to file".
5. Save the .csv file to your desktop.

In some cases you may see the following message on import

ERROR IN UPLOAD FILE No matching execution in Account Trade History for execution in Cash Balance on xx/xx/xx xx:xx:xx. Please correct your file manually and upload it again.

The way the import code works is that it looks for matching executions in two tables : Account Trade History and Cash Balance. The code matches these executions by date and time. However, there is a bug in TD where certain matching executions have one or two seconds time difference. You need to look for those time differences and change them manually.

TradeStation

1. Select the "Orders" tab at the bottom of the TradeManager window in TradeStation.
2. Choose "Filled Orders" from the "Status" drop-down menu at the top of the screen.
3. Press the "Retrieve Orders" button after entering the date range that you want to import.
4. Sort by Filled/Canceled orders in ascending order (e.g., oldest first) by changing the sort order.
5. Select "Copy" by right-clicking after clicking (ticking) the upper-left "square" right beneath "Symbol Filter" label.
6. Paste the transactions into the text box in TradeNote.

Note: currently, TradeNote does not take into account ECN fees (available soon).

Tradovate

1. click on the Account tab, then choose the account to export.
2. select "Orders".
3. Select time window of history data.
4. Download as CSV.

MetaTrader 5 (MT 5)

Please use the standalone MT5 windows application and follow the steps below. Also, make sure to set the MT5 language to English before exporting the trades. In the MT5 main menu at the top go to View -> Languages and select English.

1. In the MetaTrader Terminal window, select the History tab.
2. Right-click on any order in the account history, and select the time period you want to export.
3. Right-click on any order in the account history, and select Report.
4. Save the report as an "Open XML (MS Office Excel 2007)" file to your desktop (or anywhere else - just remember where you put it).

HeldenTrader Pro

1. In the upper section of the application select the "Account" button.
2. In the dropdown menu select "Reports" and a new window "Reports" will appear.
3. Select in the "Report type" dropdown menu - "Trades report".
4. Select the timeframe you want to export in the "From" - "To" dropdown menu. One export file can contain one or more trading days/weeks.
5. Select "Export to CSV".

Rithmic

1. Login to RTrader Pro
2. Open Order History (step1.webp)
3. Reset Order History to original template (step1.1.webp)
4. Select your Account and the date you want to export (step2.webp)
5. Adjust the reporting by adding the columns "Qty filled" and "Commission Fill Rate" (DO NO CHANGE SORTING OF THE COLUMNS) (step3.webp ; step4.1.webp ; step4.2.webp )
6. Sort the Orders ascending (first order on top) (step5.webp)
7. Export As CSV (step6.webp)

optional Steps

You can create a separate template so that the steps do not have to be carried out for every export.

1. Save the report via "Save with a name..." (step7.webp)
2. Then you can open the template with a simple click on the Sidebar (step8.webp)

Please note that trades need to be ordered in ascending order

FundTraders

1. Login to your account
2. Click Reports on the left pane
3. Click Trade History
4. Click View Report
5. Click download as csv

NinjaTrader

1. In the NinjaTrader 8 Control Panel Window, select New, and choose Trade Performance.
2. In the top right corner of the Trade Performance window, choose the date(s) you would like to export. To export a single day, please ensure both fields reflect the same day you wish to export.
3. Click the 'funnel' icon in the top left of the Trade Performace window, and ensure only the account you wish to export is selected.
4. Next, change the "Display" dropdown menu to "Executions".
5. In the Trade Performance window, click the "Generate" button in the top right corner.
6. Right-click anywhere in the output window, and choose "Export".
7. Next, change the "Save as type" field to "CSV (*.csv).
8. Finally, click "Save". Your exported file will save to the location specified

TopstepX

1. Login to TopstepX account.
2. Click the Orders component.

3. Click export.

4. Select date range and click Export.