Handle your wash sales and generator your Schedule D

Day Trading Report -  This report is for those users who want to calculate  trade performance for the day across the accounts and the symbols.It can calculate gains/losses and gross and commission subtotal for each security in a date range ( Day,Week,Month).This report come with Trade-time Field,so that you can check the open trade date-time and close trade’s Date-time(MM/DD/YYYY Hours:Mins:seconds) for each transaction.

Day trading reports that tell you gain&loss for each security in in a date range ( Day,Week,Month).

You can add this report by follow way

1. Right-click the Trade Data & Report view in the Account List and select the specific report.
2. In “Tax Current” select “Day Trading Report”

Instructions

1) On the NinjaTrader Control Center, select the “Account Performance” tab.

To generate a performance report:

4. To get the ATM style trade listing, (averaging your prices for up to three entry and exits) tick the check-box labeled “Group trades by ATM Strategy“.

5. Click “Generate“. Your trade data will now be displayed in the Account Performance tabs (Summary, Graphs, Executions, Trades, Periods, Orders, Journal).

To export your trades:

1. Click on the “Trades” tab
2. If not already set, ensure that all columns are displayed by right clicking on the column headings, selecting Grid -> Properties, and ticking all check-boxes. Click OK.
3. Right click on any of the trade data boxes.
4. Select Grid -> Export to Excel
5. Excel will open with the data entered in a new worksheet. Use Save As to store the data on your hard-drive.

To download account activity file from OptionsHouse:

1. Login your OptionsHouse account.
   

   In Account Activity window

   

   The account activity window is easily accessible from Quick Start menu so you can see everything that’s happened in your account for as long as your account has been active. You can also minimize it and it will stay on the lower navigation bar each time you log in.

   The account activity screen displays all your fills and the price at which they made it into the market.

2. You can use the filter to narrow down the activity you’re looking at by date range, transaction type, and symbol.
3. On the top-right of the screen, you can also export the activity being shown and save the data into a CSV or XLS file.
4. Your downloaded file must be in this format as shown below, otherwise, you should set your profile in profile wizard dialog box to import your data into TradeMax.
   

   Trade Date	Action	SecurityType	Description	Symbol	Underlying symbol	Quantity	Price	Commission	Amount	Fees
   4/2/2010 11:25:28 AM	Buy To Open	stock	MSFT AprWk2 280 Call	MSQ101203C00118000	MSQ	10	8.88	7	-8887.07	0.07

   If you find the your downloaded file format is different from the above formats, you should set your profile in Profile Wizard.

5. Run TradeMax to import trade activity data from local file.

To download data file from TradeKing:

Note: TradeMax suggest you choose QFX(Quicken Format) file as default data file.

If you have already set up your software to accept TradeKing data, Log into your TradeKing account and under “Accounts - Download Data” downloads your account data.

1. Choose “Quicken© 2004 or newer” format.
2. Set the desired date range of your data.
3. Click on the Download button to save the file.
4. Run TradeMax and setup a TradeKing account to import trade activity data from local file.Then click Next Button
5. In Profile Name dropdown list,select Open Financial Exchange (*.ofx,*.qfx,*.xml)
6. Click File Browser Button to select qfx data file from your computer,then click Next Button.

Q)How to import TradeMax TXF file into turbotax?

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.

(more…)

Form 8949 - Starting with the 2011 tax year, investment transactions will be reported on the new Form 8949, Sales and Other Dispositions of Capital Assets.

Use Form 8949 to report:

1. The sale or exchange of a capital asset (defined below) not reported on another form or schedule,
2. Gains from involuntary conversions (other than from casualty or theft) of capital assets not held for business or profit, and
3. Nonbusiness bad debts.

The IRS has created a page on IRS.gov for information about Form 8949 and Schedule D at www.irs.gov/form8949. Information about any tax law changes or other new developments affecting Schedule D or Form 8949 will be posted on that page. Form 8949 is new. Many transactions that, in previous years, would have been reported on Schedule D or D-1 must be reported on Form 8949 if they occur in 2011. Complete all necessary pages of Form 8949 before completing line 1, 2, 3, 8, 9, or 10 of Schedule D. Instructions for how to complete Form 8949 are included in these instructions.

Now, we will show you how to run an Form 8949 with TradeMax:

Note: Please enter your Name and SSN before run the report with the Option button in the Main Button.

Right Click the item “Trade Date & Report” > “Add Report” > “Tax Currency” > “Form 8949″ and you will get a report just like the IRS form 8949.

Use a separate Form 8949, Part I, for each of the following types of transactions.

Use a separate Form 8949, Part II, for each of the following types of transactions.

Include on each Form 8949 only transactions described in the text for the box you check (A, B, or C). If you have more than one type of transaction (A, B, or C), complete a separate Form 8949 for each. Check only one box on each Form 8949. For example, if you check box A in Part I of one Form 8949, include on that Form 8949 only short-term gains and losses from transactions your broker reported to you on a Form 1099-B (or substitute statement) showing that basis was reported to the IRS. If you have other types of transactions, report those on a separate Form 8949 and check the box that applies.

Note: In dialog box you can select the transactions,click “Move Selected Trans to …” button to move your trans to another type.

Click ok button ,your Form 8949 report will be generate.
Compare with standard Form 8949 report,TradeMax add “gain or loss combine columns” to the report.
So you can check the Formula results with this column,TradeMax also add “short term [a][b][c]subtotal/Long term   [a][b][c]subtotal” Field to help you fill schedule d form.

The tradeMONSTER Account History section allows you to review a live transaction history of your account. You may view an aggregate list of transactions or filter transactions by type or symbol.  Data can be exported to a CSV file.

First,login your tradeMONSTER Account,then from Account menu, click History button.

Explanation of Details

1. Select Transaction Type

   Select to view All transaction types or select a particular type.

   

2. Select Symbol Parameters

   Select All symbols or Custom. Custom allows you to enter a symbol and all trades associated with that symbol and any options will be displayed.

3. Time Range

   Select the time range for which to view the Account History.  Choose between “Today”, “This week”, “This Month”, or a particular date or a date range across months.

4. Menu button

   Click to invoke the Menu for the Account History Overview.

5. Edit Cost Basis

   Click to edit the cost basis of any transferred positions.

6. Export

   Export screen trade history data to a CSV file for saving and/or manipulating in Excel.

   Click the Save button in another pop-up File Download dialog box.

Run TradeMax® , click tradeMONSTER Account to import trade activity data from local file.

Note: You should select tradeMONSTER *.csv, *.txt as your profile name during the importing process.

Option 3: Import Realized Gains and Losses Report from Local File

Realized Gain and Loss Report displays trade details of the selected account’s short-term and long-term gains, short- and long-term losses, and wash sales, as defined by the IRS, grouped by security for the selected tax year.

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.

Please Note: Some Gains & Losses Report do not have year end open postion,this will effect wash sale calculating.

1. Click Import Tab in trade panel, and select the Import Trade from dropdown list.



2. A Select Import Data Source window pops up, select Import Realized Gain and Loss Report from Local file. Click Next button.
3. Select Profile and Import File dialog appears as below.Note: The Realized Gain and Loss Report data file will be in XLS format, please select Profile Wizard(*.xls) the Profile Name dropdown list.



Function	Description
Profile	Profiles Options: Default is : Profile Wizard *.xls
Type	Select TXT or XLS data file. Default is : XLS
Has Column Header	If there is a column header in your imported file, you will need to select the checkbox
Import Sample Files	Follow linked documents contains sample trade data that you can download to practice or use as templates for importing transactions into TradeMax.
Short Transacton 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 Transacton Detectionif you did not Enter the Baseline Positions or Include the Baseline Position. In this case, the TradeMax will assign the close long transaction as an open short transaction
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.
Import File	Click File Browser Button to select data file from your computer.

4. Click Next, a Trade Data Review Dialog Box pops up:



If the realized Gain and loss report has report description or report title displayed in the initial parts, TradeMax might not find these column headers or titles, but if you enter any related key words in the blank sheet behind Has Column Header, TradeMax can auto-identify these column headers.

5. Click Next and Map Fields window opens.
   Users can check the box on the left side of Show Mapping Result to display or hide Map Result Grid.
6. Click Next, and the Map Actions pops up.
   In this step, you can map your data by assigning or mapping the column header. (With the default profile, this step will be skipped.)
7. Click Next to open symbol Validation window.
8. Click Next to go to next step.
9. Click Finish Button, a File Save As dialog box appears to give the users facility to setup the profile as a new one in profile list for you to import trade more easily.
10. Click OK button to next step, the trade data is imported.

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.

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:

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