trades |Form 8949 Capital Gain & Wash Sales calculator software

Split Trades


You can split your trade as following:

  1. Select the trades you want to split.
  2. Learn more about: How to select trade records.

  3. Right-click the selected record and select the Trade Split in the context menu:
  4. A Trade Split dialog box will pop up:
  5. Function
    Description
    1.Enter Transaction

    Select the transaction type.

    There are the following option from its dropdown list :

    Stock Split/Reverse Split –– A corporate action in which a companys existing shares are divided into multiple shares.

    Stock Spin off–– A spin-off is a new company formed by a split from a larger one. Brokers’methods vary widely on how they report spinoffs in their statements.

    Stock Merge–– The combination of two or more corporations into one.

    2.Transaction Date The actual date you split the security
    3.Account Choose the specific account name from the accounts list. If you choose <All Account> from the dropdown list, event will apply to all accounts.
    4.Old Security Name
    The name of security before the specific event. Enter the old security name manually in the Old Security Name field or Select it from the Symbol dropdown list.
    5.Old Security Quantity
    Number of shares before the specific event.
    6.New Security Name
    The name of the security after the specific event. Enter the new security name manually in the New Security Name field or Select it from the Symbol dropdown list.

    If Stock Split, the New Security Name is the same as the Old Security Name.

    7.New Security Quantity
    Number of shares after the specific event.
    8.New shares Issued
    The split ratio is automatically calculated by New Security Quantity/Old Security Quantity.

    After checking all the information you have entered, click the OK button to continue the process or click the Cancel button to cancel the appending process.

  6. After pressing the button,  the following new record will be displayed:
  7. The

    The row outlined in red displays the New Split trade record.

  8. You can cancel this action with the Undo Button in the trade tab.

Trades Merge


Merge is the combination of two or more corporations into one. Manual adjustment is required by the user to account for the new stock because of the various brokerage statements.

Make the necessary adjustments as follows:

  1. Select the records referring Merger
  2. Right-click the record and select the Trade Merge from its context menu
  3. A dialog box will pop up:
Function
Description
1.Enter Transaction

Select the transaction type.

Here are the following options from its dropdown list:

Stock Split/Reverse Split – A corporate action in which a companys existing shares are divided into multiple shares.

Stock Spin off– A spin-off is a new company formed by a split from a larger one. Brokers’ methods vary widely on how they report spinoffs in their statements.

Stock Merge– The combination of two or more corporations into one.

2.Transaction Date The actual date you merge the security to another
3.Account Choose the specific account name from the accounts list. If you choose <All Account> from the dropdown list, event will apply to all accounts.
4.Old Security Name
The name of security before the specific event. Enter the old security name manually in the Old Security Name field or Select it from the Symbol dropdown list.
5.Old Security Quantity
Number of shares before the specific event.
6.New Security Name
The name of the security after the specific event. Enter the new security name manually in the New Security Name field or Select it from the Symbol dropdown list.
7.New Security Quantity
Number of shares after the specific event.
8.New shares Issued
The split ratio is automatically calculated by New Security Quantity/Old Security Quantity.

After checking all the information you have entered, click the OK button to continue the process or click the CANCEL button to cancel the appending process.

4. After you have clicked the OK button, the following new record will be displayed:

The row outlined in red displays the New Merge trade record.

  • You can cancel this action with the Undo Button in the trade tab.
  • Trades Spinoff


    A Spin-Off is a new company formed by splitting from a larger one. Brokers vary widely as to the way in which they report spinoffs on their statements. It is impossible to automate the importing of these transactions in TradeMax, so manual adjustment is required by the user to account for the new stock.

    Make the necessary adjustment as follows:

    1. Select the records to Spinoff
    2. Right-click on the record and select the Trade Spinoff from the context menu
    3. A dialog box will pop up:

    Function
    Descripton
    1.Enter Transaction

    Select the transaction type.

    There are the following option from its dropdown list :

    Stock Split/Reverse Split – A corporate action in which a companys existing shares are divided into multiple shares.

    Stock Spin off – A spin-off is a new company formed by splitting from a larger one. Brokers’methods vary widely on how they report spinoffs in their statements.

    Stock Merge The combination of two or more corporations into one..

    2.Transaction Date The actual date you spinoff the security to another
    3.Account Choose the specific account name from the accounts list. If you choose <All Account> from the dropdown list, event will apply to all accounts
    4.Old Security Name
    The name of security before the specific event. Enter the old security name manually in the Old Security Name field or Select it from the Symbol dropdown list.
    5.Old Security Quantity
    Number of shares before the specific event.
    6.New Security Name
    The name of the security after the specific event. Enter the new security name manually in the New Security Name field or Select it from the Symbol dropdown list.
    7.New Security Quantity
    Number of shares after the specific event.
    8.New shares Issued
    The split ratio is automatically calculated by New Security Quantity/Old Security Quantity.
    9.Cost Per Old Share
    Enter the cost per share of the old security,on the date of the spin-off.
    8.Cost Per New Share
    Enter the cost per share of the new security which was spin off, on the date of the spin-off.

    After checking all the information you have entered, click the OK button to continue the process or click the CANCEL button to cancel the appending process.

    4. After you have clicked the OK button, the following new record will be displayed:

    The row outlined in red displays the New Spinoff trade record.

  • You can cancel this action with the Undo Button in the trade tab.
  • Edit Trades


    TradeMax allows you to edit your trade record by editing the parameters of the record. It is so easy, just like you edit a record in any other spreadsheet applications.

    With TradeMax, you can,

    Note: The multiple trade records should have the same editing parameter

    Now we provide you a step by step wizard as follows:

    • Edit a specific trade record

      1. Click trade record row heading to select the specific trade record
      2. Click the parameter cell to activate it and then edit it with you keyboard and mouse

        -OR-

      1. Click trade record row heading to select the specific trade record
      2. Press the Edit button in the Trade Tab or right-click the selected record and select the Trade Edit from its context menu
      3. A dialog box will popup:
      4. Edit the Parameter you want to change and press OK to complete the process

    • Edit multiple trade records at one time

      1. Select the records you want to edit in the Grid
        Learn more about: How to select trade records
      2. Press the Edit button in the Trade Tab or right-click the selected records and select the Trade Edit from its context menu
      3. A dialog box popup:
      4. Edit the Parameter you want to change and press OK to complete the process
      5. Then the multiple records will have the same edited Parameter

    Delete Trades


    If you find duplicated records in the data grid, TradeMax allows you to delete them with just a few clicks, as follows:

    1. Select the records you want to delete in the Grid
      Learn more about: How to select trade records
    2. Press the Delete button in the Trade Tab
      -OR-

    1. Select the records you want to edit in the Grid
      Learn more about: How to select trade records
    2. Right-click the selected records and select the Trade Delete from its context menu

    Download Data From E*Trade


    E*trade provides you two methods to download your trade records to your computer:

    To download tax documents of an entire year:

    1. Log into your E*TRADE account .
    2. Click Accounts tab and then select Account Records.
    3. Select Tax Reports in the Brokerage Account Records section.
    4. Click the Tax Records tab and then left-click Export your 200X trades into Microsoft Excel.
    5. Click the Save button in another pop-up File Download dialog box.
    6. Open your saved file in Excel, and click File then choose Save As.. In its drop-down-list to save the data file as CSV format.
    7. Your downloaded file must be in this format as shown below.
      TradeDate
      Order Type
      Security
      Amount
      Cusip
      Transaction Description
      Quantity
      Executed Price
      Commission
      Net Amount
      3/8/2009
      Buy
      CROX
      -4272
      227046109
      CROCS INC
      1
      0039KSPT
      12.99
      1162.99

      The data in the above table is E*trade 2009 format, and the following table will display the  E*trade 2010 format:

      Transaction Date
      Transaction Ty
      SecurityTy
      Symbol
      Quantity
      Amount
      Quantity
      Price
      Commission
      Description
      12/22/09
      Bought
      EQ
      CIM
      5000
      -19407.49
      38799
      7.99
      0
      CHIMERA INVESTMENT

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

    8. Run TradeMax , click E*Trade Account in TradeMax to import trade from local file.Note: You should select E*Trade *. csv, *. txt as your profile name during the importing process. As the file data formats vary from year to year, and in the drop-down-list of Profile Name, apart from E*Trade *. csv, *. txt, there is another option, E*Trade 2008 *. csv, *. Txt, for the users to choose, according to their data file in different year. The default is E*Trade *. csv, *. txt.

    Download Transaction History within three months to update your trade data(Quicken Format-QFX) Recommend

    1. Log into your E*TRADE account.
    2. Click Trading & Portfolios > Transaction History.
    3. Click the Transactions tab, select your Brokerage account and then click the Search Transactions button
    4. Enter the specific time range.Attention: You may download up to three months’ worth of data from your account.
    5. Select .QFX format in the data format field and click Download.
    6. Choose the Save option.
    7. Run TradeMax and click E*Trade Account in TradeMax to import trade activity data from local file. Note: You should select Open Financial Exchange *.ofx, *.qfx as your profile name during the importing process

    Find Trades


    With TradeMax, you can find and display specific trade records:

    To display trades within data range in data grid:

    • Select the BeginDate/EndDate checkbox to activate this function
    • Type in the begindate/enddate manually or select it from the dropdown list

    Learn more about: how to select the date

    To display trade records by using the column header Filter:

    1. Click the icon next to the column header in the data grid (for example, column header Symbol)
    2. A Filter popup box will appear:

    3. Select the checkbox to select specific symbols. You can select the Select All checkbox to select or unselect all.
    4. Click OK

    Combine Trades


    To avoid the wash sales in one day, TradeMax allows you to combine your trades with same buying slots (TradeDate, Action and Symbol are same).

    The following figure provides you with a step-to-step wizard:

    1. Select the trades you want to combine(For example, the two trades occur in May 24, 2007)Learn more about: How to select trade records.
    2. Right-click on the selected section and select the Trade Combine in the context menu.
    3. The two records become one as in the following figure:
      Column Header Value
      Quantity Sum of all combined trades
      Price Weighted average sum of the combined trades
      Commission Sum of all combined trades
      Amount Sum of all combined trades
      Notes Note the action of combining

    Custom View


    Now the Function Custom View has been designed to give users additional control over the display of trade data on the grid, Besides this, With it you can

    • Combine Different Accounts
    • Find trades with specific symbol, amount, etc.
    • Display all open position.
    • Find multi-legs data more flexibly
    • Run reports containing customized data.

    The following will demonstrate how this function works.

    1. Right click on the specific item (e.g FY 2008 under the Account ScotTrade Jones) and select Add View> Custom.
    2. The following dialog box will pop-up:
    3. Basic Function
      1.Name
      Enter the Name of the trade view ( e.g ABC )
      2. Account Field
      Used the Arrow to select specific accounts.

      The Selected account(s) list the accounts selected.

      3. Condition List Use to customize the condition which allows TradeMax to filter the Trade data with more flexibility.
      4. Button
      Click Button to get the pop up Expression Dilalog Box below
      5. Button Click Button to delete the selected Expression data.
      6. Notes
      Notes for the trade view
    4. After you click button, the Expression Dialog Box appears as below:
      • Select the Parameter from the Trade field .
      • Select the Relation from the Relation field.
      • Enter the Value to the Value field.
    5. Basic Function
      1.Symbol
      The security name
      2. TickerMatch
      The strike price of the underlying stock in the option or future
      3. Type Security type. For instance, stocks and mutual funds, options on stocks, Single-Stock-Futures, futures, currencies etc.
      4. Date
      The Trade date of specific security
      5. Action Action name in TradeMax.

      Open Long — Buy Stock/Option to Open a Long position
      Close Long — Sell Stock/Option to Close a Long position
      Open Short — Buy Stock/Option to Close a Short position
      Close Short — Sell Stock/Option to Open a Short position

      6. Quantity Number of shares
      7. SPrice Security price
      8. OComm Original Commission
      9. O Amt
      Original Amount
    6. Each filter is comprised of one or more “conditions”. After selection, the condition List will display the conditions you selected or entered in Expression Dialog box.
    7. The default root is “And”.   To change the default root, right click AND.   A dropdown menu will appear.
      • And : Select And option to display specific expression.
      • Or: Select Or option to allow more expressions to be displayed in specific view (e.g ABC)
      • Add Expression: Click Add Expression to add another Expression.
      • Delete: Select Delete option to delete the selected expression.
    8. Click OK to continue or Cancel to cancel the process.
    Page 1 of 212

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