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 334,778 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

  #621 (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
I have sent the PM... hope it arrived.

I am having difficulties to add a new row to enter the trade manually though. Am I doing something wrong (I run at the end of the last line and new line is added below, but it is locked and I cannot write anything in it)

No, didn't get through...can you post here?

vvhg

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

Can you help answer these questions
from other members on NexusFi?
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
How to apply profiles
Traders Hideout
PowerLanguage & EasyLanguage. How to get the platfor …
EasyLanguage Programming
Trade idea based off three indicators.
Traders Hideout
Better Renko Gaps
The Elite Circle
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Just another trading journal: PA, Wyckoff & Trends
30 thanks
Spoo-nalysis ES e-mini futures S&P 500
28 thanks
Tao te Trade: way of the WLD
24 thanks
Bigger Wins or Fewer Losses?
20 thanks
GFIs1 1 DAX trade per day journal
16 thanks
  #622 (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

Since it is good to measure performance in different units than money I think it might be a good idea to include a graph of profit per contract over a period of time.
It could suggest how is one performing and derive the position size out of it.

For instance if I am consistently making 10 ticks / contract a day, it might be wise to increase size given all other conditions are met (risk is stable percentage of capital, or the target with given size is met).

Visit my NexusFi Trade Journal Reply With Quote
  #623 (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
Since it is good to measure performance in different units than money I think it might be a good idea to include a graph of profit per contract over a period of time.
It could suggest how is one performing and derive the position size out of it.

For instance if I am consistently making 10 ticks / contract a day, it might be wise to increase size given all other conditions are met (risk is stable percentage of capital, or the target with given size is met).

I like the idea, shouldn't be any problem to incorporate, as there is already a column for it ticks/contract...
That chart could go onto overview and could be cycled through with the other account charts....

vvhg

Hic Rhodos, hic salta.
Reply With Quote
  #624 (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

Killed a very persistent bug that caused an incompatibility with excel 10. It deleted the dataseries of the charts on time period tab due to a slight change between office 07 and 10. Unfortunately there was nothing to find on that change....

Finally found it. And in the process I managed to crash excel 10 in less than 10min after installationrepeatedly of course


The other change was for @ petrmac. Now the table gets resized automatically on first open after import. Please report if it is working. The cell to write to is "internal calcs P38".

Smaller fixes here and there I can't remember.


We should also agree on a roadmap what else we want to have in there. What comes to mind are Account balance here and there on "time per. stats" tab and a graph showing ticks/contract over time at same place than account balance on overview.

vvhg

Hic Rhodos, hic salta.
Attached Files
Elite Membership required to download: Journal 3.2Beta28.rar
Reply With Quote
Thanked by:
  #625 (permalink)
 
madLyfe's Avatar
 madLyfe 
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
Posts: 1,641 since Feb 2011
Thanks Given: 9,220
Thanks Received: 1,020


vvhg View Post
Killed a very persistent bug that caused an incompatibility with excel 10. It deleted the dataseries of the charts on time period tab due to a slight change between office 07 and 10. Unfortunately there was nothing to find on that change....

Finally found it. And in the process I managed to crash excel 10 in less than 10min after installationrepeatedly of course


The other change was for @ petrmac. Now the table gets resized automatically on first open after import. Please report if it is working. The cell to write to is "internal calcs P38".

Smaller fixes here and there I can't remember.


We should also agree on a roadmap what else we want to have in there. What comes to mind are Account balance here and there on "time per. stats" tab and a graph showing ticks/contract over time at same place than account balance on overview.

vvhg

nice! nice! everything is working again! ok ill get to playing around with it and see what i can find..

dont believe anything you hear and only half of what you see

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal Reply With Quote
  #626 (permalink)
 
madLyfe's Avatar
 madLyfe 
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
Posts: 1,641 since Feb 2011
Thanks Given: 9,220
Thanks Received: 1,020

i know the colors in the journal tab are red and green for positive and negative, but whats this color mean?


dont believe anything you hear and only half of what you see

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal Reply With Quote
  #627 (permalink)
 
madLyfe's Avatar
 madLyfe 
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
Posts: 1,641 since Feb 2011
Thanks Given: 9,220
Thanks Received: 1,020

when emptying the transaction tab(because i dont have any atm) and i delete the empty rows i get this runtime error:



here is the debug:


dont believe anything you hear and only half of what you see

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #628 (permalink)
 
madLyfe's Avatar
 madLyfe 
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
Posts: 1,641 since Feb 2011
Thanks Given: 9,220
Thanks Received: 1,020

here on some thoughts on the coloring for the time period stats:



-i think the commission should always be in red text.

-the amount of trades should always be in black.

-im not sure how the win% is calculated, but it should always be in black. now if its green because its a positive win% and red because its a negative win% than thats fine but should be consistent i think. im not sure if you have had no winners is setup to show 0% or not..

dont believe anything you hear and only half of what you see

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #629 (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 did a bit of testing on 2 excel versions.

Adding new row in the journal works in excel 11 for Mac and does not work in excel 10 for Windows.
The tab on the Note field adds a new row, but the fields are locked in excel 10.

Unfortunately I don't have other excel version available.

Visit my NexusFi Trade Journal Reply With Quote
  #630 (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
when emptying the transaction tab(because i dont have any atm) and i delete the empty rows i get this runtime error:

Good catch, I have to code an exception for that, as there has to be a minimum of one row...

madLyfe View Post
here on some thoughts on the coloring for the time period stats:



-i think the commission should always be in red text.

-the amount of trades should always be in black.

-im not sure how the win% is calculated, but it should always be in black. now if its green because its a positive win% and red because its a negative win% than thats fine but should be consistent i think. im not sure if you have had no winners is setup to show 0% or not..

Agree.
Agree.
Not sure, win % shows top and bottom in green/red....

We should also agree where to display account balance on that tab...

I will post a new beta in the near future.

vvhg

Hic Rhodos, hic salta.
Reply With Quote




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