NexusFi: Find Your Edge


Home Menu

 





Trading Metrics for journals/record keeping


Discussion in Psychology and Money Management

Updated
      Top Posters
    1. looks_one vvhg with 354 posts (690 thanks)
    2. looks_two madLyfe with 202 posts (104 thanks)
    3. looks_3 petrmac with 73 posts (106 thanks)
    4. looks_4 Big Mike with 35 posts (165 thanks)
      Best Posters
    1. looks_one PandaWarrior with 75 thanks per post
    2. looks_two Big Mike with 4.7 thanks per post
    3. looks_3 vvhg with 1.9 thanks per post
    4. looks_4 petrmac with 1.5 thanks per post
    1. trending_up 332,034 views
    2. thumb_up 1,509 thanks given
    3. group 234 followers
    1. forum 946 posts
    2. attach_file 252 attachments




 
Search this Thread

Trading Metrics for journals/record keeping

  #411 (permalink)
 
vvhg's Avatar
 vvhg 
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,583 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824


madLyfe View Post
I'm still away from the office, does that mean you have deleted it from the journal from now on..? it's fine by me if that's the decision you made

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)....

vvhg

Hic Rhodos, hic salta.
Reply With Quote
Thanked by:

Can you help answer these questions
from other members on NexusFi?
Build trailing stop for micro index(s)
Psychology and Money Management
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
Better Renko Gaps
The Elite Circle
NexusFi Journal Challenge - April 2024
Feedback and Announcements
ZombieSqueeze
Platforms and Indicators
 
  #412 (permalink)
 
petrmac's Avatar
 petrmac 
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
Posts: 175 since Jun 2011
Thanks Given: 275
Thanks Received: 211


vvhg View Post
Here it is (graph below plots difference):
Attachment 59057

I don't like it....

I still like this best:



vvhg

I think both can be interesting. Basically I don't have objections to any of these.
Maybe the EMA as big picture and both lines as detailed view:-)

Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #413 (permalink)
 
petrmac's Avatar
 petrmac 
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
Posts: 175 since Jun 2011
Thanks Given: 275
Thanks Received: 211


I'll try to fix these in the next version.


madLyfe View Post
here is what im getting with the newest importer version:

the imported trades are highlighted:
- the trades are not incremental in arrow 1

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.


madLyfe View Post
- i know its small but the dates are not being formatted like normal

yeah, this comes last:-D


madLyfe View Post
- the entry and exit fields are not getting formatted correctly by the journal

same as previous point. the value in the cell is correct though:-)


madLyfe View Post
- im not sure what happened with the 6E trade there but i know that the TF trades were taken by using market orders for opening and market orders for closing while the 6E trade was market for the open and limit order for the close.. im not sure if this makes a diff on importing, but it def looks diff in the trade list in NT so maybe this could be an issue..

Will need to investigate.


madLyfe View Post
- the comments are being posted instead of left blank for the users own input..
- the importing is killing all of the data that the journal uses to work for new imports as well as old trades..

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:-)


madLyfe View Post
im thinking that the importer might be writing more than just values to the cells maybe?


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.

Visit my NexusFi Trade Journal Reply With Quote
  #414 (permalink)
 
vvhg's Avatar
 vvhg 
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,583 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824


vvhg View Post
Here it is, could be helpful....


vvhg

@petrmac, have you had a look at that, and is it any help?


Sent from my iPad using Tapatalk HD

Hic Rhodos, hic salta.
Reply With Quote
  #415 (permalink)
 
vvhg's Avatar
 vvhg 
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,583 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824


petrmac View Post
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.

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.


petrmac View Post
It also replaces the formatting sometimes. Need to find out, what is causing this.

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.

Vvhg



Sent from my iPad using Tapatalk HD

Hic Rhodos, hic salta.
Reply With Quote
  #416 (permalink)
 
petrmac's Avatar
 petrmac 
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
Posts: 175 since Jun 2011
Thanks Given: 275
Thanks Received: 211


vvhg View Post
@petrmac, have you had a look at that, and is it any help?


Sent from my iPad using Tapatalk HD

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...

Visit my NexusFi Trade Journal Reply With Quote
  #417 (permalink)
 
petrmac's Avatar
 petrmac 
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
Posts: 175 since Jun 2011
Thanks Given: 275
Thanks Received: 211

@vvhg

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.

Visit my NexusFi Trade Journal Reply With Quote
  #418 (permalink)
 
vvhg's Avatar
 vvhg 
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,583 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824


petrmac View Post
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 ).

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??


petrmac View Post
But I have seen some synchronization from excel via other means... If I could only remember where...

Lol, I know that feeling too well!

Vvhg




Sent from my iPad using Tapatalk HD

Hic Rhodos, hic salta.
Reply With Quote
  #419 (permalink)
 
vvhg's Avatar
 vvhg 
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,583 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824


petrmac View Post
@vvhg

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.

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?

Vvhg


Sent from my iPad using Tapatalk HD

Hic Rhodos, hic salta.
Reply With Quote
  #420 (permalink)
 
petrmac's Avatar
 petrmac 
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
Posts: 175 since Jun 2011
Thanks Given: 275
Thanks Received: 211



vvhg View Post
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??



Lol, I know that feeling too well!

Vvhg




Sent from my iPad using Tapatalk HD


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?

Visit my NexusFi Trade Journal Reply With Quote
Thanked by:




Last Updated on June 1, 2023


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts