Trading Metrics for journals/record keeping - Psychology and Money Management | futures io social day trading
futures io futures trading


Trading Metrics for journals/record keeping
Updated: Views / Replies:165,853 / 928
Created: by Big Mike Attachments:253

Welcome to futures io.

(If you already have an account, login at the top of the page)

futures io is the largest futures trading community on the planet, with over 90,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you dont need to worry about fake reviews.

We are fundamentally different than most other trading sites:
  • We are here to help. Just let us know what you need.
  • We work extremely hard to keep things positive in our community.
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts.
  • We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

Reply
 253  
 
Thread Tools Search this Thread
 

Trading Metrics for journals/record keeping

  #491 (permalink)
Elite Member
Des Moines, Iowa
 
Futures Experience: None
Platform: Ninja, TOS
Broker/Data: AMP/CQG, TOS
Favorite Futures: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,641 since Feb 2011
Thanks: 9,217 given, 1,011 received


vvhg View Post
Non exhaustive changelog:

changed a few format things
added a few comments on journal tab
updated the readme slightly
allowed for zero mae calculation (RR calc on stop efficiency tab for zero is calculated with 1 mae to circumvent Div/0 error)
Pivot tables do not display blank cells and the heading anymore (changed to dynamic range)
on Overview tab exit 2&3 only display when there is at least one exit in the column 2 respectively 3

That's about it...I think...more or less...

vvhg

P.S. I really could use help with the b&&%y readme, haha

this one is holding up nicely.. i would wait for the next importer to be released and tested before we update the readme because as of the last few version of the journal and the new importer a bunch of things have been phased out and replaced by automation.. yay automation!

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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Reply With Quote
The following user says Thank You to madLyfe for this post:
 
  #492 (permalink)
Elite Member
Des Moines, Iowa
 
Futures Experience: None
Platform: Ninja, TOS
Broker/Data: AMP/CQG, TOS
Favorite Futures: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,641 since Feb 2011
Thanks: 9,217 given, 1,011 received

how is the journal going to hold up when importing trades from an earlier date than when the last recorded trade in the journal is?

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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Reply With Quote
 
  #493 (permalink)
Elite Member
Ghost Ranch NM
 
Futures Experience: Intermediate
Platform: NT / Rithmic
Broker/Data: Vision/Rithmic
Favorite Futures: NQ YM
 
Posts: 78 since Mar 2010
Thanks: 4,004 given, 53 received

Run time err


vvhg,

when I opened ver 21 I had run-time err . . . when i selected debug lots of screens popped up . . . I am using Office 2010 so don't know if that has anything to do with it or not ?

FYI, I didn't know the read-me file existed because every time I opened the work-space the left tab was always the trading plan tab and I didn't think to try scrolling to the left ?

On the overview page Exit 2 . . . this is still showing 6 winners and 1 looser . . . I only had a total of six trades with an Exit 2 . . . I traded a total of 13 contracts on 7 trades . . . there were seven contracts at Exit 1 and six contracts at Exit 2 . . . of the six contracts at Exit 2, one was a break even trade . . . so under Exit 2 the values should be 5 winners at 83% and 1 looser at 17% . . . however please see my thinking below regarding counting a break-even trade as a looser. . .

If it is easily feasible to have "win" , "loose" and "draw" options in the calculations I would appreciate that feature as I do not consider a break-even trade to be a looser nor a winner . . . I know I have to pay commissions and there is a financial cost there . . . but I consider that a cost of doing business and not a flaw in my trading strategy . . . if I were a trader who executed a lot of trades, a b/e trade once in a while would not impact my win/loss ratio very much . . . however I strive to have a few trades with a very high probability of success . . . thus my b/e trades would skew my results to the negative side. My one break-even trade above was the second contract of the trade . . . I had already made 3 ticks on the first contract and broke even on the second contract . . . I consider that a winning trade on the two contract trade . . . I dont want to make this too complicated, however if there could be an option to have a "draw" option for b/e trades I would appreciate it, if it is too complicated then I will just interpolate it in my head . . .

All of the other questions I had in my previous post seem to have been fixed . . .

I will send along my spread sheet to you thru a PM . . . .

Thanks again for all of your hard work, I see a "final" at the end of the short tunnel ahead . . .


Last edited by rickr; January 15th, 2012 at 02:23 PM.
Reply With Quote
The following user says Thank You to rickr for this post:
 
  #494 (permalink)
Elite Member
Northern Germany
 
Futures Experience: Intermediate
Platform: NT
Favorite Futures: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,807 received


rickr View Post
vvhg,

when I opened ver 21 I had run-time err . . . when i selected debug lots of screens popped up . . . I am using Office 2010 so don't know if that has anything to do with it or not ?

FYI, I didn't know the read-me file existed because every time I opened the work-space the left tab was always the trading plan tab and I didn't think to try scrolling to the left ?

On the overview page Exit 2 . . . this is still showing 6 winners and 1 looser . . . I only had a total of six trades with an Exit 2 . . . I traded a total of 13 contracts on 7 trades . . . there were seven contracts at Exit 1 and six contracts at Exit 2 . . . of the six contracts at Exit 2, one was a break even trade . . . so under Exit 2 the values should be 5 winners at 83% and 1 looser at 17% . . . however please see my thinking below regarding counting a break-even trade as a looser. . .

If it is easily feasible to have "win" , "loose" and "draw" options in the calculations I would appreciate that feature as I do not consider a break-even trade to be a looser nor a winner . . . I know I have to pay commissions and there is a financial cost there . . . but I consider that a cost of doing business and not a flaw in my trading strategy . . . if I were a trader who executed a lot of trades, a b/e trade once in a while would not impact my win/loss ratio very much . . . however I strive to have a few trades with a very high probability of success . . . thus my b/e trades would skew my results to the negative side. My one break-even trade above was the second contract of the trade . . . I had already made 3 ticks on the first contract and broke even on the second contract . . . I consider that a winning trade on the two contract trade . . . I dont want to make this too complicated, however if there could be an option to have a "draw" option for b/e trades I would appreciate it, if it is too complicated then I will just interpolate it in my head . . .

All of the other questions I had in my previous post seem to have been fixed . . .

I will send along my spread sheet to you thru a PM . . . .

Thanks again for all of your hard work, I see a "final" at the end of the short tunnel ahead . . .

Thanks for your feedback.

First about the runtime error: when you select debug the vba editor opens, so it is normal that a lot of windows appear. What would really help is a screenshot of the error message and an other screenshot after you clicked debug, would help big time to chase that bug!

About the exit 2 calculations: it calculates correct, as it also draws the other trades into the calculation. The reason for that is as follows: imagine a strategy with two targets and one stop. If the stop gets hit, it is filed as exit 1 for faster entry of trades. If both targets get filled exit 1 and 2 are populated. With this system exit2 would only produce winners ( this is a bit oversimplified, but I think it should get my point across).

Adding an option for scratch trades would unfortunately require rebuilding most of the journal.....so I am sorry, but I won't do that.
I also see it that in real life it is seldomly the case that a trade is a net zero trade ( because commission is always part of the game) so either it is a winner or a looser. As you mentioned cost of doing business, I would argue that loosing trades are also cost of business as no trader or bot has a 100% win rate! So a loosing trades do by no means automatically mean that there is a flaw in your trading. They are just part of the game. So it doesn't really make a difference whether you file scratch trades as winners or loosers, as it wouldn't change the approach itself, neither would it change for example your expectancy and some other stats.

Vvhg


Sent from my iPad using Tapatalk HD

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
  #495 (permalink)
Elite Member
Northern Germany
 
Futures Experience: Intermediate
Platform: NT
Favorite Futures: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,807 received


madLyfe View Post
how is the journal going to hold up when importing trades from an earlier date than when the last recorded trade in the journal is?

Most will work, but the calculations involving time derived from these dates would obviously not work. The ones I could think of now would be return/day and year on overview as they are calculated using the elapsed timespan of 1st to last journal entry.

If I am not mistaken the rest should work fine.


Vvhg

Sent from my iPad using Tapatalk HD

Hic Rhodos, hic salta.
Reply With Quote
The following 2 users say Thank You to vvhg for this post:
 
  #496 (permalink)
Elite Member
Ghost Ranch NM
 
Futures Experience: Intermediate
Platform: NT / Rithmic
Broker/Data: Vision/Rithmic
Favorite Futures: NQ YM
 
Posts: 78 since Mar 2010
Thanks: 4,004 given, 53 received

What really happened ?

vvgh,

While I understand your statement "With this system exit2 would only produce winners" . . . please see the results of my fictional journal in the attached screen shots . . .

1. There are a total of ten trades
2. Five contracts for each trade
3. Nine trades have one target of 3 tics
4. The tenth trade has 3 targets as follows: 3 contracts at 3 tics, 1 contract at 8 tics, and 1 contract at break even . . .

Please observe my calculations under Result Exit 1, 2 & 3 on the Journal vs the Overview calculations . . . please note the calculation of "Average per Contract" . . . do you think this is a worthwhile addition for the over view tab ?

I think my calculations better reflect what really happened vs the overview calculations . . . what do you think ?

The problem of a stop getting hit could be solved by the manner in which data is entered . . . if it is a single target it would be entered in Exit 1, if it was a two target trade and stop is hit enter in Exit 1 & 2, three target etc . . . I am not a big fan of multiple data entry, but if it gives me a clearer picture of what happened I am willing to do that . . .

Regarding scratch trades, I fully understand your not wanting to, nor needing to, rebuild the journal . . . as to how we philosophically view scratch trades, I respectfully agree to disagree . . .

Thanks Again

Respectifully, Rick

Attached Thumbnails
Trading Metrics for journals/record keeping-test-1.png   Trading Metrics for journals/record keeping-test-2.png  

Last edited by rickr; January 16th, 2012 at 01:00 PM.
Reply With Quote
The following 2 users say Thank You to rickr for this post:
 
  #497 (permalink)
Elite Member
Northern Germany
 
Futures Experience: Intermediate
Platform: NT
Favorite Futures: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,807 received


rickr View Post
vvgh,

While I understand your statement "With this system exit2 would only produce winners" . . . please see the results of my fictional journal in the attached screen shots . . .

1. There are a total of ten trades
2. Five contracts for each trade
3. Nine trades have have one target of 3 tics
4. The tenth trade has 3 targets as follows: 3 contracts at 3 tics, 1 contract at 8 tics, and 1 contract at break even . . .

Please observe my calculations under Result Exit 1, 2 & 3 on the Journal vs the Overview calculations . . . please note the calculation of "Average per Contract" . . . do you think this is a worthwhile addition for the over view tab ?

I think my calculations better reflect what really happened vs the overview calculations . . . what do you think ?

I disagree, I'm afraid. I think the only two realistic possibilities are either the one you explained below, or the one I used in the journal. All I can say is that the one in the journal suits me well, that's why I chose it. I admit freely that the development of this journal was/is also undertaken by me to have a journal that suits my needs...


rickr View Post
The problem of a stop getting hit could be solved by the manner in which data is entered . . . if it is a single target it would be entered in Exit 1, if it was a two target trade and stop is hit enter in Exit 1 & 2, three target etc . . . I am not a big fan of multiple data entry, but if it gives me a clearer picture of what happened I am willing to do that . . .

I agree with you except for the last sentence(in this specific case) but I clearly see where you are coming from...I might have an idea how the golden middle will look like....


rickr View Post
Regarding scratch trades, I fully understand your not wanting to, nor needing to, rebuild the journal . . . as to how we philosophically view scratch trades, I respectfully agree to disagree . . .

Under the premises that we are talking about a rather philosophical issue, I agree to agree to the above statement...


vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following 4 users say Thank You to vvhg for this post:
 
  #498 (permalink)
Elite Member
Northern Germany
 
Futures Experience: Intermediate
Platform: NT
Favorite Futures: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,807 received

Test version with new features....better or worse?

Here is sth to try out:

Exit strategy can now be chosen on overview tab:
Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).


Obsolete columns on journal tabs get hidden automatically...

Works as follows:
Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).


Please tell me if it is better or worse than the old way!

vvhg

Hic Rhodos, hic salta.
Attached Files
Register to download File Type: rar Journal 2 .3beta23.rar (1.34 MB, 26 views)
Reply With Quote
The following 4 users say Thank You to vvhg for this post:
 
  #499 (permalink)
Elite Member
Northern Germany
 
Futures Experience: Intermediate
Platform: NT
Favorite Futures: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,807 received

Beta25

Working my way up to the release....

Minor improvements:
Expectancy on overview also shows ticks now (for exit1-3 and method these are estimated, for all trades and instrument it is exact.
Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).


Migration now also copies trading plan.

vvhg

Hic Rhodos, hic salta.
Attached Files
Register to download File Type: rar Journal 2 .3beta25.rar (1.34 MB, 31 views)
Reply With Quote
The following 4 users say Thank You to vvhg for this post:
 
  #500 (permalink)
Elite Member
Ghost Ranch NM
 
Futures Experience: Intermediate
Platform: NT / Rithmic
Broker/Data: Vision/Rithmic
Favorite Futures: NQ YM
 
Posts: 78 since Mar 2010
Thanks: 4,004 given, 53 received


Mo Better

Don't know how you figured out that exit strategy option but I am very grateful for your efforts . . .

above and beyond . . .

I owe you

thanks again, rickr

Reply With Quote
The following user says Thank You to rickr for this post:

Reply



futures io > > > Trading Metrics for journals/record keeping

Thread Tools Search this Thread
Search this Thread:

Advanced Search



Upcoming Webinars and Events (4:30PM ET unless noted)

Jigsaw Trading: TBA

Elite only

FuturesTrader71: TBA

Elite only

NinjaTrader: TBA

Jan 18

RandBots: TBA

Jan 23

GFF Brokers & CME Group: Futures & Bitcoin

Elite only

Adam Grimes: TBA

Elite only

Ran Aroussi: TBA

Elite only
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
Keeping it Simple Silver Dragon Trading Journals 26 September 19th, 2011 06:00 PM
Are there any journals that define a completely OBJECTIVE method? forrestang Psychology and Money Management 46 July 31st, 2011 02:07 AM
ZH0001YE'S Trading Journals zh0001ye Trading Journals 6 March 3rd, 2011 09:23 PM
reading journals rtrade Trading Journals 9 December 2nd, 2010 12:16 PM


All times are GMT -4. The time now is 08:34 PM.

Copyright © 2017 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
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.
no new posts
Page generated 2017-12-13 in 0.18 seconds with 20 queries on phoenix via your IP 54.160.245.121