Trading Metrics for journals/record keeping - Psychology and Money Management | futures io social day trading
futures io futures trading


Trading Metrics for journals/record keeping
Updated: Views / Replies:166,655 / 928
Created: by Big Mike Attachments:253

Welcome to futures io.

(If you already have an account, login at the top of the page)

futures io is the largest futures trading community on the planet, with over 90,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors Ė all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you donít need to worry about fake reviews.

We are fundamentally different than most other trading sites:
  • We are here to help. Just let us know what you need.
  • We work extremely hard to keep things positive in our community.
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts.
  • We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

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

Reply
 253  
 
Thread Tools Search this Thread
 

Trading Metrics for journals/record keeping

  #271 (permalink)
Elite Member
Vernon, BC, Canada
 
Futures Experience: Beginner
Platform: Sierra Charts
Broker/Data: Zaner Group (Transact)
Favorite Futures: ES
 
Posts: 103 since Apr 2010
Thanks: 113 given, 62 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
 
  #272 (permalink)
Elite Member
Northern Germany
 
Futures Experience: Intermediate
Platform: NT
Favorite Futures: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,807 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
 
  #273 (permalink)
Elite Member
Vernon, BC, Canada
 
Futures Experience: Beginner
Platform: Sierra Charts
Broker/Data: Zaner Group (Transact)
Favorite Futures: ES
 
Posts: 103 since Apr 2010
Thanks: 113 given, 62 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:
 
  #274 (permalink)
Elite Member
Northern Germany
 
Futures Experience: Intermediate
Platform: NT
Favorite Futures: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,807 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
 
  #275 (permalink)
Elite Member
Vernon, BC, Canada
 
Futures Experience: Beginner
Platform: Sierra Charts
Broker/Data: Zaner Group (Transact)
Favorite Futures: ES
 
Posts: 103 since Apr 2010
Thanks: 113 given, 62 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
 
  #276 (permalink)
Elite Member
Northern Germany
 
Futures Experience: Intermediate
Platform: NT
Favorite Futures: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,807 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:
 
  #277 (permalink)
Elite Member
Vernon, BC, Canada
 
Futures Experience: Beginner
Platform: Sierra Charts
Broker/Data: Zaner Group (Transact)
Favorite Futures: ES
 
Posts: 103 since Apr 2010
Thanks: 113 given, 62 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
 
  #278 (permalink)
Elite Member
Northern Germany
 
Futures Experience: Intermediate
Platform: NT
Favorite Futures: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,807 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
 
  #279 (permalink)
Elite Member
Northern Germany
 
Futures Experience: Intermediate
Platform: NT
Favorite Futures: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,807 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, 56 views)

Last edited by vvhg; December 15th, 2011 at 12:07 PM. Reason: Error in journal (Monte Carlo account graph not autoscaling y-min)
Reply With Quote
The following 11 users say Thank You to vvhg for this post:
 
  #280 (permalink)
Elite Member
Northern Germany
 
Futures Experience: Intermediate
Platform: NT
Favorite Futures: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,807 received

Exchanged file!


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:

Reply



futures io > > > Trading Metrics for journals/record keeping

Thread Tools Search this Thread
Search this Thread:

Advanced Search



Upcoming Webinars and Events (4:30PM ET unless noted)

Jigsaw Trading: TBA

Elite only

FuturesTrader71: TBA

Elite only

NinjaTrader: TBA

Jan 18

RandBots: TBA

Jan 23

GFF Brokers & CME Group: Futures & Bitcoin

Elite only

Adam Grimes: TBA

Elite only

Ran Aroussi: TBA

Elite only
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
Keeping it Simple Silver Dragon Trading Journals 26 September 19th, 2011 06:00 PM
Are there any journals that define a completely OBJECTIVE method? forrestang Psychology and Money Management 46 July 31st, 2011 02:07 AM
ZH0001YE'S Trading Journals zh0001ye Trading Journals 6 March 3rd, 2011 09:23 PM
reading journals rtrade Trading Journals 9 December 2nd, 2010 12:16 PM


All times are GMT -4. The time now is 08:47 AM.

Copyright © 2017 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
Page generated 2017-12-18 in 0.17 seconds with 20 queries on phoenix via your IP 107.20.115.174