Handle your wash sales and generator your Schedule D

The tradeMONSTER Account History  section allows you to review a live transaction history of your account. You may view an aggregate list of transactions or filter transactions by type or symbol.  Data can be exported to a CSV file.

First,login your tradeMONSTER Account,from Account menu, click History button.

Explanation of Details

1. Select Transaction Type

   Select to view All transaction types or select a particular type.

   

2. Select Symbol Parameters

   Select All symbols or Custom. Custom allows you to enter a symbol and all trades associated with that symbol and any options will be displayed.

3. Time Range

   Select the time range for which to view the Account History.  Choose between “Today”, “This week”, “This Month”, a particular date or a date range across months.

4. Menu button

   Click to invoke the Menu for the Account History Overview.

5. Edit Cost Basis

   Click to edit the cost basis of any transferred positions.

6. Export

   Export screen trade history data to a CSV file for saving and/or manipulating in Excel.

   Click the Save button in another pop-up File Download dialog box.

Run TradeMax® , click tradeMONSTER Account to import trade activity data from local file.

Note: You should select tradeMONSTER *.csv, *.txt as your profile name during the importing process.

Option 3: Import Realized Gains and Losses Report from Local File

Realized Gain and Loss Report displays trade details of the selected account’s short- and long-term gains, short- and long-term losses, and wash sales, as defined by the IRS, grouped by security for the selected tax year.

If you already have Realized Gain and Loss Report, TradeMax can facilitate the users to import it directly from the local file with the following step-by-step wizard.

Please Notes: Some Gains & Losses Report do not have year end open postion,this will effect wash sale calculating.

1. Click Import Tab in trade panel, and select the Import Trade from dropdown list.



2. A Select Import Data Source window pops up, select Import Realized Gain and Loss Report from Local file. Click Next button.
3. Select Profile and Import File dialog appears as below.Note: The Realized Gain and Loss Report data file will be in XLS format , please select Profile Wizard(*.xls) the Profile Name dropdown list.



Function	Description
Profile	Profiles Options: Default is : Profile Wizard *.xls
Type	Select TXT or XLS data file. Default is : XLS
Has Column Header	If there is a column header in your imported file, you will need to select the checkbox
Import Sample Files	Follow linked documents contains sample trade data that you can download to practice or use as templates for importing transactions into TradeMax.
Short Transacton 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 Transacton Detectionif 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
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.
Import File	Click File Browser Button to select data file from your computer.

4. Click Next, a Trade Data Review Dialog Box pops up:



If the realized Gain and loss report has report description or report title displayed in the initial parts, TradeMax can not find these column headers or titles, but if you enter any related key words in the blank sheet behind Has Column Header, TradeMax can auto-identify these column headers.

5. Click Next and Map Fields window opens.Users can check the box on the left side of Show Mapping Result to display or hide Map Result Grid.
6. Click Next, the Map Actions pops up.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 open symbol Validation window.
8. Click Next to go to next step.
9. 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.
10. Click OK button to next step, the trade data is imported.

In order to simplify the process to run reports, TradeMax allows you to use Average Basis Method For Mutual Fund Cost Basis Calculating. With this feature, You can figure out your gain or loss using an average basis only if you acquired the funds at various times and prices.

Example 1.

You bought 300 shares in the LJP Mutual Fund: 100 shares in 2006 for $1,000 ($10 per share); 100 shares in 2007 for $1,200 ($12 per share); and 100 shares in 2008 for $2,600 ($26 per share). Thus, the total cost of your shares was $4,800 ($1,000 + $1,200 + $2,600). On May 11, 2009, you sold 150 shares. The basis of the shares you sold is $2,400 ($16 per share), figured as follows.

More detail, Please check http://www.itrademax.com/ipress/trademax-glossary/average-basis.htm

Notes: Once you select to use an average basis, you must continue to use it for all accounts in the same fund. (You must also continue to use the same method.) However, you may use the cost basis (or a different method of figuring the average basis) for shares in other funds, even those within the same family of funds.

The following wizard will tell you how to build a Black List.

1. Click main button , and a main menu opens:



2. Click Options button, and then select Avg Basis tab,  the following dialog box displays:

To download data file from JPR Capital:

1. Login your JPR Capital trading account.
2. Click Accounts > History
3. Manually enter the desired time range then click Refresh History.
4. Select the entire page or the report table.

   Please make sure you select the field name header line.

5. Copy and paste the report table into a Excel Document and save as XLS file.

6. Run TradeMax to import trade activity data from local file. Click Next Button 
7. In Profile Name Dropdown list,Please select Profile Wizard(*.xls).

TradeMax provides you the facility to import Previous Year Holding Position. You can import baseline from last December’s Statement,Such as Quicken Statement(Qif,Qfx type),Ofx fomart file or XLS, CSV,Text which include Baseline files etc.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 should select last December’s QFX or TLF data file to import baseline trade data.

Let us take AB Watlry for example:

1. Click Import button and select Import Baseline.
2. Select I want to import data from local file 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 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

3. Click File Browser Button to select data file from your computer and then click Next Button to continue.



Function	Description
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.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. 2.File Profile: Quicken Interchange Format(*.QIF), Interactive Brokers TDF Format(*.TDF), Open Financial Exchange(*.OFX), *.csv, *.txt, *.xls, *.qfx. Default is : Profile Wizard
Import File	Click Browser File Button to select data file from your computer. Notes: If you select last December’s QFX,QIF or TLF data file,you should select correct profile from profile dropdown list.

4. 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 File Profile, this step will be skipped.)

5. Click Next to pop up Symbol Vilidation dialog box.
6. More Detail,Please check import from local file.

With this function, you can download security event data from the Internet and calculate cost base of the securities in a certain period of time, which help you to better make your investment.

Download Event Data in Security View

1. In Security View,select symbols which you want to download corporate event.



2. Right click and select “Download Corporate Event“.
3. Set Begin Date and End Date for the symbols have corporate event, then click “Next>” to download event data.
4. Click “Finish” to confirm the data.

Download Event Data in Trade View

1. In Trade View,select the trade which you want to download corporate event.



2. Right click and select “Event Append“->”Download Corporate Event“
3. Set Begin Date and End Date for the symbols have corporate event, then click “Next>” to download event data.
4. Click “Finish” to confirm the data.

Mark to Market Gain and Loss Pie Report - This report is for those users who want to calculate mark to market trading performance for each security and track the gains and losses for a fiscal year or a date range after electing mark to market accounting. With this report, users also can quickly view the performance of securities and draw conclusion based on the demonstrated information so as to make better investment strategies.

If you made the mark-to-market election, you should report all gains and losses from trading as ordinary gains and losses. In that case, securities held at the end of the year in your business as a trader are marked to market by treating them as if they were sold (and reacquired) for fair market value on the last business day of the year.

Mark to Market Gain and Loss Pie Report is divided into three parts:

• The

  Mark to Market

  Gain and Loss Pie Chart - Display

  mark to market

  gain and Loss of specific security and its percentage and proportion in total value.

• The Bar Chart - Display total mark to market value of gains, losses, withdraw, deposit of the selected securities within a fixed period of time.
• The Summary Information- Display the total mark to market trading quantities, total and average profit/loss , total and average net gains.



1. The Mark to Market

   Gain and Loss Pie Charts



The pie chart is divided by several radii into sectors in which relative areas indicated by different colors represent the corresponding data percentage and proportion of single security. When the users move the mouse into one segment of the pie chart, TradeMax will auto-demonstrate the information of the specific security. For example: (Google,48.38%,29,041,00 of 60,022,00 which separately indicates the security name, the percentage, and proportion of its total value).

 

2. The Bar Chart



The Bar Chart compromises an axis which indicate the value based on the unit-thousand and a series of labeled horizontal relatively represent its Gains, Loss, auto calculated by TradeMax and each vertical bar will show different values . So the users can find it very easy to compare the data and quickly make good investment strategies.

 

3. Summary Information of the report



In this part, TradeMax will show users the total trading quantities, total and average profit/loss , total average net gains and total commissions within a set time period, so the users who bother to view the charts can also find the summary information of your trade performance here.

Realized Gain and Loss Pie Report - This report is for those users who want to calculate trading performance for each security and track the realized gains and losses for a fiscal year or date range. With this report, users also can quickly view the performance of securities and draw conclusion based on the demonstrated information so as to make better investment strategies. Note: Realized gains and losses are calculated on the basis of trading value.

Realized Gain and Loss Pie Report is divided into three parts:

• The Gain and Loss Pie Chart - Display the gain and loss of specific security and its percentage and proportion in total value.
• The Bar Chart - Display total value of gains, losses, withdraw, deposit of the selected securities within a fixed period of time.
• The Summary Information- Display the total trading quantities, total and average profit/loss , total and average net gains.



1. The Gain and Loss Pie Charts



The pie chart is divided by several radii into sectors in which relative areas indicated by different colors represent the corresponding data percentage and proportion of single security. When the users move the mouse into one segment of the pie chart, TradeMax will auto-demonstrate the information of the specific security. For example: (Google,35.94%,7,783,00 of 21,655,00 which separately indicates the security name, the percentage, and proportion of its total value).

2. The Bar Chart



The Bar Chart compromises an axis which indicate the value based on the unit-thousand and a series of labeled horizontal relatively represent its Gains, Loss, auto calculated by TradeMax and each vertical bar will show different values . So the users can find it very easy to compare the data and quickly make good investment strategies.

3. Summary Information of the report



In this part, TradeMax will show users the total trading quantities, total and average profit/loss , total average net gains and total commissions within a set time period, so the users who bother to view the charts can also find the summary information of your trade performance here.

TradeMax provides you with a simple way to track your trade data on daily basis, with the Daily Account Value function, you can easily compare and monitor your trade performance through the generated chart so as to make a better investment strategy and maximize your capital gains.

The following step-to-step wizard will show you how to generate the chart you wanted based on the imported data and the downloaded holding security prices of specific securities.

Note: You should download the security prices of the selected stocks in a fixed time period before you generate the chart.(For example, you want to generate a chart based on the trade data on Finace Year 2006, then you should set the time period within 2006).

1. After you download the price of the security in a set time range, select the specific finance year (.i.e. FY2006) under the selected account,

   then click Trade Data& Report < Add Report < Daily Account Value.


2. The Daily Account Value option will automatically add to the sub-menu under Trade Data & Report.

3. Click Daily Account Value tab to run the chart or set the parameters of the charts.

4. A Edit view dailog box pops up as below:


Basic Function
Wactch List	The title of the list
Button	Select the column header from the dropdown list by click the specific option under Type, then click Button to add this option.
Button	Select the specific column header under Type, then click Button to hide it, the chart will not display this option.
Type	The different types of column headers in this column
Symbol	The trading currency of the symbol
Color	The user can set color to indicate the line of specific colomn header in the chart.
Day	Set the day for moving average value, you can set Five day, Seven day, etc, the five-day or seven-day average value will be auto-calculated.
Portfolio Value	Portfolio Value is got by multipying Market Value and the shares of securities . TradeMax support settling by different currencies such as USD, HKD, CAD, GBP,etc, different currency means different value.
Cash Balance	The cash balance means the cash you are holding after you buy and sell the security. As you trade securtiy in different currency, if you select USD as your trading currency, TradeMax will show the USD cash balance. as for other currency, different currency means different cash balance.
Account Value	Account Value equals Portfolio Value + Cash value
Moving Avg	The average value of securities calculated on five-day or seven-day basis
Buy&Sell Amount	The transaction number of times on daily basis
Buy&Sell Amount Total	The total trade amount you buy and sell on daily basis
Trends Comparison	The comparison between your securities’ index and other index (i.e Dow Jones), the comparison can display your trade performance to see if your index is above or below other index.
Y Axis min value	1. Apply 0 to Y Axis as min value(default) 2. Use default min value as Y Axis min value
Summary Info	TradeMax will show users the total trading quantities, total and average profit/loss , total average net gains and total commissions within a set time period, maximal drawdown and percentage,so the users who bother to view the charts can also find the summary information of your trade performance here.

5. After selecting the specific column header you wanted to show(i.e Account Value, Trends Comparison) in the chart, the chart will show as below:


Basic Function
1	the selected column header you wanted to display in the chart
2	When your mouse move to some point of the line, a small notification window will show to tell you the basic information of the trades on that day.
3	The line of Comparison Trend
4	The line of Account Value
5	Left Y Axis indicates the trade total value based on the unit : thousand
6	X Axis indicates the specifc date
7	Right Y Axis indicates the percentage of the total value

Technically, TradeMax supports every broker, known or unknown, as long as this broker provides a statement in CSV/EXCEL format or Quicken Qif,QFX fomart / Money OFX format or OFX server connection. Without changing codes, TradeMax allows users to define their own templates which suit the CSV format of their broker data.

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

A) Import Trades from online Brokerage Server(OFX Server)

If you want to download trades from online brokerage account, select this option. Please check our supported broker’s OFX server list, if your brokerage provide ofx data service and not listed in our list, you can send your broker name & ofx server url to contact form we will add it to TradeMax.

B)Import Trade Activity data from local file (Recommend)

1. Build-in Broker Profile: Currently TradeMax already have build-in template for IB and ETrade, ScotTrade, OptionsXpress, TdAmeritrade, Schwab, Person,Sogotrade and more.(Please check our supported brokers list),
2. File Profile: TradeMax can support Quicken Interchange Format(*.QIF), TradeLog(*.TDF), Open Financial Exchange(*.OFX) file, Quicken Financial Exchange(*.QFX) file
   How to import Quicken QIF file to TradeMax
3. Unknow column csv or execl file:You can either define your own template with trademax profile wizard function or send us a sample CSV or Xls data file with 8~10 lines of transactions in it for importing, we will build template for customer without extra cost.

Import Sample files Follow documents contains sample trade data that you can download to practice or use as templates for importing transactions into TradeMax.

Trade Activity Sample Files.xls (Profile Wizard[*.xls]) Each Record has TradeDate,Symbol,Action,Qty,Price,Commission,Amount 15 kB Realized Gain Loss Report.xls (Profile Wizard[*.xls]) - (Symbol,qty,open/close date ,Proceeds /Cost Basis in single record) 18 kB

C) Import Realized Gains and Losses Report from Local File
If you already have Realized Gain and Loss Report, TradeMax can facilitate the users to import it directly from the local file with the following step-by-step wizard.More…

Please Notes: Some Gains & Losses Report do not have year end open postion,this will effect wash sale calculating.

D) Import Trade data copied from broker Transaction History Report
You can copy your Broker’s Transaction History report from the web browser and paste to TradeMax during the importing process. More…