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

Trading Metrics for journals/record keeping

Discussion in Psychology and Money Management

      Top Posters
    1. looks_one vvhg with 354 posts (689 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 (162 thanks)
      Best Posters
    1. looks_one PandaWarrior with 73 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.5 thanks per post
    1. trending_up 299,254 views
    2. thumb_up 1,497 thanks given
    3. group 231 followers
    1. forum 944 posts
    2. attach_file 252 attachments

Welcome to futures io: the largest futures trading community on the planet, with well over 150,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)
  #941 (permalink)
Prague, Czechia
Experience: Intermediate
Platform: Sierra Chart
Broker: Interactive Brokers
Trading: GBL
Posts: 43 since Jan 2019
Thanks: 6 given, 32 received

Great journal! (Journal 4.5) Thanks for hard work.

I have one question. I'm trading with (eurex) everything is settled and calculated in EUR. How can I change a currency everywhere to ?


Reply With Quote

Can you help answer these questions
from other members on futures io?
Import failed: the ninjasceipt archive file may contain …
Seeking super simple indicator
About alerts for intraday high price renewals
Closing Price of ES
Emini and Emicro Index
Trading instruments in different base currencies - how t …
Best Threads (Most Thanked)
in the last 7 days on futures io
NinjaTrader Brokerage Services (www.ninjatraderbrokerage …
148 thanks
Big Mike in Ecuador
95 thanks
New NinjaTrader
42 thanks
Where and How Do You Trade (via which device)?
14 thanks
Selling Options on Futures?
12 thanks
(login for full post details)
  #942 (permalink)
Tehran Iran
Posts: 1 since May 2021
Thanks: 0 given, 0 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:

  • 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...

Can you share your excel sheet plz

Reply With Quote
(login for full post details)
  #943 (permalink)
Austin Tx
Experience: Intermediate
Platform: NT, TOS, TradeStation
Trading: ES, NQ, CL, GC, Option Spreads
Posts: 24 since Sep 2013
Thanks: 9 given, 12 received


I read up to 60 and then skipped to end Not being a spreadsheet guru knid got lost. Wondering is there a Final Most current version of the spreadsheet ?

Many Thanks, Looking forward to using it.
Many Many thanks to all who contributed.


Reply With Quote
The following user says Thank You to txsroper for this post:
(login for full post details)
  #944 (permalink)
Villa Gobernador Galvez , Santa Fe , Argentina
Posts: 6 since Jun 2020
Thanks: 3 given, 1 received

For anyone who is searching for the latest excel shared of a trading journal, this is it.
Thanks vvhg

vvhg View Post
Fixed the Above/Below VWAP calcs and modified the overview chart minimum cals.


Reply With Quote
(login for full post details)
  #945 (permalink)
Trader Kevin
Houston, Texas
Posts: 13 since Jun 2020
Thanks: 3 given, 4 received

I noticed that in the latest version of Excel, many functions of this worksheet that I love do not work. In fact, every time you open certain worksheets, like "Overview" or "Pivot Table", it generates an error saying "Run-time error '1004': RefreshTable method of PivotTable class failed".

I believe it is not able to update the pivot table or InternalCalcs2 worksheet correctly in this new version of Excel.

Would this be an easy fix for anyone by chance?

Love the spreadsheet... thanks so much for sharing it with us!

Reply With Quote

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

Last Updated on December 1, 2022

Upcoming Webinars and Events

NinjaTrader Indicator Challenge!


Copyright © 2023 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),
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