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 331,911 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

  #91 (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

Thanks for your support! Once again shows this site would be nothing without you, I am truly amazed by the work you put into this forum!

But:
Big Mike View Post
You have to realize most people don't take the time to say thanks or reply, but they still use it.

Maybe I am wrong on this but I thought "most people" don't journal at all, I thought it was one of the reasons why "most people" are actually losing money....

vvhg

Hic Rhodos, hic salta.
Reply With Quote
Thanked by:

Can you help answer these questions
from other members on NexusFi?
NexusFi Journal Challenge - April 2024
Feedback and Announcements
ZombieSqueeze
Platforms and Indicators
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
Better Renko Gaps
The Elite Circle
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
61 thanks
Funded Trader platforms
38 thanks
NexusFi site changelog and issues/problem reporting
27 thanks
GFIs1 1 DAX trade per day journal
18 thanks
The Program
18 thanks
  #92 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,397 since Jun 2009
Thanks Given: 33,173
Thanks Received: 101,537


vvhg View Post
Maybe I am wrong on this but I thought "most people" don't journal at all, I thought it was one of the reasons why "most people" are actually losing money....

vvhg

Correct. I am just saying that you should not always give with the expectations to get. Sometimes you give because in the end, you will receive -- but it will be indirectly. So in other words, don't get discouraged because no one is giving feedback on the spreadsheet. Know that it all works out in the end.



Mike

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Started this thread Reply With Quote
  #93 (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


Very happy to give without recieving!
I'm not selfish, except for trading that is of course

The only thing is that it's nice to know that you actually give something as opposed to producing sth useless....

vvhg

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

I'm using the tracking spreadsheet. The other day, I went through much, but not all, of the overview tab fixing the formulas (rev 1.6.2). I got pulled away and never got back to it over the weekend.

This raises the questions:
  • How should I get the fixes to you?
  • How does one migrate to the newer revisions?
    • Are you just reentering the data in the new revision?
Samurai

Reply With Quote
Thanked by:
  #95 (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

Thank you very much @samurai!


samurai View Post
How should I get the fixes to you?

Best would probably be to send me the spreadsheet via PM so I can put it into the latest version and post it.


samurai View Post
How does one migrate to the newer revisions?

At the moment you would have to copy paste all the user entered data, I will work on making that easier for future versions.


Keep up the good work! I really appreciate the help!

About the overview tab div/0 errors, what do your corrections display? Sth that makes you realize that there isn't enough data to calculate?


vvhg

Hic Rhodos, hic salta.
Reply With Quote
  #96 (permalink)
 futuretrader 
Como Italy
 
Experience: Intermediate
Platform: Ninjatrader, customized
Trading: ES
Posts: 525 since Feb 2010
Thanks Given: 471
Thanks Received: 643

@vvhg

I'm still using the template and plan to download the new one, for which I'm grateful. However, I've made a lot of changes to my version, so I'm uncertain what approach I'll take to the new one.

As far as suggestions go, I added scatter plots for MFE and MAE to mine, which I find useful for evaluating stops etc, at least when first trying out new methods or ideas.

Reply With Quote
Thanked by:
  #97 (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

I am attaching an xls that I use to analyze best scales and initial stop loss placement.
I have two objectives, first to share with fellow MBT's and hope this will help you the same way it helped me, and second to ask for corrections and suggestions.
This is very simple compared to other xls posted here but the objective is very focused too, just to milk a specific trade as much as possible.
I do not backtest but I like to follow a trade (or a new product) and take manual records for months before adopting it.
All the numbers are entered manually/daily, this way I have a good feeling for the specific trade and I am aware of externalities (news etc). For example if I do not trade a trend set up around news then I do not include it, on the other hand, if I am trading a breakout set up, then it should be part of the "around news" trade. So each one should decide what to include or not.
The first page shows the stats, best scales all in all out, and a reasonable stop loss location. The second page shows best scales in order to maximize r/r.
Instead of explaining in detail I will let you tear it apart (lol) and ask me questions.

I hope it helps.

Attached Files
Elite Membership required to download: Scales and Stops analysis.xlsx
Reply With Quote
Thanked by:
  #98 (permalink)
 ahwii 
Austria, Vienna
 
Experience: Intermediate
Platform: CQG Trader, NT
Broker: Velocity
Trading: FDAX
Posts: 59 since Sep 2010
Thanks Given: 88
Thanks Received: 56


vvhg View Post
So....is anyone actually interested in this template? Or even using it?
I'd be happy to further develop this journal, but I don't want to spam the forum with updates noone ever needs....
Also I don't mind doing the excel stuff, but I can't always guess what functionalities you would like to add , so some input would be nice!

vvhg

Using it and liking it very much. please don't stop updating

Reply With Quote
Thanked by:
  #99 (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


futuretrader View Post
@ vvhg

I'm still using the template and plan to download the new one, for which I'm grateful. However, I've made a lot of changes to my version, so I'm uncertain what approach I'll take to the new one.

As far as suggestions go, I added scatter plots for MFE and MAE to mine, which I find useful for evaluating stops etc, at least when first trying out new methods or ideas.

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!


meyer99 View Post
I am attaching an xls that I use to analyze best scales and initial stop loss placement.
I have two objectives, first to share with fellow MBT's and hope this will help you the same way it helped me, and second to ask for corrections and suggestions.
This is very simple compared to other xls posted here but the objective is very focused too, just to milk a specific trade as much as possible.
I do not backtest but I like to follow a trade (or a new product) and take manual records for months before adopting it.
All the numbers are entered manually/daily, this way I have a good feeling for the specific trade and I am aware of externalities (news etc). For example if I do not trade a trend set up around news then I do not include it, on the other hand, if I am trading a breakout set up, then it should be part of the "around news" trade. So each one should decide what to include or not.
The first page shows the stats, best scales all in all out, and a reasonable stop loss location. The second page shows best scales in order to maximize r/r.
Instead of explaining in detail I will let you tear it apart (lol) and ask me questions.

I hope it helps.

Thanks a lot. I will have a very close look at your spreadsheet and, with your approval, might incorporate some into the journal...


vvhg

Hic Rhodos, hic salta.
Reply With Quote
Thanked by:
  #100 (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


@ 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

Hic Rhodos, hic salta.
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