Trading Metrics for journals/record keeping

February 2nd, 2012, 04:08 AM

madLyfe

here are some ideas i got form this guy:

i would like to see net, gross, and total commissions for each of the week, monthly, yearly for sure tho..

sorry for the bad quality of this screeny.. it was a screeny of a not to HD video that the guy posts to his blog..

I rather like the above, so I kind of went along the same lines.
So this is what I've got so far:

This is just a sketch, no formulas, so there are errors in the week #...

What do you think how many years we should have in there?

I also thought we should have some graphs similar to the hour of day graphs on overview: day of week, month of year and perhaps day of month?

What more do we want to stick in there? Any suggestions? (I might have missed suggestions in earlier posts, if I did, please remind me...)

vvhg

February 2nd, 2012, 04:13 AM

vvhg

I rather like the above, so I kind of went along the same lines.
So this is what I've got so far:Attachment 61315
This is just a sketch, no formulas, so there are errors in the week #...

What do you think how many years we should have in there?

I also thought we should have some graphs similar to the hour of day graphs on overview: day of week, month of year and perhaps day of month?

What more do we want to stick in there? Any suggestions? (I might have missed suggestions in earlier posts, if I did, please remind me...)

vvhg

that actually does look pretty nice and ill take an even closer look here in a moment(6E is moving as we speak).. i also like those ideas about the graphs(and pie charts!)..

is there a way to have the journal 'know' how many years you have and just plot it out? so once a new year was started it would just start building a new year below the previous(see my idea below).. since were into this whole automation stuff..

also i think the weekly, monthly, and yearly totals need the net,gross, and commish totals where the 'totals' are located.. you would also be able to make all that data fit and look nice and simple if the years went across in landscape or rows, instead of having them in portrate or columns.. monitors are wide now-a-days so that wont be an issue to have the years descend from oldest to newest and would look nice to 'flow' with the way the journal is setup..

February 2nd, 2012, 04:36 AM

madLyfe

that actually does look pretty nice and ill take an even closer look here in a moment(6E is moving as we speak).. i also like those ideas about the graphs(and pie charts!)..

is there a way to have the journal 'know' how many years you have and just plot it out? so once a new year was started it would just start building a new year below the previous(see my idea below).. since were into this whole automation stuff..

also i think the weekly, monthly, and yearly totals need the net,gross, and commish totals where the 'totals' are located.. you would also be able to make all that data fit and look nice and simple if the years went across in landscape or rows, instead of having them in portrate or columns.. monitors are wide now-a-days so that wont be an issue to have the years descend from oldest to newest and would look nice to 'flow' with the way the journal is setup..

Having it landscape is what I started with, but then I ran into problems with the week numbers of the year... But now that I think about it... We will run into problems like this as well...weeks are ofen split between two months....

Vvhg

Sent from my iPad using Tapatalk HD

February 2nd, 2012, 05:17 AM

Next try, what do you think?

vvhg

February 2nd, 2012, 05:25 AM

vvhg

Next try, what do you think?Attachment 61318

vvhg

ya i like that style better.. I'm kinda lost on the days of the week part and the week numbers art the bottom..

February 2nd, 2012, 05:55 AM

madLyfe

ya i like that style better.. I'm kinda lost on the days of the week part and the week numbers art the bottom..

They are individual blocks, perhaps this explains it a bit:

With the week number you have a matrix so we don't have to label each week# separately...just saving some space.
Works like this:

vvhg

February 2nd, 2012, 06:11 AM

vvhg

They are individual blocks, perhaps this explains it a bit:
Attachment 61319

With the week number you have a matrix so we don't have to label each week# separately...just saving some space.
Works like this:Attachment 61323

vvhg

ah ok i see what you did there on the weekly part, but on the daily part is it only supposed to show the current week?

February 2nd, 2012, 06:16 AM

madLyfe

ah ok i see what you did there on the weekly part, but on the daily part is it only supposed to show the current week?

No it shows the average of all occurrences of that weekday, eg. average of all Mondays.

Works the same way as the hourly thing on the overview tab.

vvhg

February 2nd, 2012, 06:23 AM

vvhg

No it shows the average of all occurrences of that weekday, eg. average of all Mondays.

Works the same way as the hourly thing on the overview tab.

vvhg

oh ok, i see what your doing now. i thought it was trying to show each day of the month like in the first layout you did.. wouldnt the way you setup the week days right now be better as a graph?

February 2nd, 2012, 07:20 AM

madLyfe

.... wouldnt the way you setup the week days right now be better as a graph?

Yes, there will definitely be a graph displaying that (probably not a pie chart though, sorry

)

vvhg

Trading Metrics for journals/record keeping

Discussion in Psychology and Money Management

Trading Metrics for journals/record keeping