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 ...

Reply
 
LinkBack Thread Tools Search this Thread
Old Dec 8, 2010, 10:01am   #1
 
3 Posts
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
File Type: doc Explanation of Rogh log v1.doc (66.0 KB, 4707 views)

Last edited by timsk; Mar 7, 2011 at 10:37am. Reason: Added edit at OP's request
Rogh is offline   Reply With Quote
Thanks! The following members like this post: timsk
Old Mar 4, 2011, 11:03am   #2
 
3 Posts
Joined Dec 2010
Re: Free Excel trading log template (V3)

Rogh started this thread 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
File Type: xls Trading log v3.xls (335.0 KB, 10212 views)
Rogh is offline   Reply With Quote
Old Mar 8, 2011, 7:58am   #3
 
3 Posts
Joined Dec 2010
Re: Free Excel trading log template

Rogh started this thread 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.
Rogh is offline   Reply With Quote
Old Mar 9, 2011, 6: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
File Type: xls Copy of Tradereview-SFO.xls (61.0 KB, 6269 views)
MorganatDTI is offline Coach/Trainer   Reply With Quote
Old 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.
awesomo4k is offline   Reply With Quote
Old 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 !
HairyMoose is offline   Reply With Quote
Old Dec 4, 2012, 1:13pm   #7
 
2 Posts
Joined Mar 2011
Re: Free Excel trading log template

hi where can i find a forex journal to record my trades? help appreciated..
kdcafun is offline   Reply With Quote
Reply

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 87 Jan 21, 2014 10:14am
FREE spreadsheet for trading log! clambill Trading Software 9 May 30, 2012 8:07pm
Need an Excel Journal / Log Template binar Forex 2 Dec 1, 2009 1:44pm
Trading Plan template ? mgergs First Steps 4 May 23, 2009 8:09am

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