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.
Last edited by petrmac; January 9th, 2012 at 03:15 PM.
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??
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).
I can probably draw some screen mockups.
How does that sound?
The following 4 users say Thank You to petrmac for this post: