TradeLog™ Update / Download Page

Update History

Assent -  added support to format options in TradeLog long format upon import.

Interactive Brokers - update to brokerConnect so TradeLog makes only one request for data. Fix for server error.

Schwab - updated import filter to better handle Bonds and Preferred stock trades.

Scottrade - added brokerConnect import method.

TradeStation - added brokerConnect import method. Also, the Tradestation Tax Activity report now can get your trade history for the current year as well as last tax year.

Open Positions - added option ticker column.

1099 Reconciliation report - update so options marked to market do not show up under option sales (TradeLog MTM only).

Wash Sales - update so that wash sales do not adjust backwards to previous tax years if trade was closed in previous tax year.

Opening existing files - fix for error when double-clicking to open files that use an underscore character rather than a space after the tax year (ie: 2007_Fidelity_ACCT1.tdf)
 

Fidelity - changed brokerConnect to login from login page rather than Fidelity home page.

Exercised Options - fix for exercised options triggering Change Option Tickers function.

Expire Options - added expire options item to Edit menu.

G&L Report Date Range - updated functionality of from/to date range dialog boxes on G&L report panel so that date ranges can span different tax years.  Allows for fiscal tax years.

Match Tax Lots - fix for certain imports erasing data in matched tax lots column.

Update available - automated setup file download when update is available. Setup file is downloaded and run automatically.

Wash Sales - update so that wash sales do not adjust backwards to previous tax years.
 

TD Ameitrade - updated csv file import filter to use TransID as a time stamp for when trades are reported out of order intra-day making for better trade matching upon import..

Fidelity - update to handle "in lieu of fractional shares" transactions and to better handle options.  Also tweaked the brokerConnect Fidelity login.  Fidelity seems to be going through a series of web site updates which has provided us with a moving target.

optionsXpress - update to handle futures options trades and changed time format in OX API.

Edit, Change Stock Descriptions to Ticker Symbols - added text box so you can change the stock description you are looking for and search again so the correct ticker symbol can be found.
 

Fidelity - another update for brokerConnect to deal with the Fidelity login security measures.

GTT TradeLog - fix for begin year MTM entries for bug that crept into last update which disabled this function.
 

Ameritrade - another update to the csv file import for Dividend Reinvestments and when trades are missing their price.

Fidelity - update to import "In Lieu of Fractional Shares" transactions as buys. Update to brokerConnect so that multiple imports do not cause "Invalid Account" errors.

Interactive Brokers - update to handle commission rebates and cancellation and correction trades. Added support for Bonds, Bills, and TBills.

Add/Insert - update so that clicking outside of the current record being edited cancels the add/insert function and so adding or inserting another record forces a save.

File, Combine - update so files already combined cannot be further combined. Editing of combined files is no longer allowed. All editing must be done in the individual files.

Short Sales - update so all short sales are Short-Term even if held for more than 365 days. Open short sales now get reported on Short-Term section of schedule d-1.
 

Ameritrade - update to allow manual entering of open short and long trades fro the same stock from previous tax year.

Bank of America - update to support Mozilla / Firefox web browsers.

Interactive Brokers - update to brokerConnect so that To date always reverts to Monday through Friday. IB's servers stall if To Date is Saturday or Sunday.
- update to better handle Windows International settings.

Schwab - updated support for Bonds when using web import.

Updating / Renewing - update so when installing latest update TradeLog looks up reg code so user does not have to find it. This will not work if you uninstall TradeLog and reinstall.
 

Fidelity - updated brokerConnect import method to minimize "Invalid Account Number" errors due to updated Fidelity login security measures.

- updated Web import to fix problem with missing first record due to updated HTML formatting of Fidelity online trade history page.

- Fidelity import filter now forces users to change underlying stock description fro option trades to underlying stock ticker so TradeLog can properly calculate wash sales between stocks and options.
 

brokerConnect - added a "To" date to the brokerConnect dialog box so users can now select a custom date range for the import.

Interactive Brokers - updated brokerConnect import filter now handles the new IB login security features.

Negative Shares Error - updated function so error resets properly when making edits.

Wash Sales - fix for bug in ver 7.2008.02.11 where short term trade triggers wash sales on long term trade with loss - change of purchase dates causes problems. Reverted back to previous code.
 

Schwab - fix for csv file not importing trades when date format is single digit month.

optionsXpress - update for properly import of futures using web import.

G&L report - update for running report on Futures trades - report was coming up blank.
- another update for sorting options where expired option trade was skipped due to open option trade before it with the same date.
 

Schwab - updated import filter so options are imported using stock description, expiration month and year, strike price, and put or call, rather than option ticker symbol.  Since Schwab does not report underlying stock ticker symbol, a popup routine will allow users to look up the proper stick ticker symbol after importing.

Broad-Based Index Options - added support for many other index options.  See our Broker Support page for the complete list.

G&L report - open short option trades no longer displayed on report, only open short stock sales. Update for copy to clipboard so sales and purchase dates are reversed for short sales.

Open - Close buttons - update to fix problem when first trade is open causing all the trades to be marked as open.

TXF File export - update to better handle short and long term reporting.

Wash Sales - update to better handle wash sales between stocks and options and options and stocks.  A small tweak in the sort order of similar stocks and options may reduce wash sales deferred to next year.

EIN instead of SSN - added popup box to IRS Schedule D-1 report type alerting users to the fact that the IRS Schedule D-1 is not to be used when filing as a Corporation using an EIN.
 

Fidelity - fixed bug importing QID Proshares where all trades imported as short sales.

Interactive Brokers - update for new TradeLog formatted statements. These new statements are clearer and have the exact same fields for stocks, options, futures, futures options, and currencies.

Penson / Thinkoswim - update to pull in option ticker symbol as well as description.

Writers of Options that Expire - update so all options that were sold (you write an option) and that expire worthless are reported as Short Term on the G&L report for tax filing purposes, even if they were held for more than one year - see IRS publication 550 page 57 for details.

Wash Sales on Replacement Stock - update so that wash sales are not generated on partial sales sold at a loss. (ie: You buy 100 sh and then sell 50 sh at a loss. The 50 shares left open do not trigger a wash sale because they are not replacement shares.)

See: http://www.fairmark.com/capgain/wash/wsreplac.htm

Help Window - Help window now pops up in a smaller window size for users who are using smaller screen resolutions making it easier to move or close the window.

Expire Options - update so only options that have expired in the current tax year get expired.
 

Etrade - fix for certain options imported from trade history not properly formatted.

optionsXpress - update to handle uppercase and lowercase information in OX api which caused some transactions to import with erroneous ticker data.
 

Schwab - fix for options marked as "Buy to Close" importing as "Open, Long"
 

TXF file export - fix for trades with zero cost or sales such as expired options.

Wash Sales - update for wash sales between stocks and options when option contracts are less shares than stock.

Interactive Brokers - fix for YYYYMMDD date convert error with German settings.

Preferred Trade - fix single record not importing.

Tradestation - update to support Firefox and Mozilla web browsers.
 

Gains & Losses report - fix for report labeling Long-Term trades as Short-Term when there are only Long-Term trades fro the current tax year.

Force Match Trades - fixed bug that crept in the 2007.09.08 release that kept Force Match Trades from fully executing.

Neg Share Error - fix so Neg Share Error dialog box only pops up once after generating error.

Expire Options - fix to not expire JAN 2010 Leaps

Schwab - fix for options sales marked as "Sell" rather than "Sell to Open".

Fidelity - another update to filter out unnecessary descriptive information on option trades.
 

Neg Share Error - fixed bug that kept the Neg Share Error dialog box on top of other Windows applications, and not just the TradeLog window.

Reports - Save to PDF - fixed the following bug: hitting the ESC key causes main form to resize to the left and potentially lock up the program.

Fidelity - updated import filter to import options in the TradeLog long-format
(ie: "DELL DEC07 30 CALL").

Tradestation - updated import to fix missing expiration year for options in versions dated 2007.08.15 and onward.
 

Find Grid Filter - NEW Find Grid Filter Dialog allows you to Find trades by filtering by many different combinations such as by Stocks, Options, Futures, Long/Short, Purchases/Sales, Calls/Puts, etc.

Edit, Exercise / Assign - NEW Exercise / Assign function to make all necessary adjustments for option exercises and stock assignments per IRS requirements.

Edit, Adjust for Stock Split - fixed "Cannot change visible in on Show..." error when changing split date.

Edit, Force Match Trades - fix for release dated 08/15/2007 which disabled this function.

Etrade Financial - update to better handle options traded in old BrownCo accounts.

Penson - update to better handle time of day formatting in trade history.

Schwab - update to handle options when not reported as "buy to open", "sell to close", etc.
 

Interactive Brokers - update for brokerConnect™ weekly import to make sure we get all daily statements for each week and to better handle errors.

Ameritrade - fix for 08/15 update where ordinary dividend transactions prevent further transactions from being imported.

Schwab - added support for bonds.

Chart report - fix for running Purchases/Sales chart report multiple times causing different results.

File, Open - fix for time format error when opening older files where time field may not be formatted properly. Past versions allowed improper time formats.

Open Positions - fix for number of year end open positions being reported too high. List of open positions was correct but window status bar was incorrect.
 

International Support of Windows Regional Settings - This is a major new feature so that users in locations outside the US can use whatever Windows Regional settings they like and it will be reflected in the TradeLog P&L and reports.

Date formats like "dd/mm/yyyy" and currency formats like "x.xxx,xx" no longer cause program crashes, and we no longer force the user to select US-English settings for their copy of Windows.   Popular Windows regional options have been tested in both Windows XP and Vista.

Change Stock Description to Ticker Symbol - updated routine to better match stock descriptions - more intuitive lookup.

Green bars - updated green bars which indicate different trade numbers so they are always updated and never get mixed up.

Match Tax Lots - update to better handle matching of multiple trades out of order.

Redo - Added Redo toolbar button so we now have 9 levels of undo which can all be reversed with the Redo button

Broker import filter updates:

Options, Import Filters - new popup dialog box allows users to select a default import method rather than being asked which method to use every time they click the import button.  So if you always import from the web rather than a csv file, you will not be asked this question, thus minimizing keystrokes.

Ameritrade - update to handle dividend re-investments.

FolioFN - update to use QIF import filter.

Goldman Sachs - update to import statements with no time of day column.

Interactive Brokers - all trade amounts and commissions are now converted back to the users IB account base currency. So if an IB user has Euros as their account base currency all calculations will convert to Euros, and all P&L will show as Euros rather than a mixture of US dollars and other foreign currencies.
 

Fidelity - update for new Fidelity Account History format which was causing TradeLog to miss the first trade record on the page (Web Import only - brokerConnect did not have this problem).

File, New - fix for Enter Year End MTM Closing Prices dialog box so that the ticker is clearly identified in the dialog (GTT TradeLog only).
 

Bank of America - added support for options.

Interactive Brokers - fix for getting Jan 2007 monthly statement when we should be requesting Jan 2006 statement. Changed default timeout to 90 seconds from 60 seconds.

Popup Dialog Boxes - All TradeLog popup dialog boxes now center on TradeLog window, not screen center.

Form 4797 report - (GTT TradeLog only) - fix for MTM short trades not displaying.

G&L report - fix for wash sale adjustments on open short sales not displaying (this problem exists in 03/23/2007 update only).
 

Detail report - fix for duplicate entries when trade numbers span two pages.

G&L Report - fix for missing some open short option trades.

Report Headers - update to better handle long Taxpayer name and long TradeLog file names.

File, Combine - fix to handle many files with long filenames.

Section 481 Adjustment report - (GTT TradeLog only) - update so that tax year matches with tax year of file.

Setup File - if user installs TradeLog update while old version of TradeLog is running, setup will not install update until user reboots PC so no error occurs.

Interactive Brokers - update to allow for commission credits on certain trade transactions.  IB just started doing this for certain accounts.

Etrade Financial - updated import filter for annual Excel download file so if Jan trades exist from ending previous tax year, a popup dialog box will ask if you wish to import from February 1 onward.
 

End Tax Year - trapped access violation error when running G&L report after ending the tax year.

IRS Schedule D-1 report - update so totals appear on last page of both short-term and long-term sections.

Preferred Trade - update for new Preferred Trade System software Trade Review panel.
 

GTT TradeLog - updates to all MTM reports so deferred wash sales from previous year are included.

ETrade - update to better handle options when importing from new ETrade Excel csv file.

TradeStation - update to better handle options when importing fro new Tax Activity csv file.
 

Release of Version 7 - many new features for ease of tax reporting.

Expire Options - Jan of next year options now expire in current year data file.

Options, New Folder for Data Files -update to better handle other drives.

Wash Sales - a slight update to better handle wash sales in the minus 30 day time frame so as not to have circular adjustments. NOTE: This could change previous year's wash sale deferrals if you run the G&L report with ver 7 compared to ver 6. Please verify before removing ver 6 completely from your PC.

Assent - fix to allow for negative commissions and -1 share trades.

Bank of America - added support for Firefox web browsers.

CyberTrader/MB Trading/Thinkorswim/Penson - update to filter out for extra EntryDate column.

Interactive Brokers - added support for new IB TradeLog (flex) report for Daily and Monthly statements
*** This new IB report now has a currency conversion factor so that all trades settled in a currency other than your base currency will not convert back to your base currency when calculating P&L in TradeLog.

Etrade Financial - update for new end of year Excel file format.

Excel-Text - update to better support option trades.

Fidelity - update to better handle prices that are rounded to cents.

optionsXpress - added support for futures.

TD Waterhouse - update to filter out Order-I.D.

Tradestation Securities - update to better handle prices that are rounded to cents.
 

Interactive Brokers - added support for CL futures.

Etrade Financial - another update penny stocks for trade history reports - previous update cuased some options to show a negative price.

Open Positions, Year End - fix so that the number of open positions as displayed in the status bar of the open positions window is not overstated by one.
 

Interactive Brokers - fixed problem with brokerConnect not importing Daily statements for Jan of Next Tax Year.

Subscription Expired - fixed problem which erroneously expired TradeLog subscription when trades were entered past Jan 31 of next tax year.

Rave Reports - fixed problem on certain PC multiple screen setups where report preview window hangs on startup. Reports now maximize when run as did previous versions.
 

Fidelity - update for brokerConnect to fix problem with certain stocks importing as options.

Interactive Brokers - added support for HG (copper) futures.

Penson, Cybertrader, ThinkOrSwim - fix for certain stocks importing as options (stocks which have CALL or PUT as part of their description).

Fixed problems with 2006.12.14 update:

End Tax Year - update so wash sale deferrals get moved to next year.

G&L Report - update to fix various bugs in new Rave reports.
- Added Filtered G&L option so user knows that report has been filtered before running.
 

Etrade Financial - update to better handle prices of penny stocks.

Fidelity - update to allow brokerConnect to find csv file with Fidelity web site update.

Interactive Brokers - update to brokerConnect to grab IB data that has been formatted with no line feed characters. IB has been really inconsistent in this with their html reports.

Reports - new Rave Reports replaces the Quick Report writer. This will allow us to develop updated reports in upcoming releases including a schedule d-1 which looks like the IRS form.

G&L Report - removed long-term and short term-check boxes - will now automatically run the short-term report followed by the long-term report.
 

Ameritrade - update for new "buy to open" / "sell to close" option buy/sell codes.

Etrade Financial - update for negative commission amount when ETrade misreports amount as positive when it should be negative. This only happens when trading penny stocks where the commission amount on a sale may be greater than the shares x price amount.

Schwab - update for NEW Export csv file download. Extends the 50 record limitation of the Account History report to 1500 records.

File, Save As - fix so data reloads after saving as.

Performance Report - fix so percent winning shares plus percent losing shares equal 100%.
 

New Look and Feel - updated TradeLog colors for a more muted XP look and feel.
- updated profit bar to include total contracts open as well as shares open and added a total commission field.
- added support for opening TradeLog data files attached to an email which forces users to save to their hard drive before proceeding.

File, New / File, Save As - updated dialog allows you to enter the tax year and file description from one popup dialog box window.
 - enforces standard TradeLog file naming convention.
 - added a Select New Folder option so that you can specify exactly where (what folder) on your PC this new file will be saved.

GTT TradeLog - Fix for "TradeLog is not a valid integer value" error.

Goldman Sachs - update for uppercase buy/sell codes.

Interactive Brokers - fix for brokerConnect getting the wrong report format.
 

Etrade Financial - one more update for new transaction history format to better handle options.
 

Etrade Financial - update for new transaction history format. There seems to be some inconsistencies with this new format regarding options where some options have the underlying stock ticker symbol while others have the stock description.
 

Ameritrade - update for new option buy/sell codes (ex: "bought to open", "sold to close").

Assent LLC - update for when exchange field is blank.

brokerConnect™ import - changed name of API import to brokerConnect™.

Etrade Financial - update for new option buy/sell codes in both transaction history and Excel download file.
 - options now import using TradeLog long form.  ("MICROSOFT CORP JAN07 30 CALL" instead of "MSQAK")
 - Added routine to look up underlying stock ticker symbol (Etrade uses stock descriptions instead of ticker symbols).
   "MICROSOFT CORP JAN07 30 CALL" becomes "MSFT JAN07 30 CALL"

Interactive Brokers - added ZT futures support.
 - brokerConnect import - added code so date for Daily statement moves past Saturday and Sunday.
 

Ameritrade - update to handle stock prices in the thousands and to better handle correction trades.

Assent LLC - update to handle extra spaces in history report.

Interactive Brokers - update to import old style formatted Monthly Statements with columns starting with "Date Time Description" rather than "Symbol Date Time".
- NEW API import - user enters username, password, and account number and TradeLog automatically goes out and gets the Daily or Monthly statement of your choice. One or two mouse clicks updates your data!

Fidelity and optionsXpress API import - added start date and range check boxes so user can get a specific month for importing one month at a time.

GTT TradeLog - File, New - fix for I/O error 103 when MTM and entering open positions from last year.

Wash Sales - update so that wash sale is not triggered by a trade purchased within minus 30 days that also has a loss which was moved forward.
 

BrownCo / ETrade Financial - update to ETrade import filter to better handle old BrownCo accounts. Update affects both web and Excel imports.

Interactive Brokers - update to better handle accounts with base currency other than US dollars and for better handling of Canadian stocks when base currency is USD.  Added support for single stock futures from Yearly statements.

optionsXpress - update to fix API import hanging problem when importing buy to cover transactions.

Schwab - update to better handle short sales and buys to cover when out of order intra-day. Does not renumber existing trades.

Range button - Summary and G&L Reports are now disabled when main grid is filtered by date range. These reports were never meant to have a date range applied before running which has created some confusion on the part of our users.

G&L Report - fix for total wash sale deferral amount being overstated when wash sales were deferred from previous years and attached to open positions at the end of the current tax year.  (Even though the total amount deferred on the G&L report was wrong, the File End Tax Year procedure properly deferred the right amount.)
 - Fix for missing stocks in list of stocks with wash sale attached to open positions. (ie: stocks such as X when other open wash sales attached to stocks such as PRX).

Edit, Adjust for Stock Split - update to better handle commissions when splitting up a transaction into per-split and post-split chares. (ie: 100 shares open going into split when 200 shares were purchased pre-split and 100 shares were sold pre-split - commission on 200 shares now divided up among the two new transactions after adjusting for split.

Internet Explorer 7 - fixed "cannot find resource" error upon setup when IE7 Beta is installed.
 

Fidelity - Limited date range for API import to one month because Fidelity server times out when getting large amounts of data.
 - added secondary option to import from web reports in addition to API.

optionsXpress  - added secondary option to import from web reports in addition to API.

Scottrade - fix for options with pound sign after ticker symbol importing as stocks.
 

Price Open Positions - update for open options and to speed up process.

TXF file export - update for open short sales.

Import from web - fix for File I/O error.
 

optionsXpress - update to import various straddle and spread trades.

File, Open - fix for access violation error when double-clicking on file to open file.
 

Ameritrade - update for web import using FireFox and Mozilla web browsers.

Excel-Text - update to support "Purchase" buy code.

Fidelity - new API import - allows one click import of Fidelity csv file.  Replaces OFX import.

optionsXpress - new API import - allows one click import of trade history.

Wash Sales - update to better handle the minus 30 day window and more conservative handing of short close positions. See our Product Features page under Wash Sales for details.

Year End Open Positions - another update for trades with partial open positions.

Change Option Ticker - update to better handle getting the proper expiration year.
 

Fidelity - fix for occasional system crash when importing using OFX.

FolioFN - update to filter out money market (sweep) transactions.

Interactive Brokers - another update for importing from 2003 yearly statements where two dashes replace 1099 reported number column.

Tradestation - update for importing from web when trades for the same date span multiple pages.

Change Option Ticker - update for options 4 character symbols.

Editing - updated functionality
 - Delete key now works in edit mode.
 - Notes can easily be deleted using the delete key without having to enter a space character.
 - Selected cell is now ready to edit without having to click on the cell after running the Edit Single Record function.

Edit, Paste - records pasted now include notes field. (Providing you copied the records with the notes field displayed.

Notes - Display Notes option now saved on program exit, so when you run TradeLog again the notes field is displayed.

Support Window - added Print button.

Year End Open Positions - update for unusual buy/sell combinations on open trades causing number of shares on year end open positions to be a little off.
  

Goldman Sachs - official release importing from downloadable csv file.

Scottrade - update for new csv file format with interest column.
  

ETrade Financial - update to handle fractional shares.

Interactive Brokers - update for importing 2003 Yearly Statement.
- update to better  handle foreign stocks and foreign currency futures.

optionsXpress - fix for Firefox when commission and fees check box not checked.

Delete selected records - fix deleting multiple non-contiguous trades when grid is filtered.

Change Option Tickers - added option to not verify each option symbol.
 

Change Option Tickers - update to only change if needed. Does not popup for brokers who already have provided full option descriptions.

Trade Matching - fix for trade match problem on certain option trades.

G&L report - fix for some options and futures showing as open due to new sorting on ticker field.
 

Interactive Brokers - update to handle for currency futures in yearly statement.
 - fix for problems importing currency futures and single stock futures

File, Combine - fix for error when combining files with no import filter selected.
 

Release of Version 6 - Many new features added for better handling of options and futures. Many other updates summarized below:

Bank of America - update to handle short sales

BrownCo - update for importing Brown trades from ETrade Financial website.

ETrade Financial - update for csv file trades out of order.

ETrade Pro - another update for new format.

Interactive Brokers - update for Canadian stocks to show in USD.

Investrade - update for importing from Penson. (use Penson import filter)

Open E Cry - added support for this Futures broker.

optionsXpress - update for handling Leaps.

G&L report - update for tickers with wash sales attached top open positions erroneously showing on long term G&L report.

GTT TradeLog - update for Year End MTM - fixed problem with Edit causing neg share error on short trades.

Year End Open Positions - fixed occasional problem with missing opens.

tmp files - update to delete miscellaneous temp files created from filters.