website |Form 8949 Capital Gain & Wash Sales calculator software

Import data copied from broker Transaction History Report


Option 4: Import Trade data copied from broker Transaction History Report

If your security trader holds online brokerage account, TradeMax provides an easy wizard to import trades from your broker’s website using Transaction History Report, the users just need to copy the Transaction History Report from website of the specific broker, then paste to TradeMax during the import process.

Let us take Citibank for example:

    1. Select I want to import data copied from broker Transaction History Report from the pop-up dialog.

Function Description
Account Select an account to import your data
Trade Time Range Automatically display the date range of existing trades in the current account
Mode If you already have a user name and password of the selected account, select I want to connect to ***. I have a *** user name and password.
If you have trade data in your computer, please select I want to import data from local file.
If you want to skip the file downloading process, just select I want to import data copied from broker Transaction History Report.
Include Baseline If you have already appended baseline position, you will need to select the checkbox and enter your specific tax year or select it with the arrows at the right side
    1. Click Next, the Clipboard Data dialog box appears:

    1. You just need to log onto the website of the specific broker, and copy the transaction history.

    1. Click “Paste” button to paste the data onto the clipboard of TradeMax.

    1. Click Next Button to continue.

Function Description
1. Profile Name Preset import profiles for importing trade data. With the default profile, you can skip Step 2, Step 4 and Step 5 Profiles Options:
1.Broker Profile: ScoreTrade, Interactive Brokers, E*Trade and so on
2.File Profile: Quicken Interchange Format(*.QIF),  Open Financial Exchange(*.OFX), *.csv, *.txt, *.xls, *.qfx.
3.Profile Wizard: Setup a temporary profile or replace it with specific one to setup a new profile which can be re-used to import a similar fileDefault is : Broker Profile like ScoreTrade; Quicken Interchange Format(*.QIF), Excel Format(*.XLS), Open Financial Exchange(*.OFX)
2. Sample Data The Sample Data of specific broker will be displayed in this field, if the data file you copied from the broker doesn’t match the required format of corresponding profile, a notification window will pop-up.Note: If the data doesn’t match, you can select Profile Wizard from the droplist of Profile Name to make changes in the settings.
3. Short Transaction Detection If this function is activated, whenever TradeMax imports a sell before a buy for a symbol with no shares currently open, the trade will be recorded as short.
Note: You shouldn’t select Short Transaction Detection , if you did not Enter the Baseline Positions or Include the Baseline Position. In this case, TradeMax will assign the close long transaction as an open short transaction
4.Buy to Cover long Transaction Detection If your online brokerage accounts allow the conversion of an open, short position to an open, long position with a single buy transaction (and vice versa). You can activate Buy to Cover long Transaction Detection function to allow TradeMax to make the necessary adjustments during the import process. TradeMax will automatically split up the single “buy” transaction into two – one to close the short position, and another to open up a new long position.
5. Import File Click File Browser Button to select data file from your computer.
    1. Click Next to pop up Map Field dialog box.

In this step, you can map your data by assigning or mapping the column header. (With the default profile, this step will be skipped.)

    1. Click Next for the Symbol Validation dialog box to pop up.

    1. Click Next to go to the next step

Click Finish Button, a File Save As dialog box appears to give you the option of setting up the profile as a new one in the profile list for you to import trade history more easily

    1. Click OK button go to the next step, and the trade data is imported.

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 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
Page 1 of 11

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