## Free Excel trading log template

This is a discussion on Free Excel trading log template within the Trading Journals forums, part of the Reception category; I've put this trading log together in excel - thought some of you might find it useful. Take a look ...

Dec 8, 2010, 11:01am   #1
Joined Dec 2010
Free Excel trading log template

I've put this trading log together in excel - thought some of you might find it useful. Take a look at the accompanying word file as there's a couple of loose ends. Hopefully it will develop and be re-posted from time to time. Rogh

***** T2W Edit *****
At the request of Rogh, the first version of the template referred to above has been removed - as there is a more up to date version - please scroll down!
Attached Files
 Explanation of Rogh log v1.doc (66.0 KB, 12194 views)

Last edited by timsk; Mar 7, 2011 at 11:37am. Reason: Added edit at OP's request

 The following members like this post: timsk
Mar 4, 2011, 12:03pm   #2
Joined Dec 2010
Re: Free Excel trading log template (V3)

Here's the latest version of a free excel tool I developed to analyze each trade’s risk factors, in the form of reward/risk ratio and R multiple. It is also its useful when testing new trading systems to gauge their expectancy.

Feel free to use it as you wish. Its not great for intraday trading as it takes too long to input data but for longer term trades helps me to be mindful of capital protection.

A few points:
• The initial entries are fictitious – just used for testing (It will be better to just overwrite them rather than deleting them and risk losing the formulas).
• The yellow columns are the only ones that require data input.
• Cell error messages (e.g. #div/0) relate to empty or ‘0’ content cells and correct themselves on corresponding data entry.

A few column explanations:

Reward / Risk ratio
A ratio used by many investors to compare the expected returns of an investment to the amount of risk undertaken to capture these returns. This ratio is calculated mathematically by dividing the amount of profit the trader expects to have made when the position is closed (i.e. the reward) by the amount he or she stands to lose if price moves in the unexpected direction (i.e. the risk). http://www.investopedia.com/terms/r/riskrewardratio.asp

Com+Stamp
Commission fees plus stamp duty. (Commission fixed at 2x£8. Stamp duty 0.5 of purchase cost)

Net P/L
Profit or loss including commission and fees.

R multiple
R Multiple: P&L divided by the Initial Risk.
“You want your losses to be 1R or less. That means if you say you’ll get out of a stock when it drops \$50 to \$40, then you actually GET OUT when it drops to \$40. If you get out when it drops to \$30, then your loss is much bigger than 1R.
It’s twice what you were planning to lose or a 2R loss. And you want to avoid that possibility at all costs.
You want your profits to ideally be much bigger than 1R. For example, you buy a stock at \$8 and plan to get out if it drops to \$6, so that your initial 1R loss is \$2 per share. You now make a profit of \$20 per share. Since this is 10 times what you were planning to risk we call it a 10R profit.”
http://www.iitm.com/sm-risk-and-r-multiples.htm

Expectancy
Average (mean) of the R-multiple.

Expectancy gives you the average R-value that you can expect from the system over many trades. Put another way, expectancy tells you how much you can expect to make on the average, per dollar risked, over a number of trades.

At the heart of all trading is the simplest of all concepts—that the bottom-line results must show a positive mathematical expectation in order for the trading method to be profitable. ~ Chuck Branscomb
http://www.iitm.com/sm-Expectancy.htm

In its creation, two other trading logs, found online, were referenced:
1. Trader Mike. (Trading journal.xls)
http://tradermike.net/2006/01/my_tra...l_spreadsheet/
2. Clambill. (Trading Log.xls)
http://www.trade2win.com/boards/trad...ading-log.html

Hope you find it useful
Attached Files
 Trading log v3.xls (335.0 KB, 26596 views)

 Mar 8, 2011, 8:58am #3 Joined Dec 2010 Re: Free Excel trading log template As an additional note, the risk/reward ratio calculation is somewhat inexact as the target is hopeful at best. Tim Wilcox 2005 (Timsk), http://www.trade2win.com/section/art...-plan-template section 10.7 and 10.8 proposes the inclusion of the probability of the trades success into the risk/reward equation - which will make it more effective.
Mar 9, 2011, 7:06pm   #4
Joined Mar 2011
Re: Free Excel trading log template (V3)

Here is a free copy of a trade review I send to people... It is very simple but effective.
Attached Files
 Copy of Tradereview-SFO.xls (61.0 KB, 16519 views)

 Apr 28, 2012, 1:13am #5 Joined Dec 2011 Re: Free Excel trading log template Wow, this is great! I started my own spreadsheet/journal when I first started and wasn't quite sure of what to log, and how to organize it. This helps tremendously and I look forward to seeing the patterns that will spell out.
 Apr 28, 2012, 2:35am #6 Joined Nov 2009 Re: Free Excel trading log template Only have my phone for internet at the moment so can't see any of your files. I've my own spreadsheet which simulates my spread bet account to keep me on the straight and narrow re leverage and multiple positions etc. But it's not a log file so looking forward to seeing your log file !
 Dec 4, 2012, 2:13pm #7 Joined Mar 2011 Re: Free Excel trading log template hi where can i find a forex journal to record my trades? help appreciated..
 Jul 14, 2014, 12:25am #8 Joined Jun 2014 I don't know if it is my dopy computer, or the dope using the computer but I can not get the trading log or journal to down load, is anyone else having an issue?
 Jul 11, 2016, 11:31am #9 Joined Jul 2016 Forex Trading Income Calculator Hi, Can you please help me with an excel worksheet for calculating my Forex income compounding monthly with changing risk ratios... I have seen one on videos of Inner Circle Trader but have failed creating one or find one of similar nature. Your help will be very much appreciated. Regards Ayanda - South Africa
 Jan 23, 2017, 9:30pm #10 Joined Jul 2007 Thank you for the tools.

 Thread Tools Search this Thread Search this Thread: Advanced Search

 Similar Threads Thread Thread Starter Forum Replies Last Post Article: Trading Plan Template T2W Bot Educational Resources 94 Sep 30, 2017 8:21pm clambill Trading Software 9 May 30, 2012 8:07pm binar Forex 2 Dec 1, 2009 2:44pm mgergs First Steps 4 May 23, 2009 8:09am

 Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)