NexusFi: Find Your Edge

Home Menu


Trading Metrics for journals/record keeping

Discussion in Psychology and Money Management

      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 74.5 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 321,004 views
    2. thumb_up 1,508 thanks given
    3. group 234 followers
    1. forum 946 posts
    2. attach_file 252 attachments

Search this Thread

Trading Metrics for journals/record keeping

(login for full post details)
  #941 (permalink)
Prague, Czechia
Experience: Intermediate
Posts: 69 since Jan 2019
Thanks Given: 12
Thanks Received: 57

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 NexusFi?
Do 5-days or 7-days constitute a Multiweek Channel?
Price Action Swing Pro
Traders Hideout
Optimal Futures Trading Workflow
Platforms and Indicators
Your experience with VPS Ninjamobiletrader ?
Trading Reviews and Vendors
convert tradingview pinescript to ninjascript indicator …
The Elite Circle

(login for full post details)
  #942 (permalink)
Tehran Iran
Posts: 1 since May 2021
Thanks Given: 0
Thanks Received: 0

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 Given: 9
Thanks Received: 12


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 Given: 3
Thanks Received: 1

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 Given: 3
Thanks Received: 5

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
The following user says Thank You to Trader Kevin for this post:
(login for full post details)
  #946 (permalink)
Atlanta, GA
Posts: 2 since Mar 2023
Thanks Given: 22
Thanks Received: 1

Wow.... New member here and found this thread. It took be a little while to find the updated version 4.5. I love it. I have been swing trading for years and have my own SS journal fot swings. But this is going to be great as I switch from my swing trading to day trading the mini and micro index futures.

Thank you so much!!

Reply With Quote
(login for full post details)
  #947 (permalink)
Posts: 26 since Sep 2019
Thanks Given: 74
Thanks Received: 25

Does anyone have a template or a process for grading or ranking your trades?

Something like this but looking for a bit more detailed.... image in the above url:

HTML Code:
On top of the image shared here, if It captures Grade A,B,C or #1-3 ranking against a trade then while reviewing the trades it would be a useful metric.

While I am preparing one, I don't want to iterate through if there is a proven one available here with the forum members.


Reply With Quote

Last Updated on June 1, 2023

© 2023 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