Detailed Instructions |Form 8949 Capital Gain & Wash Sales calculator software

Average Basis


Average Basis

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.

1)

Enter the total adjusted basis of all the shares you owned in the fund just before the sale. (If you have made an earlier sale of shares in this fund, add the adjusted basis of any shares you still owned after the last sale and the adjusted basis of any shares you acquired after that sale.)

$4,800

2)

Enter the total number of shares you owned in the fund just before the sale

300

3)

Divide the amount on line 1 by the amount on line 2. This is your average basis per share

$16

4)

Enter the number of shares you sold

150

5)

Multiply the amount on line 3 by the amount on line 4. This is the basis of the shares you sold

$2,400

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:

Function
Description
1.Avg Basis Tab After clicking Options button, you should select Avg Basis tab.
2.Account Select the account which you want to use average cost rule.
3. Year Select the fiscal year which you want to use average basis rule.
4. Fund List Funds symbol lists in the account.
5.Avg Cost List the symbols which use Avg Basis event in specific fiscal year.
6.Append Button Select the funds which you want to use average basis rule and Press”Append” Button.

 

Download Data from JPR Capital


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

Import Previous Year Holding Position


Import Baseline

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 format file or XLS, CSV,Text which include Baseline files etc.The importing process is also a profile setting-up process. It provides you with a 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 have one of 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.
  3. 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
  4. Click File Browser Button to select data file from your computer and then click Next Button to continue.
  5. 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.
    Note: If you select last December’s QFX,QIF or TLF data file,you should select correct profile from the profile dropdown list.
  6. Click Next to pop up Map Field dialog box.
  7. In this step, you can map your data by assigning or mapping the column header. (With the File Profile, this step will be skipped.)

  8. Click Next to pop up Symbol Validation dialog box.
  9. More Detail,please check import from local file.

Download Security Event Data


Download Security Event Data

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

Download Event Data in Security View

  1. In Security View,select the 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 which 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 to which you want to download the corporate event.
  2. Right click and select “Event Append“->”Download Corporate Event
  3. Set Begin Date and End Date for the symbols which 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



Mark to Market Gain and Loss Pie Report

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

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

     

  3. The Bar Chart
  4. 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.

     

  5. Summary Information of the report
  6. 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



Realized Gain and Loss Pie Report

Realized Gain and Loss Pie Report

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

  3. The Bar Chart
  4. 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.

  5. Summary Information of the report
  6. 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.

Daily Account Value


Daily Account Value

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:
  5. 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.
  6. After selecting the specific column header you wanted to show(i.e Account Value, Portfolio Value, Cash Balance, Trends Comparison) in the chart, the chart will show as below:
  7. Basic Function
    1.Column Header
    the selected column header you wanted to display in the chart
    2.Account Value The line of Daily Account Market Value
    3.The line of Comparison Trend
    The line of ^DJI index compare with account value
    4.Portfolio Value
    The line of Daily Portfolio Value
    5.Cash Balance
    The line of Daily Cash Balance
    6.Tip Box
    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.
    7.Left Y Axis Left Y Axis indicates the trade total value based on the unit : thousand
    8.X Axis X Axis indicates the specifc date
    9.Right Y Axis Right Y Axis indicates the percentage of the total value
    Statistics Information
    Daily Account Value Statistics
    • From 2009-01-01 to 2009-12-312009-1-1 is report Start Date,2009-12-31 is report End Date
    • Start Date Account Market Value 100,000.00End Date Account Market Value 162,148.00(62.15%)

      Daily Account market value (include securities & cash Value)

      In this case, End Date market value(162,148.00) increased by 62.15% than Start Date
      market value(100,000.00)

    • Maximal Drawdown 24,735.00(17.16%) It is defined as the biggest drop of a given asset within a certain time period. In this case, The biggest drop for 24,735.00(17.16%)

      Max 144,104.00[2009-04-16], Min 119,369.00[2009-06-30]

      The biggest drop from the highest 144,104.00[2009-04-16] down to the lowest 119,369.00[2009-06-30]
      (Marked by the triangle in the chart)

    Realized Gain&Loss Statistics
    • Realized 6 Total trades. 4 wins/2 losses. Total commission: 81.67In this case, Realized Gain&Loss has 6 total transactions. 4 Wins and 2 losses. Total commission is 81.67
    • Realized Total profit 21,726.33, Realized Total loss 2,133.00, Realized Net profit 19,593.33Realized Net profit = Realized Total profit – Realized Total loss
    • Average profit per trade 5,431.58, Average loss per trade 1,066.50, Average net profit per trade 3,265.56 

      Average loss per trade 1,066.50 = Realized Total loss 2,133.00 / 2 losses

      Average net profit per trade 3,265.56 = Realized Net profit 19,593.33 / 6 Total trades

      Average profit per trade
      5,431.58 = Realized Total profit 21,726.33 / 4 wins

    Mark to Market Gain&Loss Statistics
    • MTM 10 Total trades. 8 wins/2 losses. Total commission: 105.00 In this case, Mark to Market Gain&Loss has 10 total transactions. 8 Wins and 2 losses. Total commission is 105.00
    • MTM Total profit 64,281.00, MTM Total loss 2,133.00, MTM Net profit 62,148.00MTM Net profit = MTM Total profit – MTM Total loss
    • Average profit per trade 8,035.13, Average loss per trade 1,066.50, Average net profit per trade 6,214.80 

      Average loss per trade 1,066.50 = MTM Total loss 2,133.00 / 2 losses

      Average net profit per trade 6,214.80 = MTM Net profit 62,148.00 / 10 Total trades

      Average profit per trade
      8,035.13 = MTM Total profit 64,281.00 / 8 wins

    Total Sales
    • Short Term Total SalesTotal sales amount if the Assets hold one year or less
    • Long Term Total SalesTotal sales amount if the Assets hold more than one year
    • Short Open Position Total SalesTotal sales amount if the Investors have sold short but not yet covered or closed
    • 1099 Gross Sales (added broker fees to cost basis)1099 Gross Sales = Short Term Total Sales + Long Term Total Sales + Short Open Position Total Sales

      Gross proceeds less commissions (did not add broker fees to cost basis) = 1099 Gross Sales – Realized Total Sales commission

Import Trade History


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 (Recommended)

  1. Built-in Broker Profile: Currently TradeMax already havs built-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), Micorsoft Excel(*.xls), Open Financial Exchange(*.OFX) file, Quicken Financial Exchange(*.QFX) file
    How to import Quicken QIF file to TradeMax
  3. Unknown column csv or excel 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 any extra cost.

Import Sample files

The following 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 and 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 help you to import it directly from the local file with the following step-by-step wizard.More…

Please Note: Some Gains & Losses Reports 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…

Import data copied from broker Transaction History Report


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:

    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 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
    1. Click Next, the Clipboard Data dialog box appears:

    1. You just need to log onto the website of the specific broker, and copy the transaction history.

    1. Click “Paste” button to paste the data onto the clipboard of TradeMax.

    1. 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),  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.
    1. 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.)

    1. Click Next for the Symbol Validation dialog box to pop up.

    1. 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

    1. Click OK button go to the next step, and the trade data is imported.

Vanguard


Vanguard Import Instructions:

There are two different methods to importing your trade history from Vanguard into TradeMax (select a method for detailed instructions):

Page 2 of 1212345678910...Last »

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