NexusFi: Find Your Edge


Home Menu

 





Trading Metrics for journals/record keeping


Discussion in Psychology and Money Management

Updated
      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 75 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 334,915 views
    2. thumb_up 1,509 thanks given
    3. group 234 followers
    1. forum 946 posts
    2. attach_file 252 attachments




 
Search this Thread

Trading Metrics for journals/record keeping

  #101 (permalink)
 meyer99 
Charlotte NC
 
Experience: Advanced
Platform: Charts:TOS, execution:TOS
Broker: TOS
Trading: SPX, RUT. TQQQ, Stocks, /YM
Posts: 234 since Jul 2009
Thanks Given: 99
Thanks Received: 122


vvhg View Post
@ meyer99 great work, this looks very good!

It might be a good idea to stick that into the journal....
However, my first question would be how you define MFE for these calculations, as it clearly must be an after trade MFE!?

vvhg

It is the max profit given by the trade if you would exit to perfection. It is an after trade mfe. I record all trades at the end of day.

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Better Renko Gaps
The Elite Circle
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Trade idea based off three indicators.
Traders Hideout
ZombieSqueeze
Platforms and Indicators
MC PL editor upgrade
MultiCharts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Spoo-nalysis ES e-mini futures S&P 500
29 thanks
Tao te Trade: way of the WLD
24 thanks
Just another trading journal: PA, Wyckoff & Trends
24 thanks
Bigger Wins or Fewer Losses?
21 thanks
GFIs1 1 DAX trade per day journal
17 thanks
  #102 (permalink)
 
vvhg's Avatar
 vvhg 
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,583 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824

Ok, I see. I for myself have always a bit of a problem when determining that because eg pullbacks are also not unimportant......
BUT at the end of the day I don't have to tell anyone how to calculate it...I just jump in one step later and provide tools to analyse that data.........until it's roasted....


Next version will include target analysis (see screenshot) currently still in beta....


vvhg

Hic Rhodos, hic salta.
Attached Thumbnails
Click image for larger version

Name:	expectancy.JPG
Views:	480
Size:	169.6 KB
ID:	50906  
Reply With Quote
  #103 (permalink)
 meyer99 
Charlotte NC
 
Experience: Advanced
Platform: Charts:TOS, execution:TOS
Broker: TOS
Trading: SPX, RUT. TQQQ, Stocks, /YM
Posts: 234 since Jul 2009
Thanks Given: 99
Thanks Received: 122


vvhg,
As you know this is an art. I must add that I measure the MFE until I get a signal to trade in the opposite direction. Then I am in another trade and measuring starts again. I tend to trade rotationally. If you go for the big swings then you will stay with the first trade and yes, the pullbacks are something that need consideration.

Reply With Quote
  #104 (permalink)
 
vvhg's Avatar
 vvhg 
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,583 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824

On the Journal tab, is there anything still missing we might need in the future (second MFE is in there now)?

Background to this question is that once we don't make any changes to the Journal tab anymore it would (theoretically, don't let me promise too much yet) be possible to copy the complete sheet for easy migration....

Hic Rhodos, hic salta.
Reply With Quote
  #105 (permalink)
 samurai 
CO
 
Experience: Intermediate
Platform: NinjaTrader
Posts: 29 since Sep 2009
Thanks Given: 228
Thanks Received: 45

Sorry for not getting back sooner.

I found another reference that was causing errors. InternalCalcs!AC2 has a reference to:

'Y:\[Journal 1.5.1.xlsm]Journal'!P:P.

I removed the path so it now is:

Journal!P:P

Regarding the changes to the overview tab:

I merely display a space or a 0 where appropriate. I'll send the changed version via PM 'Real Soon Now'.

Samurai

Reply With Quote
Thanked by:
  #106 (permalink)
 futuretrader 
Como Italy
 
Experience: Intermediate
Platform: Ninjatrader, customized
Trading: ES
Posts: 525 since Feb 2010
Thanks Given: 471
Thanks Received: 643


vvhg View Post
Sounds very interesting!
Would you be willing to to share your version? Perhaps I could have a look at yours :
1. to have a look at the changes you made and perhaps steal some of them for future versions
2. to hopefully find an easy way for you to update
3. I was already thinking about these plots and would really like to see how they turn out!


vvhg

Happy to oblige, but it'll take some days because I'm currently 'on the road'. I should also say mine is probably fairly klutzy, as I really know nothing about Excel....

Reply With Quote
  #107 (permalink)
 samurai 
CO
 
Experience: Intermediate
Platform: NinjaTrader
Posts: 29 since Sep 2009
Thanks Given: 228
Thanks Received: 45

I'm afraid I've made things worse by trying to get rid of the 'DIV/0' errors.

I'm getting an 'out of resources' message when I calculate the entire workbook.

I'll keep looking.

Samurai

Reply With Quote
  #108 (permalink)
 samurai 
CO
 
Experience: Intermediate
Platform: NinjaTrader
Posts: 29 since Sep 2009
Thanks Given: 228
Thanks Received: 45

@vvhg Just sent you an updated spreadsheet via PM

Samurai

Reply With Quote
Thanked by:
  #109 (permalink)
Vengeance
Calgary Alberta Canada
 
Posts: 1 since Oct 2011
Thanks Given: 0
Thanks Received: 1

I'm new to this forum and just found it as I was looking for a journal versus reinventing the wheel. I just downloaded it and haven't yet looked at it but I will post any comments/suggestions that I might have in the next little while. I just wanted to say thanks to all for this spreadsheet as I'm sure it is the result off many hours of diligent work.

Reply With Quote
Thanked by:
  #110 (permalink)
 sysot1t 
 
Posts: 1,173 since Nov 2009


this might be of interest to you guys...

Risk Management| Position Sizing | [AUTOLINK]NinjaTrader[/AUTOLINK] | 877-646-5249

NTIndicatorWarehouse's Channel - YouTube

Attached Files
Elite Membership required to download: IW-Money-Expert.xls
Reply With Quote




Last Updated on June 1, 2023


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