There are lots of free spreadsheet journals already available online and there are quite a few professional
logging solutions. However, there are lots of reasons to prefer the simplicity and versatility of an Excel spreadsheet. Meanwhile, its customizability means that the journal only calculates and shows the stuff that you need the most.
The resulting trading journal unites approaches to logging three different
columns can be hidden if they aren’t needed) while also providing an
analysis of the trades. The only serious disadvantage such a journal has is slow performance because Excel, albeit a great software, does lots of unnecessary calculations each time you change something in a spreadsheet.
Here are some of the features of the trading journal that you can download further below:
sheet with some basic information (you can safely delete it after reading).
- ACurrency Pairs
sheet that serves to put in your currency pair settings for quick referencing and for decimal place counts. You can ignore it, but then you won’t be able to benefit from decimal places formatting; also you won’t be able to just enter a small number instead of typing in the entire currency pair name each time.
- The number of pips for profit and loss is calculated automatically.
column that can also be used to record rebates if you receive them from your broker.
column to record the swaps you pay or get from the broker.
sheet to provide detailed analysis of your trading performance.
- Scalpers and intraday traders wouldn’t probably need some of the columns (Close date
for example) but they would maybe want to track the trade length.
- You can hide
fields completely and just enter pip and $ gains/losses manually if they are more relevant to your strategy than exact price levels.
- Only first 1,000 rows are filled with formulas. If you hit the limit, just copy and paste formulas from the final row as far down as you need. However, the more filled rows you have, the slower the journal will work. It is recommended to create a new trading journal file for each new year (or for each new month if you are scalping).
Explaining the columns
Let’s look at the example journal that has been filled with some random trades.
The first columns include: a
(clear it when logging
(you can change it to time if it is more relevant to your trading strategy),
(the reason for entry),
number of the currency pair
(you define it via theCurrency Pairs
currency pair name
(you can enter it manually or have it filled automatically after you fill the currency pair number),
(the choice of Long/Short).
Then follow the
parameters of the trade:
(you can enter it in lots or in units, or you can just hide the column if you don’t want to recored this parameter),
After that, you notice the columns that mostly involve the
profit/loss in pips
(calculated automatically based on the difference between the entry and exit price, and the decimal places defined in theCurrency Pairs
profit/loss in %
(calculated automatically using the currency profit you enter and your previous account balance),
profit/loss in USD
(you can change the currency name to whatever you use),
(it can be either
or the number of days between the entry and the exit).
The final columns of the trading journal include:
(what you had thought about the trade when you just opened it),
(what you think about the trade after closing it),
(you can insert a link to a local file on your computer, or a URL to some website where you store your trading screenshots, or you can hide this column entirely).
Currency Pairs sheet
This is where you define your currency pairs with a quick reference number and a number of decimal places. There are two number fields but the second one is filled automatically when you enter something in the first one. The second column is required for technical reasons:
sheet becomes the most interesting one after you log some trades. It lets you analyze your performance using a number of metrics and charts.
First, come the various basic metrics (totals) and the ratios/indices:
(shows your total net profit, which is probably the most important result to look at),
(for a total number of trades),
(total swap for all trades),
(total commission paid for all trades),
(number wins divided by the total number of trades),
(return on investment — how much you would increase/decrease a starting balance in percentage term),
(how much you can expect to earn/lose from one trade on average),
(how much your winning trades are bigger than your losing trades),
(the volatility of your returns),
(how your ROI compares to the volatility of your returns),
(how much negative volatility is in your returns).
Then follow the metrics of averages:
profit/loss per trade,
The table ends with the columns that show the metrics of the “maximum” parameters of your strategy:
(longest sequence of uninterrupted profitable trades), losing streak (longest sequence of uninterrupted losing trades),
(how much your balance declined below its starting point),
The Analysis sheet also features two charts:
Profit/loss per Trade
Total Accumulated Profit/Loss
You can download either a
template journal spreadsheet (you can replace trades with your own or clear unnecessary rows) or an empty spreadsheet (only initial balance transaction is logged). To clear the rows, it is advised to use advanced selection (F5->Special…->Constants). If the journal is empty, an occasional
“Excel found a problem with one or more formula references in this worksheet.”
error may pop up — you may ignore it; it should disappear once you fill in some trades.
Download Forex Trading Journal 3.0
with example trades
Download an empty Forex Trading Journal 3.0
Enable iterative calculations via
File->Options->Formulas. Otherwise, you won’t able to reference currency pairs
by their name and number. You can set the maximum iterations value to 1:
If you have any suggestions or if you find any bugs in this Forex trading journal spreadsheet, please report them on our forum.
If you want to get news of the most recent updates to our guides or anything else related to Forex trading, you can subscribe to our monthly newsletter.
Forex trading bears intrinsic risks of loss. You must understand that Forex trading, while potentially profitable, can make you lose your money. Never trade with the money that you cannot afford to lose! Trading with leverage can wipe your account even faster.
CFDs are leveraged products and as such loses may be more than the initial invested capital. Trading in CFDs carry a high level of risk thus may not be appropriate for all investors.
Forex Trading Journal Excel Template Download
Posted by: derivbinary.com