Trading Metrics for journals/record keeping - futures io
futures io futures trading



Trading Metrics for journals/record keeping


Discussion in Psychology and Money Management

Updated
      Top Posters
    1. looks_one vvhg with 354 posts (687 thanks)
    2. looks_two madLyfe with 202 posts (104 thanks)
    3. looks_3 petrmac with 73 posts (105 thanks)
    4. looks_4 Big Mike with 35 posts (161 thanks)
      Best Posters
    1. looks_one PandaWarrior with 71.5 thanks per post
    2. looks_two Big Mike with 4.6 thanks per post
    3. looks_3 vvhg with 1.9 thanks per post
    4. looks_4 petrmac with 1.4 thanks per post
    1. trending_up 235,207 views
    2. thumb_up 1,485 thanks given
    3. group 221 followers
    1. forum 940 posts
    2. attach_file 252 attachments




Welcome to futures io: the largest futures trading community on the planet, with well over 125,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)

 
Search this Thread
 

Trading Metrics for journals/record keeping

(login for full post details)
  #101 (permalink)
Charlotte NC
 
Experience: Advanced
Platform: Charts:Ninja Trader w/IB, execution:TOS
Broker: TOS
Trading: CL, ES, ZN, ZB, RUT.
 
Posts: 233 since Jul 2009
Thanks: 98 given, 122 received


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
 
(login for full post details)
  #102 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

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:	229
Size:	169.6 KB
ID:	50906  
Reply With Quote
 
(login for full post details)
  #103 (permalink)
Charlotte NC
 
Experience: Advanced
Platform: Charts:Ninja Trader w/IB, execution:TOS
Broker: TOS
Trading: CL, ES, ZN, ZB, RUT.
 
Posts: 233 since Jul 2009
Thanks: 98 given, 122 received

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
 
(login for full post details)
  #104 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

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
 
(login for full post details)
  #105 (permalink)
CO
 
Experience: Intermediate
Platform: NinjaTrader
 
Posts: 29 since Sep 2009
Thanks: 228 given, 45 received

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
The following user says Thank You to samurai for this post:
 
(login for full post details)
  #106 (permalink)
Como Italy
 
Experience: Intermediate
Platform: Ninjatrader, customized
Trading: ES
 
Posts: 526 since Feb 2010
Thanks: 471 given, 640 received


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
 
(login for full post details)
  #107 (permalink)
CO
 
Experience: Intermediate
Platform: NinjaTrader
 
Posts: 29 since Sep 2009
Thanks: 228 given, 45 received

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
 
(login for full post details)
  #108 (permalink)
CO
 
Experience: Intermediate
Platform: NinjaTrader
 
Posts: 29 since Sep 2009
Thanks: 228 given, 45 received

@vvhg Just sent you an updated spreadsheet via PM

Samurai

Reply With Quote
The following user says Thank You to samurai for this post:
 
(login for full post details)
  #109 (permalink)
Calgary Alberta Canada
 
 
Posts: 1 since Oct 2011
Thanks: 0 given, 1 received

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
The following user says Thank You to Vengeance for this post:
 
(login for full post details)
  #110 (permalink)
 
 
Posts: 1,176 since Nov 2009

this might be of interest to you guys...

Risk Management| Position Sizing | NinjaTrader | 877-646-5249

NTIndicatorWarehouse's Channel - YouTube

Attached Files
Register to download File Type: xls IW-Money-Expert.xls (206.0 KB, 258 views)
Reply With Quote
 
(login for full post details)
  #111 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Nice catch!

Looks like a really good tool to get a quick impression on position sizing.

It made me realise that the Monte Carlo simulation in the journal is essentially flawed as it refers to absolute values instead of relative ones. That doesn't make much sense with a constant percentage risked andchanging account sizes....I think it might be better to change that to % of account!?
Perhaps we should also have a graph displaying account balance in there?

What would be your oppinion on that @sysot1t?

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #112 (permalink)
new york
 
Experience: Beginner
Platform: SC, NT
Trading: CL, GC
 
Posts: 213 since Sep 2009
Thanks: 99 given, 113 received

I think position sizing is base on one's comfortable zone.

The book Trader Vic, the author has a chapter on "maximum profit". One of the thing he mentions was risking 25% of your profit for an end of the year trade to maximum your profit for the year. This is something I have never consider until I read the book.

Risk 25% on 1 trade? Are you freaking crazy? Absolutely!!! But it does make sense to me. Maybe I will try it when I am more comfortable with the idea.

Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #113 (permalink)
 
 
Posts: 1,176 since Nov 2009


vvhg View Post
Nice catch!

Looks like a really good tool to get a quick impression on position sizing.

It made me realise that the Monte Carlo simulation in the journal is essentially flawed as it refers to absolute values instead of relative ones. That doesn't make much sense with a constant percentage risked andchanging account sizes....I think it might be better to change that to % of account!?
Perhaps we should also have a graph displaying account balance in there?

What would be your oppinion on that @sysot1t?

vvhg

sorry guys, I dont like to re-invent the wheel much... I leave coding to those that excel at it ()... and I use this product instead.. I've been using it since v5...

TJS Elite

I had posted the stuff from IW because I thought it would be of interest... didnt really play much with it..

as to position sizing, I always risk a % of the account, but the number of contracts is determined by how much principal is on the account to accomodate 150% overnight margin... also, only 50% is ever VaR on the account... so for example.. on an account that is $30K, only $15K is VaR of which 1% per trade is risked ($150) with two contracts ($7500/car = 2).. so on ES that would mean a 6 tick stop (assuming that was your stop) for 2 contracts... if your stop was bigger, then only 1 contract could be traded..

again, those are my rules, am in it for survival... so I do what makes sense for me as thoes are the rules i am comfortable with...

Reply With Quote
 
(login for full post details)
  #114 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Changed the Monte Carlo to % of account and added 5 iterations on account balance simulation. Thanks again @sysot1t for pointing me at it. (see attached screenshot, next update inckuding this in a few days...)

@sysot1t :
As you use TJS Elite I would be really interested to hear what you think of the 'futures.io (formerly BMT) Journal' and whether you have any suggestions for future improvements.
I don't want to copy TJS Elite or any parts of it as I wouldn't see the point of reinventing the wheel as you put it and I am also not particularly keen on breaching any copyrights.
But I'm always open to constructive criticism.

vvhg

P.S. Would it be a good idea to add a simple position size calculator?

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

Name:	New MC.JPG
Views:	191
Size:	277.4 KB
ID:	51339  
Reply With Quote
 
(login for full post details)
  #115 (permalink)
 
 
Posts: 1,176 since Nov 2009


vvhg View Post
Changed the Monte Carlo to % of account and added 5 iterations on account balance simulation. Thanks again @sysot1t for pointing me at it. (see attached screenshot, next update inckuding this in a few days...)

@sysot1t :
As you use TJS Elite I would be really interested to hear what you think of the 'futures.io (formerly BMT) Journal' and whether you have any suggestions for future improvements.
I don't want to copy TJS Elite or any parts of it as I wouldn't see the point of reinventing the wheel as you put it and I am also not particularly keen on breaching any copyrights.
But I'm always open to constructive criticism.

vvhg

P.S. Would it be a good idea to add a simple position size calculator?

where is the latest file? I can look at it and play with it and let you know my thoughts.. for whatever they would be worth

Reply With Quote
 
(login for full post details)
  #116 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

I'm working on a major update, so it'll take a day or two.......

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #117 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Changed quite a bit this time...I will edit this post ASAP and add a little changelog and description...


vvhg


P.S. My head hurts!

Edit:

Overview tab:
added a profit/ av trade/ hour chart,see screenshot 4
Added a field where all/long/short can be selected, this has an influence on the then coloured cells, see screenshots 5 and 3

Monte Carlo tab:
Changed everything to % of current account size in order to take money management into account
Added a graph displaying 5 iterations of account balance, start value is user chosen, see screenshot 2

Target analysis:
all new tab
values going into the calculation can be filtered
added scatter chart of the selected trades to show efficiency

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

Name:	Target2.0.JPG
Views:	212
Size:	182.5 KB
ID:	51436   Click image for larger version

Name:	MC2.0.JPG
Views:	174
Size:	303.7 KB
ID:	51437   Click image for larger version

Name:	Overview2.0Long.JPG
Views:	218
Size:	281.0 KB
ID:	51438   Click image for larger version

Name:	Overview2.02.JPG
Views:	186
Size:	276.6 KB
ID:	51439   Click image for larger version

Name:	Overview2.0.JPG
Views:	172
Size:	276.1 KB
ID:	51440  
Attached Files
Register to download File Type: rar Journal 2.0r.rar (1.32 MB, 168 views)
Reply With Quote
The following 12 users say Thank You to vvhg for this post:
 
(login for full post details)
  #118 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received

how do i add 6E, 6S and 6J?

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #119 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Go to 'Instrument List' and add them there (instead of adding them below the existing ones you can also change the ones in there to what you need) the only important thing is not to change the structure, meaning you should stick to the columns provided (tick size is not user entered but calculated automatically).

So for 6E you would enter the following:
6E 5,23 (or whatever your commission would be) 125000 12,5


Have a look at the screenshot....


vvhg

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

Name:	Inst.JPG
Views:	152
Size:	31.6 KB
ID:	51515  
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #120 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Perhaps it's time to add a readme to get people started and explain the various functions!?
Would be nice if we could do that together....everyone adds a bit?

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #121 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received

ya im confused, how do we start fresh on the journal, and if you make an update, how do we keep our data but get the new features..?

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #122 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


madLyfe View Post
ya im confused, how do we start fresh on the journal, and if you make an update, how do we keep our data but get the new features..?


1. Start fresh
Before you start, make sure any sheet you make changes to is protected (if not it's very likely you will break sth). If it is you can't delete any formulas which is quite important.
Then delete the trade records in the journal tab (they are just there to show the functions so you can play around with them).
If you get error messages you probably try to delete protected cells.
Next go to the instrument list tab and change the data in there to the instruments you trade.
Next go to the method list tab and change the methods to what you want.
next go to Overview tab and type in your starting account balance.


2. Migrating
As I changed things on the journal tab you must copy paste your data from the old to the new journal. The same as starting fresh applies here if you get error messages.
next copy paste the user input data from method list and instrument list tab.
In the future it should be possible to copy paste the entire journal tab, come the time I will provide a step by step guide for that.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following 2 users say Thank You to vvhg for this post:
 
(login for full post details)
  #123 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received

ok cool thanks! is everything protected in the 'Journal 2.0r.rar' you just released, or how do i check that? also i tried to change the instruments and i got this:



also can i add on instruments to the list, like how many can i add going down the list?

from above:
i think everything is protected as i checked this page, am i correct?

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #124 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

The ###### doesn't matter, the value is still in there but the column with is too small to display it, if you want to change that you would have to unprotect the sheet and then adjust the column width.

BTW: you can delete the instruments you don't need, same with methods

Yep, all protected.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #125 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
The ###### doesn't matter, the value is still in there but the column with is too small to display it, if you want to change that you would have to unprotect the sheet and then adjust the column width.

Yep, all protected.

vvhg

ok thanks. i dont think this is setup for instruments with 2 decimal places or more than 2 decimal places like the currencies like for example under the entry and exit entries.. there may but other places where this is an issue but im still poking around..

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #126 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

That might be an issue, but you can always unprotect the sheet and adjust column width, just don't forget to protect afterwards....


vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #127 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received

what all should i be selecting when re-protecting the sheet? also on the instrument list can i add as many rows of instruments as i like? i dont think the drop down for long or short in the journals tab is working.


dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #128 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


madLyfe View Post
what all should i be selecting when re-protecting the sheet? also on the instrument list can i add as many rows of instruments as i like? i dont think the drop down for long or short in the journals tab is working.

1. just click ok it remembers what was protected, so no need to make anny changes.
2. yes.
3. there is no dropdown, takes longer to get there with the mouse than to simply enter l or s and get the auto complete do the rest once you have typed it in once although I could add a dropdown....


vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #129 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received

man im slow.. when i removed everything from the journal and started fresh, nothing seems to populate at the end giving the totals, then tosses and error when i go back to the overview tab.. i must not be removing the sample data correctly.. i do notice tho that its not protected by default in the most recent version you have provided, is that the issue?

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #130 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Did you remove the sample data while the sheet was protected?
If not you might have accidentally deleted some formulas.
If yes, how many trades are in your journal now? If there is not enough data yet you get Div/0 errors on the overview tab as there is insufficient data to calculate the stats from.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #131 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Did you remove the sample data while the sheet was protected?
If not you might have accidentally deleted some formulas.
If yes, how many trades are in your journal now? If there is not enough data yet you get Div/0 errors on the overview tab as there is insufficient data to calculate the stats from.

vvhg

i just downloaded the file from your post, then removed the journal data. the journal sheet isnt protected by default, should it be?

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to madLyfe for this post:
 
(login for full post details)
  #132 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

YES it should be, let me change that...
Here you go....

vvhg

Hic Rhodos, hic salta.
Attached Files
Register to download File Type: rar Journal 2.0r.rar (1.33 MB, 73 views)
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #133 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
YES it should be, let me change that...
Here you go....

vvhg

thanks, but now when i try to delete the user data i get this:


dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #134 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Because you have also selected the protected cells..
Green heading indicates (in most cases) unprotected cells underneath.
Easiest is to delete the data column by column (except heading).
If you get an error message then, just move on to the next column....

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #135 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Because you have also selected the protected cells..
Green heading indicates (in most cases) unprotected cells underneath.
Easiest is to delete the data column by column (except heading).
If you get an error message then, just move on to the next column....

vvhg

oh jeez.. that makes it easier, thanks for the tip.

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #136 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received

ya thats really odd, i cant delete the selection as a whole(as shown in the picture), but i can delete all the columns selected in the picture one by one..



for some reason the screen grab didnt get the highlighted areas in the pic... i had all of the green columns in the picture highlighted..

also after clearing out the journal one by one, i went to the overview tab to put in my starting balance and this is what i got:



not sure if expected or not.. i know the 'Div/0' errors are supposed to be there but not the VB error..

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #137 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

1.Yepp that is expected as there are hidden columns performing calcs....
2.Well I'm not exactly a VB guru, so that could be due to my buggy code, just click end (or debug if you happen to be a guru), I'll look into that in about 12 hours...

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following 2 users say Thank You to vvhg for this post:
 
(login for full post details)
  #138 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
1.Yepp that is expected as there are hidden columns performing calcs....
2.Well I'm not exactly a VB guru, so that could be due to my buggy code, just click end (or debug if you happen to be a guru), I'll look into that in about 12 hours...

vvhg

ok cool, and thanks for you help today vvhg! im not using like half of whats in this journal so i dont know if thats whats causing this error as well, but im getting this every so often(like not while im doing things in the journal, just randomly)..



here are the only utilities that i am interested in for my records:

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #139 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received


vvhg View Post
1.Yepp that is expected as there are hidden columns performing calcs....
2.Well I'm not exactly a VB guru, so that could be due to my buggy code, just click end (or debug if you happen to be a guru), I'll look into that in about 12 hours...

vvhg

At this point the whole excel crashes due to some illegal operation (I suspect the recalc of the axis in the VB code).
Could be excel bug, but I had the chance to try it only on my Mac. I will try it on Win7 as well.

Petr

Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #140 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

@madLyfe
Yes, the errors are likely to be caused by that, I will improve on that....


@petrmac
Sorry for crashing your excel. On my end it doesn't, but I'll try to improve the VB code. Would be interesting to see what happens on Win7. Runtime errors mostly occur with the y axis maximum, perhaps there is a way to only set the min and let excel do the max.


vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #141 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Could you please try this one, improved VB and got rid of ref errors (hopefully all).


vvhg

Hic Rhodos, hic salta.
Attached Files
Register to download File Type: rar Journal 2.0.1.rar (1.09 MB, 85 views)
Reply With Quote
The following 6 users say Thank You to vvhg for this post:
 
(login for full post details)
  #142 (permalink)
Market Wizard
Portland, OR
 
Experience: None
 
Massive l's Avatar
 
Posts: 1,918 since Mar 2011
Thanks: 1,526 given, 3,722 received

Haven't tried it yet but the screenshots are awesome.

Nice work everyone, especially vvhg. Thank you.

Reply With Quote
The following user says Thank You to Massive l for this post:
 
(login for full post details)
  #143 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Migration Guide

From older versionsto latest version:
See HERE and next posts.

From version 2.0 onwards to latest version:
1. in the new version, unprotect the journal tab.
2. in the old version copy ALL cells of the journal tab (Ctrl+a then Ctrl+c)
3. in the new version click the cell A1 on the journal tab once
4. paste (Ctrl+v)
5. click yes on all dialog boxes
6. protect journal tab
7.if you edited the values on the method list and comment list tabs you want to copy these as well (only the user entered values though)
8. set starting account balance on overview tab

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following 2 users say Thank You to vvhg for this post:
 
(login for full post details)
  #144 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Migration Guide

From older versionsto latest version:
See HERE and next posts.

From version 2.0 onwards to latest version:
1. in the new version, unprotect the journal tab.
2. in the old version copy ALL cells of the journal tab (Ctrl+a then Ctrl+c)
3. in the new version click the cell A1 on the journal tab once
4. paste (Ctrl+v)
5. click yes on all dialog boxes
6. protect journal tab
7.if you edited the values on the method list and comment list tabs you want to copy these as well (only the user entered values though)
8. set starting account balance on overview tab

vvhg

thanks for the update, no errors as of yet! is there a way you can make this currency futures friendly and also the long/short option a drop down? thanks again!

here are some issues, i dont think the cells are big enough or something:


i also think the equity curve is kinda jacked..?

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to madLyfe for this post:
 
(login for full post details)
  #145 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

1. have a look here you might also want to adjust column width (unprotect, drag column width, protect)
2. yep changed that, will upload later
3. the equity curve has a minimum y value of 1000, really a bit complicated to change that (I thought that most people using this journal would have a few k starting balance, no offiense)


vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #146 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
1. have a look here you might also want to adjust column width (unprotect, drag column width, protect)
2. yep changed that, will upload later


vvhg

well i was wondering if on your end you could make things a tad bigger to compensate for the occasional odd value. i know i, and the rest of us can make the change, but every new release we are going to have to change it back.. lmk your thoughts.

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #147 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

It's really a one time change, if you migrate copying the journal tab just make sure to copy with source formatting.

Also if not used for currencies, it's probably easier to fit as many columns as possible on the screen...

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #148 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

got an idea for the format of currencies entry exit: Ill use conditional formatting based on tick size.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #149 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
got an idea for the format of currencies entry exit: Ill use conditional formatting based on tick size.

vvhg

ya i was just tinkering but wasnt getting very far.. cuz the 6E and 6S have 4 places and the 6J has 6.. so the only way i was seeing it working was to make everything have 6 places..

i think the time section is tossing dates?

actually everything is tossing dates for me now.. lol

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #150 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Good, got it, will upload soon....


vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #151 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Here is the new version, as I made (unplanned) changes to the journal tab, please use the migration guide for versions BEFORE 2.0

Added conditional formatting based on tick size.
Added dropdown for long/short.

vvhg

Hic Rhodos, hic salta.
Attached Files
Register to download File Type: rar Journal 2.0.2r.rar (1.23 MB, 73 views)
Reply With Quote
The following 3 users say Thank You to vvhg for this post:
 
(login for full post details)
  #152 (permalink)
Buckeye Nation
 
Experience: Intermediate
Platform: Ninja Trader
Broker: Amp/CQG, TOS
Trading: CL, 6E, YM and ES
 
Posts: 211 since Jul 2010
Thanks: 159 given, 241 received


vvhg View Post
Here is the new version, as I made (unplanned) changes to the journal tab, please use the migration guide for versions BEFORE 2.0

Added conditional formatting based on tick size.
Added dropdown for long/short.

vvhg

@vvhg

Could you please post a zipfile instead of a .rar file?

Thanks

Reply With Quote
The following user says Thank You to kulu for this post:
 
(login for full post details)
  #153 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Here is the new version, as I made (unplanned) changes to the journal tab, please use the migration guide for versions BEFORE 2.0

Added conditional formatting based on tick size.
Added dropdown for long/short.

vvhg

2.0.2


dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
The following 2 users say Thank You to madLyfe for this post:
 
(login for full post details)
  #154 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Oops.... could you click edit and post a scrrenshot of that?

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #155 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Oops.... could you click edit and post a scrrenshot of that?

vvhg


dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
The following 2 users say Thank You to madLyfe for this post:
 
(login for full post details)
  #156 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Ok, fixed it, sorry.
I changed the file in the last post containing the update...
Seems I'm producing a lot of

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #157 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Ok, fixed it, sorry.
I changed the file in the last post containing the update...
Seems I'm producing a lot of

vvhg

something keeps messing up when either i change the instrument and method lists, or when im clearing the journal content because the time keeps getting all jacked up..

is this what that column should be formatted to?


also is there a way to get it to calculate exactly to the penny instead of rounding in the prices? i think it might be happening with the commissions or something, but cant track it down..

as an entry: 7 ticks x 12.5 tick value = 87.5 - 5.07commission = 82.43 total.. the sheet says 82

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #158 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Time seems right (It's MIL time so 6:30am is 0600 and 5:20pm is1720) just enter the string of hours and minutes.

Prices are not rounded, they are only displayed that way to make it a bit easier on the eyes....you can change the format if you want to... (have a look at net profit on overview tab)


vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #159 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Time seems right (It's MIL time so 6:30am is 0600 and 5:20pm is1720) just enter the string of hours and minutes.

Prices are not rounded, they are only displayed that way to make it a bit easier on the eyes....you can change the format if you want to... (have a look at net profit on overview tab)


vvhg

ok thanks. i know the method list is in green but it always makes me un protect it to make changes to that column, is that correct?

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to madLyfe for this post:
 
(login for full post details)
  #160 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Yes and no.
Yes it makes you unprotect as these cells are locked.
No, they shouldn't be, I changed it so in the next version it is corrected....

Thanks very much for your help! Impossible for me to find all those problems on my own.
I really appreciate it!


vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following 2 users say Thank You to vvhg for this post:
 
(login for full post details)
  #161 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Yes and no.
Yes it makes you unprotect as these cells are locked.
No, they shouldn't be, I changed it so in the next version it is corrected....

Thanks very much for your help! Impossible for me to find all those problems on my own.
I really appreciate it!


vvhg

thank you for putting up with me!

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #162 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

I fear it might be the other way around

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #163 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received

for getting the prices to not show whole numbers, what setting should i use for that under the format cells.. i might just change them in the overview tab, but i might get OCD about it and change them in the journal as well..

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #164 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

now it says in the formatting string sth like 0_ just change it to the string similar to this but saying 0.00_ (on my machine it's 2 further up....

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #165 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
now it says in the formatting string sth like 0_ just change it to the string similar to this but saying 0.00_ (on my machine it's 2 further up....

vvhg

when i opened the journal again i got this:



also i cant get the overview tab to update the values after i change the starting balance.. (net profit/current account bal)

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #166 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

I will look into that in a few hours, bedtime here.......

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #167 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Could you try this and have a look if the link error is gone...
Account balance seems to work.... but your net profit seems somewhat high....


vvhg

Hic Rhodos, hic salta.
Attached Files
Register to download File Type: rar Journal 2.0.3.rar (1.23 MB, 61 views)
Reply With Quote
The following 2 users say Thank You to vvhg for this post:
 
(login for full post details)
  #168 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Could you try this and have a look if the link error is gone...
Account balance seems to work.... but your net profit seems somewhat high....


vvhg

just started playing with the new build.. so far going through my normal changes and i havnt seen a single error pop up.. so far so good vvhg, and thanks!

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to madLyfe for this post:
 
(login for full post details)
  #169 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received

im trying to add 2 decimal places to everything where there is price, and im not sure how to do that on the results columns and balance?



looks like something i shouldnt mess with.. i changed them on the overview tab by formatting them to currency and 2 decimal places like this:


dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #170 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

1st screenshot 3 further up.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #171 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
1st screenshot 3 further up.

vvhg

ok cool, so this one?



also, what are the overview pages one set at before i edited them? i seem to remember them not being set to anything?

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #172 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Yep.


vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #173 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received

i think the net tick gain and gain/contract results are off a bit?


dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #174 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Sorry, can't read it on the screenshot, I will have a look tomorrow.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #175 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Sorry, can't read it on the screenshot, I will have a look tomorrow.

vvhg

ok cool, it is only a 4 tick move entered in my journal entries and those last two columns are reporting 3.6.. see ya tomorrow vvhg!

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #176 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Ok, I see, my guess would be (as I am not at MY computer and can't have a look at the formula as of now) that commission has been substracted (thus net gain).

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #177 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Ok, I see, my guess would be (as I am not at MY computer and can't have a look at the formula as of now) that commission has been substracted (thus net gain).

vvhg

yep i just looked and thats exactly what its doing.. i was reading it wrong.. thanks again!

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to madLyfe for this post:
 
(login for full post details)
  #178 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

So....can we (finally) leave the journal tab as it is now...? Or any more error correction or changes to be done?

I'm really greatful for any feedback! (not only on the journal tab btw)

vvhg

PS. Special thanks to @madLyfe for all the help!

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #179 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
So....can we (finally) leave the journal tab as it is now...? Or any more error correction or changes to be done?

I'm really greatful for any feedback! (not only on the journal tab btw)

vvhg

PS. Special thanks to @madLyfe for all the help!

i think so.. now if you make changes im going to have to redo my journal page because of the changes ive made right?

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #180 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Unfortunately so.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #181 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

ok, here is a minor update for you to play with over the weekend..

Changelog:

Added a simple position size calculator (see screenshot).
Added a tab for your trading plan, so you always have it handy (see screenshot).
Improved a little on the vba code, is now a bit easier on the processor.
On monte carlo tab added a recalc button (has to do with improved vba).
Various minor changes.

Migration Guide can be found below THIS post.


vvhg

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

Name:	Position Size Calculator.JPG
Views:	101
Size:	162.3 KB
ID:	52086   Click image for larger version

Name:	Trading Plan.JPG
Views:	80
Size:	60.8 KB
ID:	52087  
Attached Files
Register to download File Type: rar Journal 2.0.4.rar (1.15 MB, 61 views)
Reply With Quote
The following 8 users say Thank You to vvhg for this post:
 
(login for full post details)
  #182 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

I think the journal would really profit from a little readme or user guide (as it somehow got quite massive, don't know how that happened), so it would be phantastic if anyone would be willing to help with that.

Whether it is in the form of suggestions, questions, bullet points or whole paragraphs, every bit helps!

As I know the journal inside out, it's really hard for me and I might not see what would have to go in there. Basically I feel a bit blind on that eye.....


vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #183 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received

i think we should make it currency futures friendly from default.

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #184 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

It already is, the only thing that might need adjustment is the width of a few columns, that's 30 seconds.....
Maybe, maybe I could do that via vba, but I'm really no expert in that field.....

@madLyfe, the only other thing you would need to change is displaying the $ cents in the result columns, again 30 seconds....(btw. they are not rounded in the default format, they only don't show, but they are still there)


vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #185 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Changelog:

1. Pimped the optics a bit, hope you like it (let me know if not).
2. Width is automatically adjusted on entry, exit and result columns.
3. Target analysis has now option for BE stop.
4. Some little things I can't remember

See migration guide below THIS post.


vvhg

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

Name:	over.5.JPG
Views:	123
Size:	254.1 KB
ID:	52146   Click image for larger version

Name:	tp.5.JPG
Views:	86
Size:	75.9 KB
ID:	52147   Click image for larger version

Name:	journal.5.JPG
Views:	101
Size:	315.2 KB
ID:	52148   Click image for larger version

Name:	mc.5.JPG
Views:	97
Size:	278.4 KB
ID:	52149  
Attached Files
Register to download File Type: rar Journal 2.0.5.rar (1.55 MB, 49 views)
Reply With Quote
The following 2 users say Thank You to vvhg for this post:
 
(login for full post details)
  #186 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received

where did the comment list go to? also can we get the auto width adjustments to the instruments tab?

another thing, i changed the balance tab to 3 up from your selection so i could get 2 decimal places and i dont think its working with the auto width of columns fix you put in. the point value didnt seem to auto width itself either.



i think the risk % needs the treatment as well:


dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #187 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Changelog:
More columns with autofit (see screenshot).
Fixed error with the efficiency calculations of Followed Rules (Long or Short) on overview.

See migration guide below THIS post.

@madLyfe
The autofit only kicks in every time you activate the journal tab, so just go to an other tab and back to journal tab, should do the trick.
The comment tab is hidden (as I thought that everyone could leave them as they are as you can either follow your rules or not). You can always unhide it though by right clicking a tab and selecting unhide.
Auto width on Instruments tab is not necessary I think as you could easily do that manually if you want to but actually it doesn't matter that much at all as you enter the values there once and you never have to look at them again...... it's not a tab you would work with every day......


vvhg

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

Name:	autofit.JPG
Views:	50
Size:	20.4 KB
ID:	52188  
Attached Files
Register to download File Type: rar Journal 2.0.6.rar (1.64 MB, 43 views)
Reply With Quote
The following 2 users say Thank You to vvhg for this post:
 
(login for full post details)
  #188 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Changelog:
More columns with autofit (see screenshot).
Fixed error with the efficiency calculations of Followed Rules (Long or Short) on overview.

See migration guide below THIS post.

@madLyfe
The autofit only kicks in every time you activate the journal tab, so just go to an other tab and back to journal tab, should do the trick.
The comment tab is hidden (as I thought that everyone could leave them as they are as you can either follow your rules or not). You can always unhide it though by right clicking a tab and selecting unhide.
Auto width on Instruments tab is not necessary I think as you could easily do that manually if you want to but actually it doesn't matter that much at all as you enter the values there once and you never have to look at them again...... it's not a tab you would work with every day......


vvhg

changing the balance tab again for 2 decimal places and its not auto widthing itself..

also i am getting this error on the new journal version:


dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #189 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


madLyfe View Post
changing the balance tab again for 2 decimal places and its not auto widthing itself..

My bad, I'll fix that.


madLyfe View Post
also i am getting this error on the new journal version:


Any chance you can actually find the error?

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #190 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
My bad, I'll fix that.



Any chance you can actually find the error?

vvhg

im not sure.. i only have the option to click ok.. then nothing after that..

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #191 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Can you run an error check?

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #192 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Can you run an error check?

vvhg

sure do i have to do it when the error comes up or?... and also how do i do that?

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #193 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Doesn't matter when you do that, go to formulas tab and there is the error checking tool.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #194 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Doesn't matter when you do that, go to formulas tab and there is the error checking tool.

vvhg

ok cool here is what i got:



and that goes from W3-W6, it just so happens that those are the rows i have filled in for the journal i think.. 3,4,5,6..

i also did the 'trace error' option and it put this line through one of my rows and not sure what i should do about it..


dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to madLyfe for this post:
 
(login for full post details)
  #195 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Can you give this a try?

vvhg

Hic Rhodos, hic salta.
Attached Files
Register to download File Type: rar Journal 2.0.7.rar (1.56 MB, 59 views)
Reply With Quote
The following 2 users say Thank You to vvhg for this post:
 
(login for full post details)
  #196 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Can you give this a try?

vvhg

balance column auto width thing is fixed, but im still getting the same error as before..

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #197 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Could you send me your file via PM so I can have a look?


vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #198 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Could you send me your file via PM so I can have a look?


vvhg

ok sent, i usually takes abot 10 minutes of letting the journal sit idle for me to get the errors..

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to madLyfe for this post:
 
(login for full post details)
  #199 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Try this.

vvhg

Hic Rhodos, hic salta.
Attached Files
Register to download File Type: rar Journal 2.0.7.rar (1.73 MB, 69 views)
Reply With Quote
The following 2 users say Thank You to vvhg for this post:
 
(login for full post details)
  #200 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Try this.

vvhg

i got the same error again after i made my changes: here is my version..


dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Attached Files
Register to download File Type: rar Journal 2.0.7.rar (1.47 MB, 46 views)
Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to madLyfe for this post:


futures io Trading Community Psychology and Money Management > Trading Metrics for journals/record keeping


Last Updated on April 29, 2020


Upcoming Webinars and Events
 

NinjaTrader Indicator Challenge!

Ongoing
 

Journal Challenge!

February
 

Battlestations!

March
     



Copyright © 2021 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
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.
no new posts