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

Download Data From E*Trade


E*trade provides you two methods to download your trade records to your computer:

To download tax documents of an entire year:

  1. Log into your E*TRADE account .
  2. Click Accounts tab and then select Account Records.
  3. Select Tax Reports in the Brokerage Account Records section.
  4. Click the Tax Records tab and then left-click Export your 200X trades into Microsoft Excel.
  5. Click the Save button in another pop-up File Download dialog box.
  6. Open your saved file in Excel, and click File then choose Save As.. In its drop-down-list to save the data file as CSV format.
  7. Your downloaded file must be in this format as shown below.
    TradeDate
    Order Type
    Security
    Amount
    Cusip
    Transaction Description
    Quantity
    Executed Price
    Commission
    Net Amount
    3/8/2009
    Buy
    CROX
    -4272
    227046109
    CROCS INC
    1
    0039KSPT
    12.99
    1162.99

    The data in the above table is E*trade 2009 format, and the following table will display the  E*trade 2010 format:

    Transaction Date
    Transaction Ty
    SecurityTy
    Symbol
    Quantity
    Amount
    Quantity
    Price
    Commission
    Description
    12/22/09
    Bought
    EQ
    CIM
    5000
    -19407.49
    38799
    7.99
    0
    CHIMERA INVESTMENT

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

  8. Run TradeMax , click E*Trade Account in TradeMax to import trade from local file.Note: You should select E*Trade *. csv, *. txt as your profile name during the importing process. As the file data formats vary from year to year, and in the drop-down-list of Profile Name, apart from E*Trade *. csv, *. txt, there is another option, E*Trade 2008 *. csv, *. Txt, for the users to choose, according to their data file in different year. The default is E*Trade *. csv, *. txt.

Download Transaction History within three months to update your trade data(Quicken Format-QFX) Recommend

  1. Log into your E*TRADE account.
  2. Click Trading & Portfolios > Transaction History.
  3. Click the Transactions tab, select your Brokerage account and then click the Search Transactions button
  4. Enter the specific time range.Attention: You may download up to three months’ worth of data from your account.
  5. Select .QFX format in the data format field and click Download.
  6. Choose the Save option.
  7. Run TradeMax and click E*Trade Account in TradeMax to import trade activity data from local file. Note: You should select Open Financial Exchange *.ofx, *.qfx as your profile name during the importing process

Download Data From Interactive Brokers


 

 

 

Download From Interactive Brokers

To download data from Interactive Brokers:

  1. Run TradeMax and setup an IB account
  2. Log into your Interactive Brokers account.
  3. Click the plus sign in front of  Reports -> Activity -> Third-Party Downloads

    interactive broker trade activity third party download

    interactive broker trade activity third party download

  4. Select the appropriate Daily or Monthly Statement, In “Format” choose “TradeLog(*.tlf), Quicken(*.qfx) or MS Money(*.ofx)” ,then click the Download button.
    From the Account Administration section select Base Currency.In the Date fields, select the Period (Daily, Monthly or Custom Date Range) and a Date. For Custom Date
    Range, select the From and To dates, which define the period covered by the statement you want to download.

    • If you download TradeLog format(*.tlf), select and copy entire report to Text Document then save it as TXT file or use orignal TLF format.Your downloaded tlf or txt file must be in this format as shown below:

      In Trademax import wizard, you should select profile InterActive Brokers TLF(*.tlf,*.txt,*.csv) format.
    • If you download Quicken(*.qfx), you should select Profile Name / Open Financial Exchange(*.ofx,*.qfx,*xml).Note: Currently only the US version of Quicken is supported for IB. The US version of Quicken requires all values to be in USD. Regardless of the base currency in which you trade, you must ensure that your base currency for reporting needs is set to USD. To set or change your base currency for reporting, log into Account Management.
      Note that downloads to Quicken (.OFX format) can go back 90 days
    • If you download MS Money(*.ofx), you should select Profile Name / Open Financial Exchange.
  5. If you find the your downloaded file format is different from the above formats, you should set your profile in Profile Wizard.
  6. Run TradeMax and setup an IB account to import trade activity data from local file.

Solution 2

b) Use flex queries function
1. Login to your Interactive Brokers account, Account Management area.
2. In the main menu, click on “Reports”, then “Trade Confirmations”.
3. Click “Create New Flex Query”
4. Name the Query, select text file as export type (TXT), select date range and from the “Available Fields” choose the following: TradeDate, Symbol, Buy/Sell, Price, Quantity, Commission.
5. Save the Query.
6. Run the Query.
7. Copy and paste the text file into Microsoft Excel. File –> Save as –> select “Comma Delimited (CSV)” for Save as Type, choose a name then Save.
8. You can either define your own template with trademax profile wizard function or send us a sample CSV or Xls data file(activity statement) with 8~10 lines of transactions in it for importing, we will build the template for our customer at no extra cost.(in statement choose legacy full->choose period(custom date range)->ms execl)

Download Data From Folio FN


To download data file from FolioFN:

  1. Log into FolioFN trading account.
  2. Go to the Download Center.
  3. Select the desired year of the data and click Download File
  4. Select a date range for your trade history and click Download Now.
  5. Click save button.
  6. Run TradeMax to import trade activity data from local file.

Download Data From Fidelity Investment


To download data file from Fidelity Investment:

  1. Log in your Fidelity Investments account.
  2. Click Accounts & Trade > Portfolio.

  3. Select History from the View Side Bar.
  4. Select the desired Time Period.
  5. Click Display button to view the Trade History.
  6. Click Download button.
  7. Press Save and save the data as csv file.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.
  8.  

    Tradedate
    Action
    Symbol
    Secu
    Securi
    Quan
    Price
    Comm
    Fees
    Accr
    Amount($)
    Settlement Date
    03/21/2009
    Sold
    ACAS
    PUT
    Margin
    -10
    3.05
    15.5
    0.04
    3034.46
    04/01/2009
  9. Run TradeMax to import trade activity data from local file.

 

Download Data From eRegal Securities


To download data file from eRegal Securities:

  1. Log to your trading account.

  2. Click the Account Information then select Activity.

  3. Select Trades from the “Activity Type” drop down box.
  4. Unselect the Current check box and set the time range.
  5. After your Trade History report displays, click Download Data. Your reports should contain the right columns as below:

    Account Type | Trade Date | Settle Date | Exec Time | Trade Number | CUSIP/Symbol | ISIN | Description | Buy/Sell | Qy | Price | Principal Amt | Comm | Other Comm | Net Amount | Curr

  6. Select Delimited text file and Comma delimited and then click the Download now button.

  7. Click the Save button.
  8. Run TradeMax to import trade activity data from local file .

Download Data From Schonfeld Group Holdings LLC


To download data file from Schonfeld Group Holdings LLC:

  1. Go to Schonfeld Group Holdings LLC website and log in to My InfoCenter.
  2. Click Ticket Information<Ticket Activity.
  3. Set a specific time range , then select Account Number.

  4. Click Save Results to File button.

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

Download Data from Goldman Sachs


To download data file from Goldman Sachs:

  1. Log to your Goldman Sachs account.
  2. Select Activity from the Online Reports menu.
  3. Set the report parameters then click the Search button.
  4. Click the Excel icon (just above the Search button).
  5. Click Save button.
  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).

 

Download From Lightspeed


To download data file from Lightspeed:

  1. Log into your Lightspeed trade account.
  2. Click MY ACCOUNT tab > APEX Online,
  3. select Account Information -> Trade Activity from its dropdown menu.
  4. Select Data Range.
  5. Save the file to your desired directory.
  6. Run TradeMax and setup a Lightspeed account to import trade activity data from local file.

Download From OptionsXpress


To download data file from OptionsXpress:

  1. Login your OptionsXpress account.
  2. Click Accounts > Activity.
  3. Select the Period and Type.
  4. Select Comma Delimited (CSV) in the Download File drop down box and then click the GO button.Note: Click on the box “Show Commissions & Regulatory Fees.
  5. Press Save to save the report as csv file.
  6. 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.
    Symbol
    Description
    Action
    Quantity
    Price
    Commission
    Reg Fees
    Date
    TransactionID
    Order Number
    Transaction Type ID
    Total Cost
    MSQ^^^101203C00118000
    MSFT AprWk2 280 Call
    Buy To Open
    10
    8.88
    7
    0.07
    4/2/2010 11:25:28 AM
    199999999
    98888888
    21
    -8887.07

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

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

Download From Penson Financial


To download data file from Penson Financial:

  1. Login your Penson Financial account.

  2. Click Account Information > Trade Activity.

  3. Set specific time range and click Go button.
  4. After your Trade History report displays, your report should contain the right columns as shown below:Account Type | Trade Date | Settle Date | Exec Time | Trade Number | CUSIP/Symbol | ISIN | Description | Buy/Sell | Qy | Price | Principal Amt | Comm | Other Comm | Net Amount | Curr
  5. Click Download Data icon.

  6. Select Delimited text file and Comma delimited and then click the Download now button.
  7. Press Save to save the report as txt file.
  8. Your downloaded TXT 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.

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

  9. Run TradeMax to import trade activity data from local file.
Page 3 of 512345

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