Custom Trading Journal
This multi-sheet trading journal has been carefully designed to track all the most important statistics you need to improve your trading.
Through one line of spreadsheet inputs for each of your trades and a detailed backend of automatic formulas, this Custom Journal will present you with actionable information about every aspect of your trading performance.
All the data and statistics taken from your trades are displayed through colorful, organized, and labeled tables & charts, so learning from your trades is both easy and convenient.
The journal is incredibly user-friendly and will require zero setup before use. The only inputs necessary are the data points for each of your trades outlined in the first spreadsheet.
The trade entry section of the journal includes pop-down windows displaying the relevant options so you can quickly choose the appropriate answer. All other entries needed will be manual entries and abundantly clear.
The Purpose of this Journal
The purpose of this journal outside of being a record for all of your trades is to find your statistical edges and shortcomings.
With such a deep statistical insight into all of your trades, you can fully optimize your strategies to lean into exactly what works and rid your strategies of exactly what doesn't.
Let the numbers do all the hard work, and let your trading journal provide you with a statistical edge in the market that separates you from the crowd.
Sheets Included:
Journal Entry Sheet
This is the data input page that everything in the journal uses to function. This includes things like trade entry and exit date, asset name, order type, confluences, chart pattern, mistake, PnL, et cetera.
With all this information added for each of your trades, the formulas will automatically provide you with all the averages, win rates, expectancies, and everything else it tracks.
The journal page also keeps a running ledger of equity statistics after each trade, including the equity value after each trade, the equity percentage gain for each trade, and your cumulative equity gain after each trade.
General Statistics Sheet
Cheat Sheet:
STARTING ACCOUNT VALUE
CURRENT ACCOUNT VALUE
TOTAL PROFIT
TOTAL RETURN
WIN RATE
LOSS RATE
RISK TO REWARD
TOTAL # OF TRADES
TOTAL WINS
TOTAL LOSSES
TOTAL B/E
AVERAGE TRADE
AVERAGE WIN
AVERAGE LOSS
EXPECTENCY
AVERAGE %
AVERAGE WINNING %
AVERAGE LOSING %
% EXPECTENCY
Equity Statistics:
PEAK VALUE
LOWEST VALUE
MAX % DRAWDOWN
MAX $ DRAWDOWN
LARGEST CONSECUTIVE % LOSS
LARGEST CONSECUTIVE $ LOSS
Advanced Statistics:
STANDARD DEVIATION
RISK-FREE RATE
SHARPE RATIO
Performance Statistics On:
BEST AND WORST TRADES
SPECIFIC ASSETS
LEVEL OF CONVICTION
SPECIFIC MISTAKES
LONG VS SHORT
POSITION SIZE
VIX LEVELS
Entry/Exit Statistics Sheet
Tracks Performance On:
6 DIFFERENT ENTRY SETUPS
SPECIFIC CHART PATTERNS
SPECIFIC CANDLE PATTERNS
ORDER TYPE
EXIT TYPE
SPECIFIC CONFLUENCES
SPECIFIC TIMEFRAMES
Time Statistics Sheet
Includes Data On the Following:
PNL TABLE & CHART FOR EACH DAY OF THE MONTH
# OF TRADES FOR EACH DAY OF THE MONTH
TRADE ENTRY TIME PERFORMANCE
TRADE EXIT TIME PERFORMANCE
SPECIFIC DAY OF THE WEEK PERFORMANCE
AVERAGE WIN/LOSS/OVERALL TRADE DURATIONS
Entry Setup Sheets
In addition to tracking all the above statistics on your overall performance, there are SIX separate sheets for tracking statistics on individual entry setups that all include their own CHEAT SHEET (as seen in the General Statistics sheet) as well as performance statistics on the following:
SPECIFIC ASSETS
SPECIFIC CHART PATTERNS
LONG VS SHORT
SPECIFIC TIMEFRAMES
SPECIFIC MISTAKES
SPECIFIC CONFLUENCES
ORDER TYPE
SPECIFIC DAY OF THE WEEK
VIX LEVELS