Trade statistics spreadsheet - suggestions? - futures io
futures io futures trading



Trade statistics spreadsheet - suggestions?


Discussion in Psychology and Money Management

Updated by JPx2
      Top Posters
    1. looks_one Gary with 9 posts (17 thanks)
    2. looks_two caprica with 5 posts (12 thanks)
    3. looks_3 zeller4 with 3 posts (5 thanks)
    4. looks_4 Big Mike with 2 posts (7 thanks)
      Best Posters
    1. looks_one Big Mike with 3.5 thanks per post
    2. looks_two caprica with 2.4 thanks per post
    3. looks_3 Gary with 1.9 thanks per post
    4. looks_4 zeller4 with 1.7 thanks per post
    1. trending_up 16,403 views
    2. thumb_up 45 thanks given
    3. group 27 followers
    1. forum 37 replies
    2. attach_file 7 attachments




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

Trade statistics spreadsheet - suggestions?

(login for full post details)
  #31 (permalink)
Florida
 
Experience: Intermediate
Platform: NT7
Trading: CL, NQ, NG
 
Posts: 469 since Jun 2009
Thanks: 1,401 given, 402 received


sam028 View Post
Sorry if I'm a bit off-topic, but does someone here have a very basic strategy, which use ATM stuff ?
I just to see how we integrate this, and don't want to reinvent the wheel...

hey sam28

i like the sampleatmstrategy attached as a starting point
i'm currently working with an atm that looks like the attached screenshots with only 2 contracts - these work pretty well for CL
first contract is target 10ticks and after 8 or 9 go to breakeven + 1 tick
(can't figure how to post screenshots of the atm setup windows)

https://screencast.com/t/FHJXv9F782Ri
https://screencast.com/t/mn2ghvmhIP
Kirk

Attached Files
Register to download File Type: zip SampleAtmStrategy_v01.zip (3.5 KB, 68 views)
Reply With Quote
The following 5 users say Thank You to zeller4 for this post:

Can you help answer these questions
from other members on futures io?
Using Built In Volume Profile in the Code
NinjaTrader
EQIX - Digital REITs - any experiences?
Stocks and ETFs
Looking freelancer for MT4 Indicator
Platforms and Indicators
GBP/ARS Pair
Traders Hideout
The Real Forex Trader Series 2
Traders Hideout
 
Best Threads (Most Thanked)
in the last 7 days on futures io
Excited and scared at the same time
13 thanks
What Is the Source of Your Edge??
12 thanks
CME to launch Nasdaq-100 Volatility Index (VolQ) futures
12 thanks
https://ivytrusts.com/ SCAM ALERT
11 thanks
financial transaction tax
10 thanks
 
(login for full post details)
  #32 (permalink)
Florida
 
Experience: Intermediate
Platform: NT7
Trading: CL, NQ, NG
 
Posts: 469 since Jun 2009
Thanks: 1,401 given, 402 received


fesx View Post
Prior today, I always believed that the pot of gold layed with that one indicator I would eventually come across. There are many great strategies, indicators, scalping techniques, but not much discussion regarding money management. I will only say that if as much time and effort was put into money management as what everyone puts into indicator development there would be alot of very wealthy individuals on this board. How do I know???? Today would have been my best day ever had I been live. I am consistently profitable on a daily basis and have been for years. Today, the strategy I worked on, got me a quick pop (on 2 contracts) and then let my winners run on the final 2 contracts.

I am open to some suggestions, criticism, improvements or whatever else you might want to share with me. I will attach a chart with some of the trades, and Excel spreadsheet, ATM Strategy and Stop.

I believe this is an important thread....lets share some ideas and keep this thread active. I am convinced more then ever the pot of gold is right before us, most just fail to realize where this gold lies.

Hi fesx,
Is your data downloading to excel via .csv? or manual entries...

Please explain data transporting method you use.

thx.
kz

Reply With Quote
 
(login for full post details)
  #33 (permalink)
Near Dallas, Texas, US
 
Experience: Advanced
Platform: NinjaTrader
Broker: ZenFire
Trading: CL
 
Gary's Avatar
 
Posts: 1,070 since Jun 2009
Thanks: 502 given, 2,233 received


Keep the thread alive.

Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #34 (permalink)
Netherlands, Blaricum
 
Experience: Intermediate
Platform: Excel, Python, R
Broker: IB
Trading: Options
 
Zwaen's Avatar
 
Posts: 250 since Dec 2010
Thanks: 848 given, 236 received

Hello,



very nice statistics to keep I see. I already kept track of some sort of MAE, but not yet MFE. Thanks for sharing that idea. The statistics can be very insightful in your trading. E.g. you will get a feeling for what are normal losses. For example, it is nice to know if 3 stops being hit ( demoralizing) in a row is “a relatively normal occurrence” or not and it is better to stop trading for the day.


I keep track of 1 more statistic. I like to keep track of some sort of time-based stop loss. What I found out ( in the Eurodollar currency futures 3 min chart) is that if the trade doesn’t move in my direction in 3 1-minute bars ( 180 seconds ) the odds of a profitable trade will become very small. For sake of simplicity:


1) If position in profit after 3 1-minute bars then my SL -> to BE/entry
2) If position in loss after 3 1-minute bars exit immediately. This is more difficult( feelings->accepting the loss). But when after 3 1-minute bars my position is for example in loss for -2 pip it is most of the time( lets say 8/9 out of 10) better to scratch the trade immediately instead of waiting for my hard stoploss to get hit.


The great benefit of this “rule” is that I can minimize losses of the bad trades.


I must say I haven’t got hard statistics of this 180 seconds rule, but it is more from experience (which offcourse could be biased by heuristics).


Maybe it can be valuable for you to track some kind of own version of this statistic. If you have a better idea or think there are flaws in this approach, I would love to hear.


Kind regards,



Willem

Reply With Quote
 
(login for full post details)
  #35 (permalink)
Site Administrator
Manta, Ecuador
 
Experience: Advanced
Platform: My own custom solution
Trading: Emini Futures
 
Big Mike's Avatar
 
Posts: 49,053 since Jun 2009
Thanks: 31,658 given, 94,962 received

Check here for a more detailed journal example in Excel:



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
The following 4 users say Thank You to Big Mike for this post:
 
(login for full post details)
  #36 (permalink)
Near Dallas, Texas, US
 
Experience: Advanced
Platform: NinjaTrader
Broker: ZenFire
Trading: CL
 
Gary's Avatar
 
Posts: 1,070 since Jun 2009
Thanks: 502 given, 2,233 received

Where'd you go Caprica?


caprica View Post
where's the pivot table? anything new on this? ihate to see such a brilliant idea die.


As consistently profitable traders.. "We get paid to wait, and we wait to get paid."
Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to Gary for this post:
 
(login for full post details)
  #37 (permalink)
Netherlands, Blaricum
 
Experience: Intermediate
Platform: Excel, Python, R
Broker: IB
Trading: Options
 
Zwaen's Avatar
 
Posts: 250 since Dec 2010
Thanks: 848 given, 236 received

I can't edit my posting of 7th july ( second prior posting) but with testing this timebased stoploss in eurodollar failed miserably. There were too many stopouts and just holding the stoploss (instead of moving it quickly to breakeven) yielded far better results.
Offcourse the management of the stoploss is all dependend on your tradestyle as a whole, so no hard rules can be given. It's the whole combination of entry, exit, trademanagement and moneymanagement which must have a positive NPV.

Reply With Quote
 
(login for full post details)
  #38 (permalink)
Columbus, IN. USA
 
Experience: Intermediate
Platform: NinjaTrader 7 & TOS
Broker: AMP
Trading: CL & GC
 
Posts: 14 since Oct 2009

Gary,
As a newbie with NT7, I'm having difficulty setting up my CL charts/Indicators/Strategies to match yours.
Do you have a post where I can download your trading methods ?
Regards,
Jim

Reply With Quote


futures io Trading Community Psychology and Money Management > Trade statistics spreadsheet - suggestions?


October 8, 2013


Upcoming Webinars and Events
 

Dealing with burnout w/Linda Bradford Raschke

Elite only
     



Copyright © 2020 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