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:
- Select I want to import data copied from broker Transaction History Report from the pop-up dialog.
|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|
- Click Next, the Clipboard Data dialog box appears:
- You just need to log onto the website of the specific broker, and copy the transaction history.
- Click “Paste” button to paste the data onto the clipboard of TradeMax.
- Click Next Button to continue.
|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.|
- 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.)
- Click Next for the Symbol Validation dialog box to pop up.
- 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
- Click OK button go to the next step, and the trade data is imported.