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 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?
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.
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.
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.
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..
dont believe anything you hear and only half of what you see
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.
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).