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

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


naveen View Post
Hi vvhg,
Yeah macros are enabled and i tried redownloading and enable "Always use two exits" but its not working. Is it working on ur end?

Just checked, working perfectly fine on my end...what version of excel are you using and have you noticed any more strange behavior?

vvhg

Hic Rhodos, hic salta.
Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Exit Strategy
NinjaTrader
Are there any eval firms that allow you to sink to your …
Traders Hideout
Build trailing stop for micro index(s)
Psychology and Money Management
Online prop firm The Funded Trader (TFT) going under?
Traders Hideout
Ninja Mobile Trader VPS (ninjamobiletrader.com)
Trading Reviews and Vendors
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
59 thanks
Funded Trader platforms
37 thanks
NexusFi site changelog and issues/problem reporting
23 thanks
GFIs1 1 DAX trade per day journal
22 thanks
The Program
19 thanks
  #732 (permalink)
naveen
mumbai
 
Posts: 10 since Feb 2011
Thanks Given: 4
Thanks Received: 0

Hi vvhg,
i am using MS excel 2007. I havn't noticed any strange behavior as of now, rest is working perfectly fine .

Regards,
Naveen

Reply With Quote
  #733 (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



naveen View Post
Hi vvhg,
i am using MS excel 2007. I havn't noticed any strange behavior as of now, rest is working perfectly fine .

Regards,
Naveen

Just to make sure we are talking about the exit columns on journal tab!?
I tried again to reproduce, but all is working fine...

Vvhg


Sent from my iPad using Tapatalk HD

Hic Rhodos, hic salta.
Reply With Quote
  #734 (permalink)
naveen
mumbai
 
Posts: 10 since Feb 2011
Thanks Given: 4
Thanks Received: 0

yeah..im talking about the exit columns....they are still visible after choosing "Always have two exits"..should i download previous versions and try?

Reply With Quote
  #735 (permalink)
 Superdoug3 
Vernon, BC, Canada
 
Experience: Beginner
Platform: Sierra Charts
Broker: Zaner Group (Transact)
Trading: ES
Posts: 103 since Apr 2010
Thanks Given: 113
Thanks Received: 64

1. simple question
I have the 2 original trades in Journal 4.1 which I modified to my 1st 2 trades
How to I add a trade 3, cell B4 is read only, trying to right click on row 3 but insert is not available,

2. I thought that my inability to insert a trade 3 had something to do with me clicking 'delete empty rows' in column D, but apparently not. not sure what that is there for

Reply With Quote
  #736 (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


Superdoug3 View Post
1. simple question
I have the 2 original trades in Journal 4.1 which I modified to my 1st 2 trades
How to I add a trade 3, cell B4 is read only, trying to right click on row 3 but insert is not available,

2. I thought that my inability to insert a trade 3 had something to do with me clicking 'delete empty rows' in column D, but apparently not. not sure what that is there for

1. Have a look at the readme, you have to go through the cells with the tab key, then the next row is added automatically.

2. Its there for deleting empty rows. Lets say for arguments sake you have added too many and want to temporarily get rid of them.




Sent from my iPad using Tapatalk HD

Hic Rhodos, hic salta.
Reply With Quote
  #737 (permalink)
 
petrmac's Avatar
 petrmac 
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
Posts: 175 since Jun 2011
Thanks Given: 275
Thanks Received: 211

Hi vvhg,

I have couple of next suggestions for the journal improvement. Consider the following ones:

1. add two more chart types to the Overview tab - the gross tick gain/loss per day and net tick gain/loss per day. The idea behind that is that one should concentrate on how well he trades, not how much money is made. 20 ticks on M6E might look like nothing compared to 20 ticks in 6E of FDAX but it would help to visualize the consistency. The commissions on the m6e have much higher impact on the results than on some more leveraged instrument.

2. In the time period statistics the deltas from the the last period might be an interesting item. For the weeks as well for the months.

Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #738 (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


petrmac View Post
Hi vvhg,

I have couple of next suggestions for the journal improvement. Consider the following ones:

1. add two more chart types to the Overview tab - the gross tick gain/loss per day and net tick gain/loss per day. The idea behind that is that one should concentrate on how well he trades, not how much money is made. 20 ticks on M6E might look like nothing compared to 20 ticks in 6E of FDAX but it would help to visualize the consistency. The commissions on the m6e have much higher impact on the results than on some more leveraged instrument.

I like that idea. We could perhaps also add ticks per contract...


Quoting 
2. In the time period statistics the deltas from the the last period might be an interesting item. For the weeks as well for the months.

I'm not entirely sure what you mean, sorry. Could you perhaps try and explain again (perhaps add a screenshot), thanks.


vvhg

Hic Rhodos, hic salta.
Reply With Quote
  #739 (permalink)
 
Sniff's Avatar
 Sniff 
San Francisco Bay Area, CA
 
Experience: Beginner
Platform: NinjaTrader, TWS
Broker: IB
Trading: CL, ES
Posts: 18 since Jun 2012
Thanks Given: 99
Thanks Received: 60

Sorry to jump in here but I just HAD to express my most sincere gratitude to everyone (especially Big Mike and vvhg and all the other testers) for putting this beautiful trading Journal together. I spent the whole morning reading through much of the thread (I started jumping ahead after the 20th page or so) and it's quite evident how much effort went into this.

I noticed about 500 posts back, vvhg said he wasn't really an expert at Excel....well, I bet you are now!

Thanks again for all the hard work--you can bet I will put this journal to good use!

Reply With Quote
Thanked by:
  #740 (permalink)
JonS
Edmonton, Canada
 
Posts: 3 since Jun 2012
Thanks Given: 2
Thanks Received: 1



vvhg View Post
Have a look if this beta suits your needs.

As to tick value it simply is the value of the smallest unit the underlying instrument can move. So in your original example it would be 0.05 of the underlying base currency.

vvhg

First off thanks for creating this amazing spreadsheet and incredibly useful forum. I honestly didn't think it was possible to find a civil and helpful trading forum.

As a someone who trades options and stocks, I'd like to suggest that the commission field needs to be handled differently. Typically options are priced at a base rate plus a per options cost. Same thing for stocks in my Thinkorswim account.

The way I do it in my spreadsheet is to add a "commission" cost per trade and enter it manually with each trade.

Reply With Quote
Thanked by:




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