Sunday, July 31, 2005

Do your homework

Sorry, but what homework?

I’m a futurestrader! I don’t need to look for trading vehicles, I know what I trade and I choose daytrading, so I need not to worry about open overnight positions.


But I thought so as well!

Do you question your signals? Do you try to second guess them, getting a better entry? Did you find yourself unable to press the button and then see the Euro, ER2, anything, explode without you? Leaving you behind, trying to chase it the moment the rocket cools down and everyone on board is glad there is such a fool as you are one to take the contracts off their hands.



You need to be confident in the system you are supposed to trade.

You need to know at the end of the day, how much your system would have made you, had you taken each and every signal.

An empty copy of the above spreadsheet has been placed on my server for you to download. Be aware that the spreadsheet is used for trading currencies, so you will need to adjust Cells C47, C48 and C49, if you trade index futures, as the spreadsheet currently assumes that 1 tick is 0.0001 = 12.50$.

  • You enter the direction of the trade (L)ong / (S)hort
  • the signal
  • the time the trade was opened
  • the entry price (use the close of the bar)
  • the recent swing High (on Shorts) or Low (on Longs)
  • the exit Signal
  • the exit price (again use one you could reasonably expect to get)
  • MAE (Maximum Averse Excursion) or what was the worst price the trade went against you. You need this to determine if you use sufficient stops.
  • Max. The maximum price the trade went to, before you covered the trade

What will you get:

  • Pt: Points the trade made.
  • The colums labelled 10/12/15/20/25/30: You might use targets instead of exit signals in your trading and these colums will tell you, if you use reasonable targets, if these will get you more points than trading with exit signals. Change the label to test your system with different targets.
  • MAE-PT: How many ticks the trade went against you
  • Max-Pt: After how many ticks did the trade make its maximum. Used to question your exit  signals, if what you get is a lot less than what you could have gotten
  • In addition you get the Totals for the day, the Win/Loss% ratio and the Win$/Loss$ and the total amount you could have made trading 1 contract assuming 12.50$/tick
  • You also get the amount you made/lost on average on your winning/losing trades
  • Last you get the percentage of the points you made compared to what was available

But doing this homework is taking the second step before you took the first:

First you have to define clear entry rules for your trades. No second guessing, no other timeframes, no other markets. You take 1 timeframe, you define, what you look for and every time these conditions are present, you put a marker on your chart.

If you are able to build trade alerts in your chartprogram, even better. Define your rules, translate them in the language your chartprogram understands and let these arrows be placed automatically on the chart.

EG: You want to trade CCI zero crosses with price near the 34ema. For shorts below, for longs above.
So the Trade Alert Long has to trigger, when the CCI crosses the zeroline and price trades above the 34ema but below the 30ema and the 30ema is above the 34ema. (Alternatively you could check, that the close of the bar is within 2 ticks of the 34ema)
Last you need to decide, if you take signals only at the close of the bar or intrabar as well.

I strongly suggest you take signals at the close of the bar only, as intrabar signals can and do (often/sometimes) vanish at the close of the bar and it is nearly impossible to backtest systems, which take intrabar signals, as you will not see these signals after the close of the bar on the chart. So the results you get will be better than the results you get in real trading, because the good signals stay, while all the intrabar signals giving you a loss will not be visible after the close of the bar.

The most important thing the database will tell you is, whether your system has an edge or not.
If you have more losers than winners, if your system shows you a loss day after day, it means: Back to the drawing board. Trading your system with real money is just a waste of time, the money would be better spent on a real great vacation.
But, if on the other hand you see a 4:1 ratio of Win$ : Loss$ with a 70% : 30% Win% : Loss%, you know you have a good system with a real edge.

Maybe you are not yet getting these results in your real trading, but if you just followed your signals, you would get these results. That’s why I recommend using automatic trade signals. They don’t lie, they are present or not and they stay once they have triggered. So your backtesting results are the same as your real time results will be, unless the market changes considerably, making your system invalid. Something which happens over time but usually not from one day to the other.

Now doing your homework, seeing every day, what your system would have made, had you just followed all the signals, will enforce takeing these signals once they trigger in real trading.

It’s not about every trade being a winner, but it’s about having an edge, knowing that in the long run your system will make you money. Don’t try to avoid the losing trades, instead find rules, which allow you to distinguish between a losing and a winning trade real fast.

The database will also inform you which of your tradesignals have a better probability of success compared to others. It might also tell you, that you can finetune your entry rules. Eg, if you see all/most of your winning trades go 8 ticks against you during the trade before it starts going in your direction, you could look for an entry 5 ticks better after the signal triggers.

But most important, you get a lot more screentime doing your homework.


Avellanas said...

Once again the voice of reason trying to help us poor souls. Thanks

Globetrader said...

If you want to announce a new blog, send me an email (, I will look at the blog and if I find something interesting for me there, which I think might help other traders as well, I will add a link to the blog to my Link-List.
I have allowed some blog announcements to be made in the "" thread and if you'r interested, you can continue to post your blog's there. But as I already said in the last thread, I will no longer tolerate unrelated blog announcements, especially repetitions of blog announcements, in the top-most blog entry.

Globetrader said...

I'm answering your question posted in the last thread here, as it fit's here better.
You asked about taking profits.

You need to know your edge, your statistics, then you can answer the question, which is the way to go for you, how you should take profits. Using targets or using exit signals provided by the market.
Taking targets you will miss the eventual home-run, but you will get usually more during he average trades, as waiting for the exit signal always means giving something back, you would cash in using targets.
My analysis shows that taking targets always comes second to taking exit signals, because I always have one or two home-run trades in the daily statistic. If taking exit signals only is 100%, taking targets runs between 75% and 90% of the profits you get taking exit signals.
But taking targets is a lot more relaxing, as the market often spikes, hits the target and retraces to slowly retest the spike high or low again.

Of course the moment you get an exit signal, even if the target is not reached you are out of the trade.

geosing said...

Very nice spreadsheet and concept. Second stage of evaluation is the trader's performance vis-a-vis what is possible. Once you have done the homework and filled in the worksheet, then you go through your own actual trades of the day. For each trade that you actually took, score one point. For each day, work out a ratio or a percentage (trades taken/total possible trades). Objective is to measure your ability to pull the trigger and enter the trade once the signal arrives.

Couple of additional columns in the spreadsheet to record the daily score is all that is needed here. You can improve on this by developing a scoring system for following/breaking rules and other disciplinary issues for each trade taken. e.g. taking trades not in the homework worksheet ... may be impulsive/emotional trading???


illninho said...
This comment has been removed by a blog administrator.
Anonymous said...

Keep up the good work Topical neurontin withdrawal Starvation and fat loss hello folks ed chevrolet holyoke ma. trademark attorney Norton anti virus 2004 cd key Computer fraud in accounting audi dealer