Trading Articles Article Categories Article Tools
Trading Metrics for journals/record keeping
Updated December 1, 2022
Top Posters
looks_one
vvhg
with 354 posts (689 thanks)
looks_two
madLyfe
with 202 posts (104 thanks)
looks_3
petrmac
with 73 posts (106 thanks)
looks_4
Big Mike
with 35 posts (162 thanks)
Best Posters
looks_one
PandaWarrior
with 73 thanks per post
looks_two
Big Mike
with 4.6 thanks per post
looks_3
vvhg
with 1.9 thanks per post
looks_4
petrmac
with 1.5 thanks per post
trending_up
299,254 views
thumb_up
1,497 thanks given
group
231 followers
forum
944 posts
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)
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.
Can you help answer these questions
Best Threads (Most Thanked)
(login for full post details)
#942 (permalink
Tehran Iran
Posts: 1 since May 2021
Thanks: 0 given,
0
received
thetradinghermit
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...
(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
Hi,
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.
vvhg
Fixed the Above/Below
VWAP calcs and modified the overview chart minimum cals.
vvhg
(login for full post details)
#945 (permalink
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".
Last Updated on December 1, 2022
Ongoing
Not being a spreadsheet guru knid got lost. Wondering is there a Final Most current version of the spreadsheet ? 