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


Trading Metrics for journals/record keeping
Updated: Views / Replies:153,910 / 919
Created: by Big Mike Attachments:250

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 don’t 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
 250  
 
Thread Tools Search this Thread
 

Trading Metrics for journals/record keeping

  #1 (permalink)
Site Administrator
Manta, Ecuador
 
Futures Experience: Advanced
Platform: My own custom solution
Favorite Futures: E-mini ES S&P 500
 
Big Mike's Avatar
 
Posts: 45,947 since Jun 2009
Thanks: 29,139 given, 81,896 received

Trading Metrics for journals/record keeping

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

Due to time constraints, please do not PM me if your question can be resolved or answered on the forum.

Need help?
1) Stop changing things. No new indicators, charts, or methods. Be consistent with what is in front of you first.
2) Start a journal and post to it daily with the trades you made to show your strengths and weaknesses.
3) Set goals for yourself to reach daily. Make them about how you trade, not how much money you make.
4) Accept responsibility for your actions. Stop looking elsewhere to explain away poor performance.
5) Where to start as a trader? Watch this webinar and read this thread for hundreds of questions and answers.
6)
Help using the forum? Watch this video to learn general tips on using the site.

If you want
to support our community, become an Elite Member.

Reply With Quote
 
  #2 (permalink)
Quick Summary
Quick Summary Post

Latest version can be found HERE **Updated 5-13-2013
Latest BETA can be found HERE (my betas are often VERY buggy, vvhg)

To start fresh
Before you start, make sure any sheet you make changes to is protected (if not it's very likely you will break sth). If it is you can't delete any formulas which is quite important.
Then delete the trade records in the journal tab (they are just there to show the functions so you can play around with them).
If you get error messages you probably try to delete protected cells.
Next go to the instrument list tab and change the data in there to the instruments you trade.
Next go to the method list tab and change the methods to what you want.
next go to Overview tab and type in your starting account balance.

Migration/Compatibility:

To migrate your old journal to a new version use the "Import Old Journal" button on Overview tab, it will ask for the old journal to import.
Migration can be used from v1.6.8, but from v1.6.8 - v2.0.8 will break the table on "Instrument List" tab, this has to be fixed after migration (copy paste from untouched release).
Migrating from versions later than v2.0.8 should be a smooth ride...

From even older versions:
See HERE and next posts.

@petrmacs importer:

Latest version can be found HERE.

Just a couple of lines here:
1. export the trades from the NT (Account Performance -> Trades). Use the currency or points setting and then right click on the grid and Save as CSV file
2. Open the tool and import (more info on settings coming soon)
3. The tool allows to save either as a new file or append to existing




vvhg


Last edited by tturner86; June 30th, 2014 at 06:56 PM.
 
  #3 (permalink)
Elite Member
In the heat
 
Futures Experience: None
Platform: NT
Favorite Futures: Energy
 
PandaWarrior's Avatar
 
Posts: 3,155 since Mar 2010
Thanks: 6,306 given, 13,230 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
Trading Metrics for journals/record keeping-30-july-income-excel.jpg  
Attached Files
Register to download File Type: xls Basic System acct tracking.xls (340.5 KB, 2200 views)
Reply With Quote
The following 122 users say Thank You to PandaWarrior for this post:
0bl1vion, AAtrader, adcum, Aktie, Alan, Albnd, alejo, alemandiego, Anatta, angchuande, Angel, Arpad, AttitudeTrader, baristarick, beetrader, Bermudan Option, Big Mike, blang, blindtrader, bob5e, br8080, cal1152, Cayuga, chalupsky, cheznazi, CobblersAwls, Cogito ergo sum, cpanderson, DaveTrading, David_R, daytrader07, DayTraderEd, dmeachy, dqbuzz, drunkcolonel, dwntik5454, eclipsemf, eminijalapeno, Endgrainjim, erk53, falconpilot, Fat Tails, fctrader, fibfisherman, ftn1989, Fu510n, Gabriyele, Ganymed, Gary, garysu, gever17, gordo, Hatrick28, heiermonster, iqgod, isatrader, itsallinthemind, Jaba, JackJohn, jhobbs92, JKODA, Jogoreshi, johnnolte, JohnS, jose, joselopezde, Josephine268, listu, Locust, manuil, matevisky, Meecc, Mightynorsman, mihaizn, MrBluecat, nicoet, ocmsrzr, 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, swinger, tagem777, Tasi, TempletonPeck, TheShrike, tomas262, Trader.Jon, Trader146, traderbaker, traderfw, Tradert, tradingatLarge, TradingSebi, trendisyourfriend, tturner86, vegasjolla, VinceVirgil, websouth, wiztrader, wwlacey, Ykarius
 
  #4 (permalink)
Member
Panama!
 
Futures Experience: None
Platform: Hit the Bid!
 
Posts: 44 since Jun 2009
Thanks: 1 given, 22 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 8 users say Thank You to tortexal for this post:
 
  #5 (permalink)
Just starting out...
Global Citizen
 
Futures Experience: Advanced
Platform: Multicharts, Ninjatrader, Metastock, Tradestation
Favorite Futures: ES, ESTX50, GBP/JPY
 
thetradinghermit's Avatar
 
Posts: 3 since Jul 2010
Thanks: 1 given, 17 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 13 users say Thank You to thetradinghermit for this post:
 
  #6 (permalink)
Site Administrator
Manta, Ecuador
 
Futures Experience: Advanced
Platform: My own custom solution
Favorite Futures: E-mini ES S&P 500
 
Big Mike's Avatar
 
Posts: 45,947 since Jun 2009
Thanks: 29,139 given, 81,896 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

Due to time constraints, please do not PM me if your question can be resolved or answered on the forum.

Need help?
1) Stop changing things. No new indicators, charts, or methods. Be consistent with what is in front of you first.
2) Start a journal and post to it daily with the trades you made to show your strengths and weaknesses.
3) Set goals for yourself to reach daily. Make them about how you trade, not how much money you make.
4) Accept responsibility for your actions. Stop looking elsewhere to explain away poor performance.
5) Where to start as a trader? Watch this webinar and read this thread for hundreds of questions and answers.
6)
Help using the forum? Watch this video to learn general tips on using the site.

If you want
to support our community, become an Elite Member.

Reply With Quote
The following user says Thank You to Big Mike for this post:
 
  #7 (permalink)
Elite Member
Near the BEuTiFULL Horse Shoe
 
Futures Experience: Beginner
Platform: NinjaTrader
Broker/Data: MBTrading Dukascopy ZenFire
Favorite Futures: $EURUSD when it is trending
 
Trader.Jon's Avatar
 
Posts: 500 since Jul 2009
Thanks: 401 given, 175 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:
 
  #8 (permalink)
Just starting out...
Global Citizen
 
Futures Experience: Advanced
Platform: Multicharts, Ninjatrader, Metastock, Tradestation
Favorite Futures: ES, ESTX50, GBP/JPY
 
thetradinghermit's Avatar
 
Posts: 3 since Jul 2010
Thanks: 1 given, 17 received

Excel workbook

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 user says Thank You to thetradinghermit for this post:
 
  #9 (permalink)
Elite Member
Near the BEuTiFULL Horse Shoe
 
Futures Experience: Beginner
Platform: NinjaTrader
Broker/Data: MBTrading Dukascopy ZenFire
Favorite Futures: $EURUSD when it is trending
 
Trader.Jon's Avatar
 
Posts: 500 since Jul 2009
Thanks: 401 given, 175 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
 
  #10 (permalink)
Site Administrator
Manta, Ecuador
 
Futures Experience: Advanced
Platform: My own custom solution
Favorite Futures: E-mini ES S&P 500
 
Big Mike's Avatar
 
Posts: 45,947 since Jun 2009
Thanks: 29,139 given, 81,896 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

Due to time constraints, please do not PM me if your question can be resolved or answered on the forum.

Need help?
1) Stop changing things. No new indicators, charts, or methods. Be consistent with what is in front of you first.
2) Start a journal and post to it daily with the trades you made to show your strengths and weaknesses.
3) Set goals for yourself to reach daily. Make them about how you trade, not how much money you make.
4) Accept responsibility for your actions. Stop looking elsewhere to explain away poor performance.
5) Where to start as a trader? Watch this webinar and read this thread for hundreds of questions and answers.
6)
Help using the forum? Watch this video to learn general tips on using the site.

If you want
to support our community, become an Elite Member.

Reply With Quote
The following 6 users say Thank You to Big Mike 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)

July Journal Challenge w/$1100 in prizes from TopstepTrader

July

John @ No BS Day Trading (TBA)

Elite only

An Afternoon with FIO member Softsoap (being rescheduled)

Elite only
     

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


All times are GMT -4. The time now is 02:53 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-06-23 in 0.15 seconds with 20 queries on phoenix via your IP 54.81.130.86