The Trading Journal Spreadsheet began in 2005 as a way to track my own personal trading progress.By early 2007, I had shared what I created with a handful of other trading cohorts. They all loved it, and more importantly, they benefited from the analysis it provided, and were adamant that it should be available to other aspiring traders. Free Excel Trading Log. This fantastically simple trading log was designed to get used, just enter the ticker / currency pair and pips won/lost and the rest is done for you. It automatically calculates your required breakeven risk reward (RR) based on your win ratio. This is great for setting stops / take profit levels at a glance.

A trading journal is a trading book you write about your own journey, system, risk management and lessons learned. It helps you clearly see your past mistakes so you don’t repeat them in the future. Your edge as a trader is the advantage you have over other traders with your system, psychology, risk management, or trade management that creates your profits from other’s losses.

Free Trading Log Spreadsheet I think we all know that using a trading log for our trading activities is pretty vital to ensure we are moving forward in our trading profits. Sometimes we are so tuned into simply learning a system we forget that we have real money on the line. Looking for a Trading Journal Spreadsheet? Upgrade from the old way of journaling your trades on Excel, xlsx, spreadsheet or Google Sheet. TRY IT FREE FOR 7 DAYS.

Keeping an up to date trading journal makes you put your feelings, thoughts, mistakes, risk management issues along with emotional and ego problems on paper. Writing helps clarify your thoughts, identify your errors, and become mindful of the emotions that lead to trading errors.

Having a great trading plan and following that plan consistently are different things. The major causes of being and unprofitable trader are having no edge, mental mistakes, bad risk management or all of the above. A trading journal can document your mistakes and quantify where you are going wrong.

Free Options Trading Journal Spreadsheet

With the data and patterns you see from a detailed trading journal you can see both when you were disciplined and when you failed to follow your plan and why. The goal of good trading is not to make money every time but to follow your own trading systems, entries, exits, and position sizing with discipline every time. If you have a system with a edge and follow your process you will make money over time in the markets. You will lose money over the long term if you have no edge or if you have one but not the discipline to implement it.

How exactly you keep your trading journal is not as important as whether you do or not. A trading journal can be a notebook, on a spreadsheet, or using advanced software, however you like doing it.

Your trading journal should document the following things.

Before you start to trade:

1. Your return expectations for your effort.
2. Your risk tolerance for individual trading losses and total account drawdown limits.
3. Quantify your statistical risk of ruin.
4. What are the long term backtested results of the signals you will be using through multiple market environments?
5. Your watchlist that meets your filter parameters.
6. Are all the items on your watchlist liquid enough to trade with little slippage in the bid/ask spread?
7. The quantified principles of your profitable trading system.
8. The quantified entries and exit signals you will be following.
9. Your position sizing parameters based on volatility.
10. The rules for total risk exposure and correlation limits.

Here are ideas for what to document during each trade, take what is useful to you as you zero in on your own errors.

Trading Journal Spreadsheet Free

1. Document your chart at entry.
2. Your entries and why you chose to enter at that price.
3. How do you feel on entry? What are your expectations?
4. Your position sizing and why.
5. Your initial stop loss plan if the trade moves too far against you.
6. Your profit target expectation and why.
7. How you plan to trail your stop loss.
8. What is your risk/reward ratio based on your entry level versus your profit target.
9. Document your chart after you exit.
10. How did you feel on the exit?
11. What errors of execution did you commit if any?
12. What would you have done differently to minimize the size of a losing trade?
13. What would you have done differently to maximize the size of a winning trade?
14. Do you have any regrets?
15. What were your thoughts during each stage of the trade?
16. Did you have faith in yourself to follow your plan?
17. Did you have faith in your signals to make money over the long term?
18. Are you mentally comfortable trading this timeframe?
19. Are you comfortable with your trading system?
20. What was your stress level during each step of the trade?
21. Does your trading system fit your own beliefs about the markets?

Forex Trading Journal Spreadsheet Free Download

Here is an example of a free trading journal template in Microsoft Excel: Trade Journal.zipSource