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

 
 
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


Big Mike View Post
I would like to talk about using R-Multiple.

On Trade #1, I risk $200. $200 is 1R. On Trade #2, I risk $250. $250 is 1R. Let's say in both cases, my profit is $400 on the trade. So profit on trade #1 is 2R, and profit on trade #2 is 1.6R.

Van Tharp suggests calculating all R-Multiples together (sum) then using that to find the median expectancy. I guess where I am getting hung up is that 1R is not always equal from trade to trade, as in my above example. What am I missing here? Don't I also need to factor in what 1R actually equals in terms of percentage risk to my account, as an anchor to the value?

Mike

One trade

For one trade the expectancy is a theoretical value, as it assumes probabilities for losing and winning. There is only one practical outcome, which is statistically insignificant, and you cannot calculate the expectancy without assuming ex-ante probabilities.

The R-multiple depends a bit on the mechanics of the trade. If you enter long for 2 contracts with a logical stop of -10 ticks, a 1st profit target of + 10 ticks with adjustment to breakeven, and a second profit target of +20 ticks, the outcome for a random market after a larger number of trades would be close to:

-10 ticks = 50%
+10 ticks = 25% (first contract)
+20 ticks = 12.5% (second contract splits between 0 and 20 ticks)
+- 0 ticks = 12.5%

The weighted reward-to-risk is (0.125*20 + 0.125*0 + 0.25*10)/ 0.5*10 = 5:5 = 1:1 Reward-to-risk is needed to calculate the edge of a trading system. The edge is the expectancy.

Expectancy = Average winner * Winning percentage - Average Loser * Losing percentage or by requiring a positive expectancy this equation can be transformed to

(1) R-Multiple > 1/winning percentage - 1

Example: If your winning percentage is 40%, your R-Multiple required to breakeven would be 1/0.4 -1 = 1.5 This example is before transaction cost and slippage. This is the easy part.

Many similar trades

If you have a larger number of similar trades, you can calculate a statistically based expectancy. This is based on an ex post probability which is a result of the trades. Note the difference with one trade.

If you are trading an automated system, always using the same stop and the same profit targets, you can calculate the correct reward-to-risk ratio by empirically counting the number of outcomes for each of the four possible results (I stay with my no-slippage model). The relative frequency of the outcomes is an approximation of the probability, and you can again calculate the reward-to-risk ratio by comparing the added positive outcomes with the added negative outcomes:

(2) R-Multiple = (added $ of winning trades/ number of winning trades)/ (added $ of losing trades/ number of losing trades)

Many different trades

If there are many different trades, you may want to evaluate them. For technical and other reasons your risk will sometimes be 2.3%, sometimes 1.4% of your account. I think that Van Tharp wants to make these trades comparable by not using the $$ outcome, but the outcome measured in multiples of R.

This is a way of normalizing the position sizing of the trades. If an undisciplined trader doubles position size and luckily wins, this for sure affects his account. In this case Van K Tharp - as I understand him - does not want to take into account the unduly increased position size, so he measures the outcome in terms of R achieved.

Now, there is a catch.

Expectancy

The idea of calculating an average R-Multiple is mathematical nonsense. But it can be a valid educational concept. The expectancy can only be calculated by taking into account both winning percentage and R-Multiple. A scalper with a high winning percentage does not need high R-multiples, as he relies on a hihg winning percentage. The high winning percentage will even allow him to increase his position sizing, because the probability of a larger drawdown is reduced. The scalper may actually tolerate a higher risk per trade, without increasing the risk of ruin*).

So why does Van Tharp calculate R-multiples?

Psychological Barriers

Most beginning traders do not let their profits run, and achieve bad R-Multiples. You will find some journals here that show R-multiples < 1. It is psychologically easy to take a quick profit, and have a large loss every 5 trades. You are emotionally rewarded with 4 successes and only 1 failure! Van Tharp uses this method as a way to monitor the trader's performance to cope with loss aversion and not letting profits run.

It is an educational tool

And there is another reason to use this method. To complete evaluate a trader's edge you would need to know the winning percentage and the R-multiple. To get a good approximation for the winning percentage, you would need something like 100 trades if you search for statistical significance. So you cannot give the trader immediate feedback on his performance. The R-Mulitple can be used even after 1 trade and is significant. So it is a concept that can be used to train traders.

Why does he choose the median?

He could choose the arithmetic average, the geometric average, the median, the mode, etc. No importance, the median can be observed without calculating anything.

And the mathematics?

There is little valid mathematics in the books of Van K Tharp. If you are really intested in the subject you should start with "The Mathematics of Money Management" by Ralph Vince. Not an easy read though, but very important. I am slowly digging through this, interrupted again and again by other priorities.

*) not known by many traders: Let us assume two trading systems:

system 1: winning percentage 70%, R-Multiple = 2
system 2: winning percentage 42%, R-Multiple = 4

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.

Who is able to calculate the position sizing for the 1st system relative to the 2nd, so that the risk of ruin becomes equal?


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
 
 
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,398 since Jun 2009
Thanks Given: 33,173
Thanks Received: 101,537

I found this on the interwebs, it has some good functions in it for risk (R-Multiples, SQN, Expectancy, MAE, exit efficiency) etc.

I'm still working on my own new journal.

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 Thumbnails
Click image for larger version

Name:	8-19-2010 4-25-05 PM.jpg
Views:	1933
Size:	472.4 KB
ID:	18863  
Attached Files
Elite Membership required to download: Trade-Sheet-V-4.7.xlsx
Follow me on Twitter Visit my NexusFi Trade Journal Started this thread
 
 
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,398 since Jun 2009
Thanks Given: 33,173
Thanks Received: 101,537


Here are some screen shots of the new journal I am working on. Thanks goes to @sam028 and @Gary for helping me with some of it.

The basic idea is an Overview panel that shows me at a glance some meaningful statistics. I still have a lot of work to do on this, so the screen shot is not complete. The idea is to be able to breakdown stats by Method (entry) and also by result (Comment field), so I can see how methods compare, and also I can track 'Comment' like followed rules/not followed rules, or any other comment I want, and see how stats breakdown. There are not many sample trades entered in this journal yet, so some pages appear empty.

The Journal panel is for data entry. Most fields are auto-populated. Just need to enter the date/time, instrument (from drop-down choice), method (drop-down choice), entry/exit price. I have VWAP here because I want to conduct a study to determine if tracking VWAP in relation to my trades is important -- stats on the Overview page reflect this, am I more successful longing above VWAP, more successful shorting below, etc? This will allow me to track that. MAE is self-explanatory. The Bench field is what I call benchmark, it is the absolute best-case scenario for a trade. If I exited at the absolute best tick possible during this trade while following my rules, I would get <xx> ticks. The next field is efficiency, it measures my actual realized exit compared with the benchmark. Minutes tracks how long the trade was, so I can breakdown my average winner and loser in minutes (on overview page). Risk, Result, Balance are self-explanatory. The Comment field will allow me to enter a few 'scenarios' perhaps and track each uniquely, getting stats per scenario. The rest of the fields are just there to make formulas easier, they are all automatic.

The Method List allows you to enter new methods that will appear automatically in the drop-down menu and the rest of the spreadsheet.

The Comment List is the same way.

The Instrument List is the same, and is necessary to define tick values and such so math calculations can be done correctly on the Journal tab.

The Internal Calcs tab/panel is just for behind-the-scenes formulas that are necessary to create some of the results in the Overview page, like the trade result per hour breakdown, the annualized returns, etc.

I will post the spreadsheet when I consider it 'ready'. I welcome feedback with what I have so far.

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 Thumbnails
Click image for larger version

Name:	8-21-2010 12-50-03 PM.jpg
Views:	1902
Size:	262.9 KB
ID:	18949   Click image for larger version

Name:	8-21-2010 12-55-20 PM.jpg
Views:	1360
Size:	242.9 KB
ID:	18950   Click image for larger version

Name:	8-21-2010 12-51-06 PM.jpg
Views:	1152
Size:	22.1 KB
ID:	18951   Click image for larger version

Name:	8-21-2010 12-51-26 PM.jpg
Views:	1108
Size:	38.4 KB
ID:	18952   Click image for larger version

Name:	8-21-2010 12-51-40 PM.jpg
Views:	1036
Size:	38.1 KB
ID:	18953  
Follow me on Twitter Visit my NexusFi Trade Journal Started this thread
 
 
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

Looks brilliant, I will stop all my efforts in this area, and wait until you're ready. But of course, post any later improvements, if this is still possible.

Thanked by:
 
 
TraderJesse's Avatar
 TraderJesse 
Denver
 
Experience: None
Platform: NinjaTrader
Posts: 85 since Aug 2009
Thanks Given: 51
Thanks Received: 95

BigMike:

You might be able to import from the following to save some typing on the instrument list.


Thanked by:
 
 
Trader.Jon's Avatar
 Trader.Jon 
Near the BEuTiFULL Horse Shoe
 
Experience: Beginner
Platform: NinjaTrader
Broker: MBTrading Dukascopy ZenFire
Trading: $EURUSD when it is trending
Posts: 473 since Jul 2009
Thanks Given: 401
Thanks Received: 184


Big Mike View Post
Here are some screen shots of the new journal I am working on. Thanks goes to @sam028 and @Gary for helping me with some of it.

The basic idea is an Overview panel that shows me at a glance some meaningful statistics. I still have a lot of work to do on this, ....
Mike

Mike,

This is excellent for assisting with discretionary trading. I know you have a keen interest in the 'state of mind' && 'state of health' when you are trading ... do you intend to incorporate those as inputs for a later version?

Jon

Thanked by:
 
 
trendisyourfriend's Avatar
 trendisyourfriend 
Quebec Canada
Market Wizard
 
Experience: Intermediate
Platform: NinjaTrader
Broker: AMP/CQG
Trading: ES, NQ, YM
Frequency: Daily
Duration: Minutes
Posts: 4,527 since Oct 2009
Thanks Given: 4,171
Thanks Received: 6,018

BigMike, i don't want to make free publicity and i know every programmer like to recreate the wheel but have you considered this tool $57 ?

Trading Journal Spreadsheet - Trade Tracking for Traders

Maybe you could get inspired too.

There is this other tool too:
- | Y o u r T r a d i n g J o u r n a l | -


I post them just for inspiration as i know you'll prefer to build your own from scratch
(i know as i was a programmer before)

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,398 since Jun 2009
Thanks Given: 33,173
Thanks Received: 101,537


Trader.Jon View Post
Mike,

This is excellent for assisting with discretionary trading. I know you have a keen interest in the 'state of mind' && 'state of health' when you are trading ... do you intend to incorporate those as inputs for a later version?

Jon

Yes, the 'comments' block will be where I tag each trade with relevant info to help me track such things.


trendisyourfriend View Post
BigMike, i don't want to make free publicity and i know every programmer like to recreate the wheel but have you considered this tool $57 ?

Trading Journal Spreadsheet - Trade Tracking for Traders

Maybe you could get inspired too.

There is this other tool too:
- | Y o u r T r a d i n g J o u r n a l | -


I post them just for inspiration as i know you'll prefer to build your own from scratch
(i know as i was a programmer before)

I will look at them to see if I can add anything useful to mine. The second link, I tried this last year and ran into too many technical problems. I actually still have a membership there, it was comped gratis due to the issues. But, I prefer my spreadsheet.

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:
 
 
Trader.Jon's Avatar
 Trader.Jon 
Near the BEuTiFULL Horse Shoe
 
Experience: Beginner
Platform: NinjaTrader
Broker: MBTrading Dukascopy ZenFire
Trading: $EURUSD when it is trending
Posts: 473 since Jul 2009
Thanks Given: 401
Thanks Received: 184


Big Mike View Post
Yes, the 'comments' block will be where I tag each trade with relevant info to help me track such things....

Mike

So, more than one comment can be tagged for each trade? C@@L

TJ

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,398 since Jun 2009
Thanks Given: 33,173
Thanks Received: 101,537



Trader.Jon View Post
So, more than one comment can be tagged for each trade? C@@L

TJ

No not at present. But I could have a list of pre-defined comments that should cover enough range to give me post-trade analysis info. There are two fields to classify or categorize trades, the 'method' and 'comment' field. More could be added, but this is enough for me.

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:

 



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