Import Trade History |Form 8949 Capital Gain & Wash Sales calculator software

Download Account Activity From NinjaTrader


Instructions

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

To generate a performance report:

Control_Center_20

1. Select the From and To date range for the report
2. Select the Mode for the performance data to be displayed in. The options are Percent, Currency, Points.
3. Click the “Advanced >>” button if you wish to filter your listed trades by either of the following categories: Account, Instrument, ATM Strategy, Data Provider, or Market Type.

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.
TradeMax built-profile now support the NinjaTrader’s TradeReport.xls and Executions.xls
To import NinjaTrader xls files,please use following step
1.Create an account(NinjaTrader) in TradeMax Database.
2.Select the account,right click the mouse,select “Import”-> “import trade” from the menu
3.In import wizard dialog box,select “Import from local file”
4.In profile name dropdown list,select the profile name(Executions“,Trades Report “,”Order Report”)
Report should like follow xls file templet
5.Browse the xls file
6.click 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.

http://www.itrademax.com/ipress/detailed-instructions/run-reports/mark-to-market-for-form-4797.htm

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

http://www.itrademax.com/ipress/news/how-to-include-forex-trades-in-the-realized-gainloss-report.htm

Download Account Activity From OptionsHouse


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.

Download Data From TradeKing


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.

Download Trade History From tradeMONSTER


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.

Import Realized Gains and Losses Report from Local File


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

  5. Click Next, a Trade Data Review Dialog Box pops up:
  6. 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.

  7. 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.
  8. 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.)
  9. Click Next to open symbol Validation window.
  10. Click Next to go to next step.
  11. 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.
  12. Click OK button to next step, the trade data is imported.

Download Data from JPR Capital


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

Import Previous Year Holding Position


Import Baseline

TradeMax provides you the facility to import Previous Year Holding Position. You can import baseline from last December’s Statement,Such as Quicken Statement(Qif,Qfx type),Ofx format file or XLS, CSV,Text which include Baseline files etc.The importing process is also a profile setting-up process. It provides you with a wizard to filter the useful trade data, match the data, and then generate a TradeMax data format for the following tax purpose calculation.

Note:

  1. The file could have one of the following type extension: *.csv, *.txt, *.xls, *.qif, *ofx, *.qfx, *tdf.
  2. You should select last December’s QFX or TLF data file to import baseline trade data.

Let us take AB Watlry for example:

  1. Click Import button and select Import Baseline.
  2. Select I want to import data from local file from the pop-up dialog.
  3. Function Description
    Account Select an account to import your data
    Trade Time Range Automatically display the date range of existing trades in the current account
    Mode
    If you have trade data in your computer, please select I want to import data from local file.
    If you want to skip the file downloaded process, just select I want to import data copied from broker Transaction History Report.
    Include Baseline If you have already appended baseline position, you will need to select the checkbox and enter your specific tax year or select it with the arrows at the right side
  4. Click File Browser Button to select data file from your computer and then click Next Button to continue.
  5. Function Description
    Profile Name Preset import profiles for importing trade data. With the default profile, you can skip Step 2, Step 4 and Step 5

    Profiles Options:
    1.Profile Wizard: Setup a temporary profile or replace it with specific one to setup a new profile which can be re-used to import a similar file.
    2.File Profile: Quicken Interchange Format(*.QIF), Interactive Brokers TDF Format(*.TDF), Open Financial Exchange(*.OFX), *.csv, *.txt, *.xls, *.qfx.

    Default is : Profile Wizard

    Import File Click Browser File Button to select data file from your computer.
    Note: If you select last December’s QFX,QIF or TLF data file,you should select correct profile from the profile dropdown list.
  6. Click Next to pop up Map Field dialog box.
  7. In this step, you can map your data by assigning or mapping the column header. (With the File Profile, this step will be skipped.)

  8. Click Next to pop up Symbol Validation dialog box.
  9. More Detail,please check import from local file.

Download Security Event Data


Download Security Event Data

With this function, you can download security event data from the Internet and calculate the cost base of the securities in a certain period of time, which can help you to plan your investment better.

Download Event Data in Security View

  1. In Security View,select the symbols which you want to download corporate event.
  2. Right click and select “Download Corporate Event“.
  3. Set Begin Date and End Date for the symbols which have corporate event, then click “Next>” to download event data.
  4. Click “Finish” to confirm the data.

Download Event Data in Trade View

  1. In Trade View,select the trade to which you want to download the corporate event.
  2. Right click and select “Event Append“->”Download Corporate Event
  3. Set Begin Date and End Date for the symbols which have corporate event, then click “Next>” to download event data.
  4. Click “Finish” to confirm the data.

Import Trade History


Technically, TradeMax supports every broker, known or unknown, as long as this broker provides a statement in CSV/EXCEL format or Quicken Qif,QFX fomart / Money OFX format or OFX server connection. Without changing codes, TradeMax allows users to define their own templates which suit the CSV format of their broker data.

There are Four options to import your trade data into TradeMax:

A) Import Trades from online Brokerage Server(OFX Server)

If you want to download trades from online brokerage account, select this option. Please check our supported broker’s OFX server list, if your brokerage provide ofx data service and not listed in our list, you can send your broker name & ofx server url to contact form we will add it to TradeMax.

B)Import Trade Activity data from local file (Recommended)

  1. Built-in Broker Profile: Currently TradeMax already havs built-in template for IB and ETrade, ScotTrade, OptionsXpress, TdAmeritrade, Schwab, Person,Sogotrade and more.(Please check our supported brokers list),
  2. File Profile: TradeMax can support Quicken Interchange Format(*.QIF), Micorsoft Excel(*.xls), Open Financial Exchange(*.OFX) file, Quicken Financial Exchange(*.QFX) file
    How to import Quicken QIF file to TradeMax
  3. Unknown column csv or excel file:You can either define your own template with trademax profile wizard function or send us a sample CSV or Xls data file with 8~10 lines of transactions in it for importing, we will build template for customer without any extra cost.

Import Sample files

The following documents contains sample trade data that you can download to practice or use as templates for importing transactions into TradeMax.

Trade Activity Sample Files.xls (Profile Wizard[*.xls])
Each Record has TradeDate,Symbol,Action,Qty,Price,Commission,Amount
15 kB
Realized Gain and Loss Report.xls (Profile Wizard[*.xls]) –
(Symbol,qty,open/close date ,Proceeds /Cost Basis in single record)
18 kB

C) Import Realized Gains and Losses Report from Local File
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.More…

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

D) Import Trade data copied from broker Transaction History Report
You can copy your Broker’s Transaction History report from the web browser and paste to TradeMax during the importing process. More…

Import data copied from broker Transaction History Report


Option 4: Import Trade data copied from broker Transaction History Report

If your security trader holds online brokerage account, TradeMax provides an easy wizard to import trades from your broker’s website using Transaction History Report, the users just need to copy the Transaction History Report from website of the specific broker, then paste to TradeMax during the import process.

Let us take Citibank for example:

    1. Select I want to import data copied from broker Transaction History Report from the pop-up dialog.

Function Description
Account Select an account to import your data
Trade Time Range Automatically display the date range of existing trades in the current account
Mode If you already have a user name and password of the selected account, select I want to connect to ***. I have a *** user name and password.
If you have trade data in your computer, please select I want to import data from local file.
If you want to skip the file downloading process, just select I want to import data copied from broker Transaction History Report.
Include Baseline If you have already appended baseline position, you will need to select the checkbox and enter your specific tax year or select it with the arrows at the right side
    1. Click Next, the Clipboard Data dialog box appears:

    1. You just need to log onto the website of the specific broker, and copy the transaction history.

    1. Click “Paste” button to paste the data onto the clipboard of TradeMax.

    1. Click Next Button to continue.

Function Description
1. Profile Name Preset import profiles for importing trade data. With the default profile, you can skip Step 2, Step 4 and Step 5 Profiles Options:
1.Broker Profile: ScoreTrade, Interactive Brokers, E*Trade and so on
2.File Profile: Quicken Interchange Format(*.QIF),  Open Financial Exchange(*.OFX), *.csv, *.txt, *.xls, *.qfx.
3.Profile Wizard: Setup a temporary profile or replace it with specific one to setup a new profile which can be re-used to import a similar fileDefault is : Broker Profile like ScoreTrade; Quicken Interchange Format(*.QIF), Excel Format(*.XLS), Open Financial Exchange(*.OFX)
2. Sample Data The Sample Data of specific broker will be displayed in this field, if the data file you copied from the broker doesn’t match the required format of corresponding profile, a notification window will pop-up.Note: If the data doesn’t match, you can select Profile Wizard from the droplist of Profile Name to make changes in the settings.
3. Short Transaction 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 Transaction Detection , if you did not Enter the Baseline Positions or Include the Baseline Position. In this case, TradeMax will assign the close long transaction as an open short transaction
4.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.
5. Import File Click File Browser Button to select data file from your computer.
    1. Click Next to pop up Map Field dialog box.

In this step, you can map your data by assigning or mapping the column header. (With the default profile, this step will be skipped.)

    1. Click Next for the Symbol Validation dialog box to pop up.

    1. Click Next to go to the next step

Click Finish Button, a File Save As dialog box appears to give you the option of setting up the profile as a new one in the profile list for you to import trade history more easily

    1. Click OK button go to the next step, and the trade data is imported.

Page 1 of 512345

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