cash balance |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
    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

Daily Market Value Report


Daily Market Value Report – This report is for those users who track the performance and market value of the securities on daily basis in specific finance year. The report will show the portfolio of every transaction on daily basis.  Before you run this report, you should download the price history of the securities in specific finance year. Otherwise, the data in this report isn’t accurate enough.

Daily Market Value is the relative market value of a security is simply equal to the aggregate market value of the security divided by the sum of the aggregate market values of all securities.

The following will tell you how to run a Daily Market Value Report

    Click the item Daily Market Value Report, you will get the following report window: 

    Basic Function
    1 Report data information including Data Source, Create Date, Tax Payer and Page of Total
    2

    Display market value details for all transactions in the current account on daily basis

    3 The chart display the day balance and cash balance

    The following grid give a detailed introduction about the report .

    Function
    Description
    1.Trade Time

    The transaction date of the security

    2.Portfolio Value Portfolio Value is a portfolio consisting of all securities where the proportion invested in each security correspons to its relative market value
    3. Available Funds Funds that are available to an account holder for withdrawal or other use.
    4.Total Market Value The Amount auto-calculated by Portfolio Value + Available funds
Page 1 of 11

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