online broker |Form 8949 Capital Gain & Wash Sales calculator software

Import Trade History

Technically, TradeMax supports every broker, known or unknown, as long as this broker provides a statement in CSV/EXCEL format or Quicken Qif,QFX fomart / Money OFX format or OFX server connection. Without changing codes, TradeMax allows users to define their own templates which suit the CSV format of their broker data.

There are Four options to import your trade data into TradeMax:

A) Import Trades from online Brokerage Server(OFX Server)

If you want to download trades from online brokerage account, select this option. Please check our supported broker’s OFX server list, if your brokerage provide ofx data service and not listed in our list, you can send your broker name & ofx server url to contact form we will add it to TradeMax.

B)Import Trade Activity data from local file (Recommended)

  1. Built-in Broker Profile: Currently TradeMax already havs built-in template for IB and ETrade, ScotTrade, OptionsXpress, TdAmeritrade, Schwab, Person,Sogotrade and more.(Please check our supported brokers list),
  2. File Profile: TradeMax can support Quicken Interchange Format(*.QIF), Micorsoft Excel(*.xls), Open Financial Exchange(*.OFX) file, Quicken Financial Exchange(*.QFX) file
    How to import Quicken QIF file to TradeMax
  3. Unknown column csv or excel file:You can either define your own template with trademax profile wizard function or send us a sample CSV or Xls data file with 8~10 lines of transactions in it for importing, we will build template for customer without any extra cost.

Import Sample files

The following documents contains sample trade data that you can download to practice or use as templates for importing transactions into TradeMax.

Trade Activity Sample Files.xls (Profile Wizard[*.xls])
Each Record has TradeDate,Symbol,Action,Qty,Price,Commission,Amount
15 kB
Realized Gain and Loss Report.xls (Profile Wizard[*.xls]) –
(Symbol,qty,open/close date ,Proceeds /Cost Basis in single record)
18 kB

C) Import Realized Gains and Losses Report from Local File
If you already have Realized Gain and Loss Report, TradeMax can help you to import it directly from the local file with the following step-by-step wizard.More…

Please Note: Some Gains & Losses Reports do not have year end open postion,this will effect wash sale calculating.

D) Import Trade data copied from broker Transaction History Report
You can copy your Broker’s Transaction History report from the web browser and paste to TradeMax during the importing process. More…

Download Your Data File

TradeMax provides you a powerful way to import your data file from your hard drive. You should download your data from your online broker or export it from Microsoft Money or Quicken etc.

  1. You can directly download your data from your online broker. The process is:
    1. Log in to your online Broker’s web site and go to the Account History Section.
    2. Find the Data file option (*.txt,*.qif, *.csv,*.xls).
    3. Select a Time Period for your data file (for example, Start “1/1/2008”, End “12/31/2008”).
    4. Click the download button.
    5. Download the file to your hard drive. Save it to “C:\My Documents\TradeMax”.
  2. You can also copy the data file from your online broker’s website. The process is:
    1. Log in to your online Broker’s web site and go to the Account History Section.
    2. Find the Data file option(*.txt,*.qif, *.csv).
    3. Select a Time Period for your data file (for example, Start “1/1/2008”, End “12/31/2008”).
    4. Display the data file
    5. Select and copy the data file just like the Microsoft excel and past it to a NotePad.
    6. Save it to “C:\My Documents\TradeMax”.
  3. Export from an acceptable program like Microsoft Money or Quicken; just follow the program’s HELP. Qif format file ,ofx format file and Excel format are supported by TradeMax.


If your online broker does not support any of the above formats, please contact them asking for the possible data file such as CSV file, a text file (tab delimited) or a QIF file

Page 1 of 11

Copyright © 2008-2016 Neutral Trend Inc. All Rights Reserved.