csv file |Form 8949 Capital Gain & Wash Sales calculator software

Vanguard


Vanguard Import Instructions:

There are two different methods to importing your trade history from Vanguard into TradeMax (select a method for detailed instructions):

Download From OptionsXpress


To download data file from OptionsXpress:

  1. Login your OptionsXpress account.
  2. Click Accounts > Activity.
  3. Select the Period and Type.
  4. Select Comma Delimited (CSV) in the Download File drop down box and then click the GO button.Note: Click on the box “Show Commissions & Regulatory Fees.
  5. Press Save to save the report as csv file.
  6. 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
    Description
    Action
    Quantity
    Price
    Commission
    Reg Fees
    Date
    TransactionID
    Order Number
    Transaction Type ID
    Total Cost
    MSQ^^^101203C00118000
    MSFT AprWk2 280 Call
    Buy To Open
    10
    8.88
    7
    0.07
    4/2/2010 11:25:28 AM
    199999999
    98888888
    21
    -8887.07

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

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

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.

Download Data from Investrade


The following steps will show you how to download data from Investrade.

  1. Login your Investrade trade account.
  2. Click Account Information > Activity.
  3. Select Trades from the “Activity Type” drop down box.

  4. Unselect Current check box , then set a specific time range.
  5. Your Trade History report will display, the report should contain the right columns as shown below:

    Account Type | Trade Date | Settle Date | Exec Time | Trade Number | CUSIP/Symbol | ISIN | Description | Buy/Sell | Qy | Price | Principal Amt | Comm | Other Comm | Net Amount | Curr

  6. Click Download Data icon

  7. Select Delimited text file and Comma delimited and then click the Download now button

  8. Click the Save button.
  9. Click Save button in Save In drop down dialog box.
  10. Run TradeMax and setup an Investrade account 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.