• Trading Log sheet, Created “Sort by Exit Date” function/link.

• Trading Log sheet, Created macro to Hide/Unhide MAE-MFE-BSO columns.

• Tracking sheet, Linked each Performance-tracking category heading to the corresponding column headers in the Trading Log sheet.

• Trading Log sheet, Created button/code to automatically insert 100 new trading log rows.

• Home Menu, Created functionality to automatically import trade information from an older Elite file, to an updated Elite file.

• Calendar – new sheet,   Enter important trading events coming up for the current month.

• Trading Log sheet,   All “Identifier” columns are now fixed. Now easy to match column data to the far-right with their corresponding trade information.

• Workbook,   Pop-up comment revisions.

• Trading Log,   Created custom Filters for the Equity-curve graph. No longer just a cumulative equity-curve, but now users can view their ‘curve’ by filtering out specific Performance-tracking codes.

• TJS Importer – new sheet,   Add-on functionality for “Ninja Traders” (does not work with most other broker export files).

• Trading Log sheet,   Changed file-protect attributes, allowing users to modify column widths, and insert hyperlinks without having to unprotect the sheet.

• Workbook,   Modified coding to fix “error on close” when other spreadsheets were open at the same time.

• Accounts sheet,   Created a “Link-to” drow-down arrow, allowing users to link a specific account balance to one of the Analysis sheet headers.

• Trading Log and Analysis sheets,   Made all pertinent cells (shrink to fit) to overcome the various screen resolution settings on users systems.

v5.2

• Analysis sheet,   Created button/code to ‘unlink’ the Account Capital to the Accounts sheet.

• Trading Log sheet,   Created “Return to Column A” button. Now quick & easy to return to the left side of the Trading Log.

• Forex Trading Log sheet,   Added text link for “Trade Input” help.

v5.3

• Home Menu,   Added product version #, which previously was only in the file name.

• Trading Log sheet,   Created “Mentor” button. Now all users can send a copy of their Trading Log sheet to a mentor/coach/partner, etc.

• Analysis sheet,   Created “Mentor” button. Now all users can send a copy of their Analysis sheet to a mentor/coach/partner, etc.

v5.31 – v5.33

• Forex: Trading Log sheet,   Revised all MAE/MFE calculations to 5-decimals.

v5.4

• Progress sheet,   Deleted images to reduce file size.

• Trading Log sheets,   Deleted all unused Rows/Columns to reduce file size.

v5.5

• Futures Analysis sheet,   Replaced “Trade Category” with “Time of Day”.

• Expectancy sheet,   Revised instructional comments.

• Scale In/Out sheet,   Changed decimal formats and made all cells ‘shrink-to-fit’.

v5.6

• Analysis sheets,   Created button (coding) to Show/Hide all supporting data.

• Options Trading Log sheet,   Created coding and new section, giving ability to change contract sizes for specific trades (Standard or Mini contracts, etc).

• Futures Position Sizer,   Created functionality for Stop-loss pricing increments.

• Workbook,   Lots of instuctional pop-up comment edits.

v6.1

• Futures Position Sizer sheet,   Re-coded the 2/4-decimal macro.
• Workbook,   Made it possible to save the file as ‘binary’ with the (.xlsb) extension, which significantly lessens the file size.

v6.2

• Trading Log sheet,   Minor aesthetic changes to the upper header section.
• SpreadBet Trading Log,   Added input instruction for ‘Currency’ traders.

v6.3b

• Workbook,   Changed file name extension to (.xlsb) format to significantly lessen the file size.
• Workbook,   Revised coding for better compatibility with Excel 2013/365.
• Analysis sheets (all),   Revised formatting in “Error Recognition” P&L column. – now displays both Positive & Negative amounts.

v6.3.1b

• TJS Importer,   (Add-on sheet). Added default entry text when Forex Trading Log is chosen. Modified the Futures Trading Log default entry (Exit Date was displayed as Entry Date).

v6.4b

• Workbook,   Modified vba coding for Mac users. The “Save-As” function, as well as TJS‘s “Sort by Exit Date” functionality should work now.
• Futures Analysis sheet,   Linked the “Futures Symbols” header text to the TJS website Contract Size page.
• Workbook,   Pop-up (instructional) comment changes and additions.

v6.4.1b

• Trading Log(s),   Added formula to auto-calculate the “Day of Week” column in the Tracking Codes section.

v6.4.2b

• Forex Trading Log,   Modified “Net P&L” calculation to include the Rollover Expense column.

v6.4.3b

• Workbook,   Minor vba coding updates.

v6.4.4b

• Forex Position Sizer,   Fixed (micro unit) calculation in the bottom-left ‘Cross-pair’ section.

v6.4.5b

• Accounts sheet,  Reformatted columns resulting in a quicker import when using the TJS Data-transfer function.

v6.4.6b

• Trading Log,   Fixed the “Sort by Exit Date” link, as all links were pointing to the Stocks Trading Log, regardless of which Trading Log was being used.

> Please feel free to contact us for a quick instructional fix or a manual work-a-round for v6.4.6b.

The “v7” is a significant update taking more than 5-months to complete and nearly $4k in developer coding costs. Thus, all “v7” update requests will incur a nominal $39.99 charge to help cover our time and expense to make this update a reality.

There are too many modifications to list, as a fine-toothed comb and many days were spent refining the small details (comments, formatting, formulas, coding, etc,.). Here’s a list of the major changes along with the more visual modifications:

Trading Log(s):

• Modified the top-header section to incorporate linked buttons instead of text links.

• Formulated the “Day of Week” Tracking column to auto-populate after an Entry Date is entered. If “Day of Week” is not listed as a ‘Tracking’ category, the formula will not display anything.

• Changed P&L bar color (now a neutral ‘blue’), and other aesthetic modifications.

• Made all “Date” columns Shrink-to-fit.

• Options Trading Log,   New Risk Amount formula to better work in conjunction with the new Contract Size formulas.

Analysis sheets:

• Month / Year filters. Now, all performance-tracking analysis can be filtered to display specific Months (and/or) Years or All cumulative trades.

• Changed P&L bar color. Now is a neutral blue instead of green, which was confusing when looking at negative analysis figures.

• Show/Hide buttons for displaying hidden reference cells.

• Modified the top-header section to incorporate linked buttons instead of text links.

• New identification area to show which Analysis sheet the user is on.

Trade Summary (New sheet)!!!:

• Summarizes all pertinent trade info on one sheet, automatically.

• Print parameters are preset to print each trade outcome on one organized sheet.

• Also displays any hyperlinked image (from the Symbol column in the Trading Log).

Home Menu:

• Added buttons to Expand/Collapse the center of the menu (making the menu easier to view).

• Reconfigured the order of a couple of sections.

• Deleted the Toolbox link in favor of the TJS Support page.

Forex PosSizer sheet:

• Modified “Micro Lot” formulas.

• Added “Units” calculations.

v7.1 – v7.4

Feb, 2014

• CFD Trading Log,   Cells (B19 – B20) were mistakenly ‘protected’ preventing users from clicking them without ‘unprotecting’ the sheet.

• Home Menu,   Code change for the Data-transfer function. The code will now detect when a user has deleted a sheet.

• Options Trading Log,   Resized the data table for “Sort” button functionality when user manually changed the Contract Size multiplier. 

v7.5.x

June – Sep, 2014

• Progress Chart,   Modified code for Mac users who got error message (Mac vba issue).

• Futures Trading Log,   Added “Total # Points” calculation at the bottom of the table.

• Forex Trading Log,   Added “Total # PIPs” calculation at the bottom of the table.

• Trading Logs (all),   Added five additional columns for ‘user’ to customize their own columns.

• Trading Logs (all),   Revised “Risk Amount” formula in header to be dynamic (always current based on Closed Equity).

• Progress Chart,   Modified vba code to be compatible with expanded data table.

v7.6

Oct. 2014

• Analysis sheets (all),   Created a custom filter enabling users to view analysis by either Gross or Net P&L (was only Gross before).

v7.7

May, 2015

• Progress Chart,   Enlarged chart area.

• Scale In/Out,   Modified aesthetics (colors and formats, etc.).  Revised instructions.

• Options Trading Log,   Modified “Expiry” column formula – will no longer read “Expired” on the same day of Expiry (it will read “0”).

• Options Analysis sheet,   Deleted ‘numbers’ in the Codes column in the “Trading Indicator” section, which affected the display of the Ultimate Trade Analyzer in some situations.

v7.8 – v7.8.4

Sep. 2015

• Analysis sheets (all),   Modified aesthetics in top Header. Created new buttons for “Hide/Unhide” of hidden reference cells.

• Trading Logs,   Added capability to adjust “Closed Equity” to coincide with Accounts sheet ledger (when adding Deposits or Withdrawals) – view the CT column.

Mar 28. 2016

• Trading Logs,   Data-validated and Pop-up comment revisions. Minor formula revision in “Closed Equity” column.

• Analysis sheets (all),   Comment revisions to: (Expectancy, Entry Strategy, Reversal Times).

May 19. 2016

• Workbook,   Minor aesthetic, comments and data-validated message modifications. All Pricing cells are now “shrink-to-fit”.

New to v8? Click here! >>Click to close, then view the 'v8' changelog below

---

Current v8 user? Click here to view the Changelog >>Close v8 changelog