data |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 Data From Schwab


To download data file from Schwab:

  1. Log into your Charles Schwab account.

  2. Click Account > History.
  3. Select Previous Year, or Current Year from the Date Range:

  4. Select All from the Transactions drop down box.

  5. Click the Go button.
  6. Click the Export button.
  7. Click the OK button on the popup History Download Disclaimer dialog box.
  8. Click the Save button on the popup File Download dialog box.

  9. 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.
    TradeDate
    Action
    Quantity
    Symbol
    Price
    Amount
    Commision
    3/8/2009
    Buy
    -550
    ANH
    10
    5500
    0

     

  10. Run TradeMax to import trade activity data from local file

Export Trade Data to TaxAct


Export Trade Data to TaxAct

There are two processes involved in using TaxACT® to file your trading gains and losses with TradeMax:

Step 1 : Export Trade Data from TradeMax

Step 2: Import Data into TaxAct

Follow the instructions below to export trade data from TradeMax then import the data into TaxAct.

Step 1 : Export Trade Data from TradeMax

The following  illustration will show you how to export trade data from TradeMax:

  1. Run TradeMax, Click the specifc account and select the specific financial year.
  2. Right click specific Financial Year (e.g FY2009), and a dropdown list pops up:
  3. Select TaxAct Export option, a dialog box appears as below:
  4. Save your data into the specific directory.

Step 2: Import Data into TaxAct

Follow the steps below to import your TradeMax generated CSV file into TaxACT® Online version:

  1. Open your web browser and navigate to your TaxACT® 2010 Online Deluxe account.
  2. From the Q&A main menu, select the Federal Q&A tab.
  3. Expand the Investment Income menu option,and  then select Gain or loss on the sale of investments.
  4. Select Import from a brokerage provider via a CSV file option.
  5. Click on Import CSV File.
  6. Click on the Browse button.
  7. Navigate to and select the appropriate CSV file you saved in your computer.
  8. Next click Continue to begin upload and import process.
  9. TaxACT® will attempt to indentify the column header data in the file as shown in the images below. Make sure that the header data is identified correctly, the then click Next.
  10. Next TaxACT® will prompt you to select which rows of data will be imported. By clicking the check box at the top of the Import column you can select all rows – typically the easiest method.
  11. Click OK when prompted.
  12. Now you will need to un-select the top two rows, and bottom two rows as shown in the images below. Then click Next to continue.Note: TaxACT® will now allow you to chose the owner of the data, if necessary. Click Next to continue.
  13. TaxACT® will list all data found in the CSV file, click Import to complete the data import.
  14. Click Close when finished.
  15. To review the import result click on Income under the Federal Q&A tab.
  16. The total listed under Capital Gains & Losses should reflect the total gain or loss reflected in TradeMax (in addition to any other capital gains or losses you have already entered into TaxACT). Once you complete your online filing you can confirm your short-term and long-term capital gains and losses on the Schedule D form.
Page 1 of 11

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