Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
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.
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.
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)?
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.
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 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.
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.