Forex Blog

First-hand Forex trading experience and information about foreign exchange market that will be useful to traders


Organize Your Forex Trading with Trade Journal

May 18, 2009 (Last updated on June 18, 2020) by

One of the most obvious and easy ways to improve your trading results and organize the whole Forex trading process is to use a trade journal to log every trade that you make. It’s an almost unknown fact among Forex beginners, but even some experienced traders still trade without such journal. Of, course some trading styles or types of psychological characters of the traders aren’t compatible with keeping a journal, but 99% of traders may still benefit from this simple and completely free tool.

I suggest logging every trade you make in a special trade journal. It can be an Excel (or OpenOffice Calc) table or a printed table, or anything else you may find usable for logging your trades. By maintaining a journal you’ll be able to see which trades were successful and which weren’t any why. You’ll be able to improve your trading system and see your repeating mistakes. While many trading platforms (e.g. MT4) have account activity reporting feature that is useful to know your total profit/loss for the period, they don’t offer a functionality of a real trade journal.

Here is the example of a trade journal that I keep. It’s created as a Microsoft Excel table, which allows some calculation automation:

Trade Journal

As you see there are 15 columns that I feel are required for a good trade journal:

  1. # — index number of a trade. It can be either cross-journal or start anew each month. Whatever is more appealing to your trading style.
  2. Date Open — date when the trade was opened. If you scalp or trade extremely short-term you may also log time when the trade was opened.
  3. Strategy — here you can log the strategy/signal that was used for this trade entry. Only useful if you employ several strategies or signal services simultaneously.
  4. Pair — currency pair of the trade. Quite obvious.
  5. Direction — short or long.
  6. Entry Price — initial rate at which the position was opened.
  7. Initial Stop — stop-loss level that you’ve set when the trade was entered.
  8. Initial Target — take-profit level that you’ve set when the trade was entered.
  9. IRR — initial reward/risk ratio. Take-profit in pips divided by the stop-loss in pips. Your Excel/Calc table can calculate this ratio automatically.
  10. Exit — rate, where your position was actually closed.
  11. Date Closed — date when the trade was exited. Scalpers can also log the closing time.
  12. Profit/Loss, Pips — profit or loss in pips. Your Excel/Calc table can calculate it automatically.
  13. Profit/Loss, % — profit or loss in percent to the initial account balance. Logging absolute values (e.g. $120.00 profit) isn’t recommended because doesn’t tell anyone anything about the riskiness or profitability of the trade.
  14. Length — length of the trade’s life. In days for normal traders and in hours, minutes or even seconds for scalpers.
  15. Comment — don’t be too lazy and comment your trades to understand why have you failed or succeeded in a given moment of your trader’s career.

Of course, other columns can be added for even greater logging informativeness but for me those are enough. If you have any questions, comments or recommendations regarding trade journals, please, feel free to reply below.

Update: Some traders asked me to share my trading journal table, so that they could use it to create their own trade journals. Here it is — download trade journal Excel table.

Updated 2: One year has passed and I’ve made a major update to a trade journal. Please, read more about it here: Advanced Forex Trade Journal.

Update 2020-06-18: Please use our updated Trading Journal 3.0.

4 Responses to “Organize Your Forex Trading with Trade Journal”

  1. Chris

    is this journal available for download or is this just a illustration of what is needed?


    Andrei Reply:

    It’s just an illustration or more exactly an example of a trade journal. What’s the point in downloading a simple Excell table, when every trader definitely needs some own modification to such table?


  2. K.C.

    Thx for info.
    I’m about to metaphorically get my trading-feet wet and would like to subscribe to your site but do not see where one may register; please shall you indicate where I do that?
    I thank you in advance for your contemplated assistance.


    admin Reply:

    I am not sure what do you mean by subscribing to our site, but you have several options:

    1. You can subscribe to this blog’s feed –

    2. You can subscribe for our monthly newsletter –

    3. And you can join our Forum –


Leave a Reply

required (will not be published)