TJS v1 (Debut) - 2011
Like the TJS Pro product version before it, the TJS Elite comes to market as an entirely new product, with new: Features, Functionality, Home Menu, Formatting, Data-Validation, Layout, Aesthetics, Coding, etc.
The TJS Elite continues to evolve; the following is a list of enhancements made to the TJS Elite since its inception.
Scroll down to find your current version, then click the following shaded version links to see what’s new!
TJS version #’s are located near the top-right of the Home Menu sheet, under the word “TJS“
starting July 2011
- Analysis sheet, “Broker Stats” section created.
- Workbook, Created coding allowing TJS to ‘reset’ the file in case the user executed the protection feature.
- Workbook, Created coding allowing users to use file on a 2nd computer.
- Trading Log sheet, Modified SQN formula – prior formula overestimated the quality of the system after 100 trades.
- Trading Log sheet, Added “Equity Calculations” showing Open/Closed equity.
- Candlestick – new sheet, Plot P&L progress based on a candlestick chart.
starting February 2012
- 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.
starting June 2012
- 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.
starting December 2012
- 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.
- 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.
- 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.
- Progress sheet, Deleted images to reduce file size.
- Trading Log sheets, Deleted all unused Rows/Columns to reduce file size.
- 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’.
- 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.
starting May 2013
- 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.
- Trading Log sheet, Minor aesthetic changes to the upper header section.
- SpreadBet Trading Log, Added input instruction for ‘Currency’ traders.
- 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.
- 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).
- 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.
- Trading Log(s), Added formula to auto-calculate the “Day of Week” column in the Tracking Codes section.
- Forex Trading Log, Modified “Net P&L” calculation to include the Rollover Expense column.
- Workbook, Minor vba coding updates.
- Forex Position Sizer, Fixed (micro unit) calculation in the bottom-left ‘Cross-pair’ section.
- Accounts sheet, Reformatted columns resulting in a quicker import when using the TJS Data-transfer function.
- 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.
May 2013, through June 2017
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:
- 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.
- 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).
- 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
- 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.
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.
- Analysis sheets (all), Created a custom filter enabling users to view analysis by either Gross or Net P&L (was only Gross before).
- 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
- 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”.
June 2017 debut
The “v8” update coincided with the new TJS website, which was created to give a better and more intuitive user experience.
We went way over budget on this update with a masterful coder who demands a hefty premium, so if it sounds like we’re begging you to check it out – we’re not… (yea, we are!). Anyhow, we are truly excited about the new TJS Elite “v8”, and hope you will be too.
The “v8” deserves its own page, so… we created one.
>> View the new v8 Updates! <<
President / Developer
Trading Journal Spreadsheet, Corp.
Checkout the new 'v8'>>
September 8, 2017
- Analysis sheets, Deleted “Pie Graph” numbers. Aesthetically, they were cluttering the graph, not always readable, and redundant.
- Futures Analysis sheet, Modified analysis filter. Old filter was, (Gross P&L and Net P&L). New filter is, (POINTS and Net P&L).
- Forex Analysis sheet, Modified filter. Old filter was, (Gross P&L and Net P&L). New filter is, (PIPS and Net P&L).
- Trading Logs. Instructional pop-up comments were revised in row 18, and for the Scale In/Out section.
- Fix – Forex Trading Log, Modified Gross P&L formula so that the calculation would remain blank until an Exit Price was entered. An email was sent out to all affected users. Apologies for this oversight.
- Fix – TJS Importer, Coding needed to be revised for the new “v8” file, which initially passed testing. This won’t affect most users, as the Importer sheet only works for Futures “Ninja Trader” users who purchased this add-on. Apologies for this oversight.
September 25, 2017
- Forex Trading Log, Column B (Currency Code #) is no longer used – it’s gone! So is the JPY column. This process is much more intuitive. Just pick from the new Currency Pair drop-down list and the new formulas and validation will take care of the rest. Click to view an image of the changes.
Thank you to fellow TJS user (and Excel wizard) Trevor Norman for his feedback and assistance with this new functionality!
November 3, 2017
- Home Menu > Data-transfer function has been added, which will import the trade data from a prior “v8” version to a newer “v8” version.
- Fix – Accounts sheet, vba coding was preventing the protection attributes to allow the hyperlink function to work (at the top-right of the sheet). Apologies for this oversight.
- Fix – Trade Review sheet, Compile error may occur for some users if they don’t have (or deleted) the Forex market sheets.
If you are impacted by any of the “fixes” above, please send your file via email (or use the Contact form) and we will fix and return to you asap.
If you prefer updating to a brand new “v8” product file, please visit the TJS Update page — (a nominal $15.99 fee applies to new updated product files).
November 8, 2017
- New sheet! > “Symbols Stats”. This new sheet will show stats for all: Stocks, SpreadBet, and CFD‘s Symbols/Instruments that you trade, and in combination with the type of Strategy that was tagged for each.
November 17, 2017
- Milestones sheet, Added stats: Average # Days and Average # Hours:Minutes in each trade.
Ready to update to "v8"?
* Please know, at this time the “v8” product can only be used by Windows Excel users.
If you have currently registered your TJS with a “Mac” user listing, we will notify you separately when/if the “v8” file is ready for download.