The Smart Trade Tracker is an Excel spreadsheet that is made up of a range of worksheets that are designed to track your trading so that you can see at a glance your funds available, portfolio heat, where your current stop losses are, open and closed trade information and most importantly, it will evaluate your trading.
Below is an outline of the worksheets that make-up the Smart Trade Tracker. If you would like to view a particular worksheet, click on the worksheet name and an example worksheet image will appear.
This worksheet forms the basis of your capital allocation and tracks your available capital and margin based on different systems (or indices if you prefer), as well as keeping you up to date on your portfolio heat, number of open trades, profits, etc.
The Smart Trade Tracker is set up so that you have one detailed worksheet dedicated to each trade that you open and it tracks all the information for that trade – position sizing, percentage risk, stop losses, GSLOs (guaranteed stop loss orders), pyramid points, etc. Information can be shown in one currency or two currencies, if it is an overseas trade.
Blank trading worksheets are provided so that you can select the one that relates to the trade you are undertaking and copy it. Worksheets are available for long and short trades, catering for share, CFD and Forex instruments.
To help you understand how to complete a worksheet for the different types of trades, example trades are included with the original Spreadsheet for your review.
This worksheet tracks all your trades in a summary format so that you can see all your trades at a glance on one worksheet. Each trade you have opened will have its own row which will track all the information for that trade – current stops, profit based on stops, portfolio heat, status of the trade (open or closed), profit gain or loss per dollar invested, trade hold time, return, etc. As new trades are opened you will be required to manually add a new row to the “Summary” worksheet using the simple cut/paste and replace feature of Excel.
One of the key highlights of the Smart Trade Tracker is that it has its own evaluation page to enable you to track your specific performance in the market. Not only does it evaluate your total trading performance, it also allows you to evaluate a particular system and other scenarios. For example, you can evaluate your weekly trading system separately from your daily trading system, or your Forex trading separately from your CFD trading, or your long direction trades from your short trades.
The Evaluation Worksheet updates itself as you make changes to your trades. It analyses your profitability, reliability, win to loss statistics, expectancy and time in the market and much more. You can see at a quick glance how you are performing in the current market conditions and also analyse an individual trading system.
This worksheet provides a range of different calculators for you to use before you open a trade and any time throughout the trade – position sizing calculators, resistance and support profit potential calculators, brokerage and GSLO cost calculators, margin calculator and a dividend calculator.
Equity Curve Worksheet
An equity curve is a visual representation of your trading performance which is charted to form an equity curve which rises and falls as your trading performance changes.
This worksheet is optional and is available if you would like to plot your Total Reduced Equity figure at the end of each month and see how your trading equity changes over the financial year.