i am looking for a trading journal as well and this looks nice but has soooo much stuff im not sure where to start. i use NT, i was looking through the control center tabs in NT(still dont know much about them) and shouldnt it already keep a journal?

madLyfe 

i am looking for a trading journal as well and this looks nice but has soooo much stuff im not sure where to start. i use NT, i was looking through the control center tabs in NT(still dont know much about them) and shouldnt it already keep a journal?

Most people have problems with the NT 'journal'. Many times it's calculations are WAY off. I think you really want separate software for this.

forker

forker 

Most people have problems with the NT 'journal'. Many times it's calculations are WAY off. I think you really want separate software for this. forker

ya im going to have to figure out how to work a a spread sheet so i can do all the drop down selection stuff.. hmmm..

madLyfe 

ya im going to have to figure out how to work a a spread sheet so i can do all the drop down selection stuff.. hmmm..

If you found problems with the spreadsheet on this thread, you could try Trading Journal Spreadsheet (TJS). Google it. The learning curve probably isn't too steep.

forker

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.

Kudos to vvhg. I will take a look at this later. Based on your screen shots, you really know how to use excel!

forker

VVHG,

Will the Trading Journal work on any versions of Excel for Mac? I tried it on version 2004, and got numerous reported issues. Thanks,

forker

p.s. what is your favorite version of excel? I'm interested, because you are very good on it, and I've heard a lot of bad things about versions 07,08 and 11.

Hello forker,

the journal was created using 07 so it should work with that and newer. I don't know a lot about Macs to say the least, so I can't give you any advice on that.
Thank you very much, but I'm afraid that I'm not half as good with Excel as you think I am....Big Mike has done most of the work here as I only added some stuff to his journal!
As to excel versions...I think they all are good but it does take some time to get used to the changed layout in the versions you mentioned.


vvhg

i was wondering if someone could help me out with my journal that ive taken from big mikes thread and added my own stuff.. what i need added on is when i select the instrument from the drop down list that i made and i enter the entry and exit price it will calculate the total ticks for that particular instrument, add the commission for that instrument, and then post the net profit and gross profit less the commissions..

here is where i got attached below..

Hello fellow traders,

I have decided to add something of my doing to this thread.
Here is the automatic tool that generates the xlsx journal (version 1.5 with some minor fixes) from the ninja trader grid of trade results (Account performance -> Trades ).

1. Just set the output to the points (combo Mode, select Points), export to csv
2. Run the exe
3. Select the CSV
4. Click Import!
5. The program allows you to select the location of the excel
6. You have the trades imported to the journal

Please bear in mind, that the software is provided AS IS. Feel free to post any suggestions though. This is merely the "beta" version - at the moment it has enough features that I need.

Consider this as my way to say "thank you" for the excellent journal.
Attached the zip with .NET assemblies. Built under the .Net 4.0 profile.


Regards

Petr

forker 

VVHG, Will the Trading Journal work on any versions of Excel for Mac? I tried it on version 2004, and got numerous reported issues. Thanks, forker p.s. what is your favorite version of excel? I'm interested, because you are very good on it, and I've heard a lot of bad things about versions 07,08 and 11.

Hello Forker,

consider upgrading the excel. I am using excel (2011) for mac myself and everything works fine. The only issue is with the custom VBA on the dashboard calculating the bounds for the equity curve.

The problem could be caused, that the file format (xml) is not supported in excel 2004 (but I cannot swear).

Read the specs..

Petr