Welcome to the Traders Laboratory Forums.
Money Management Risk and money management related topics.

Reply
Old 06-21-2009, 05:35 PM   #9

Join Date: Aug 2008
Location: Montana
Posts: 7
Ignore this user

Thanks: 4
Thanked 0 Times in 0 Posts

Re: Excel Template

Thanks Bear,

I like to keep things simple. This is exactly what some of us might need. Even if one of these start out that way, people tend to add their own bells and whistles. For me, this will be a great starting point. Thanks again.

Last edited by Bohunck; 06-21-2009 at 05:36 PM. Reason: typo
Bohunck is offline  
Reply With Quote
Old 06-22-2009, 02:52 PM   #10

Bear Mtn.'s Avatar

Join Date: May 2009
Location: Trading
Posts: 36
Ignore this user

Thanks: 32
Thanked 17 Times in 12 Posts

Re: Excel Template

You are all welcome If anyone comes up with good additions to my basic record-keeping sheets then please do re-post them on here...
Bear Mtn. is offline  
Reply With Quote
Old 06-22-2009, 04:31 PM   #11

atto's Avatar

Join Date: Mar 2008
Location: USA
Posts: 403
Ignore this user

Thanks: 112
Thanked 347 Times in 123 Posts
Blog Entries: 2

Re: Excel Template

I have a good spreadsheet that I've used and improved for a while that allows you to keep track of scaleouts, add-ins, etc., and calculates pts profit, $ profit, and so on based on entry/exit prices. I've given it to a few people to play around with and test, and will post it when I'm certain enough that it's bug free.
atto is offline  
Reply With Quote
Old 06-23-2009, 11:56 AM   #12

Bear Mtn.'s Avatar

Join Date: May 2009
Location: Trading
Posts: 36
Ignore this user

Thanks: 32
Thanked 17 Times in 12 Posts

Re: Excel Template

Quote:
Originally Posted by atto »
scaleouts, add-ins, etc., and calculates pts profit, $ profit, and so on based on entry/exit prices.
Really interested to see this Atto as finding a way to accurately represent multi-entry/exit trades has been one thing I've struggled with. I now do this fairly manually which I think gives me an accurate way to benchmark these against simpler trades.. but like I say, look forward to seeing your setup or hearing how you handle these?
Bear Mtn. is offline  
Reply With Quote
Old 06-23-2009, 12:56 PM   #13

atto's Avatar

Join Date: Mar 2008
Location: USA
Posts: 403
Ignore this user

Thanks: 112
Thanked 347 Times in 123 Posts
Blog Entries: 2

Re: Excel Template

Yeah, that was the hardest logically, but I really wanted it to work that way. Still trading now, and I need to fix a couple things, then I'll post it.

Here's how the trade journal section looks (and you might get an idea how I managed scaleouts and adds):


The data entered is Date/Time, Instrument (entered or selected from a menu that's easy to set up), size, and price. The rest is calculated: position (showing the total position on that instrument) and profit (in pts and $, taking into account the average entry price). Cumulative profit, Drawdown, and some other stats are also kept track of.
Attached Thumbnails
Excel Template-tj.png  
atto is offline  
Reply With Quote
Old 06-23-2009, 01:13 PM   #14

Bear Mtn.'s Avatar

Join Date: May 2009
Location: Trading
Posts: 36
Ignore this user

Thanks: 32
Thanked 17 Times in 12 Posts

Re: Excel Template

Looks like a good layout Atto - your cumulative approach is slightly different from how I approached things so v.interesting. Look forward to seeing more.

Thanks for sharing

BM
Bear Mtn. is offline  
Reply With Quote
Old 06-23-2009, 06:00 PM   #15

Join Date: Aug 2008
Location: Belfast
Posts: 41
Ignore this user

Thanks: 16
Thanked 13 Times in 10 Posts

Re: Excel Template

Very nice atto. I am still playing around with bears. thanks again bear and thanks atto.
thetatrader is offline  
Reply With Quote
Old 08-28-2009, 12:04 AM   #16

Join Date: Aug 2009
Location: New Orleans
Posts: 1
Ignore this user

Thanks: 0
Thanked 0 Times in 0 Posts

Re: Excel Template

Thank you for posting the template. It is just what I needed to begin properly.
Lidera is offline  
Reply With Quote

Reply

Thread Tools
Display Modes Help Others By Rating This Thread
Help Others By Rating This Thread:


Similar Threads
Thread Thread Starter Forum Replies Last Post
MP on excel gomes Market Profile 123 11-27-2009 03:16 AM
DOM -- Excel / IB Tams Trading Indicators 8 11-10-2009 08:52 AM
Excel Question Eiger Coding Forum 2 06-04-2008 12:28 PM
Excel Help Needed brownsfan019 Trading Indicators 5 06-02-2008 07:24 PM
Market Profile in Excel winnie Market Profile 5 01-31-2008 11:13 AM

All times are GMT -4. The time now is 07:39 PM.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
CS to VB integration by DeskLancer
©2006-2011 Traders Laboratory, All Rights Reserved.