foreign currency |Form 8949 Capital Gain & Wash Sales calculator software

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

Does TradeMax handle multiple currencies across multiple portfolios and accounts ?

I am a Non-USD trader who is managing 5-6 accounts for my family and I trade Equities, Options, Futures etc. Does TradeMax handle multiple currencies across multiple portfolios and accounts?

TradeMax supports individual view and combined views, which mean you can setup different accounts to import your data files from different brokers to calculate your capital gains. TradeMax also supports combining different accounts into a new view, with the function, you can handle all of your trade data in a combined account.
As for foreign currencies, TradeMax supports the following foreign currencies such as EUR, CAD, AUD, JPY, HKD, GBP, CHF. After you import your trade data into TradeMax, TradeMax supports running various reports for tax purpose with your base currency.

Page 1 of 11

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