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

Column Headers

The headers on the columns in the grid have the following meanings.

Column Header Meaning
Action Action name in TradeMax.
Buy to Open / Long — Buy Stock/Option to Open a Long position
Sell to Close/ Closed Long— Sell Stock/Option to Close a Long position
Buy to Close — Buy Stock/Option to Close a Short position
Sell to Open — Sell Stock/Option to Open a Short position
dividend, Journal, stock merge etc.
ActionName Action name in your brokerage trade history.
For example, Buy, sell, dividend, Journal, stock merge etc.
Account Trade account in TradeMax
Amount Trade amount
Commission Trade broker commissions (Including fees)
DeferCost Deferloss produced by wash sales from last year
ExpireDate Expire date of option or future.
ID Trade ID in TradeMax.
Market Exchange market where you bought the financial product. For instance, NASDAQ.
Notes Any information of the trade record
Price Security price
Quantity Number of shares
Rate Option or future rate. An option has a 100 “Rate” which means an option contract is for 100 shares of the underlying stock.
StrikePrice The strike price of the underlying stock in the option or future
Symbol Security Ticker Symbol
TickerMatch The strike price of the underlying stock in the option or future
TradeDate Trade date
TradeTime Trade time
TradeMatch The amount of “Force-Match” for tax purpose.
Type Security type. For instance, stocks and mutual funds, options on stocks, Single-Stock-Futures, futures, currencies etc.

Stock Split

Stock Split

A stock split is one of  corporate actions that happens when a company changes the amounts of shares and adjusts the share’s price accordingly. A stock split  increases or decreases the number of shares in a public company. The price is adjusted such that the before and after market capitalization of the company remains the same and dilution does not occur.

For example, a company with 100 shares of stock priced at $20 per share. The market capitalization is 50 × $20, or $1000. The company splits its stock 2-for-1. There are now 100 shares of stock and each shareholder holds twice as many shares. The price of each share is adjusted to $10. The market capitalization is 100 × $10 = $1000, the same as before the split.

Stock splits are usually non-taxable. It is important to note that after a stock split, the number of shares you own in the security and the cost basis of those shares will change. Often stock splits are expressed as a fraction.  A two-for-one stock split is the most common – the investor receives one additional share for every share owned in the security.

Cost Basis Transaction Report

Cost Basis Transaction Report -This report is for those users who track the cost basis in stocks, bonds and mutual funds to report a cost basis when an investment is sold.

Cost Basis, also known as “tax basis”, refers to what you paid for any investment which include commissions or the original value of an asset for tax purpose (usually the purchase price). Cost basis can be adjusted for stock splits, dividends and return of capital distributions, wash sale, and used to decide the capital gain, which can be got by subtracting the cost basis and current market value.

The following will tell you how to run a Cost Basis Transaction Report

    Click the item Cost Basis Transaction 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

    Display the cost basis details for all transactions in the current account and current period.

    3 Display the total USD Amount

    The following grid give a detailed introduction about the report .

    1.Trade Time

    The transaction date of the security

    2.Action Action name of the trade
    3.Description The information of the trade
    4.USD Price The share price at USD Currency price
    5.USD Amount Auto-Calculated by USD Price* Qty(Quantity)
    6.Qty( Quantity) The quantity of security you purchase
    7.Hold Qty ( Hold Quantity) The quantity of holding security
    8. Cost
    Aggregate Amount of USD Amount
Page 1 of 11

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