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 335,996 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

  #541 (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

Coming along...

What do you think?


vvhg

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

Can you help answer these questions
from other members on NexusFi?
ZombieSqueeze
Platforms and Indicators
Better Renko Gaps
The Elite Circle
MC PL editor upgrade
MultiCharts
Quant vue
Trading Reviews and Vendors
How to apply profiles
Traders Hideout
 
  #542 (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
Coming along...

What do you think?
Attachment 61330

vvhg

thats looking pretty darn sexy @vvhg!

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

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #543 (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
thats looking pretty darn sexy @ vvhg!

Thanks a lot!

Shall I use the same rows for the day of week block(Net, Trades, Net/Trade...)?
Any more stats we need?

vvhg

Hic Rhodos, hic salta.
Reply With Quote
  #544 (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
Thanks a lot!

Shall I use the same rows for the day of week block(Net, Trades, Net/Trade...)?
Any more stats we need?

vvhg

that would be perfect, although i think those stats would be better for the weeks as im not sure how helpful they would be on days of the week.. the only thing i could see useful would be what days of the week i do the best or worst on over the entire year..

on the weeks i would want those stats so i can go through and see how that month ended up the way it did type of thing..

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

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal Reply With Quote
  #545 (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
... the only thing i could see useful would be what days of the week i do the best or worst on over the entire year..

on the weeks i would want those stats so i can go through and see how that month ended up the way it did type of thing..


That is exactly what the day of week will do, show performance for all Mondays, Tuesdays... of the entire year...

The week matrix is a bit more tricky, but possible. What stats are the most essential ones for the week thingy?

vvhg

Hic Rhodos, hic salta.
Reply With Quote
  #546 (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
That is exactly what the day of week will do, show performance for all Mondays, Tuesdays... of the entire year...

The week matrix is a bit more tricky, but possible. What stats are the most essential ones for the week thingy?

vvhg

ya i was just saying that for the way you have the day of the week setup you would only need to know the profit/loss for each day over the year, and that seems like it would be better as say a bar chart kinda like the hours of the day we have right now in the journal.

the weeklies could be done by having each week of the month in rows under each month.. i see what your saying on how its not always the same.. hmmm.. ill have to think about that for a min or two..

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

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #547 (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
ya i was just saying that for the way you have the day of the week setup you would only need to know the profit/loss for each day over the year, and that seems like it would be better as say a bar chart kinda like the hours of the day we have right now in the journal.

We'll have both, the table and charts (as the charts need a table somewhere anyways).


Quoting 
the weeklies could be done by having each week of the month in rows under each month.. i see what your saying on how its not always the same.. hmmm.. ill have to think about that for a min or two..

Nay, doesn't work without really intense scripting...Excel doesn't handle that well anyways, but if you do it for the individual months, you end up with many truncated and chopped up weeks making the study pretty worthless.
So I think the best way would be using the matrix...but I'll improve that a bit more...

vvhg

PS. 500

Hic Rhodos, hic salta.
Reply With Quote
  #548 (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
We'll have both, the table and charts (as the charts need a table somewhere anyways).

Nay, doesn't work without really intense scripting...Excel doesn't handle that well anyways, but if you do it for the individual months, you end up with many truncated and chopped up weeks making the study pretty worthless.
So I think the best way would be using the matrix...but I'll improve that a bit more...

vvhg

PS. 500

ok cool, that sounds good.

btw, how do you actually tell what day of the week it is by the dates entered with our trades?

i guess the main point of this part of the journal for me would be so i can at a glance see how much im up/down for the day and how much commish ive paid. then see where i stand for the week, and year as i enter trades.. then the ability to go back at the end of the month/year and use the information to see the things im doing well and also see the leaks in my game..

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

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal Reply With Quote
  #549 (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
btw, how do you actually tell what day of the week it is by the dates entered with our trades?

Excel wizardry there is a function WEEKDAY(Serial_number,return type) giving you the weekday of a date.


Quoting 
i guess the main point of this part of the journal for me would be so i can at a glance see how much im up/down for the day and how much commish ive paid.

The day can be seen on Pivot Table tab middle table (comm is not in there..)

Quoting 
then see where i stand for the week, and year as i enter trades.. then the ability to go back at the end of the month/year and use the information to see the things im doing well and also see the leaks in my game..

Yes, that's what these stats shall provide...have a look:



vvhg

Hic Rhodos, hic salta.
Reply With Quote
Thanked by:
  #550 (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


This is how it looks now:

And here a little explanation how the weeks table works (this will also be in the journal):

And finally the Alpha build to fiddle around with (no charts for the new stats yet...).



vvhg

Hic Rhodos, hic salta.
Attached Files
Elite Membership required to download: Journal 3.2ALPHA5layout6.rar
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