I think you are referring to risk reward ratio.

vvhg

Hello vvhg and Big Mike,

I´am tweaking your spreadsheet but I hate working with exel. I can not code the formulas for the different columns. I have try it but it made me furious, the only thing that I want to do is pick a hammer and crack that monitor in front of me.

Can I count with your help?
I have already made the journal and I´am working on the overview.
When I have this done I will post the attachment.

Best regards,
João Soares

BM and vvhg,

Thanks very much for this - I'm just coming back to trading after months away, and this is just what I was looking for.

I have two suggestions / requests:

1. I think it would be very useful to be able to include trades that were 'Passed' on or 'Missed', perhaps with a separate column with dropdown to note their status, so that their metrics would be separated from the actual account.

2. The Benchmark could usefully be split in two: MFE before Exit1, and MFE if the trade had been held until the ideal exit.

Thanks again for the great work.

futuretrader 

BM and vvhg, Thanks very much for this - I'm just coming back to trading after months away, and this is just what I was looking for. I have two suggestions / requests: 1. I think it would be very useful to be able to include trades that were 'Passed' on or 'Missed', perhaps with a separate column with dropdown to note their status, so that their metrics would be separated from the actual account. 2. The Benchmark could usefully be split in two: MFE before Exit1, and MFE if the trade had been held until the ideal exit. Thanks again for the great work.

1. I really like the idea! But I believe if I stick that in too, that beast will bring nearly every computer down on its knees, it's quite big already. May I suggest that you just use a second journal for that (ie just copy this template)?

2. No problem to have a 2nd MFE column. Though I don't get your concept on that yet. Wouldn't the MFE before E1 1. on a winning trade be E1
2. on a loosing trade the same than any other definition of MFE (as long as you are not thinking of increasing your stop)?

Thanks a lot for your ideas!

vvhg

Latest update:
Added some stuff like drawdown now on overview displayed, added some pivot tables, completed calculations on overview tab....and minor things here and there.....
If you are missing sth just shout and I'll try to stick it in. If you find any errors (and I'm sure that I missed the occasional one) please report them, so I can correct them.....thanks.

vvhg

Edit: corrected glitch in macro.

vvhg 

1. I really like the idea! But I believe if I stick that in too, that beast will bring nearly every computer down on its knees, it's quite big already. May I suggest that you just use a second journal for that (ie just copy this template)? 2. No problem to have a 2nd MFE column. Though I don't get your concept on that yet. Wouldn't the MFE before E1 1. on a winning trade be E1 2. on a loosing trade the same than any other definition of MFE (as long as you are not thinking of increasing your stop)? Thanks a lot for your ideas! vvhg

Hi vvhg,

yes of course you're right about (1), as it is I turned off the auto-recalculate function to make inputting data more bearable.

Re the MFE - the standard measure is of course the maximum excursion before the exit (which will correspond to E1 on a winning trade only if you're using a profit target, not if you're using some sort of trail). But it's also very useful to keep track of the 'ideal' exit after your target is hit. Anyway, I'm starting to remember how Excel works, so I can add this myself, but I thought you might also be interested in it.

Thanks again for your work on this!

Hello futuretrader,
thank you for your input, that's exactly what we need to develop this template!

Next version will have a 2nd MFE.
I often have thought about MFE after exit, though IMHO it is slightly complicated how exactly to define that...

vvhg

Hi,

Thanks vvhg for all your hard work on this journal.

Can someone please help. Is it possible to use this journal (spreadsheet) to track Euro (6E) trades? I added the 6E to the instrument list. It will not allow me to record an entry price with four decimal places. EX...I type in 1.4777 and it shows 1.48. Sorry, I am not that familiar with Excel.

Any help/suggestions would certainly be appreciated. Thanks.

emini

Just format the cell:

Let me google that for you

Mike

Thanks for all the inputs, I am now looking for record-keeping tools, and found the Excel spreadsheets in the thread very helpful, I also notice two commercial software: Stator and Elder's AK47 (I was not able to post the links yet, but Google should help), which seem to satisfy my needs.