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 234,666 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)
  #201 (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

testing the new version you sent me, ill report back if i find 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)
  #202 (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 not even sure what monte carlo is, but even tho my journal is set to 1k in the starting balance it show 100k still in there..


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)
  #203 (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, user input field. You can set the starting account balance for the monte carlo manually.

What it is:
The Monte Carlo engine randomly selects a specified number trades from your journal (the pivot table on the left, can also be filtered) and builds a 'new trades collection' from them. This is done 50 times. It can give you an idea of profitability and drawdowns.

Hic Rhodos, hic salta.
Reply With Quote
The following 2 users say Thank You to vvhg for this post:
 
(login for full post details)
  #204 (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
Yep, user input field. You can set the starting account balance for the monte carlo manually.

What it is:
The Monte Carlo engine randomly selects a specified number trades from your journal (the pivot table on the left, can also be filtered) and builds a 'new trades collection' from them. This is done 50 times. It can give you an idea of profitability and drawdowns.

would it be good to have it pull the starting account balance from the overview page?

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)
  #205 (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

Not really, no, because you should be able to filter the trades and just simulate based on a segment of your journal eg. using trades # 147-438 in that case it would sometimes be handy to use the account balance as of trade # 147....

That's the theory...

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)
  #206 (permalink)
adelaid australia
 
 
Posts: 3 since Oct 2011
Thanks: 3 given, 3 received

well done, top work. was wondering if it comes with some simple instructions lol.
any links on where i could read up some of the abbrevations and the usefullness in futures trading?

cheers

Reply With Quote
The following user says Thank You to arnie78 for this post:
 
(login for full post details)
  #207 (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

There is no readme (yet). But just ask what ever you want to know....I could also use that to start a readme...

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #208 (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 it would be cool to have a page in the journal where it breaks down the entire year by weeks and then months.. this way its not just for the entire year.. also, what about multiple years in the journal? or do you just start a new journal? if thats the case how do you compare years..?

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)
  #209 (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

Months would be possible....Weeks would be rather complex..... I think that would be easier accomplished with a database, but I don't know anything about databases....

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #210 (permalink)
adelaid australia
 
 
Posts: 3 since Oct 2011
Thanks: 3 given, 3 received

HI mate some questions on your journal, i know some off the answers, helping out with the readme. Hope this helps.

Trading plan tab
What colour cells are required to be filled? i know some are protected (this question goes for all tabs really)
What is vwap?
Benchmark eff?
MAE?
SQN?
Expectancy?
Drawdown?
Profit Factor?

Monte carlo tab

What is monte carlo mean? (not the city for the rich)

will add more after you reply

cheers


Sharpe Ration?
Calmar Ratio?




Journal Tab
Time (MIL)?
Possible to change and add methods? how many? (method list tab)
Possible to add instruments? How many? (instruments tab)
V stand for?
MAE1? 2 and 3? what are they?
Benchmark?
MFE2?

Reply With Quote
The following 2 users say Thank You to arnie78 for this post:
 
(login for full post details)
  #211 (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


arnie78 View Post
HI mate some questions on your journal, i know some off the answers, helping out with the readme. Hope this helps.

Overview tab
What colour cells are required to be filled? i know some are protected (this question goes for all tabs really)
Light green cells or cells below a light green heading (not all are required).

What is vwap?
Voume weighted average price.

Benchmark efficiency?
How much of the maximum favourable excursion while in the trade (before exit) was realised.

MAE?
Average maximum adverse excursion.

SQN?
System Quality Number by Van Tharp.

Expectancy?
(Probability of Win * Average Win) – (Probability of Loss * Average Loss)
Basically the average outcome of a trade.

Drawdown?
Maximum decrease of account balane.

Profit Factor?
(sum of winning trades)/(sum of losig trades)*-1

Sharpe Ration?
Calmar Ratio?

Monte carlo tab

What is monte carlo mean? (not the city for the rich)
The Monte Carlo engine randomly selects a specified number trades from your journal (the pivot table on the left, can also be filtered) and builds a 'new trades collection' from them. This is done 50 times. It can give you an idea of profitability and drawdowns.


Method list tab
Possible to change and add methods? how many?
Methods can be edited (changed, added, deletd as long as one remains) there is no limit to the number of methods.

Instruments tab
Possible to add instruments? How many?
Yes. Unlimited.

V stand for?
Don't know what you are referring to, sorry.

Journal tab
Time (MIL)?
Military time is an unambiguous, concise method of expressing time.
E.g. 6:30am is 0600 and 5:20pm is1720.

Benchmark?
Maximum favourable excursion while in the trade (before exit).

MFE2?
Absolute maximum favourable excursion (before or after exit).

MAE1,2 and 3, what are they?
Maximum adverse excursion of exit 1,2 and 3.




vhg

Hic Rhodos, hic salta.
Reply With Quote
The following 3 users say Thank You to vvhg for this post:
 
(login for full post details)
  #212 (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

is there a way to change these to two decimal places but keep the formatting of your '$' sign over there on the left?


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)
  #213 (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

just use the number formatting of I3 (easiest is to paste the format and then correct the colour and borders again)


vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #214 (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

the journal page is rounding on numbers but not others? if you look the 6E prices dont get rounded but these ES number get rounded from .25 to .30?

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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Attached Thumbnails
Click image for larger version

Name:	2011-11-09_0003.png
Views:	54
Size:	20.5 KB
ID:	54385  
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #215 (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. It's not rounded, it only displays not all digits.
2. This is due to the conitional formatting, meaning there is either a fomating error or an error with the instrument list.
For this reason it would be very helpful if you coud post a screenshot of the instrument list you use, so that I can track down the error.

Thanks for all your help!


vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #216 (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. It's not rounded, it only displays not all digits.
2. This is due to the conitional formatting, meaning there is either a fomating error or an error with the instrument list.
For this reason it would be very helpful if you coud post a screenshot of the instrument list you use, so that I can track down the error.

Thanks for all your help!


vvhg

here you go:

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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Attached Thumbnails
Click image for larger version

Name:	2011-11-09_1056.png
Views:	65
Size:	18.6 KB
ID:	54440  
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)
  #217 (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, it was a problem with the conditional formatting logic, my bad. It will be fixed in the next update. (which I will post somewhen soonish)


vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #218 (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
just use the number formatting of I3 (easiest is to paste the format and then correct the colour and borders again)


vvhg

is there a way you can put this into the next version that your about to release? i was a bit confused on how to do what you were talking about..?

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)
  #219 (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
is there a way you can put this into the next version that your about to release? i was a bit confused on how to do what you were talking about..?

Well, I'm not too sure...
It's ment to be an overview, so it doesn't substitute your brokers statement....
I would prefer to keep it simple.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #220 (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
Well, I'm not too sure...
It's ment to be an overview, so it doesn't substitute your brokers statement....
I would prefer to keep it simple.

vvhg

ok thats cool, i can live with it and just make my modifications.. also is there a way to when you have a drop down on the journal tab, ex. the instrument drop down, that it expands fully to the amount of instruments you have so there is not scroll bar?

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)
  #221 (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 these kind of lists have a maximum list length of eight rows, it's an excel limitation, so I can't change that.
OT: A slightly indiscrete question: How many instruments do you trade?


vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #222 (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
Unfortunately these kind of lists have a maximum list length of eight rows, it's an excel limitation, so I can't change that.
OT: A slightly indiscrete question: How many instruments do you trade?


vvhg

i trade all over the place either through SIM or real monies..

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)
  #223 (permalink)
Vancouver, BC, Canada
 
Experience: Intermediate
Platform: NT
Broker: Ninja-Traders Technology
Trading: 6E, ZN, CL
 
Posts: 41 since Aug 2011
Thanks: 115 given, 18 received

Hi guys, this has been a great thread to read through and to find a trade journal. it sounds complicated, but as i begin to use it, perhaps it will make sense. i used to use the TJ journal for forex, but since moving over to futures, haven't bought a new TJ journal--and here's one on futures.io (formerly BMT)! amazing. what an incredible site to have stumbled upon. Thanks again.

Reply With Quote
The following user says Thank You to Richie Z for this post:
 
(login for full post details)
  #224 (permalink)
Vancouver, BC, Canada
 
Experience: Intermediate
Platform: NT
Broker: Ninja-Traders Technology
Trading: 6E, ZN, CL
 
Posts: 41 since Aug 2011
Thanks: 115 given, 18 received


vvhg View Post
Can you give this a try?

vvhg

Do i need to buy some sort of softward to download .rar? how do i download this?thanks for your help!

Reply With Quote
 
(login for full post details)
  #225 (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 you go.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #226 (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, it was a problem with the conditional formatting logic, my bad. It will be fixed in the next update. (which I will post somewhen soonish)


vvhg

along with this, do you have any other features/fixes planned? i really havnt run into much else..

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)
  #227 (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

also i think there is an issue in the instrument list, or i am doing something wrong.. the M6E is 10,000.00 a point and 1.25 a tick, which comes out to 0.000125 on the instrument list, but the instrument manager in NT says 0.0001. and for some reason my totals per my statement/journal are not matching up..


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)
  #228 (permalink)
Site Administrator
Swing Trader
Data Scientist & DevOps
Manta, Ecuador
 
Experience: Advanced
Platform: My own custom solution
Trading: Emini Futures
 
Big Mike's Avatar
 
Posts: 49,345 since Jun 2009
Thanks: 32,022 given, 96,544 received

Pretty sure point value for M6E is $12,500 not $10,000.

Mike

We're here to help -- just ask

For the best trading education, watch our webinars
Searching for trading reviews? Review this list

Follow us on Twitter, YouTube, and Facebook

Support our community as an Elite Member:
https://futures.io/elite/
Follow me on Twitter Visit my Facebook Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #229 (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


Big Mike View Post
Pretty sure point value for M6E is $12,500 not $10,000.

Mike

ah, i wonder why NT is wrong.. should that be something i correct in NT?

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)
  #230 (permalink)
Site Administrator
Swing Trader
Data Scientist & DevOps
Manta, Ecuador
 
Experience: Advanced
Platform: My own custom solution
Trading: Emini Futures
 
Big Mike's Avatar
 
Posts: 49,345 since Jun 2009
Thanks: 32,022 given, 96,544 received


madLyfe View Post
ah, i wonder why NT is wrong.. should that be something i correct in NT?

You can type in the new value manually and alert @NinjaTrader it is wrong. It would effect PnL reports inside NT as well.

Mike

We're here to help -- just ask

For the best trading education, watch our webinars
Searching for trading reviews? Review this list

Follow us on Twitter, YouTube, and Facebook

Support our community as an Elite Member:
https://futures.io/elite/
Follow me on Twitter Visit my Facebook Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #231 (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


Big Mike View Post
You can type in the new value manually and alert @NinjaTrader it is wrong. It would effect PnL reports inside NT as well.

Mike

thanks for you help mike!

hey! @NinjaTrader! i think your M6E point value is wrong.. it should be 12,500 and not $10,000. tyty

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)
  #232 (permalink)
Vernon, BC, Canada
 
Experience: Beginner
Platform: Sierra Charts
Broker: Zaner Group (Transact)
Trading: ES
 
Posts: 103 since Apr 2010
Thanks: 113 given, 63 received

Just a suggestion; I have been reading the metrics journal and find Big Mikes metric journal the most to my liking.
I posted a Sierra Chart 'spreadsheet for auto trading' in the Downloads section and then realized that not everyone is familiar with the technical details of Sierra Chart, so I included a 'how to' for updating your Sierra Chart folder, how to modify what I had submitted and dangerous things you should not do because of how Sierra Chart works.

Would you spend some time to put together a 'how to use' list for this spreadsheet. Something that would include Post #13, #88, #119. A brief overview of what each tab is for, which data to enter (is date yy/mm/dd or American mm/dd/yy) and maybe some reference links to Expectancy, MAE, MFE. Maybe some limitations, for example: is Instrument List restricted to 8 entries? Since you are posting using RAR, this could be easily included once it is done. B.T.W - I do not mean a tutorial on Excel, as this can be found with Google, just some guidance on using this wonderful tool. I know MAE and MFE are well documented in futures.io (formerly BMT) and in Investopedia - just a suggestion. If not, I am sure there is enough in this thread to figure it out.
Opps - I see that I should have read to post #122 - perhaps a Word document in the RAR file with a summary of the 'read me' would be useful

Reply With Quote
The following 2 users say Thank You to Superdoug3 for this post:
 
(login for full post details)
  #233 (permalink)
England
 
Experience: Advanced
Platform: SierraChart
 
Posts: 69 since Jul 2009
Thanks: 9 given, 78 received

Superdoug

I have just looked at your contribution in the SierraChart Download section and it looks like the spreadsheet file (scwbf) is missing from the zip file. Maybe you can check it?

Regards

Rob




Superdoug3 View Post
Just a suggestion; I have been reading the metrics journal and find Big Mikes metric journal the most to my liking.
I posted a Sierra Chart 'spreadsheet for auto trading' in the Downloads section and then realized that not everyone is familiar with the technical details of Sierra Chart, so I included a 'how to' for updating your Sierra Chart folder, how to modify what I had submitted and dangerous things you should not do because of how Sierra Chart works.


Reply With Quote
 
(login for full post details)
  #234 (permalink)
Vernon, BC, Canada
 
Experience: Beginner
Platform: Sierra Charts
Broker: Zaner Group (Transact)
Trading: ES
 
Posts: 103 since Apr 2010
Thanks: 113 given, 63 received

thank you Swandro - SORRY to anybody to downloaded my useless Sierra Chart zip file. I uploaded the latest files just now

Reply With Quote
The following user says Thank You to Superdoug3 for this post:
 
(login for full post details)
  #235 (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

As promised, but late, here comes an other update....


Changelog:

Included very crude readme.
Errors pointed out by @madLyfe corrected.
Some minor bits and bobs I can't remember right now...


vvhg

Hic Rhodos, hic salta.
Attached Files
Register to download File Type: rar Journal 2.0.8.rar (1.72 MB, 98 views)
Reply With Quote
The following 7 users say Thank You to vvhg for this post:
 
(login for full post details)
  #236 (permalink)
Vernon, BC, Canada
 
Experience: Beginner
Platform: Sierra Charts
Broker: Zaner Group (Transact)
Trading: ES
 
Posts: 103 since Apr 2010
Thanks: 113 given, 63 received

thank you VVHG
with the great exchange between you and Madlyfe, I was able to comb some tips from this thread and put into my own readme. I include it as a word file. I look forward to using Journal 2, thank you for all of your developments in this project.

Attached Files
Register to download File Type: docx How to.docx (19.6 KB, 96 views)
Reply With Quote
The following 6 users say Thank You to Superdoug3 for this post:
 
(login for full post details)
  #237 (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

so from 2.0.7 -> 2.0.8 i cant just copy the journal over because you made changes to the journal coding. so i should copy each green column individually?

also i dont think the issue with the rounding in the journal tab is fixed.

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)
  #238 (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
so from 2.0.7 -> 2.0.8 i cant just copy the journal over because you made changes to the journal coding. so i should copy each green column individually?

Unfortunately, yes.



madLyfe View Post
also i dont think the issue with the rounding in the journal tab is fixed.

Oops! Where??


vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #239 (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


Superdoug3 View Post
thank you VVHG
with the great exchange between you and Madlyfe, I was able to comb some tips from this thread and put into my own readme. I include it as a word file. I look forward to using Journal 2, thank you for all of your developments in this project.


Thanks! This is excellent! With your permission I would like to use it for, or in fact as the help/readme....

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #240 (permalink)
Vernon, BC, Canada
 
Experience: Beginner
Platform: Sierra Charts
Broker: Zaner Group (Transact)
Trading: ES
 
Posts: 103 since Apr 2010
Thanks: 113 given, 63 received

Sure - go ahead
I had experience with Excel 2002, so was unfamiliar with many of the features you discuss. I viewed the tutorial video and found out Excel 2010 is so much better.
I include an updated version - just a few tips on how to use Excel 2010.

Attached Files
Register to download File Type: docx How to.docx (19.8 KB, 58 views)
Reply With Quote
The following 5 users say Thank You to Superdoug3 for this post:
 
(login for full post details)
  #241 (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! Where??
vvhg

in the journal, for me, the entry/exit columns..

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)
  #242 (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, could you tell me in what specific cases or post some screenshots of that and your inst list??
Thanks!


vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #243 (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 here is what I came up with as a readme. It's mostly copy/paste from @Superdoug3 as he put a lot of time into that and did a brilliant job.
I think it's a good start for a readme and we can expand it as we go along...


vvhg

Hic Rhodos, hic salta.
Attached Files
Register to download File Type: docx How to.docx (20.4 KB, 62 views)
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #244 (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
@madLyfe, could you tell me in what specific cases or post some screenshots of that and your inst list??
Thanks!


vvhg

its basically the same issue as before that you can see here:


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)
  #245 (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

Strange, it's working on my side....

As I interpret the screnshot only ES is the problem....TF and 6E seem to be fine....

Could you perhaps post a screenshot of your instrument list and the conditional formatting rules?
For th latter do the following:
1. unprotect
2. select one of the ES entry price cells
3. go to conditional formatting
4. select manage rules
5. make screenshot

Thanks for all your help!

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #246 (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
Strange, it's working on my side....

As I interpret the screnshot only ES is the problem....TF and 6E seem to be fine....

Could you perhaps post a screenshot of your instrument list and the conditional formatting rules?
For th latter do the following:
1. unprotect
2. select one of the ES entry price cells
3. go to conditional formatting
4. select manage rules
5. make screenshot

Thanks for all your help!

vvhg

where is this at? '3. go to conditional formatting'

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)
  #247 (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.

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

Name:	CF.JPG
Views:	54
Size:	152.0 KB
ID:	55841  
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #248 (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

here you are:



you can also see that i pointed out, if you have 6E where all the decimal places are there, the others should do that as well. so if a price entered is 720.90, it shouldnt be 720.9, or 1254.50 shouldnt be 1254.5 etc..


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)
  #249 (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

Thanks.
For some reason you still hve the old formatting rules. Coul you double check that you are using the current version and used the proper migration guide?

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #250 (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
Thanks.
For some reason you still hve the old formatting rules. Coul you double check that you are using the current version and used the proper migration guide?

vvhg

well if i enter the trade manually, starting fresh with no copy/pasting, it works fine. but if im copying over my old trades it doesnt work.. if i do the copy the whole journal method, or if i do it column by column..

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)
  #251 (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 to paste and select "match destinaion formatting"?

vvg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #252 (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 to paste and select "match destinaion formatting"?

vvg

when copying from old journal to new one? and should i do it column by column this way?

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)
  #253 (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. You could try the whole page (it should work, I think), and if that doesn't work then try column by column.


vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #254 (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. You could try the whole page (it should work, I think), and if that doesn't work then try column by column.


vvhg

this time around i did it column by column, and it worked perfectly.. now the only problem left is on sat the TF where 765.90 = 765.9 in the journal..



also i think the internal calcs sheet should be hidden by default.

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)
  #255 (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

TF seems to be right as tick size is 0.1 on your Inst list (see screenshot).


vvhg

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

Name:	tf.JPG
Views:	42
Size:	47.6 KB
ID:	55925  
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #256 (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
TF seems to be right as tick size is 0.1 on your Inst list (see screenshot).


vvhg

how would you go about making the TF, GC, CL etc. have two decimal places?

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)
  #257 (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

As decimal places are now determined by tick size CL would have two decimal places, the others mentoned would have not though.

The only way to work around that is to have a cloumn in the inst list of how many deimal places to show...
What do you think?


vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #258 (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
As decimal places are now determined by tick size CL would have two decimal places, the others mentoned would have not though.

The only way to work around that is to have a cloumn in the inst list of how many deimal places to show...
What do you think?


vvhg

i am totally cool with that.. we could maybe expand the default inst list too so that way its already done for people, and they can just delete what they don't want instead of having to go in and add them causing more confusion? anyways yes i like the decimal idea..

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)
  #259 (permalink)
Vernon, BC, Canada
 
Experience: Beginner
Platform: Sierra Charts
Broker: Zaner Group (Transact)
Trading: ES
 
Posts: 103 since Apr 2010
Thanks: 113 given, 63 received

looks like awhile since anybody posted here.
Questions
1. column O - is green but it is calcuated automatically, what does the up green arrow mean, if anything
2. Column U - what is column U - Bench mark for
3.
4. I see there is specific logic for VWAP value - is this complicated
4.1 is adding another column (say after VWAP) going to throw out all of the other calculations (not suggesting to do this, just wondering on how flexible this is)
5. I added method - Crossover - I entered 1 trade into journal using Crossover - then went to Pivot Table and only found S/R and Fade Channel listed.
6. Overview - found some invalid fields filled with ######
6.1 Average Net Profit (exit 1 and exit 2)

Reply With Quote
 
(login for full post details)
  #260 (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. Indicates above/below vwap
2. see readme here
4. Sorry, didn't get your point, what do you mean exactly?
4.1.Short aswer: Yes!
5.There are very likely some filters applied to the pivot tables, make sure to also select crossover method there.
6. Have you entered any exits 2&3?

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #261 (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

Finally a new version:

1. implemented this:

vvhg View Post
As decimal places are now determined by tick size CL would have two decimal places, the others mentoned would have not though.

The only way to work around that is to have a cloumn in the inst list of how many deimal places to show...
What do you think?


vvhg

2. greatly improved the drawdown calculation for the monte carlo engine.
3. new, improved but still rudimentary readme
4. for the ones interested in excel: on the overview tab on the right are calculations for risk of ruin, they are still flawed, se also this thread


vvhg

Hic Rhodos, hic salta.
Attached Files
Register to download File Type: rar Journal 2.1.rar (4.02 MB, 52 views)
Reply With Quote
The following 2 users say Thank You to vvhg for this post:
 
(login for full post details)
  #262 (permalink)
Vernon, BC, Canada
 
Experience: Beginner
Platform: Sierra Charts
Broker: Zaner Group (Transact)
Trading: ES
 
Posts: 103 since Apr 2010
Thanks: 113 given, 63 received

thank you for the quick response
2. silly me - I created this 'how to'
4. my thoughts - Big Mike put in VWAP because he was evaluating VWAP, I would like to put in other columns for evaluation, then export them and import to Access DB. This might mean removing VWAP logic in the journal or modifying it. Since I can not add extra columns without destroying the journal, this idea is probably out
5. worked, thank you, I noticed that I have 7 entries in my methods list, the trade types drop down menu has my new entries but retained all of the old entries including ones that I deleted from my methods list
6 . Avg Net Profit Exit 1 and Exit 2 seem to be OK now, but I am getting Divide by 0 error in Avg Benchmark efficiency exit 2, profit factor exit 1, win/loss ration exit 1. I only have 6 entries of which only 1 is exit 2, so small sample size.
7. I have attached screen shots and am wondering about gain/contract for the last trade in row 8

Attached Thumbnails
Click image for larger version

Name:	2011-12-12_0623.png
Views:	68
Size:	9.7 KB
ID:	57064   Click image for larger version

Name:	2011-12-12_0624.png
Views:	58
Size:	14.4 KB
ID:	57065  
Reply With Quote
 
(login for full post details)
  #263 (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


Superdoug3 View Post
thank you for the quick response
2. silly me - I created this 'how to'
4. my thoughts - Big Mike put in VWAP because he was evaluating VWAP, I would like to put in other columns for evaluation, then export them and import to Access DB. This might mean removing VWAP logic in the journal or modifying it. Since I can not add extra columns without destroying the journal, this idea is probably out
5. worked, thank you
6 . Avg Net Profit Exit 1 and Exit 2 seem to be OK now, but I am getting Divide by 0 error in Avg Benchmark efficiency exit 2, profit factor exit 1, win/loss ration exit 1. I only have 6 entries of which only 1 is exit 2, so small sample size.
7. I have attached screen shots and am wondering about gain/contract for the last trade in row 8

4. sounds sensible... shout if you need help, also possible but not very practical would be to add columns to the far right...
6. the Div/0 errors vanish as soon as there is sufficient data in the journal tab.
7. seems at least consistant with row 4...

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #264 (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

2.1 is now taking considerable processing when just viewing the overview tab compared to the previous versions.. the other tabs do as well(not the read me, trading plan, instrument list, method list etc..)

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)
  #265 (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'll look into that, probably is due to the monte carlo...


vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #266 (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, found a way to limit the recalc scope.....should be much lighter on CPU now (Monte Carlo is kind of heavy though, 50 iterations take their toll)

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #267 (permalink)
Vernon, BC, Canada
 
Experience: Beginner
Platform: Sierra Charts
Broker: Zaner Group (Transact)
Trading: ES
 
Posts: 103 since Apr 2010
Thanks: 113 given, 63 received

I guess this is an example of columns not wide enough for the values
I started entering CL and switched to 6E and the now the value in entry and exit and point value columns shows #####
I guess any solution would be helpful

Attached Thumbnails
Click image for larger version

Name:	2011-12-13_0814.png
Views:	50
Size:	48.9 KB
ID:	57180  
Reply With Quote
 
(login for full post details)
  #268 (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


Superdoug3 View Post
I guess this is an example of columns not wide enough for the values
I started entering CL and switched to 6E and the now the value in entry and exit and point value columns shows #####
I guess any solution would be helpful

you can double click the the top columns line to widen it, but the journal tab is supposed to auto configure the width if i remember correctly..

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)
  #269 (permalink)
Dublin
 
Experience: Intermediate
Platform: NinjaTrader
Trading: YM,NQ
 
mikky182's Avatar
 
Posts: 295 since Oct 2010
Thanks: 464 given, 505 received


Superdoug3 View Post
I guess this is an example of columns not wide enough for the values
I started entering CL and switched to 6E and the now the value in entry and exit and point value columns shows #####
I guess any solution would be helpful

Go to review menu (review tab), click on unprotect sheet then increase the size of the entry/exit box. Back to review and hit protect the sheet again.. This will do the trick

Attached Thumbnails
Click image for larger version

Name:	Excel.png
Views:	63
Size:	47.9 KB
ID:	57183  
Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to mikky182 for this post:
 
(login for full post details)
  #270 (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

No need to unprotect anything, just activate an other tab and then journal tab again, that should trigger the auto fit.


vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #271 (permalink)
Vernon, BC, Canada
 
Experience: Beginner
Platform: Sierra Charts
Broker: Zaner Group (Transact)
Trading: ES
 
Posts: 103 since Apr 2010
Thanks: 113 given, 63 received

1. I did activate other tabs and returned to journal, this did make my values readable a couple of days ago, but not now, I think it may have to do with starting with CL and moving to 6E. I have not downloaded the new journal file
2. I unprotected journal tab, double clicked it and adjusted width, then reprotected, this worked
3. I have about 20 trades entered, but only 6 show up in my pivot table, how do I 'recalculate' pivot table with all trades

Reply With Quote
 
(login for full post details)
  #272 (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 should not make any difference with what you start. There is a code that should do exactly the same what you did manually, unprotect, doubleclick column, protect. So it seems that the code is for some obscure reason not firing as intended.
Regarding the trades missing in the pivot table, to which pivot table are you referring exactly?

vvhg

P.s. Could you please check again that macros are in fact enabled?

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #273 (permalink)
Vernon, BC, Canada
 
Experience: Beginner
Platform: Sierra Charts
Broker: Zaner Group (Transact)
Trading: ES
 
Posts: 103 since Apr 2010
Thanks: 113 given, 63 received

1. Pivot table - I am referring to Grand totals - column F and inside the box under column J, K, L
2. I do not know how to use some of the supplied info and plan to find out more later, after I have more trades entered
2.1 Position Size calculator - I have about 7 lines that start at -2 and go to 0 Contracts, AND none of the lines enter into the positive # of contracts. Is it telling me I should not be trading
2.2 Overview - Hourly Profit per trade - I presume this is trying to show which hours are profitable or not, but no labels on the X-axis. I also see numbers 6, 7, 8 inside some bars showing my losses, perhaps these are the # of trades used to get these losses.

Reply With Quote
The following user says Thank You to Superdoug3 for this post:
 
(login for full post details)
  #274 (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


Superdoug3 View Post
1. Pivot table - I am referring to Grand totals - column F and inside the box under column J, K, L
2. I do not know how to use some of the supplied info and plan to find out more later, after I have more trades entered
2.1 Position Size calculator - I have about 7 lines that start at -2 and go to 0 Contracts, AND none of the lines enter into the positive # of contracts. Is it telling me I should not be trading
2.2 Overview - Hourly Profit per trade - I presume this is trying to show which hours are profitable or not, but no labels on the X-axis. I also see numbers 6, 7, 8 inside some bars showing my losses, perhaps these are the # of trades used to get these losses.


1. Seems to be that the tables are not refreshing as intended or have some filters applied: see button next to trade types (A3) and next to Date (J3).
2.1 This was an error in the calculation, will be fixed in the next version (well spotted, thanks)
2.2 No that should be the hours.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #275 (permalink)
Vernon, BC, Canada
 
Experience: Beginner
Platform: Sierra Charts
Broker: Zaner Group (Transact)
Trading: ES
 
Posts: 103 since Apr 2010
Thanks: 113 given, 63 received

1. - Pivot Table - I tried to 'clear date filters' - it did uncheck the date filter but still only getting 1 day - Nov 1, 2011 (6 trades) and blank (2307 rows)
- tried to uncheck all dates, would not let me

Reply With Quote
 
(login for full post details)
  #276 (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

Thanks for the feedback.
To be honest, I ran out of ideas.
I could have a look at your file, but it might be easier to wait a bit as I'll have a new version up tomorrow, perhaps you could switch to that then and see whether the error persists.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #277 (permalink)
Vernon, BC, Canada
 
Experience: Beginner
Platform: Sierra Charts
Broker: Zaner Group (Transact)
Trading: ES
 
Posts: 103 since Apr 2010
Thanks: 113 given, 63 received

I will switch to new release tomorrow, maybe screen printouts would help or I can also send a CSV file (comma separated variables)

also Pivot Table Date Filter shows a date for every trade day I have entered in a drop down, will this show 2500 dates when I have 10 years data entered, all in a drop down menu. I haven't used the data filter service, so I do not know how flexible it is - i.e can you specify different ranges of dates and exclude some dates inside of these ranges

how about a more database way of specifying

specify date
between mm-dd-yyyy to mm-dd-yyyy AND
between mm-dd-yyyy to mm-dd-yyyy AND
between mm-dd-yyyy to mm-dd-yyyy
exclude mm-dd-yyyy to mm-dd-yyyy
exclude mm-dd-yyyy to mm-dd-yyyy AND
exclude mm-dd-yyyy to mm-dd-yyyy AND
I know that this is not as flexible, but an option

Reply With Quote
 
(login for full post details)
  #278 (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, you could apply quite sophisticated filters based on rather complicated rules. The easiest way would be to google the pivot table filter functions....


vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #279 (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 a minor update.

Corrected an error in the position size calculator which @Superdoug3 pointed out.

Let me stop here for a second and say thanks. Developing this journal has been an incredible journey for me, I have learned a lot about excel, especially vba, but more importantly, it has also taught me a great deal about trading. As I had to think about all the stats and tools in the journal they got quite important to me. I see it a bit like a workman who needs his tools to do his job. Without the proper tools for money management, risk assessment, risk management and actually verifying that I am still on track within statistical variance has been an incredible help (and at times a much appreciated boost of confidence).
But above all else it has taught me to journal religiously.

Although many people have participated in this thread and my sincere thanks go to all of them, I first and foremost have to thank two people without whom this learning experience would not have been possible:

@Big Mike for starting this thread and this journal and letting me hijack it (and of course thanks for this amazing forum). I feel like the dwarf standing on the shoulder of a giant.

@madLyfe for countless valuable ideas and feedback as well as for his tireless search for all my errors.


vvhg

Hic Rhodos, hic salta.
Attached Files
Register to download File Type: rar Journal 2 .2.rar (3.93 MB, 63 views)
Reply With Quote
The following 11 users say Thank You to vvhg for this post:
 
(login for full post details)
  #280 (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

Due to a minor error (Monte Carlo account chart was not auto scaling y-axis correctly) I have exchanged the file in the previous post, sorry for any inconvenience caused.


vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #281 (permalink)
Vernon, BC, Canada
 
Experience: Beginner
Platform: Sierra Charts
Broker: Zaner Group (Transact)
Trading: ES
 
Posts: 103 since Apr 2010
Thanks: 113 given, 63 received

I have tried your migration method (CtrlA - CtrlC) several times - when I paste in A1 all columns after AJ are incorrect

I tried just copying columns B - AJ (since this is the data I enter) and and pasting just to B - AJ they do not fill in correctly
I tried creating a CSV file, but lose the formatting
what am I doing wrong

Reply With Quote
 
(login for full post details)
  #282 (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 tried to migrate from 2.0.8 to the current version and everything worked out as intended.
Could you please tell me which version you are using at the moment, so I can try to reproduce the error?

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #283 (permalink)
Vernon, BC, Canada
 
Experience: Beginner
Platform: Sierra Charts
Broker: Zaner Group (Transact)
Trading: ES
 
Posts: 103 since Apr 2010
Thanks: 113 given, 63 received

well that is interesting
I am converting from V2.0.8 to V2.2
1. I copied my instruments list and methods list from V2.0.8 first so that they would be there for reference
2. I reset starting account to $25k
3. I did Ctrl A ctrl C on Journals tab and pasted in A1 of new version
4. I attached a screen print of A - AJ as you can see minutes columns are messed up
5. I see the first 22 rows are greyed out, but you can see the bottom rows have % and a green circle in minutes columns
6. looks like 3 columns are missing AF should be AJ

Attached Thumbnails
Click image for larger version

Name:	2011-12-15_1146.png
Views:	56
Size:	99.8 KB
ID:	57422   Click image for larger version

Name:	2011-12-15_1155.png
Views:	77
Size:	76.6 KB
ID:	57424  
Reply With Quote
 
(login for full post details)
  #284 (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


Superdoug3 View Post
well that is interesting
I am converting from V2.0.8 to V2.2
1. I copied my instruments list and methods list from V2.0.8 first so that they would be there for reference
2. I reset starting account to $25k
3. I did Ctrl A ctrl C on Journals tab and pasted in A1 of new version
4. I attached a screen print of A - AJ as you can see minutes columns are messed up
5. I see the first 22 rows are greyed out, but you can see the bottom rows have % and a green circle in minutes columns
6. looks like 3 columns are missing AF should be AJ

i always just copy the data column by column and only the data and not the column titles.. i couldnt get the other ways to work..

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)
  #285 (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
i always just copy the data column by column and only the data and not the column titles.. i couldnt get the other ways to work..

Have you tried recently?

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #286 (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


Superdoug3 View Post
well that is interesting
I am converting from V2.0.8 to V2.2
1. I copied my instruments list and methods list from V2.0.8 first so that they would be there for reference
2. I reset starting account to $25k
3. I did Ctrl A ctrl C on Journals tab and pasted in A1 of new version
4. I attached a screen print of A - AJ as you can see minutes columns are messed up
5. I see the first 22 rows are greyed out, but you can see the bottom rows have % and a green circle in minutes columns
6. looks like 3 columns are missing AF should be AJ

Would you mind sending me your journal via PM so I can track the error on my side?

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #287 (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
Have you tried recently?

vvhg

nah, still back on 0.7 will try todays update sometime tonight..

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)
  #288 (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, just remember that from 0.7 you have to go column by 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)
  #289 (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, just remember that from 0.7 you have to go column by column.

vvhg

ya that seems like its always the safest route anyways for awhile

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)
  #290 (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

Well, theoretically the easy method should work from 0.8 onwards, and it does on my side. As long as it works it is definitely the safer way.

Anyways, it's quite easy to try and if it fails to do it column by 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)
  #291 (permalink)
Vernon, BC, Canada
 
Experience: Beginner
Platform: Sierra Charts
Broker: Zaner Group (Transact)
Trading: ES
 
Posts: 103 since Apr 2010
Thanks: 113 given, 63 received

well to save making a fool of myself and to not waste your time, I downloaded 2.2 from yesterday (slightly newer version than I was using) and followed the method to migrate exactly as you said and it worked as you said.

Pivot Table
1. I added Crossover, Pullback, Continuation to my Methods list, the Trade Types dropdown does not reflect these 3 new trade types
2. I have 44 trades entered, I cleared the Date Filter and the 'total number of trades' shows 3 - presume I need to learn more about using Date Filter
3. I do not know where those dates came from in the Date Filter drop down menu, I guess these are dates that you entered and are left there by Excel.
4. will send my xlsm via pm to you

Reply With Quote
 
(login for full post details)
  #292 (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

@Superdoug3, I sent you a PM.

Also if you want to get rid of the count of blanks in that pivot table, go to the filter in J3 -> Date Filters -> Between and enter first date way in the past and second way in the future, that will exclude the blanks.


vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #293 (permalink)
Vernon, BC, Canada
 
Experience: Beginner
Platform: Sierra Charts
Broker: Zaner Group (Transact)
Trading: ES
 
Posts: 103 since Apr 2010
Thanks: 113 given, 63 received

I see that I am not being understood. some of my problems are with the drop down menus in Pivot Table. I tried to capture the drop down menu image, but can not, so I have images below with arrows to the drop down menus I am talking about
1. in my methods table you will see that I have 7 methods of which I am using Crossover, Pullback, Continuation in my journals
1.1 in Pivot Table - see green arrow to Trade Types, if I open this drop down I see 11 methods none of which are Crossover, Pullback or Continuation, and you will see I have 2 Pivot Tables displayed, S/R and Fade Channel of which I have No journal entries for
2. in Pivot Table there is a green arrow to Date Filter drop down menu, I have cleared the Date Filter and yet I is selecting only 4 trades. I tried selecting all dates in the period November and it still gives me the same dates in October.

Attached Thumbnails
Click image for larger version

Name:	2011-12-18_0830.png
Views:	44
Size:	17.0 KB
ID:	57626   Click image for larger version

Name:	2011-12-18_0831.png
Views:	39
Size:	14.0 KB
ID:	57627  
Attached Images
 
Reply With Quote
 
(login for full post details)
  #294 (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


Superdoug3 View Post
1.1 in Pivot Table - see green arrow to Trade Types, if I open this drop down I see 11 methods none of which are Crossover, Pullback or Continuation, and you will see I have 2 Pivot Tables displayed, S/R and Fade Channel of which I have No journal entries for

Ok, I have understood it now. And I was able to replicate it, but only when macros were disabled. So please make sure you have macros enabled, otherwise it will not work.
If macros are enabled then just go to journal tab, back to pivot table tab and then select the filter.

Superdoug3 View Post
2. in Pivot Table there is a green arrow to Date Filter drop down menu, I have cleared the Date Filter and yet I is selecting only 4 trades. I tried selecting all dates in the period November and it still gives me the same dates in October.

Same here.

I hope that helps.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #295 (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

Just in case you need help enabling macros I made a few screenshots:



vvhg

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

Name:	trust center.JPG
Views:	52
Size:	79.3 KB
ID:	57629   Click image for larger version

Name:	trust center2.JPG
Views:	48
Size:	62.1 KB
ID:	57630   Click image for larger version

Name:	trust center3.JPG
Views:	48
Size:	33.0 KB
ID:	57631   Click image for larger version

Name:	trust center4.JPG
Views:	51
Size:	67.4 KB
ID:	57632  
Reply With Quote
 
(login for full post details)
  #296 (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 some reason it still take forever to reload when switching between pages.. also the decimal places thing isnt working no matter what value i put in.. im going to play with it some more to see if its something ive done wrong and i will post back..

-------------------------------------------------------------------

ok i got the decimal places thing working.. im not sure if its cuz i didnt copy and paste only values on the instrument list or on the journal side, but i did paste values only on the second time around on both and it works now.. the calculations are still an issue.. well compared to 2.0.7 and 2.0.8 they are..

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)
  #297 (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
ok i got the decimal places thing working.. im not sure if its cuz i didnt copy and paste only values on the instrument list or on the journal side, but i did paste values only on the second time around on both and it works now..

Precisely it was because you also copied the format on the journal tab. The logic for the decimals is in the formatting as no values change in any case, the only thing that can change there is how the value will be displayed.


madLyfe View Post
the calculations are still an issue.. well compared to 2.0.7 and 2.0.8 they are..

Seems to be identical to 2.0.8 on my side.... would you mind sending me a PM with your journal (if you don't want me to see your trades, you could delete (ideally only some of) them) so I can compare the calc times and hopefully fix it?


vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #298 (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
Precisely it was because you also copied the format on the journal tab. The logic for the decimals is in the formatting as no values change in any case, the only thing that can change there is how the value will be displayed.

Seems to be identical to 2.0.8 on my side.... would you mind sending me a PM with your journal (if you don't want me to see your trades, you could delete (ideally only some of) them) so I can compare the calc times and hopefully fix it?


vvhg

ah ok, i thought that if it was protected that it wouldnt accept any new formatting just values..

umm even with the default trades you have entered on a clean journal fresh from zip its the same speed for 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)
  #299 (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

Hmm, for me it's identical to 0.8......that's somehow strange, let me double check the file I posted.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #300 (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
Hmm, for me it's identical to 0.8......that's somehow strange, let me double check the file I posted.

vvhg

here i made a video of each fresh from the zip files:

2011-12-20_0254.swf

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:


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


Last Updated on April 29, 2020


Upcoming Webinars and Events
 

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