News |Form 8949 Capital Gain & Wash Sales calculator software

What’s New in TradeMax Ver 2015 – Software for capital gains tracking

TradeMax™ Ver 2015, inheriting the features of version 2014, perfects its functions by expanding its Appliacition Module,Report Module.

  • Speed up trade data load time, 200% performance boost
    Compare with TradeMax 2014 trade data load time, TradeMax 2015 show 200% performance boost, it loaded 100,000 records just in 10 seconds. TradeMax 2015 performance that’s fast and powerful, and much more.
  • Software for capital gains tracking
  • Support IRS Form 8949
     A new tax form for reporting capital gains and losses from stocks, bonds, mutual funds and similar investments.
  • Application can handle 2GB+ address


How to import trade data from MetaTrader statement

How to download account activity or statement file from MetaTrader Software:

  1. Run MetaTrader sofware & Login your MetaTrader account find terminal view.
  2. To find the Terminal view,Just in “View” Menu select “Terminal” or click CTRL+T as shortchut then change tab to Account History…
  3. Click MetaTrader Forex Account History tab to export MetaTrader Detailed Statement(*.htm)

  “Account History” tab that is located in the bottom of MetaTrader trading platform.

metatrader 4 all histoy

3.In “Account History” tab, Right click the mouse.In dropdown menu,Please select  “All History” or “Custom Period” . After that operation all of your trade historical data should appear.

 Right clicking on the mouse and selecting “Save as Detiled Report”, a HTML form metatrader statement can be created. You may choose a folder where you wish the save the statement.

You can also save the Account History as Detailed Report. The difference to a normal report is that a Detailed Report draws a chart with detailed information of the account events.

  1. Import MetaTrader Detailed statement into TradeMax
  2. Run TradeMax,Create a account which broker name is MetaTrader.The import function is available under the Account List: Right-click the account which you want to import your data and select the Import Trade.

Option 2 : If you already have downloaded trade data from your brokerage, just choose “Import Trade Activity Data from Local File” Option.

Click the next window,

4.In profile name dropdown list,select the profile name(“MetaTrader Detailed Statement”),in import file field,click the browse file button to choose “detailedstatement.htm”


Sample data should look like follow html templet.

Ticket Open Time Type Size Item Price S / L T / P Close Time Price Commission Taxes Swap Profit
4469735 2012.10.11 07:56:12 balance R2 – OFM20121011022051 – NA 1 000.00
4470876 2012.10.11 08:59:51 buy 0.10 usdjpy 78.087 0.000 0.000 2012.10.11 15:55:42 78.505 0.00 0.00 0.00 53.25
4479844 2012.10.11 22:00:32 buy 0.10 usdjpy 78.344 0.000 0.000 2012.10.15 03:35:15 78.476 0.00 0.00 -0.01 16.82
4486272 2012.10.12 13:25:19 buy 0.10 usdjpy 78.399 0.000 0.000 2012.10.15 08:05:29 78.623 0.00 0.00 -0.01 28.49 the Next button to continue

If you want to calculate future gain&loss,you should use “Mark to Market Form 4797″ report to view your Sect.1256 future’s Gain & Loss.

Or remove the Sect.1256 future’s in the Short/Long term Gain/Loss report blacklist. ask md

Why there are some trades are showing in Short term when the dates would seem like Long Term.

Q:Why there are some trades that are showing in Short term when the dates would seem like Long Term?

In USA, the wash sale rule has the following consequences:
Holding Period: The holding period for the replacement stock includes the holding period of the stock you sold.

Wash sale Holding period
When a wash sale occurs, the holding period for the replacement stock includes the period you held the stock you sold.
Example: You’ve held shares of XYZ for 10 years. You sell it at a loss but then buy it back within the wash sale period. When you sell the replacement stock, your gain or loss will be long-term — no matter how soon you sell it.

So short term loss can be change to long term loss because of wash sale event,please check it.

Will I be able to produce a 4797 that is accurate without the need to correct errors

Q:I downloaded the trial version and produced a report that is not accurate with many errors.  The account I’ve elected mark to market is with mb trading/apex.  If I purchase your software will I be able to produce a Form 4797 that is accurate without the need to correct errors?  I want to keep this as simple as possible.

A:TradeMax use matched Trades to calculate capital gain&loss.(Long/CloseLong)(Short/CloseShort)

If TradeMax reports an Unmatched Trade in the Scan Information tab(part 4), this means you have closed some securities, but you do not have any open position.
Please fixed these warning first,then use Trademax to generate your Form 4797

Unmatched Trades may be caused by 3 conditions:
1) You do not have FY2011’s Baseline (Baseline position is the holding open position from the previous tax year).

This can be rectified by importing the Baseline function or by manually enter the Baseline one at a time.

2) The Trade sequence is wrong
Some times, Brokers will send one day’s trade sequence en masse, without proper chronological ordering, which will cause problems.
TradeMax allows you to adjust the sequence of the transaction records traded on the same day by moving each transaction up or down the records.
3) Some Corporate Events mightcause the unmatched Trade Error.
In-built functions like the Stock Split, Merge or the Spin-off Action will help you change the stock quantity.

For example, these are some Unmatched Transactions that can be found in a database.

Clicking on the ‘Unmatched Quantity’ (highlighted in blue), will trigger TradeMax to move the transaction to the Unmatched Records.
case 1(172967101)

This error may be caused by missing Baseline Positions. (You should have 17296710’s Baseline Position on FY2011)

You can use the Import Baseline function or manually enter the Baseline one by one.

In this case, please make note of the Split Event, since if the Sell Stock is implemented after the Split Event, TradeMax will split it 1 to 10.
Whereas, if Sell Stock is before the Split Event, you must use the Move Up function to adjust 1251 and 1376’s sequence.

Case 2(EEM)

In this case, EEM has a “Div Event” on 2011-01-05 and has the Close/Long action on 2011-02-26, which implies there may be a Baseline Position error.Please check your Monthly Broker Statement.

Case 3 (F)

If you do not have enough stock, executing a Close action will cause an Unmatched Error.
In this case, 2400 shares were bought, whereas 2410 are to be sold, which is not possible. Hence TradeMax give you a warning.
Please check the trade history (Income reinvestment can help add 10 shares and thus avoid the error).

Case 4

In this case , the Trade sequence is wrong. Sometimes, Brokers  submit one day’s trade sequence without time ordering it and this will cause the problem.
If your Broker’s Trade History provides a Trade Time column, you can import it into TradeMax and it will automatically sort the sequence by the Trade Time.
Alternately, TradeMax allows you to adjust the sequence of the transaction records by moving up or moving down  each transaction. (Select record[134] and use the Move Down function to move it under record[136])


If you recieve a “Tolerance Warning” in TradeMax, Click the Tolerance Warning Records in theinformation bar andTradeMax Data gird will move automatically to the warning records
In TradeMax
buy amount = qty* price +commission +fee
sale amount = qty*price  – commission – fee

This warning implies that Quantitty, Price, Commission, Fee and Amount Datafields have some problems like a hidden fee not being listed in the trade data csv file.

This problem can be viewed in the warning records

TradeMax has a default tolerance value of 0.5.

In some cases, Microsoft Excel’s column number format might trigger this warning.(When you import excel file)

Consider this record #1505.

6-15-2011 Sell 700 VXX BARCLAYS BANK IPATH NEW IPATH S&P 500 VIX SHORT 24.50 $17,141.14 $2.56

Excel displays the first two digits after the decimal point under default settings.
Similarly, If the actual price is 24.491 and TradeMax is set to use xls API to import the data by default, TradeMax will read the value as 24.50.

The number of places after the decimal point can be adjusted in the Excel “Price” column format which will change it to  the first three digits after the decimal point.

Excel can format numbers any way required using the “Format Cell” feature. Select the cell with the number to be formatted and press CTRL+1 (or right mouse click > format cells) to go to the Number tab in the dialog box. Select “Number” category and change 2 digits to 3 digits. This will force Excel will show the correct value.

Once saved, the excel file can then be used to import correct datafields to TradeMax again.

How to Import TXF Files into H&R Block TaxCut

Q)How to import TradeMax TXF file into H&R Block TaxCut ?

With TradeMax, you can export your gains and losses to popular tax software programs with the TXF Export function.Here we will provide you with a step to step wizard to show you how to export your TXF file with the TXF Export function

For example, if you want to export the FY2008’s G & L Report to TXF file, you can do the following:

  1. Right click the folder FY2008 under the Trade Bar and select the TXF Export from its context menu:
  2. Following dialog box will pop up:
  3. Select the path & File name to save your TXF file.
  4. Press Save button to finish the process. Now you can find your TXF file in your selected path.

To import txf file from TradeMax to H&R Block TaxCut ,You should use follow step

H&R Block At Home imports your personal tax and financial information from last year’s H&R Block At Home, Microsoft Money (Windows only), Quicken, and last year’s TurboTax (software) federal return.

If your information is in a .txf file, H&R Block At Home will also import other financial programs. To import financial information from a .txf file: Open Taxcut or H&R Block At Home, depending on which version of the program you use.

  1. Click File in the top left corner of the screen.
  2. Choose Import Financial Information.
  3. Click Browse on the Import Financial Information window.
  4. Select your file to import.
  5. Click Import Selected File and Select the “TXF” file you created. This will import your tax files  to Taxcut.
  6. To review your imported financial information, click the Reports menu and click Review Financial Imports.

if you start a new tax return, please select “Welcome” and then “Smart Import” and follow the steps below.

  1. Import Data from Financial Software
  2. Select Financial Program infomation from “File” menu
  3. Other Financial Program and Import TXF file
  4. Import Individual TXF Files
  5. Choose a TXF file to Import
if H&R Block ask you “Do you want to import data from financial software?”,Select “Yes
Click on the “Next” button.

In “Select Financial Program” Dialogbox,Select “Other program that supports Tax Exchange Format (TXF)“,Click on the “Next” button.

Click on the “Import” button.

Choose a .txf file you want to import.

click “next” button,you could select the imported txf file.

Click on the “Import Selected File” button

Trade accounting software for day trading(day trader program)

TradeMax® is a trade accounting software for day trading.It designed for active trader for its great capacity to support unlimited number of trades(stock,future,options,bonds, Commodities, Fund, Currency), also breezes normal traders with its function to auto-generate various reports from several accounts.

TradeMax 2013 supports more brokerage accounts than 2012, especially those popular brokers from which trade data can be directly imported. TradeMax also provides multiple easy and convenient options for users to import their trade data into TradeMax, users can either import trade data from local file(*.xls,*.csv,*.txt) or import directly from online brokers, or just copy the transaction history from the brokerage then paste to TradeMax’s clipboard

As your transactions are imported, profit and loss of each trade is automatically calculated for the entire year for day trader. Neutral Trend’s TradeMax® 2013 provides you with a powerful filter function to filter your trade data. It also allows user to add   various reports in TradeMax

TradeMax 2013 provides users with easy steps to generate Daily Account/Portfolio Value Chart Report or Mark to Market Gains & Losses Pie report for the purpose of better investing , Daily Account Value chart report helps you to compare your current Account Value with other index(DowJones,S&P500) and analyze trade performance based on the detailed information on daily basis, while the Gains & Losses Pie reports give you a concise or summarized information about the gains or losses of selected securities during a specific fiscal year or a set time period.

TradeMax® 2013 processes corporate events that affect cost basis or Capital Gains Tax for the Schedule D(Form 1040) and keeps track of cost basis adjustments due to corporate actions like splitsspin-offs, and mergers. By using this feature, investors can view all of their transactions that have occurred in this particular symbol such as Return of capital, Reinvested Income and Dividend paid on Short Sales which will provide them with the facility to conduct transactions more accurately and adjust their trade for tax purpose by maintaining the trade history.

Can TradeMax generate monthly and quarterly transactions report?

Q:Can TradeMax generate monthly and quarterly transactions report?
TradeMax can generate  monthly and quarterly transactions report by select Subtotal field in Report Window.

Now, we take the Realized Gain/Loss Report as an example.

After you select the report,you can choose Subtotal from drop-down list(1).

If you select Month ,TradeMax’s report will group by Month.(Default is group by Symbol)

TradeMax reports can group by follow types:Symbol,Quarter,Month,Year,Day,Action

How to include forex trades in the Realized Gain/Loss Report

Q:I come from a country where forex is treated the same as stocks for realized gains purposes.

I have not been able to find a way to include forex trades in the Realized Gain/Loss Report.Is there any way to do it in TradeMax?

A:In TradeMax, Forex trade should be reported on Sect.1256 Report( Mark to Market as default)

You also can use blacklist function add the forex data to the realized gain/loss report.

  1. Click Options button, and select Black List tab,  the following dialog box is displayed:

In “filter” dropdown-list select the “Realized Gain/Loss report”,remove the “Forex”,””Forex Future”  from the blacklist

Click the “ok” button,

In general tab,click “clear report cache” button

Now you can check your Realized Gain/Loss Report.Forex data is included in the report

How to check 1099 Gross sales in TradeMax

This value(1099 Gross Sales) allows you to reconcile the Total Sales amount in TradeMax to your brokerage provided 1099-B Gross Sales amount and shows any necessary adjustments to the TradeMax Total Sales such as for open short sales and option sales.

  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. In Daily Account Report,there will a lot of Statistics information under chart report.
    Include 1099 Gross sales Value,short open position total sales,
    Short Term Total Sales,Long Term Total Sales
    Start Date Market Value,End Date Market Value,Max Account Value Drop Down
    Realized Total profit,Average Profit per trade
    Realized Total Loss,Average loss per trade
    Realized net profit,Average net Profit per trade
    Mark to Market Total profit(loss),Mark to Market Average Profit(loss) per trade

What’s New in TradeMax Ver 2012

TradeMax™ Ver 2012, inheriting the features of version 2011, perfects its functions by expanding its Calendar Module, Portfolio Beta Calculator Function.

Calendar Module —With Trademax calendar view, transactions can be viewed by month or by week. This helps you to visualize when transactions occur each month.You can use Day View, Work Week View, Week View or Month View to check the transactions record for a certain period.

Portfolio Beta Calculator
Portfolio Beta model shows the risk-adjusted return of the portfolio and that of the index over a time period in the past.This model also includes options trading strategy evaluation function which can give you a graphic reporting on specific options spread trade strategies, specificallybutterflies, calendars, iron condors, and their adjustments.

Page 1 of 212

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