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 331,911 views
    2. thumb_up 1,509 thanks given
    3. group 234 followers
    1. forum 946 posts
    2. attach_file 252 attachments




 
 

Trading Metrics for journals/record keeping

 
 
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
Did you remove the sample data while the sheet was protected?
If not you might have accidentally deleted some formulas.
If yes, how many trades are in your journal now? If there is not enough data yet you get Div/0 errors on the overview tab as there is insufficient data to calculate the stats from.

vvhg

i just downloaded the file from your post, then removed the journal data. the journal sheet isnt protected by default, should it be?

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

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal
Thanked by:

Can you help answer these questions
from other members on NexusFi?
Exit Strategy
NinjaTrader
Deepmoney LLM
Elite Quantitative GenAI/LLM
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
NexusFi Journal Challenge - April 2024
Feedback and Announcements
ZombieSqueeze
Platforms and Indicators
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
61 thanks
Funded Trader platforms
38 thanks
NexusFi site changelog and issues/problem reporting
26 thanks
GFIs1 1 DAX trade per day journal
19 thanks
The Program
18 thanks
 
 
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

YES it should be, let me change that...
Here you go....

vvhg

Hic Rhodos, hic salta.
Attached Files
Elite Membership required to download: Journal 2.0r.rar
Thanked by:
 
 
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
YES it should be, let me change that...
Here you go....

vvhg

thanks, but now when i try to delete the user data i get this:


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

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal
 
 
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

Because you have also selected the protected cells..
Green heading indicates (in most cases) unprotected cells underneath.
Easiest is to delete the data column by column (except heading).
If you get an error message then, just move on to the next column....

vvhg

Hic Rhodos, hic salta.
Thanked by:
 
 
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
Because you have also selected the protected cells..
Green heading indicates (in most cases) unprotected cells underneath.
Easiest is to delete the data column by column (except heading).
If you get an error message then, just move on to the next column....

vvhg

oh jeez.. that makes it easier, thanks for the tip.

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

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal
 
 
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

ya thats really odd, i cant delete the selection as a whole(as shown in the picture), but i can delete all the columns selected in the picture one by one..



for some reason the screen grab didnt get the highlighted areas in the pic... i had all of the green columns in the picture highlighted..

also after clearing out the journal one by one, i went to the overview tab to put in my starting balance and this is what i got:



not sure if expected or not.. i know the 'Div/0' errors are supposed to be there but not the VB error..

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

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal
 
 
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

1.Yepp that is expected as there are hidden columns performing calcs....
2.Well I'm not exactly a VB guru, so that could be due to my buggy code, just click end (or debug if you happen to be a guru), I'll look into that in about 12 hours...

vvhg

Hic Rhodos, hic salta.
Thanked by:
 
 
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
1.Yepp that is expected as there are hidden columns performing calcs....
2.Well I'm not exactly a VB guru, so that could be due to my buggy code, just click end (or debug if you happen to be a guru), I'll look into that in about 12 hours...

vvhg

ok cool, and thanks for you help today vvhg! im not using like half of whats in this journal so i dont know if thats whats causing this error as well, but im getting this every so often(like not while im doing things in the journal, just randomly)..



here are the only utilities that i am interested in for my records:

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

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal
 
 
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
1.Yepp that is expected as there are hidden columns performing calcs....
2.Well I'm not exactly a VB guru, so that could be due to my buggy code, just click end (or debug if you happen to be a guru), I'll look into that in about 12 hours...

vvhg

At this point the whole excel crashes due to some illegal operation (I suspect the recalc of the axis in the VB code).
Could be excel bug, but I had the chance to try it only on my Mac. I will try it on Win7 as well.

Petr

Visit my NexusFi Trade Journal
 
 
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
Yes, the errors are likely to be caused by that, I will improve on that....


@petrmac
Sorry for crashing your excel. On my end it doesn't, but I'll try to improve the VB code. Would be interesting to see what happens on Win7. Runtime errors mostly occur with the y axis maximum, perhaps there is a way to only set the min and let excel do the max.


vvhg

Hic Rhodos, hic salta.

 



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