Handle your wash sales and generator your Schedule D

Option 4: Import Trade data copied from broker 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.

If I import from my computer, do I need to assign header in one (like Buy/Sell) then in next screen need I clarify that B is open to long and S is sell to close?

You can see unmatched transactions warning during the import procedure. TradeMax identifies transaction into 2 pairs: a Long Trade, contains Buy to Open(Open Long) and Sell to Close(Close Long) ; a Short Trade, contains Sell to Open(Open Short) and Buy to Close(Close Short). Not every broker is very responsible for the accuracy of their statement. Many Brokers mark Open Short and Close Short as Sell and Buy. That will confuse TradeMax during the trade matching, because Wash Sale rule only allow to carry loss between Trades with same intention. Therefore, one of your option is to manually alter these trades’ action type to get correct result and to avoid the unmatched transaction warning. For some special cases, You can change it to Short and Close Short (e.g. 100+200 short, then a 300 Close Short.) Unmatched transaction warning will disappear by adjusting.