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



Trading Metrics for journals/record keeping


Discussion in Psychology and Money Management

Updated
      Top Posters
    1. looks_one vvhg with 354 posts (687 thanks)
    2. looks_two madLyfe with 202 posts (104 thanks)
    3. looks_3 petrmac with 73 posts (105 thanks)
    4. looks_4 Big Mike with 35 posts (162 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 petrmac with 1.4 thanks per post
    1. trending_up 243,856 views
    2. thumb_up 1,487 thanks given
    3. group 224 followers
    1. forum 942 posts
    2. attach_file 252 attachments




Welcome to futures io: the largest futures trading community on the planet, with well over 125,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)
 Big Mike 
Site Administrator
Swing Trader
Data Scientist & DevOps
Manta, Ecuador
 
Experience: Advanced
Platform: Custom solution
Trading: Futures & Crypto
 
Big Mike's Avatar
 
Posts: 50,119 since Jun 2009
Thanks: 32,593 given, 98,697 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/

Visit other sites? Please spread the word about your experience with our community!
Follow me on Twitter Visit my futures io Trade Journal Started this thread Reply With Quote

Can you help answer these questions
from other members on futures io?
Looking for VisEMA indicator for NT7
NinjaTrader
S&P option chain data
Python, Pandas, Matlab/R
Using fxd files in FXCM trading station
Platforms and Indicators
you cant wait for life is not hard anymore before you de …
Psychology and Money Management
Driving Crazy please help: MUltichart bar closing event …
MultiCharts
 
 
(login for full post details)
  #3 (permalink)
 PandaWarrior 
In the heat
 
Experience: None
 
PandaWarrior's Avatar
 
Posts: 3,163 since Mar 2010
Thanks: 6,328 given, 13,387 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:	6130
Size:	499.7 KB
ID:	17806  
Attached Files
Register to download File Type: xls Basic System acct tracking.xls (340.5 KB, 2817 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, 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, Powdrpig, 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)
tortexal
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)
thetradinghermit
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)
 Big Mike 
Site Administrator
Swing Trader
Data Scientist & DevOps
Manta, Ecuador
 
Experience: Advanced
Platform: Custom solution
Trading: Futures & Crypto
 
Big Mike's Avatar
 
Posts: 50,119 since Jun 2009
Thanks: 32,593 given, 98,697 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/

Visit other sites? Please spread the word about your experience with our community!
Follow me on Twitter Visit my futures io Trade Journal Started this thread Reply With Quote
The following user says Thank You to Big Mike for this post:
 
(login for full post details)
  #7 (permalink)
 Trader.Jon 
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, 184 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)
thetradinghermit
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)
 Trader.Jon 
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, 184 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)
 Big Mike 
Site Administrator
Swing Trader
Data Scientist & DevOps
Manta, Ecuador
 
Experience: Advanced
Platform: Custom solution
Trading: Futures & Crypto
 
Big Mike's Avatar
 
Posts: 50,119 since Jun 2009
Thanks: 32,593 given, 98,697 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/

Visit other sites? Please spread the word about your experience with our community!
Follow me on Twitter Visit my futures io Trade Journal Started this thread 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


Last Updated on June 5, 2021


Upcoming Webinars and Events
 

NinjaTrader Indicator Challenge!

Ongoing

Your Trading Jekyll and Hyde w/Peter Davies @ Jigsaw Trading

Elite only
 

Our 12-year anniversary w/ $$,$$$ prizes (check soon)

June
     



Copyright © 2021 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada), 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