NexusFi: Find Your Edge


Home Menu

 





Trade statistics spreadsheet - suggestions?


Discussion in Psychology and Money Management

Updated
      Top Posters
    1. looks_one Gary with 9 posts (17 thanks)
    2. looks_two munikhan130 with 6 posts (0 thanks)
    3. looks_3 caprica with 5 posts (12 thanks)
    4. looks_4 zeller4 with 3 posts (5 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 21,581 views
    2. thumb_up 45 thanks given
    3. group 28 followers
    1. forum 37 posts
    2. attach_file 7 attachments




 
Search this Thread

Trade statistics spreadsheet - suggestions?

  #31 (permalink)
 zeller4 
Orlando Florida
 
Experience: Intermediate
Platform: NT8
Trading: CL, NQ, ES, RTY
Posts: 477 since Jun 2009
Thanks Given: 1,416
Thanks Received: 404


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
Elite Membership required to download: SampleAtmStrategy_v01.zip
Reply With Quote

Can you help answer these questions
from other members on NexusFi?
NexusFi Journal Challenge - April 2024
Feedback and Announcements
Exit Strategy
NinjaTrader
Deepmoney LLM
Elite Quantitative GenAI/LLM
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Ninja Mobile Trader VPS (ninjamobiletrader.com)
Trading Reviews and Vendors
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
60 thanks
Funded Trader platforms
37 thanks
NexusFi site changelog and issues/problem reporting
24 thanks
GFIs1 1 DAX trade per day journal
22 thanks
The Program
19 thanks
  #32 (permalink)
 zeller4 
Orlando Florida
 
Experience: Intermediate
Platform: NT8
Trading: CL, NQ, ES, RTY
Posts: 477 since Jun 2009
Thanks Given: 1,416
Thanks Received: 404


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
  #33 (permalink)
 
Gary's Avatar
 Gary 
Near Dallas, Texas, US
 
Experience: Advanced
Platform: NinjaTrader
Broker: ZenFire
Trading: CL
Posts: 1,072 since Jun 2009
Thanks Given: 502
Thanks Received: 2,239


Keep the thread alive.

Visit my NexusFi Trade Journal Started this thread Reply With Quote
  #34 (permalink)
 
Zwaen's Avatar
 Zwaen 
Netherlands, Blaricum
 
Experience: Intermediate
Platform: Excel, Python, R
Broker: IB
Trading: Options
Posts: 250 since Dec 2010
Thanks Given: 848
Thanks Received: 238

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
  #35 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,399 since Jun 2009
Thanks Given: 33,175
Thanks Received: 101,541

Check here for a more detailed journal example in Excel:



Mike

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
  #36 (permalink)
 
Gary's Avatar
 Gary 
Near Dallas, Texas, US
 
Experience: Advanced
Platform: NinjaTrader
Broker: ZenFire
Trading: CL
Posts: 1,072 since Jun 2009
Thanks Given: 502
Thanks Received: 2,239

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 NexusFi Trade Journal Started this thread Reply With Quote
Thanked by:
  #37 (permalink)
 
Zwaen's Avatar
 Zwaen 
Netherlands, Blaricum
 
Experience: Intermediate
Platform: Excel, Python, R
Broker: IB
Trading: Options
Posts: 250 since Dec 2010
Thanks Given: 848
Thanks Received: 238

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
  #38 (permalink)
 JPx2 
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




Last Updated on October 8, 2013


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
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.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts