NexusFi: Find Your Edge


Home Menu

 





Modeling spreadsheet


Discussion in Traders Hideout

Updated
    1. trending_up 5,715 views
    2. thumb_up 10 thanks given
    3. group 3 followers
    1. forum 3 posts
    2. attach_file 2 attachments




 
Search this Thread

Modeling spreadsheet

  #1 (permalink)
 
Saroj's Avatar
 Saroj 
Arcata, CA
 
Experience: Intermediate
Platform: NinjaTrader
Trading: index futures, oil
Posts: 485 since Jun 2009
Thanks Given: 232
Thanks Received: 415

This is a spreadsheet to figure on various Money Management techniques given certain assumptions about targets and a "set" of trades (how many fail, how many go further than initial target, etc.)

This is a work-in-progress... ES seems complete; NQ I just added and have not taken the time to verify...

Any and all comments, suggestions, enhancements, new ideas are welcomed.

Attached Files
Elite Membership required to download: Model a.xls
Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
ZombieSqueeze
Platforms and Indicators
Better Renko Gaps
The Elite Circle
How to apply profiles
Traders Hideout
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Spoo-nalysis ES e-mini futures S&P 500
34 thanks
Just another trading journal: PA, Wyckoff & Trends
30 thanks
Tao te Trade: way of the WLD
23 thanks
Bigger Wins or Fewer Losses?
23 thanks
GFIs1 1 DAX trade per day journal
21 thanks
  #2 (permalink)
 
hondo69's Avatar
 hondo69 
Austin, TX
 
Experience: Intermediate
Platform: NinjaTrader
Trading: Currencies
Posts: 162 since Jun 2009
Thanks Given: 57
Thanks Received: 248

Nice job Saroj, I think I can incorporate your work into my exercise. The real trick, it seems to me, is to arrive at an "Ease of Movement" ratio to finish the job. In other words, discover how easily a particular instrument moves from one tick to the next after entry. It gets crazy complicated in a hurry.

For example, let's say you study the 6E from midnight to 6 AM for 2 months. You would need to first identify a particular strategy for entry. Code that strategy in Ninja and have it draw an arrow at each entry point. Then go back and count how many ticks it moved in your favor before turning against you.

The idea being you can best determine exit points and stops. My gut feeling is this is really an exercise in futility because markets change over time. But if this were quantifiable, I think it would be a real eye opener.

Attached Thumbnails
Click image for larger version

Name:	entry_chart.gif
Views:	124
Size:	2.7 KB
ID:	3171  
Reply With Quote
Thanked by:
  #3 (permalink)
 
Saroj's Avatar
 Saroj 
Arcata, CA
 
Experience: Intermediate
Platform: NinjaTrader
Trading: index futures, oil
Posts: 485 since Jun 2009
Thanks Given: 232
Thanks Received: 415



hondo69 View Post
Nice job Saroj, I think I can incorporate your work into my exercise. The real trick, it seems to me, is to arrive at an "Ease of Movement" ratio to finish the job. In other words, discover how easily a particular instrument moves from one tick to the next after entry. It gets crazy complicated in a hurry.

For example, let's say you study the 6E from midnight to 6 AM for 2 months. You would need to first identify a particular strategy for entry. Code that strategy in Ninja and have it draw an arrow at each entry point. Then go back and count how many ticks it moved in your favor before turning against you.

The idea being you can best determine exit points and stops. My gut feeling is this is really an exercise in futility because markets change over time. But if this were quantifiable, I think it would be a real eye opener.

speaking of "ease of movement", there is an indicator for that.. native NT I believe... don't know if it has any relevancy to you, but thought I'd mention it.

As far as the modeling spreadsheet goes.. one step that would make it much easier to use is to make the assumptions data rather than string where you have to manually enter the combinations.

Another thing is that you need to keep stats to know just how the market is changing. I posted another spreadsheet which will do this in 25 item samples...

it was oriented towards testing the consolidation method but was adapted from testing Woodie's CCI and can be adapted to others.. the important aspect of it is that it automatically calculates the P/L, MFE and MFA with minimal entries... Mike recently posted one that does nice lookups to reason for entry and exit...

Started this thread Reply With Quote
Thanked by:
  #4 (permalink)
 
hondo69's Avatar
 hondo69 
Austin, TX
 
Experience: Intermediate
Platform: NinjaTrader
Trading: Currencies
Posts: 162 since Jun 2009
Thanks Given: 57
Thanks Received: 248

Thanks for the pointers, they look promising. Yes, there is an Ease of Movement indicator, but this is a little different idea. It's based on the following observations:

- my stops have a knack for calling market tops (or bottoms)
- I let too many winners turn into losers
- the "eye in the sky" knows when I enter a trade, and then moves the market in the other direction

OK, it's not really all that bad but some days it kind of feels like it. Here's the idea: a trader uses Strategy A of 3 contracts with a 10 pip stop. Take off 1 contract at +4, another at +8 and then move the stop to break even. Then monitor the last contract (the runner) and take it off as needed. If there were a method of tracking each trade, it might be discovered that win percentage would increase by making a slight change.

Change #1: move stop to 12 pips, win percentage changes how?
Change #2: take contracts off at +4 and +6, what is the change?
Change #3: take contracts off at +4 and +4, what is the change?
etc.

So I think I'll come up with a new type of trading journal in Excel that tracks all the usual information but with eventual market outcome added. Since you can easily add images to Excel I could include a chart snapshot as well. My guess is it will be a real eye opener.

Reply With Quote
Thanked by:




Last Updated on October 7, 2009


© 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