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,571 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?

  #11 (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

Hey Velocity,

Can you provide more details or an example of a pivot table with regards to trading?

Thanks,
Gary

Visit my NexusFi Trade Journal Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
NexusFi Journal Challenge - April 2024
Feedback and Announcements
Deepmoney LLM
Elite Quantitative GenAI/LLM
Exit Strategy
NinjaTrader
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
61 thanks
Funded Trader platforms
39 thanks
NexusFi site changelog and issues/problem reporting
26 thanks
Battlestations: Show us your trading desks!
26 thanks
The Program
18 thanks
  #12 (permalink)
 
caprica's Avatar
 caprica 
USA
 
Experience: Master
Platform: NinjaTrader
Posts: 155 since Jul 2009
Thanks Given: 45
Thanks Received: 114

gary what's new with this? i am looking forward to your results and how you interpret them. sorry i can't help with pivot tables i am no good at excel but Velocity sounds like he does so hopefully he will decide to show us something.

"Let us be thankful for the fools. But for them the rest of us could not succeed." - Mark Twain

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


I have been gone all week. I am just now working on updating numbers from last week. I'll let you know once I make some notable advancements.

Visit my NexusFi Trade Journal Started this thread Reply With Quote
  #14 (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

Still gathering more information, making small changes, and looking for more suggestions. I am exploring the pivot table option as well.

Visit my NexusFi Trade Journal Started this thread Reply With Quote
  #15 (permalink)
 
caprica's Avatar
 caprica 
USA
 
Experience: Master
Platform: NinjaTrader
Posts: 155 since Jul 2009
Thanks Given: 45
Thanks Received: 114

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

"Let us be thankful for the fools. But for them the rest of us could not succeed." - Mark Twain

Reply With Quote
  #16 (permalink)
 
deltason's Avatar
 deltason 
Memphis, Tennessee
 
Experience: None
Platform: NinjaTrader
Trading: ES, EUR/USD
Posts: 133 since Jul 2009
Thanks Given: 1,613
Thanks Received: 122

Useful thread. I'm looking to trade the ES with at least 2 contracts and wondered how to determine a good place to set the first target and stops. Thanks.

Visit my NexusFi Trade Journal Reply With Quote
  #17 (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

DeltaSon,

Can you tell me/us more about your setup that you are looking at testing/using with the ES?

Visit my NexusFi Trade Journal Started this thread Reply With Quote
  #18 (permalink)
 
deltason's Avatar
 deltason 
Memphis, Tennessee
 
Experience: None
Platform: NinjaTrader
Trading: ES, EUR/USD
Posts: 133 since Jul 2009
Thanks Given: 1,613
Thanks Received: 122


Gary View Post
DeltaSon,

Can you tell me/us more about your setup that you are looking at testing/using with the ES?

For longs, I look for higher highs and higher lows and enter on breaks above resistance. For shorts, I look for lower lows and and lower highs and enter on breaks below support. I watch several timeframes and align my entries on the lower timeframes with what's happening on the higher timeframes. I use minute charts and tick charts and watch day session and 24 hour session price action. I trade multiple units (testing 2 and 4) with the goal of hitting a profit target on the first unit in the short term. This suits my psychology and often allows for some profit taking on false breakouts or whipsaws. The goal for the second unit is to give winners an opportunity to run. The exit is discretionary and executed at some logical place (S/R, end of day, trailing stop, etc.). After the first target is hit or if I believe the trade is going nowhere, I move stops to breakeven or exit with a loss. My catastrophic stop (currently placed at a percentage of the account balance) is usually not hit unless I miss something, but it does get hit too often for me. Experience will help in this area.

Visit my NexusFi Trade Journal Reply With Quote
  #19 (permalink)
 
fesx's Avatar
 fesx 
Georgia
 
Experience: Intermediate
Platform: Ninja
Broker: AMP/CQG
Trading: ZN, ES, FGBL, FESX
Posts: 133 since Jul 2009
Thanks Given: 874
Thanks Received: 113

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.

Attached Thumbnails
Click image for larger version

Name:	CL_Spreadsheet_MAE_MFE.png
Views:	537
Size:	99.5 KB
ID:	1834   Click image for larger version

Name:	CL09.08.2009a.png
Views:	473
Size:	99.6 KB
ID:	1835   Click image for larger version

Name:	CL09.08.2009.png
Views:	432
Size:	102.1 KB
ID:	1836   Click image for larger version

Name:	CL_Stop_Strategy.png
Views:	416
Size:	15.9 KB
ID:	1837   Click image for larger version

Name:	CL_Strategy.png
Views:	452
Size:	16.7 KB
ID:	1838  
Reply With Quote
Thanked by:
  #20 (permalink)
 
jdella's Avatar
 jdella 
Concord, NH USA
 
Experience: Intermediate
Platform: Ninja trader
Broker: AMP/CQG
Trading: ES
Posts: 182 since Jun 2009
Thanks Given: 140
Thanks Received: 115


looks really good and if your profitable to boot, then stick with what you have. What's your criteria for entering the trade?

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