---

Functionality

New “Toolbox and Settings” section.
You’ll now have control over the following:

• Decimals buttons  Easily change the decimal structure for all Price columns, with 1-click. (0-5 decimals).

• Clear All Data No more having to request a new file download when wanting to start over. Amen to that!

• Reset Formulas Have you ever mistakenly erased a formula, or received a #REF error? If you’ve ever deleted a row, you can relate to that. Now, just click a button and have all your formulas reset. You may never need our support again. 

• HFT “High Frequency Trader” mode This mode is for traders who wish to save time in regards to record-keeping.

When this mode is enabled, all (Qty, Price and Time) columns will be locked, allowing the Tab key to skip over those columns. It will also conveniently hide the Scatter Plot graph and specific columns in the blue “Trade Summary” section, which would no longer populate anyway. None of the stats in the Analysis sheet are affected by HFT mode.

• Account Balance section The days of having to ‘Link’ your Broker/Account sheet, or add a formula to your Analysis sheets…are gone. It’s all been simplified! Now, you’ll just go to a designated cell in your Trading Log to enter your beginning Account Balance. The Account Adjustment column is right below it, allowing you to easily adjust your account balance, for (deposits or withdrawals).

Your Trading Log Cumulative Balance and Closed Equity stats will be easily managed, and the ROI figure in your Analysis sheet will always be accurate. A side benefit is that it makes for a cleaner and more useful Broker/Accounts sheet 

• Forex, Gross P&L There is a new drop-down menu in the (Forex Trading Log header) that will allow you to choose your “native” currency. 

Before the “v8”, all prior versions would only calculate Gross P&L for currency pairs that were quoted in USD (xxx/usd). The “v8” no longer discriminates, and will now auto-calculate any Pair that is quoted in your native currency. The choices are: (usd, gbp, cad, aud, chf, jpy, nzd).

• Forex, Currency Pair “Codes” No longer will you need to remember a Number code for the various Pairs you trade, nor will you need to deal with the JPY column. Those columns are gone! Just pick from the new Currency Pair drop-down list… Sweet!

---

Aesthetics

• Equity-curve now has functionality to change the graph background. The default shows the TJS Logo. With six preset backgrounds, there is sure to be one that suits your fancy.

• Home Menu button Did you ever wish the TJS used an actual “home menu” button instead of a button with a home on it? Sleep tight tonight, as your wishes have come true.

• Sort button link in the Exit Date column now has a happy disposition. Gone are the days of just being a lonely text link.

• Hyperlink text remains readable after being clicked. Before this change, Excel would assume you wanted the hyperlink to become small and unreadable. Yea, we’re stumped too.

• Headers, Borders, Buttons Subtle changes have been made to make this the best looking TJS to date.

• Blue! We spent many nights mixing different RGB’s, HSL’s and Hex color formats until we created a hue that’s never been seen before. Cool fact; this new site uses the same blue as the TJS product.

So, while we’re off trademarking our new blue invention, please enjoy the fruits of our labor, which reminds us of a little poem… “Roses are Red, Violets are Blue, along came the TJS, to provide trade analysis for you!”

• Fonts  Consistency is key for the new “v8”. No longer will you find a plethora of fonts adding chaos to your sheets. We tried hard to standardize the look and feel of each sheet the best we could. You can think of the various TJS sheets as a company with a standard (yet, upbeat) dress code.

---

Usability / Efficiency

• Scale In / Out section This is separate from the Scale In / Out sheet. Now, you can quickly enter (up to 5) separate Entries and Exits for each trade. Are you doing the happy dance yet?

• Review Trade column This new column has a “Click” link, which will take you immediately to the Trade Review sheet, displaying the exact trade from the row that you came from. No more using the toggle button to scroll through your trades, unless you want to.

• Personal Data section has increased from (4) “Personal” columns… to (8). Most TJS users will not need all (or any) of these extra columns, but they are there for you just in case. Add any type of data you wish.

• Return Arrow buttons are now numerous and in key locations. Getting back to Column A is now easy peasy, no matter where you’re at in the Trading Log.

• Section Arrow buttons have been created to quickly get you to whatever section you desire. Want to get to your new Toolbox & Settings section?… click a button. How about getting to your Personal data section, or your new Scale In/Out section… click a button.  With the new “v8”, your “scrolling” days are over!

• Paste it We created some magical coding that detects when you’re trying to Copy and Paste data from other cells or other spreadsheets, and then made sure your good intentions won’t compromise the formatting of your TJS. It’s just a safeguard to ensure that we are not the source of any potential frustrations.

---

Fixed it!

• Graph “Spike” issue For some users (variables unknown) the Equity-curve graph would display a spike after using the “Click to add 100 trades” button. Even if you weren’t one of the ‘chosen’ ones, the data-table and coding have been revised to prevent this from happening.

We hope you like the updated Trading Log!