Trading Metrics for journals/record keeping - futures io
futures io futures trading



Trading Metrics for journals/record keeping


Discussion in Psychology and Money Management

Updated by kremat0r
      Top Posters
    1. looks_one vvhg with 354 posts (685 thanks)
    2. looks_two madLyfe with 202 posts (104 thanks)
    3. looks_3 petrmac with 73 posts (103 thanks)
    4. looks_4 Big Mike with 35 posts (161 thanks)
      Best Posters
    1. looks_one PandaWarrior with 71.5 thanks per post
    2. looks_two Big Mike with 4.6 thanks per post
    3. looks_3 vvhg with 1.9 thanks per post
    4. looks_4 madLyfe with 0.5 thanks per post
    1. trending_up 218,501 views
    2. thumb_up 1,481 thanks given
    3. group 219 followers
    1. forum 940 replies
    2. attach_file 252 attachments




Welcome to futures io: the largest futures trading community on the planet, with well over 100,000 members
  • Genuine reviews from real traders, not fake reviews from stealth vendors
  • Quality education from leading professional traders
  • We are a friendly, helpful, and positive community
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts
  • We are here to help, just let us know what you need
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

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

 
Search this Thread
 

Trading Metrics for journals/record keeping

(login for full post details)
  #1 (permalink)
Site Administrator
Manta, Ecuador
 
Experience: Advanced
Platform: My own custom solution
Trading: Emini Futures
 
Big Mike's Avatar
 
Posts: 48,896 since Jun 2009
Thanks: 31,580 given, 94,510 received

I'm on a mission to improve my Excel trade journal.

I'd like to hear input on what metrics you guys measure in your journal. For instance:
  • Sharpe ratio
  • Expectancy
  • Win/Loss Dollar Ratio
  • Win Percentage
  • Dollar gain per trade put on
  • Account balance
  • Risk % per trade
  • Maximum drawdown
  • Realized MAE/MFE
  • Unrealized MFE (benchmark potential)

I was reading Brett's "Enhancing Traders Performance" book and it gave me the idea to consider categorizing days themselves, like uptrend, downtrend, reversal day, range bound, etc. I was wondering, do any of you guys do this and what have you found?

Mike

We're here to help -- just ask

For the best trading education, watch our webinars
Searching for trading reviews? Review this list

Follow us on Twitter, YouTube, and Facebook

Support our community as an Elite Member:
https://futures.io/elite/
Follow me on Twitter Visit my Facebook Visit my futures io Trade Journal Reply With Quote

Can you help answer these questions
from other members on futures io?
Volume Chart Trend Lines
TradeStation
highest high help
NinjaTrader
Chart text fixed and move with time
NinjaTrader
How to place an order where the stop loss price changes when a price is touched
TradeStation
FYI plot bug & workaround: changing color or width is delayed 1 bar
EasyLanguage Programming
 
 
(login for full post details)
  #3 (permalink)
In the heat
 
Experience: None
Platform: Tradeovate
Trading: Energy
 
PandaWarrior's Avatar
 
Posts: 3,162 since Mar 2010
Thanks: 6,324 given, 13,368 received



Big Mike View Post
I'm on a mission to improve my Excel trade journal.

I'd like to hear input on what metrics you guys measure in your journal. For instance:
  • Sharpe ratio
  • Expectancy
  • Win/Loss Dollar Ratio
  • Win Percentage
  • Dollar gain per trade put on
  • Account balance
  • Risk % per trade
  • Maximum drawdown
  • Realized MAE/MFE
  • Unrealized MFE (benchmark potential)

I was reading Brett's "Enhancing Traders Performance" book and it gave me the idea to consider categorizing days themselves, like uptrend, downtrend, reversal day, range bound, etc. I was wondering, do any of you guys do this and what have you found?

Mike

I've attached a copy of my spreadsheet....as well as screen shot. Feel free to copy at will. I am sure mine is pretty rudimentary compared to some but I am making it available just the same.

I will be making more enhancements as time goes by, for instance I have a column for risk per trade, currently I just jam in a default 10 ticks. I want to actually put in the original stop in this column but so far, this has proved elusive. In time, I think this will be valuable piece of information. The MSA software tracks this as well I think.

Simplicity is the ultimate sophistication, Leonardo da Vinci


Most people chose unhappiness over uncertainty, Tim Ferris
Attached Thumbnails
Click image for larger version

Name:	30 July Income Excel.jpg
Views:	5444
Size:	499.7 KB
ID:	17806  
Attached Files
Register to download File Type: xls Basic System acct tracking.xls (340.5 KB, 2698 views)
Reply With Quote
The following 141 users say Thank You to PandaWarrior for this post:
0bl1vion, 6E hopeful, AAtrader, adcum, Aktie, Alan, Albnd, alejo, alemandiego, Anatta, angchuande, Angel, arjfca, Arpad, AttitudeTrader, baristarick, beetrader, belekas, Bermudan Option, Big Mike, BJNagel, blang, blindtrader, bob5e, br8080, brwdbill, cal1152, Cayuga, chalupsky, cheznazi, CobblersAwls, Cogito ergo sum, cpanderson, CurtisC, cvphuoc, DaveTrading, David_R, daytrader07, DayTraderEd, dmeachy, dotmag, dqbuzz, drunkcolonel, dwntik5454, eclipsemf, eminijalapeno, Endgrainjim, erk53, falconpilot, Fat Tails, fctrader, fibfisherman, ftn1989, Fu510n, futurewiz, Gabriyele, Ganymed, Gary, garysu, gever17, gordo, Hatrick28, hector2, heiermonster, iqgod, isatrader, itsallinthemind, Jaba, JackJohn, jhobbs92, JKODA, Jogoreshi, johnnolte, JohnS, jose, joselopezde, Josephine268, kanepa, listu, Locust, Malthus, maman, manuil, matevisky, Meecc, Mightynorsman, mihaizn, MrBluecat, MTCTrades, n3xtl3v3l, nicoet, ocmsrzr, OldGerman, Onisowo, PBTrader, Pipnatized, Popsicle, Portland, project belgrade, rainbowchaser, Reddingcrudetrade, rgmattson, RichardHK, RideTheCurve, rossco, RUtrading, sabot7726, sam028, Sam21, SatchFan, SeeTrader, sharmas, Silver Dragon, smbkmb, snakedoctor, Sniff, Spike13, suko, sumanth365, swinger, tagem777, Tasi, TempletonPeck, TheShrike, tomas262, Trader.Jon, Trader146, traderbaker, traderfw, Tradert, tradingatLarge, TradingSebi, trendisyourfriend, tturner86, txsroper, vegasjolla, VinceVirgil, websouth, wiztrader, wwlacey, Ykarius
 
(login for full post details)
  #4 (permalink)
Panama!
 
 
Posts: 44 since Jun 2009
Thanks: 1 given, 24 received

system quality number is interesting to look at:
(sqrt(total trades) *avg net profit)/stdev of net profit

the higher the number the better which translates into higher net profits w/ lower stdev of returns, ie consistent profitability

Reply With Quote
The following 9 users say Thank You to tortexal for this post:
 
(login for full post details)
  #5 (permalink)
Global Citizen
 
 
Posts: 3 since Jul 2010
Thanks: 1 given, 22 received

Hey Mike,

Congrats on the forum, I think it is one of the better trading forums I have come across, and I've seen my fair share. As to what I measure in terms of performance, besides the items you have, I also include the following in an excel file i've designed myself over the years:

  • Profit per day, month, quarter and annually, with the ability to provide filtered results instantly;
  • # of Trades
  • Trade Class/Type based on my trading system (eg, may have 'A' class trend continuation, 'B' class breakout, 'C' Reversal, etc...
  • # winners/losers per Class/Type
  • Trade Batting Average (winners to losers as above)
  • Average winning/losing trade amount ($ & R multiple)
  • Largest winning/losing trades
  • Average consecutive winners/losers
  • Largest consecutive winners/loser
  • Average winning/losing trade time
  • Average winning/losing trade - time of orders
  • Winning/losing periods (eg opening bell vs morning vs lunch vs afternoon vs close)
  • Winners to losers per Instrument
  • Average winner/loser per instrument
  • Average time in trade per instrument
  • Equity Curve per instrument and portfolio (see how my own trend is going )
  • Equity Curve vs Weekly Review Score (my own system for rating myself on trades, including completion of non-trading items each day) Essentially finding my profits go up when i complete all my tasks...
  • Average winner per trade rating (rating given based on performance criteria in each trade, detailing observation and monitoring of market, trade setup recognition, entry and execution, trade monitoring, trade exit, post trade analysis, etc...)
  • Profit/Loss Average per day of week (eg - do i trade well on Friday vs Monday)
  • Profit/Loss Average per session per day


There's a few other things i measure, but i won't go into detail as it probably isn't relevant to anyone except my strange self....


Hope this helps in some way...


The Hermit...

Reply With Quote
The following 17 users say Thank You to thetradinghermit for this post:
 
(login for full post details)
  #6 (permalink)
Site Administrator
Manta, Ecuador
 
Experience: Advanced
Platform: My own custom solution
Trading: Emini Futures
 
Big Mike's Avatar
 
Posts: 48,896 since Jun 2009
Thanks: 31,580 given, 94,510 received


thetradinghermit View Post
Hey Mike,

Congrats on the forum, I think it is one of the better trading forums I have come across, and I've seen my fair share. As to what I measure in terms of performance, besides the items you have, I also include the following in an excel file i've designed myself over the years:



Good list, care to attach the Excel file?

Mike

We're here to help -- just ask

For the best trading education, watch our webinars
Searching for trading reviews? Review this list

Follow us on Twitter, YouTube, and Facebook

Support our community as an Elite Member:
https://futures.io/elite/
Follow me on Twitter Visit my Facebook Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to Big Mike for this post:
 
(login for full post details)
  #7 (permalink)
Near the BEuTiFULL Horse Shoe
 
Experience: Beginner
Platform: NinjaTrader
Broker: MBTrading Dukascopy ZenFire
Trading: $EURUSD when it is trending
 
Trader.Jon's Avatar
 
Posts: 500 since Jul 2009
Thanks: 401 given, 183 received


Big Mike View Post


Good list, care to attach the Excel file?

Mike


thetradinghermit View Post
Hey Mike,..., I also include the following in an excel file i've designed myself over the years:

  • Profit per day, month, quarter and annually, with the ability to provide filtered results instantly;
  • # of Trades
  • Trade Class/Type based on my trading system (eg, may have 'A' class trend continuation, 'B' class breakout, 'C' Reversal, etc...
  • # winners/losers per Class/Type
  • Trade Batting Average (winners to losers as above)
  • Average winning/losing trade amount ($ & R multiple)
  • Largest winning/losing trades
  • Average consecutive winners/losers
  • Largest consecutive winners/loser
  • Average winning/losing trade time
  • Average winning/losing trade - time of orders
  • Winning/losing periods (eg opening bell vs morning vs lunch vs afternoon vs close)
  • Winners to losers per Instrument
  • Average winner/loser per instrument
  • Average time in trade per instrument
  • Equity Curve per instrument and portfolio (see how my own trend is going )
  • Equity Curve vs Weekly Review Score (my own system for rating myself on trades, including completion of non-trading items each day) Essentially finding my profits go up when i complete all my tasks...
  • Average winner per trade rating (rating given based on performance criteria in each trade, detailing observation and monitoring of market, trade setup recognition, entry and execution, trade monitoring, trade exit, post trade analysis, etc...)
  • Profit/Loss Average per day of week (eg - do i trade well on Friday vs Monday)
  • Profit/Loss Average per session per day


There's a few other things i measure, but i won't go into detail as it probably isn't relevant to anyone except my strange self....


Hope this helps in some way...


The Hermit...

Hermit,

I second the request ..... VERY MUCH PLEASE would you share the spreadsheet ? You have put a lot of thought and expertise in that ... I hope we all here can develop it even further with input and work.

Jon

Reply With Quote
The following 3 users say Thank You to Trader.Jon for this post:
 
(login for full post details)
  #8 (permalink)
Global Citizen
 
 
Posts: 3 since Jul 2010
Thanks: 1 given, 22 received

Hey lads,

Am in the process of rejigging all my trading items this week in an effort to simplify and remember why i started trading all that time ago. My worksheets are just a part of that, but hoping to cull my trading plan from the bloated 70+ pages it currently sits at to about 5-10 pages max. Will be more than happy to upload my worksheets when i've made the necessary adjustment, as right now it's been in the "chop shop" for about a week.

Give me about a week and will gladly post it up...

the hermit

Reply With Quote
The following 2 users say Thank You to thetradinghermit for this post:
 
(login for full post details)
  #9 (permalink)
Near the BEuTiFULL Horse Shoe
 
Experience: Beginner
Platform: NinjaTrader
Broker: MBTrading Dukascopy ZenFire
Trading: $EURUSD when it is trending
 
Trader.Jon's Avatar
 
Posts: 500 since Jul 2009
Thanks: 401 given, 183 received


thetradinghermit View Post
Hey lads,

Am in the process of rejigging all my trading items this week in an effort to simplify and remember why i started trading all that time ago. My worksheets are just a part of that, but hoping to cull my trading plan from the bloated 70+ pages it currently sits at to about 5-10 pages max. Will be more than happy to upload my worksheets when i've made the necessary adjustment, as right now it's been in the "chop shop" for about a week.

Give me about a week and will gladly post it up...

the hermit


Wow ... I can empathize with that feeling ..

My situation is nowhere as massive, unless I think of different strategy iniatives as I look in my custom folders

... lol ..


Good speed with the culling and look forward to the result for you and your ability to enjoy your trading, and also to share it with us!

Thanks!!
Jon

Reply With Quote
 
(login for full post details)
  #10 (permalink)
Site Administrator
Manta, Ecuador
 
Experience: Advanced
Platform: My own custom solution
Trading: Emini Futures
 
Big Mike's Avatar
 
Posts: 48,896 since Jun 2009
Thanks: 31,580 given, 94,510 received


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

We're here to help -- just ask

For the best trading education, watch our webinars
Searching for trading reviews? Review this list

Follow us on Twitter, YouTube, and Facebook

Support our community as an Elite Member:
https://futures.io/elite/
Follow me on Twitter Visit my Facebook Visit my futures io Trade Journal Reply With Quote
The following 6 users say Thank You to Big Mike for this post:


futures io Trading Community Psychology and Money Management > Trading Metrics for journals/record keeping


April 29, 2020


Upcoming Webinars and Events
 

Every journal equals ten meals for the hungry

Now
     



Copyright © 2020 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