scottrade |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…

Supported Brokers


TradeMax supports importing data form the following brokers.

The brokers who support import type OFX server, can get import trade history from online brokerage in a fast and easy manner.

With the help of TradeMax’s Import Profile Wizard function, you can import csv,excel files with unknown column header.

Column Header Import Type Link Detail
Ameritrade OFX Server ,CSV http://www.tdameritrade.com/welcome1.html Click Here
American Century Investment OFX Server ,CSV https://www.americancentury.com/index.jsp Click Here
Ameriprise Financial service OFX Server ,CSV http://www.ameriprise.com/default-home.asp Click Here
Brown Co OFX Server ,CSV https://us.etrade.com/e/t/home Click Here
Edward Jones OFX Server ,CSV http://www.edwardjones.com/index.html Click Here
Fidelity Investment OFX Server ,CSV https://www.fidelity.com/ Click Here
Fidelity Netbenefit OFX Server ,CSV https://www.fidelity.com/ Click Here
Penson Financial OFX Server ,CSV https://online.penson.com/ Click Here
Schwab OFX Server ,CSV https://www.schwab.com/ Click Here
ScotTrade OFX Server ,CSV http://www.scottrade.com/ Click Here
BOA Investment OFX Server ,CSV www.baisidirect.com Click Here
E-Trade OFX Server ,CSV https://us.etrade.com/ Click Here
Harrisdirect OFX Server ,CSV https://www4.harrisbank.com Click Here
OptionsXpress OFX Server ,CSV http://www.optionsxpress.com/ Click Here
OppenheimerFunds OFX Server ,CSV http://www.opco.com/ Click Here
RBC Dain Rauscher OFX Server ,CSV http://www.rbcwm-usa.com Click Here
Robert W. Baird OFX Server ,CSV http://www.rwbaird.com/ Click Here
Vanguard OFX Server ,CSV http://www.vanguard.com/ Click Here
Merrill Lynch OFX Server ,CSV http://www.ml.com/ Click Here
Morgen Stanley Smith Barney OFX Server ,CSV http://www.morganstanleysmithbarney.com/ Click Here
Morgen Stanley ClientServ OFX Server ,CSV https://www.morganstanleyclientserv.com/default.aspx? Click Here
T.Rowe Price OFX Server ,CSV http://corporate.troweprice.com/ Click Here
UBS OFX Server ,CSV http://www.ubs.com/ Click Here
USAA OFX Server ,CSV https://www.usaa.com/inet/ent_logon/Logon Click Here
Wells Fargo OFX Server ,CSV https://www.wellsfargo.com/ Click Here
Wells Fargo Funds OFX Server ,CSV http://www.wellsfargoadvantagefunds.com/ Click Here
Interactive Broker CSV, TXT, etc https://www.interactivebrokers.com/ Click Here
Tradestation Security CSV, TXT, etc http://www.tradestation.com Click Here
TradeKing QFX, CSV , TXT, etc http://www.tradeking.com Click Here
Assent LLC CSV, TXT, etc http://www.etgtrade.com/ Click Here
Bank of America CSV, TXT, etc http://www.baisidirect.com/ Click Here
eRegal Discount Security CSV, TXT, etc http://www.eregal.com/ Click Here
ETG LLC CSV, TXT, etc http://www.etgtrade.com/ Click Here
Folio FN CSV, TXT, etc https://www.foliofn.com/ Click Here
Goldman Sachs CSV, TXT, etc http://www2.goldmansachs.com/ Click Here
Investrade CSV, TXT, etc http://www.investrade.com/ Click Here
JPR Capital CSV, TXT, etc http://www.jprcapital.com/ Click Here
Lightspeed CSV, TXT, etc http://www.lightspeedtrading.com/ Click Here
Mastertrader CSV, TXT, etc https://online.penson.com/ Click Here
MB Trading CSV, TXT, etc https://online.penson.com/ Click Here
NinjaTrader CSV, XLS, etc http://www.ninjatrader.com Click Here
Optionshouse CSV, TXT, etc https://www.optionshouse.com/ Click Here
SogoTrade CSV, TXT, etc http://www.sogotrade.com/ Click Here
Southwest Securities (SWS) CSV, TXT, etc http://swst.com/ Click Here
Spear, Leeds& Kellogg CSV, TXT, etc http://www.slk.com/ Click Here
Terra Nova Trading CSV, TXT, etc http://www.terranovatrading.com/ Click Here
Thinkorswim CSV, TXT, etc https://www.thinkorswim.com Click Here
tradeMONSTER CSV, TXT, etc https://www.trademonster.com/ Click Here
UNX CSV, TXT, etc http://web.unx.com/ Click Here
Zecco CSV, TXT, etc http://www.zecco.com/ Click Here
Other Imports
Excel or CSV,TXT XLS,CSV,TXT.etc File From your own computer(Profile Wizard) Click Here
Ofx format(*.ofx) *.ofx Ms-money or Your broker provide you ofx file
Quicken(*qfx) QFX Log in to Quicken Software to download the data
Quicken(*qif) QIF Log in to Quicken Software to download the data
MetaTrader(*.htm) Detailed Statement Log in to MetaTrader Software to export the DetailedStatement html file Click Here

Download Data From Scottrade


To download data file from Scottrade:

  1. Log in your  Scottrade account .

  1. Click on the My Account Tab and select Account History and Transactions
  2. (Transactions are default option).

  3. Scottrade provides you with two options to filter your Trade data for downloading data under specific condition.
  4. Basic Function
    1. Date Scottrade provides six options to choose from.Yesterday, Last 7 days, Last 14 days, Last 30 days, Last 60 days, All available.It’s a shortcut for users to select the data in that period.
    2. Transactions If you want to download the data in specific transaction type, you can choose one specific transaction type from its drop down list.
    3. Symbol Manually enter the specific symbol name.
    4. Select Date Range If you want to download the trade data in specific time range, you can click this tab to select date range.
    5. Download File There are two options : Comma Delimited (CSV), Quick/Money.You can select data file format accordingly from the dropdown list.

    One Option: Download the data by choosing Date, Transaction, symbol.

    Two Option: Specific date range by selecting a Start Date and End Date

  5. Select Comma Delimited (CSV) in the Download File drop down box and then click the GO button.
  6. It will land on another page there left click Trade History Records option.Attention: This window will popup only when your ad blocker and popup blocker is disabled
  7. File Download dialog box will popup

  1. Press Save and specific file location to save the report csv file to your computer.
  2. Your downloaded file must be in this format as shown below, otherwise, you should set your profile in profile wizard dialog box to import your data into TradeMax.
    Symbol
    Quant
    Price
    Actio
    TradeD
    SettledD
    Inte
    Amou
    Commi
    Fees
    CUSIP
    Descrip
    Act
    TradeNum
    RecordType
    CHQ
    890
    4.8
    Buy
    3/8/2009
    3/13/2009
    -4272
    0
    0
    15758N101
    BOUGH
    1
    0039KSPT
    Trade

    If you find the your downloaded file format is different from the above formats, you should set your profile in Profile Wizard.

  3. Run TradeMax, and click Scottrade account to import trade activity data from local file.
Page 1 of 11

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