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

 
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,396 since Jun 2009
Thanks Given: 33,172
Thanks Received: 101,537


rassi View Post
Yo Mike, hit us up with those metrics, been hanging out for them !

Yeah sorry, have had no time to work on it yet.

Mike

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Started this thread
Thanked by:

Can you help answer these questions
from other members on NexusFi?
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
NexusFi Journal Challenge - April 2024
Feedback and Announcements
Better Renko Gaps
The Elite Circle
ZombieSqueeze
Platforms and Indicators
Exit Strategy
NinjaTrader
 
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
39 thanks
NexusFi site changelog and issues/problem reporting
26 thanks
The Program
18 thanks
GFIs1 1 DAX trade per day journal
18 thanks
 
 
gabga100's Avatar
 gabga100 
New York
 
Experience: Advanced
Platform: NT
Posts: 147 since Nov 2009
Thanks Given: 44
Thanks Received: 72


Fat Tails View Post
One trade


Both systems have the same expectancy of 1.1R (which is excellent, 0R stands for break-even). However, the first system has a better Sharpe Ratio, so you can actually trade it with a larger position sizing, without increasing your actual risk (measured in terms of max. drawdown).

Note that mathematics is in contradiction with the methods of Van Tharp.


Why do you think they are in contradiction ? SQN also includes a standard deviation consideration so a high win rate will implicitly be favored => under the constraint of an optimal average size

You know what you know but you do not know what you do not know.
You do not see things how they are, you see things how you are.
In life you do what you want but you do not want what you want.
Thanked by:
 
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader, MultiCharts
Broker: Interactive Brokers
Trading: Keyboard
Posts: 9,888 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,102



gabga100 View Post
Why do you think they are in contradiction ? SQN also includes a standard deviation consideration so a high win rate will implicitly be favored => under the constraint of an optimal average size

Being a foreigner I have a hard time to understand all those abbreviations, no idea what you mean with SQN.

Van Tharp teaches his students to look for larger R-Multiples. This points to a lower percentage of winning trades. This also increases the probability of larger drawdowns, if you compare this to an alternating approach that achieves the same expectancy with a higher win rate but lower R-Multiples.

As the number of contracts that you can trade is related to the max. expected drawdown, you may trade a higher number of contracts for the same risk of ruin.

There are several reasons that Van Tharp recommends to trade high R-multiples

(a) The R-Multiple is known for each trade setup, the win rate is unknown.

(b) Letting your profits run is counterintuitive. With a defined R-Multiple you can monitor your impulse to close out your winning trades too early.

(c) An unfavourable R-Multiple allows you to skip a trade.

This is valid for discretionary trading. If I was a systems trader, I would look for strategies with a win rate as high as possible, taking into account a low R-Multiple. This would allow me to trade size for the same risk.

 
 
gabga100's Avatar
 gabga100 
New York
 
Experience: Advanced
Platform: NT
Posts: 147 since Nov 2009
Thanks Given: 44
Thanks Received: 72


Fat Tails View Post
Being a foreigner I have a hard time to understand all those abbreviations, no idea what you mean with SQN.

SQN = System quality Number = Average Profit per trade * SquareRoot(NumberTrades)/Standard Deviation of Profit per trade


"let your profits run" worked before when a strategy was not backtestable , now that we have this very powerful tool there is no sense anymore to trade without knowing exactly what happened in the past .... not that th situation will repat itself, but I am convinced that knowing the odds is a great statistical edge ...

You know what you know but you do not know what you do not know.
You do not see things how they are, you see things how you are.
In life you do what you want but you do not want what you want.
 
 
tigertrader's Avatar
 tigertrader 
Philly, Pa
Legendary Market Wizard
 
Experience: Master
Platform: NinjaTrader
Trading: ES, ZB
Posts: 6,482 since Jul 2010
Thanks Given: 6,662
Thanks Received: 36,257

you might be interested in Trader DNA...
TraderDNA - Performance Analysis for Active Traders

Follow me on Twitter
Thanked by:
 
 
PTG1's Avatar
 PTG1 
Nijmegen, NL
 
Experience: Intermediate
Platform: Sierra Chart, JForex
Broker: TP Futures, Sierra Chart data feed
Trading: 6E,6B,ES
Posts: 31 since Sep 2009
Thanks Given: 9
Thanks Received: 15


Big Mike View Post
Yes, I will. I haven't had time this week to make any progress on it unfortunately.

Mike


Quoting 
@ Big Mike, are you planning on making your spreadsheet available when you are satisfied with it? I took a look at your beta version screen shot and I really like it......just curious.
Mike

Mike, have you actually released something yet ?


If it requires a uniform, it’s a worthless endeavor. - GC
Thanked by:
 
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,396 since Jun 2009
Thanks Given: 33,172
Thanks Received: 101,537

Here is where I left off on this project (attached). Needs some work, I've just had zero time lately to do it. Lots of calculations so it takes a second to open.

Please be certain to re-post if you finish it.

Mike

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Attached Files
Elite Membership required to download: BMT Trading Journal.xlsx
Follow me on Twitter Visit my NexusFi Trade Journal Started this thread
 
 
PTG1's Avatar
 PTG1 
Nijmegen, NL
 
Experience: Intermediate
Platform: Sierra Chart, JForex
Broker: TP Futures, Sierra Chart data feed
Trading: 6E,6B,ES
Posts: 31 since Sep 2009
Thanks Given: 9
Thanks Received: 15


Big Mike View Post
Here is where I left off on this project (attached). Needs some work, I've just had zero time lately to do it. Lots of calculations so it takes a second to open.

Please be certain to re-post if you finish it.

Mike

Will do, thanks !


If it requires a uniform, it’s a worthless endeavor. - GC
Thanked by:
 
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,396 since Jun 2009
Thanks Given: 33,172
Thanks Received: 101,537


tigertrader View Post
you might be interested in Trader DNA...
TraderDNA - Performance Analysis for Active Traders

Thanks, looks interesting.

Mike

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Started this thread
Thanked by:
 
 
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


Hello Big Mike,

thanks for the great journal template. Though I could'nt resist fiddling around with it a bit.
I hope you don't mind, otherwise I will delete the attachment of course.
It now calculates up to three exits (calc based on one contract each, could be easily changed though). Big Mike, thought you might like this!
All user input fields/columns are marked green.
Added some psychologically interesting stats (light blue fields in overview).
Added column for comments (no drop down list).
Simplified rules column (now only two options, whether trade worked or not is calculated automatically).
Would be possible to refine that (grading) if anyone needs it I'll be happy to do that.
Expectancy calculation seemed to have a sign error (please double check whether it is corrected now (might be that I am wrong here)).
Protected sheets so that no formula gets changed by mistake (no password).

v

Attached Thumbnails
Click image for larger version

Name:	JournalScreenshot.JPG
Views:	954
Size:	240.5 KB
ID:	32891  
Attached Files
Elite Membership required to download: Copy of BMT Trading Journal.xlsx

 



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