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)
As I keep all historical journal versions I can always stick it back in (once we got the formula(s) to work, but as I stated in the risk of ruin thread I think they are flawed)....
I suggest ordering the trades in the NT by entry time first. Otherwise I am not able to match them. Perhaps once I have the grouping up and running.
yeah, this comes last:-D
same as previous point. the value in the cell is correct though:-)
Will need to investigate.
It wouldn't have been you not having something special. I am not experiencing this issues. Are you sure you had the discretionary mode on while importing?
It shouldn't replace any old data, since it is not writing to the cells. However on the picture I noticed, that there is missing the number in trade 2 and 3. This could pose problem to the journal, since i guess it takes it that if there is no value, it ignores the row. That way everything could be broken. Also me, when I am detecting the row to write am looking at the trade number. If there is nothing there, I use the line. If I recall correctly, the number fills in automatically by the journal.
Perhaps sending me the example prior import and after import might help me to pinpoint the issue. There is never enough of test data:-)
It also replaces the formatting sometimes. Need to find out, what is causing this.
EDIT: seems that met issues are solved by the journal version used. Please append to older one.
Yes, it automatically populates the trade number. I think with checking for that number you have found the best way of finding the end of the existing records.
that's why I initially thought it would perhaps be better to do it from within excel, but excel formatting has always been a pain in the b...side so it probably wouldn't even make a difference.
Have just gone through that very quickly. It actually tells how to import the text file from excel via VBA.
Not that I want to play with VBA too much, it would probably require to throw away everything I have so far...
It might be extremely difficult to parse the csv from within excel, since it can be in quite many locales the NT is able to produce (in .NET it is much easier, since it is .NET what is producing the results ).
So i guess the way does not lead here...
But I have seen some synchronization from excel via other means... If I could only remember where...
there is still one issue with the journal. The maximum drawdown on the overview is not refreshing for some reason.
The new version helped a lot (except for the drawdown). Now the imported data (mostly) works.
Before a new version of importer is out, please append to some older version of journal that has less issues.
OK, that makes sense. Perhaps we could later have an excel front end, saving and closing the journal, calling your importer with the desired settings and forwarding the csv to your importer, import and then open the journal again??
I will double check with the max drawdown, but as I remember correctly it was working fine on my end...would you mind sending me the file where the max dd is not updating?
Hmm, let's try to think out of the box....
how do you guys write the notes for each trade? Piece of paper or some text editor, Evernote or directly into the journal?
What about an easy form, that will offer the text box, instrument drop down and will allow to make notes?
The notes would be stored in an local db and then could be merged with "technical" data from the trading platform - like the csv we are parsing from NT...
Since the trades will be in the database together with the notes, we could then just generate the excel in order to perform the statistics.
Since such tool would be also something I need for my trading - I could perhaps create something if there is time (I am lazy and I try to make the computer do the things for me if it is tedious task).