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:165,887 / 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

  #801 (permalink)
Elite Member
Toronto, ON, Canada
 
Futures Experience: Intermediate
Platform: NinjaTrader
Broker/Data: Global futures (Continum), IB, FXCM
Favorite Futures: ES 6E Forex ETF
 
Anatta's Avatar
 
Posts: 41 since Sep 2012
Thanks: 201 given, 28 received

Journal 4.3


vvhg View Post
2007 should be fine.
The error you get should not be there, it seems to be some kind of bug. I will try to reproduce and fix this.

Vvhg

I think I am ok. I figures that whenever there are some inconsistent logic on the input, the same error message when I try to save the file. Let say if I put 20 on point value, the tick value must be lower, if not the inconsitenct will create problem. Or if I change the name of the instrument or whatever, I have to make sure other pages have made the changes properly. Any slight inconsistency will create an error.
The difficulty is that there is no hints pointing to the problem area. I guess the main reason is I am not familiar with the spreasheet. I will have to play around it more to understand how it works.

Anyway. Big thanks. The spreadsheet is very comprehensive and you have put a lot of effort to build it.

Reply With Quote
The following user says Thank You to Anatta for this post:
 
  #802 (permalink)
Make it count
Vancouver, Canada
 
Futures Experience: Beginner
Platform: SC
Favorite Futures: Guitar
 
traveller's Avatar
 
Posts: 118 since Mar 2012
Thanks: 222 given, 179 received


NW27 View Post
I couldn't find anything that did this style of thing, so I ended up making my own.
I got this far and became sidetracked on other things.
To give you an idea of what I keep, here are some screen shots.

Neil.

Now this seems like a great Journal- I like the idea of putting the data on one page for the day then in the background all the info is tabulated. Great user interface and simple to use.

Few Questions?
How does your spreadsheet cope when adding data that is scaled in and out of trades? Multiple entries etc
DO you collate MAE and MFE and or R?


Regards

"Train yourself to let go of everything you fear to lose."
-Yoda, Star Wars Episode III Revenge of the Sith
Reply With Quote
 
  #803 (permalink)
Elite Member
Newcastle, Australia
 
Futures Experience: Intermediate
Platform: Multicharts 8 - Full Version
Broker/Data: IB
Favorite Futures: SPI,FTSE100, 6E, 6A
 
Posts: 285 since Oct 2010
Thanks: 108 given, 177 received



traveller View Post
Now this seems like a great Journal- I like the idea of putting the data on one page for the day then in the background all the info is tabulated. Great user interface and simple to use.

Few Questions?
How does your spreadsheet cope when adding data that is scaled in and out of trades? Multiple entries etc
DO you collate MAE and MFE and or R?


Regards

Thanks, It's a work in progress.

In regard to your questions -
1. I tossed and turn on this one. In regard to scaling in with multiple entries, basically I decided on the fact that each new trade entry was a new trade with it's own risk ie you could buy 5 contracts at 4000 with a stop at 3990, risk 5*10. Prive moves in your favour and goes to 4020 so currently long at 4000 with 5 contracts, Buy another 5 at 4020.
What is the risk? Is the risk on these new 5< 4015? Or if we are willing to say we are playing with the markets money, there is no risk because we are plus 15 on the trade?
To hard. Each new entry has it's own risk.
2. Staged exits are allowed. Ie Trade entry, Buy 20, Sell 10 PT, Sell 5 on PT, trail last 5.
Note, each of these exits has it's own recorded reason for exit ie PT or TS.
3. MAE is based on the worst case from the entry. MFE is based on the least performing exit. Ie in answer 2 this would be the 10 PT exit.
As you can see, each exit has it's own MAE and MFE recorded and then at the bottom in the summary area, the worst case is displayed.

Neil.

Reply With Quote
The following user says Thank You to NW27 for this post:
 
  #804 (permalink)
Observe. Know yourself
Granada, Spain
 
Futures Experience: Advanced
Platform: Multicharts
Broker/Data: IB
Favorite Futures: Futures, FX
 
dog4's Avatar
 
Posts: 13 since Jan 2012
Thanks: 11 given, 40 received

I presume MAE is in ticks as defined per instrument in the file?

And same for Benchmark?

thanks for your help.



vvhg View Post
Benchmark is the maximum favourable excursion of the trade WHILE still in the trade. MFE2 is the maximum favourable excursion BEFORE or AFTER the trade was exited.

There also is a rudimentary help file that explains some of the stats.


vvhg


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


dog4 View Post
I presume MAE is in ticks as defined per instrument in the file?

And same for Benchmark?

thanks for your help.

Yes, that is correct, everything is on a tick basis, same for initial risk and many metrics on Overview tab.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
  #806 (permalink)
Elite Member
Sydney, Australia
 
Futures Experience: Intermediate
Platform: NinjaTrader
Broker/Data: Kinetick/IB
Favorite Futures: ES
 
NoMagic's Avatar
 
Posts: 13 since Nov 2012
Thanks: 33 given, 4 received

Problems with importing


perryg View Post
No matter what I do I get an error "string was not recognized as a valid Date Time". I use the format DD/MM/YYYY in Ninja, so maybe you are checking for the USA format of MM/DD/YYYY or something different. Can this be fixed to recognize different date formats.

Hi vvhg

First of all thank you for your hard work and generous spirit in sharing and updating this Journal for communal use. I had put one of my own together and was looking for ways to improve it when I found yours. Needless to say, mine is now confined to the archives section on my backup drive!

I have a question regarding the importing of the NT7 .csv files into the excel sheet. I am encountering exactly the same errors as perryg in the quote above. I have tried all kinds of configurations but I don't know what I am doing wrong to get this error. Any pointers would be much appreciated.

Secondly, I trade from Sydney, Australia so are there any other settings that I need to be wary of?


Many thanks again for the great work.

Mike

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


NoMagic View Post
Hi vvhg

First of all thank you for your hard work and generous spirit in sharing and updating this Journal for communal use. I had put one of my own together and was looking for ways to improve it when I found yours. Needless to say, mine is now confined to the archives section on my backup drive!

I have a question regarding the importing of the NT7 .csv files into the excel sheet. I am encountering exactly the same errors as perryg in the quote above. I have tried all kinds of configurations but I don't know what I am doing wrong to get this error. Any pointers would be much appreciated.

Secondly, I trade from Sydney, Australia so are there any other settings that I need to be wary of?


Many thanks again for the great work.

Mike

Thank you for your kind words. Regarding the importer for NT trades, I have never used it, so I can not offer any help. You would have to ask @petrmac as he created it.
I am not aware of any other settings you would have to change, just remember that the journal can only handle one currency correctly (if the account balance has to stay correct...).

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following 2 users say Thank You to vvhg for this post:
 
  #808 (permalink)
Elite Member
Washington DC/USA
 
Futures Experience: Intermediate
Platform: NinjaTrader7, TOS
Broker/Data: ATInfinity/Kinectick
Favorite Futures: ES, Forex
 
jmccabeVA's Avatar
 
Posts: 11 since Oct 2011
Thanks: 0 given, 4 received

Just downloaded teh Trade tracking spreadsheet. In your summary you state to delete trades in the "journal Tab". The only tabs on the workbook are "trade tracking" and "sheet1". Are you speaking of some other area on the sheet? A column?

Reply With Quote
 
  #809 (permalink)
Elite Member
Washington DC/USA
 
Futures Experience: Intermediate
Platform: NinjaTrader7, TOS
Broker/Data: ATInfinity/Kinectick
Favorite Futures: ES, Forex
 
jmccabeVA's Avatar
 
Posts: 11 since Oct 2011
Thanks: 0 given, 4 received

Well bummer. Appears this was built to only run on MS Excel in windows. Tried to run in Excel for Mac 2011 and nothing but a bunch of VB script errors. :-(

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



jmccabeVA View Post
Just downloaded teh Trade tracking spreadsheet. In your summary you state to delete trades in the "journal Tab". The only tabs on the workbook are "trade tracking" and "sheet1". Are you speaking of some other area on the sheet? A column?

Are you sure you have the right journal? There are other people's journals in here too...

jmccabeVA View Post
Well bummer. Appears this was built to only run on MS Excel in windows. Tried to run in Excel for Mac 2011 and nothing but a bunch of VB script errors. :-(

If you are referring to my journal, that is correct, as I have no mac compatibility is limited to windows. However, you could run it on a virtual windows machine...

vvhg

Hic Rhodos, hic salta.
Reply With Quote

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 04:51 PM.

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-14 in 0.15 seconds with 20 queries on phoenix via your IP 54.221.73.186