Handle your wash sales and generator your Schedule D

TradeMax supports any broker only if it can supply files containing your trades. You can import CSV file, text file (tab delimited) or QIF file, TDF file into TradeMax From TradeMax Supported Broker List, you can see that the trade data of common brokers can be imported into TradeMax directly. The following form displays brokers import support matrix.

There are 3 options to import your trade data into TradeMax:

Option 1:  Import Trade Data from Local File ( If you already downloaded trade data from your Brokerage, just choose Import Data from Local File Option in Mode field. )

Option 2: Import Trades from Brokerage Account ( If you want to download trades from online brokerage account, select this option) please see Supported Brokers List . )

Option 3: Import Trade data copied from broker Transaction History Report ( The users just need to copy Transaction History report from the web of sepcific broker, and paste to TradeMax during the importing process. )

Option 3: Import Trades from web using Transaction History Report

If the security trader holds online brokerage account, TradeMax provides an easy wizard to import trades from web using Transaction History Report, the users just need to copy the Transaction History Report from the web of 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 downloaded 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

2. Click Next, the Clipboard Data dialog box appears:



3. You just need to log on the website of specific broker, copy the transaction history.



4. Click “Paste” button to paste the data into the clipboard of TradeMax.



5. 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), TradeLog(*.TDF), 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 file Default is : Broker Profile like ScoreTrade; Quicken Interchange Format(*.QIF), TradeLog(*.TDF), Open Financial Exchange(*.OFX)
2. Sample Data	The Sample Data of specific broker will display 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 some 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, the 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.

6. 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.)

7. Click Next to pop up Symbol Vilidation dialog box.



8. Click Next to go to next step



Click Finish Button, a File Save As dialog box appears to give the the users facility to setup the profile as a new one in profile list for you to import trade more easily.



9. Click OK button to next step, the trade data is imported.

TradeMax provides you the facility to Import data from more advanced formats majority of the brokers support. You can import Quicken, or Text files etc. These transactions can later be managed from your desktop.

The importing process is also a profile setting process. It provides you wizard to filter the useful trade data, match the data, and then generate a TradeMax data format for the following tax purpose calculation.

Note:

1. The file could be the following type extension: *.csv, *.txt, *.xls, *.qif, *ofx, *.qfx, *tdf.
2. You can Undo or Redo the importing action by Click the icon in the Quick Access Toolbar

Trade Import Process

Step 1: Select import trade data source

Step 2: Map Field

Step 3: Map Actions

Step 4: Map Types

Step 5: Symbol Validation

Step 6: Trade Record Preview

If you have created a new broker account and located a compatible trade history report from the online broker’s web site, the next step is to import trades into TradeMax.

The import function is available under the Account List: Right-click the account which you want to import your data and select the Import Trade.

Then the Select Import File And Profile dialog box will popup. TradeMax provides a step-by-step wizard to guide you through the rest of the process.

Step 1:Select import trade data source .

There are three options for you choose to import your data.

Option 1 :  Import Trade Data from Local File （If you already downloaded trade data from your Brokerage, just choose Import Data from Local File Option in Mode field.）

Option 2 :  Import Trades from Brokerage Account (If you want to download trades from online brokerage account, select this option) please see Supported Brokers List .

Option 3: Import Trade data copied from broker Transaction History Report (The users just need to copy Transaction History report from the web of sepcific broker, and paste to TradeMax during the importing process.)

The following dialog box is used to select a profile to import the data into TradeMax. You can also create a new profile and save the profile settings and re-use it to import a similar file. In addition, you can edit an existing profile as per requirement.

Option 1 : If you already have download trade data from your brokerage, just choose Import Data from Local File Option in Mode field.

Click Next to make furthering settings.

The aboved dailog is the default one, the users can select to import trade data in Profile Wizard, just click the Profile Name in the above dialog box , then select Profile Wizard from its dropdown list, you can see the following dialog:

1. Press the Import file button. Import Trade dialog box opens where you can browse and select your desired file.
2. Select or setup a specific profile
   1. Select a profile
   2. The options from the dropdown list are:
      • Previous user defined or system defined profile, for example, SocreTrade. If you select this option, you skip Step 2, Step 4 and Step 5 of the importing process.
      • You can also setup and save a new profile by entering a new profile name to replace the <Profile Wizard >.
3. Select Record Separator from its dropdown list.
4. From the Field Separator dropdown list, scroll through the list to find the exact one according to the imported files.It can be one of the defined separators: Comma, Double Quote, Single Quote, Space and Tab.
5. You can use the default setting in Text Qualifier and you also can enter the new one according to your imported files.
6. Select the Has Column Header checkbox according to the files you imported
7. Click Next to the next step.

Step 2: Map Fields

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



2. Drag the Scroll Bar to Map your data.



3. Click the cell under the Map your data? column and select the right column header to map the data.
   • You can assign the column header Commission to fee column and the Commission in the data grid will be the sum of the two.
   • You can assign the column header Notes to the columns refer to notes and TradeMax will combine them to the notes column in the data grid.
   • You can also exclude the useless column by selecting the option Ignore

Learn more about Column Header in TradeMax

Note:

4. The scroll bar (below) can be used to scroll the display more rows in the trade grid.
5. To verify your previous settings, press the Back button.
6. Click Next to go to the next step.

Step 3: Map Actions

In this step, you are allowed to change transaction Action types suggested by TradeMax.

1. Click on the Action column and select the desired option from the list to match the action listed under ActionName heading.
   

   Function	Description
   Long	Buy Stock/Option to Open a Long position
   Short	Sell Stock/Option to Close a Long position
   Close Long	Buy Stock/Option to Close a Short position
   Close Short	Sell Stock/Option to Open a Short position
   Expired	Expired Option
   Exercised	Exercised Option
   Assigned	Assigned Option
   Split	Stock Split
   Spinoff	Stock Spinoff
   Merge	Stock Merge
   SharesAdded	Shares Added into Account
   SharesRemoved	Shares Removed from Account
   DIV	Dividend
   IntInc	The interest paid in cash
   Misclnc	Miscellaneous Income
   ReinvDiv	Reinvested Dividend
   ReinvInt	Reinvested Interest
   CancelBuy	An open buy order is being cancelled and is waiting for a “Cancelled” status
   CreditInterest	Interest of Credit
   PeriodicInterest	The interest charged on a loan or realized on an investment over a specific period of time
   Journal	Represent all areas of money, investment, banking and related disciplines
   CashAdj	Cash Adjustment
   IRAReceipt	Receipt of IRA
   TaxExemptDiv	Tax Exempted Dividend
   StkAdj	Stock Adjustment
   Deposit	Deposit into your account
   Withdraw	Withdraw from your account
   RtrnCap	Return of Capital
   MiscExp	Miscellaneous Expense
   MargInt	Margin Interest
   Buy	you need to be sure every trade action. For example, ONLY IF you can sure that in the data file every BUY is open a long position, you can select the Long to map with the buy.
   Sell	You need to be sure every trade action. For example. ONLY IF you can sure that in the data file every Sell is sell to short, you can select Short to map with the Sell.

2. Press the Back button, if you want to change previous setting or click on Next button to go to next step.

Step 4: Map Types

Check your stock type in this step.

1. From the dropdown list under the Symbol type , you can select the security’s type to match your imported data file.
2. Click Next to go to next step

Step 5: Symbol Validation

Validate your symbol in this step.

1. Select the Type for each symbol from its dropdown list (Stock is the default type)Attention: Records can be sorted in ascending or descending order by clicking on any column header.
2. Enter the Underlying Stock, Strike Price and Expire Date etc (You can skip this step if it is not option or future)Attention: You can manually enter the Expire Date or select from its dropdown calendar.Learn more about: How to select the date.

3. Merge to is an option which can merge one security into another. Attention:
   • Symbol # represents that option has expired or been cancelled buy, and the function Merge to enable the option or stock mentioned above to merge to normal one automatically.
   • If the symbol type is option, you need to enter the Underlying Stock, Strike Price and Expire Date. If the symbol type is future, you only need to enter Underlying Stock and Expire Date

   Basic Function
   1	To sort by Symbol Name in ascending order, click Symbol Name in the column header once and there will be up-arrow after Symbol Name. To sort issn descending order, click Symbol Name twice and there will be a down-arrow after Symbol Name. To cancel the sorting, you can click Symbol Name the third time.
   2	Merge to is an option which can merge one security into another. As picture shows: .AUDBU# in above window is an option which corresponds to .AUDBU.in Scottrade, it merges to .AUDBU automatically. If you want to merge it to another specific option, you can manually enter the name of the specific option OR select from the dropdown list.
   3	Underlying Stock is the stock on which an option is written, giving the option holder the right to buy or sell.

4. Click Next to go to next step

Step 6: Trade Record Preview

In this step, you will have a Trade Record Preview window shows the details of import data. If you scroll down the transaction list, you will see all transactions that TradeMax has concerned will be highlighted in red and green. You need validate and correct these Suspected Transactions (red one) before you proceed. In addtion, the Error Trade(s) dialog box will ease your task.

1. Click the error trade record to go to the specific error record in the Trade Record Preview dialogue box.
2. Check the Action and ActionName and select the right one from its dropdown list
3. Press the Rescan button to rescan errors. If it does have, repeat the above two steps to remove the error.
4. Select the import it column checkbox to import that transaction
5. Click Finish to complete the whole importing process. You can verify the previous setting by clicking the Back button. In addition, you can also cancel the data importing with the Cancel button.

Tips:

• For a more accurate gain/loss report, we suggest:
  1. Click the TradeDate column header once to show the records be sorted in ascending order
  2. Check the Action and ActionName transaction by transaction and select the right one from its dropdown list
• TradeMax can automatically recalculate the missing or inconsistent data fields found in the file to be imported by using Qty, Price, Commission, Fees and Rate information.

TradeMax provides you a powerful way to import your data file from your hard drive. You should download your data from your online broker or export it from Microsoft Money, TradeLog or Quicken etc.

1. You can directly download your data from your online broker. The process is:
1. Log in to your online Broker’s web site and go to the Account History Section.
2. Find the Data file option (*.txt,*.qif, *.csv,*.xls).
3. Select a Time Period for your data file (for example, Start “1/1/2008″, End “12/31/2008″).
4. Click the download button.
5. Download the file to your hard drive. Save it to “C:\My Documents\TradeMax”.
2. You can also copy the data file from your online broker’s website. The process is:
1. Log in to your online Broker’s web site and go to the Account History Section.
2. Find the Data file option(*.txt,*.qif, *.csv).
3. Select a Time Period for your data file (for example, Start “1/1/2008″, End “12/31/2008″).
4. Display the data file
5. Select and copy the data file just like the Microsoft excel and past it to a NotePad.
6. Save it to “C:\My Documents\TradeMax”.
3. Export from the acceptable program like Microsoft Money, TradeLog or Quicken just follow the program’s HELP.

Note:

If your online broker is not supported the above way, please contact them asking for the possible data file such as CSV file, a text file (tab delimited) or a QIF file

TradeMax supports importing data form the following brokers.

The brokers which support import type OFX server, can get import trade history in a quickest and easiest way.

The headers on the columns in the grid have the following meanings.