Monday 28 April 2008

Filled!

Just updated my portfolio page with trades from this morning. I went long a leveraged base-metal miners ETF for my copper trading setup, which has flipped to bullish. I also went to cash with my NASDAQ 100 position based on my setup for that market flipping to neutral.

Friday 25 April 2008

Oh-Oh! Sell Signal for Banks, Cash for NASDAQ

This afternoon's Commitments of Traders data has given me a few interesting new signals in my setups based on these free weekly government reports about trader positioning in futures and options markets. The details are up on my Latest Signals page table. Most notably, my setup for the BKX Bank Index, based on trading on the same side as the large speculators in the three-month Eurodollars contract when they hit specific extreme levels of positioning, has just flipped from bullish to bearish. This setup uses a one-week trade delay, so that means execution is for the open of trading May 5. Also, my setup for the NASDAQ 100 index, about which I was just blogging in a post earlier today here, has gone to cash as of next week's open of trading. This setup combines the signals from the "smart money" commercial traders and "dumb money" small traders. If you follow the bright lights out there and avoid the wrong-way crowd, how can you go wrong! Turns out that the commercial traders have reduced their net long position as a percentage of the total open interest to an extreme level of bearishness, which has flipped my commercials setup to a sell. When the two signals don't concur, the overall NDX setup goes to cash. Have a good weekend and good luck next week!

Has the Commitments Data Lost Its Relevance? Uh, No

I was doing some out-of-sample testing on my trading setup for the NASDAQ 100 index based on the Commitments of Traders reports, and I found something interesting. It dispels the notion that this weekly government data on trader positioning in major markets has lost relevance in recent years. The NDX setup, which combines the signals from a couple of superior setups for the commercial traders and small traders, achieved a 20.8-percent compound annual growth rate from 2003 to 2007 (or 19.7 percent if a 0.2-percent commission is included per trade). During that time, the index itself had a CAGR of 15.4 percent. Not bad when you consider that the setup was in the market only 69 percent of the time. (When the two signals don't concur, the setup goes to cash.) The details of this setup are in a note at the end of this post, so you can replicate the signals.

On a side note, I think it's fairly obvious it's harder to beat the market during a bull period like we've seen since 2003. That fact alone would tend to reduce the margin of outperformance. The real question is how does the strategy do once the bull ends, as it may be doing now. A connected question is, how do you know what kind of market it is in the first place? I think the best longer-term strategy will perform well in a bull, bear or congested market. So even if we could prove the COTs data has lost its power since 2003, which as I show above it clearly hasn't, I think you'd want to see how it does in a bear market before jumping to any conclusions.

As for the out-of-sample testing on my NDX setup, it was also interesting. This kind of testing is done to help see how the setup would have done in real-live trading. In six tests (I plan to add a few more as I refine my testing further), the setup achieved an out-of-sample CAGR of 91 percent of the in-sample period. In other words, if CAGR during the test window was 10 percent, then the out-of-sample CAGR would have been 9.1 percent. Out-of-sample "efficiency" above 60 to 70 percent is considered robust. Out-of-sample efficiency for regressed annual return was 76 percent. The out-of-sample efficiency for the Sharpe score was 1.5, with an out-of-sample Robust Sharpe efficiency of 1.1 and an out-of-sample largest drawdown only 38 percent as large as the in-sample drawdown. On average, the out-of-sample efficiency of all these scores was 1.4 - meaning that it was 40 percent better than the backtesting window.

I also like to get a more robust look at all this out-of-sample data by dividing it by its standard deviation in the six out-of-sample tests. I find this evens out any unusual data spikes resulting from a small number of exceptionally strong or weak trades in a single test window. By that measure, the average out-of-sample score was even better - 2.0 - which suggests that the out-of-sample data was quite consistent across the six tests, another good sign. I intend to start publishing more data like this for all my setups on my Latest Signals page table. I've also been improving my testing procedures to optimize my search for the top setups and hope to have an improve S&P 500 setup to announce soon. See you in a little while with this afternoon's COTs data update.

NDX setup parameter values: My trading setup for the NASDAQ 100 combines the signals from two different setups. The first setup goes long when the commercial trader net percentage-of-open-interest position is -1.05 standard deviations or greater (higher) than its three-week moving average. It goes short when the position is -1.05 standard deviations or lower than the moving average. The setup uses a five-week trade delay. The second setup goes long when the small trader net percentage-of-open-interest position is 0.45 standard deviations or lower than its 14-week moving average and goes short when the position is 1.4 standard deviations or higher than the average. This setup has no trade delay. I'll post a spreadsheet for this setup some time early next week.

Tuesday 22 April 2008

CXO Study: Some Good Points... And Some Not So Good

Thankfully, Steve LeCompte over at CXOAdvisory.com has taken down his erroneous post about my S&P 500 trading setup and reevaluated the data in a new post today. He raises a good point about how "trading friction" (i.e. transaction costs) would have eaten into the past profitability of the setup, which I'm going to include in my ongoing revision process of my setups based on the Commitments of Traders reports. I think this independent look at my trading strategy is great and can only help me build a better system. I didn't take into account trade friction earlier because my original group of setups traded fairly infrequently. As my revision process comes up with setups that trade more often, this is definitely an important factor to consider. But I think some of Steve's other conclusions are again flawed. (See my post here about his earlier erroneous study of my strategy.) Here is the response I just sent him about his latest work:

Thanks for revising your erroneous post and reevaluating the data. You raise some good issues about this particular trading setup for the S&P 500, for which I thank you. But I also would like to draw you attention to other conclusions you draw that I believe are flawed and raise questions about some of your evaluation methods.

You are correct to say that trade friction is an important variable to take into account. As I've mentioned on my blog and to you, I'm going through a re-evaluation process of my setups right now to find those that are the most statistically robust. Trade friction would be a good element to include.

However, when you delve into the area of statistical robustness, your conclusions are weaker:

1) You say the performance of the SPX setup with trade friction mostly lags buying and holding the index in the last five years. You evaluate this by studying only the profit. That's probably the weakest measure you can use. It's easy to find incredibly profitable trading setups that aren't very statistically robust by other measures. One more robust measure to use, for example, is the Sharpe score. This tells if the return was achieved at the expense of great volatility. The 2003-07 Sharpe score for this setup is 2.8, while for buying and holding it is 2.0 - a large difference suggesting the setup achieved the same return with less tough-to-stomach ups and downs. Over the entire 1995-2007 period, the Sharpe for the setup was 3.4, while for SPX it was 1.2. That's not to say your point about trade friction eating up those profits isn't a good one. It's just that your evaluation method isn't based on a very robust measure.

2) You also say the COTs dataset for the SP500 has a small sample size that reduces confidence in the setup. Your conclusion doesn't seem to be based on anything very solid. I invite you to read up on how to determine this question by studying Robert Pardo's new book on trading strategy development. One way of checking the adequacy of the sample size is the number of trades. This setup has 150. That's well over the 30 minimum trades Pardo recommends for a reliable setup.

In his book, you will also see a simple method described to evaluate if you've got enough data for your strategy. I've blogged about this here. Using this method, this setup's nine-week moving average period uses only 3 percent of the available degrees of freedom of the dataset. (That is based on the 12 trading rules in the strategy.) That's well below the 10 percent maximum suggested by Pardo.

Pardo outlines other methods of reducing the risk of data-mining, which I've implemented or am in the process of implementing during my revision process. One is out-of-sample testing. This particular setup achieves an out-of-sample efficiency of 1.3 in 10 tests - meaning on average the out-of-sample performance was 30% higher than for the in-sample data for Sharpe, Robust Sharpe, compound annual growth rate, drawdown and regressed annual return.

3) Finally, I think you're incorrect to conclude that your study confirms that "the predictive power of COT report data may have diminished in recent years." I invite you to take another look at your own chart of annualized return by calendar year for buying and holding the SP500 and the COTs Timer Strategy with your trade friction. The best performances came at the end of that five-year period, in 2005 to 2007. As well, you draw this conclusion based on evaluating one possible setup. Again, I would suggest that's not a very robust conclusion. All that said, I thank you again for including me in your research and for raising some good issues to evaluate further.

Monday 21 April 2008

Weirdness From CXO

I've had a very bizarre exchange this morning with the gentleman who runs CXOAdvisory.com about my trading system based on the Commitments of Traders report. Steve LeCompte, the author of that site, made a mistake in testing my setup for the S&P 500. He tests my setup with a one-week trade delay and finds inferior results to buying and holding the index. The only problem is my setup uses a three-week delay, as I make clear on the table linked here. He admits to making a mistake, but instead of removing his incorrect post or apologizing, he has just added my comments at the end. As well, he continues to display an erroneous chart showing the inferior results of the setup he tested, suggesting that those are the results from the "COTs Timer Strategy," when they're not. I've invited Steve to retest the data with the correct setup parameter values, which he says he will do. Very weird stuff from what is otherwise an interesting site, which by coincidence I had linked on my blogroll just a few days ago.

Update (1:20 p.m.): Steve just emailed saying he's removed that erroneous post and will retest the data. He'll post the correct results tomorrow morning.

Portfolio Update: Long SPX and Crude

Just updated my portfolio page to reflect trades as of today's open based on my setups built around the Commitments of Traders reports. I went long the S&P 500 and crude oil based on bullish signals in those two setups. Good luck this week!

Friday 18 April 2008

S&P 500, Crude Oil Shift to Bullish Column Monday

More bullish signs as the Toronto Stock Exchange composite index breaks up above an ascending triangle in recent days. Is it just a fakeout or will other indexes like the S&P 500 follow suit? Technical analyst guru Tom Bulkowski (you can check out lots of his stuff free at ThePatternSite.com, where he's got a new daily blog) was telling me earlier today he's watching some potentially bullish reverse head-and-shoulders patterns on Japan iShares, Brazil iShares and Australia iShares. He's done a lot of interesting number-crunching: In 900 ascending triangles in a bull market, 74 percent broke out upward with an average 35-percent gain. (Caveat: in the SPX's case, his measure rule puts the target at more like 10 percent.) But caution is advised. Such breakouts throw back to the bottom of the triangle or thereabouts 57 percent of the time! (Btw, Bulkowski has an interesting-looking new book out, Encyclopedia of Candlestick Charts.)

So what do the precious little Commitments of Traders reports have to say about all this? As you can see from the table on my Latest Signals page, they're also lining up smartly on the bullish side. My trading setup for the S&P 500 flipped to bullish a few weeks ago, with the execution date for the trade coming up on the open of Monday, April 21. That setup is based on trading on the same side as the "smart money" commercial traders in SPX futures and options. Right now, they're resolutely upbeat. This makes five of my six equity setups bullish (all except for the holdout Dow Jones industrials). Also taking effect on Monday's open is my bullish signal for crude oil.

From today's new COTs data release, my setup for the 30-year Treasury bond has flipped to bearish. (This means it calls for the yield to rise.) This new signal takes effect Monday, too. I should note that I'm presently long Treasuries through my setup for the 10-year note. That setup is far more robust statistically speaking than the setup for the 30-year bond, and it remains in bullish mode. So I don't plan on taking any action on the 30-year signal. I'll be updating the 30-year setup soon to improve its robustness.

Housekeeping: I know, I know - I keep promising more updates for my setups based on the COTs reports. Rest assured, I'm busy testing and refining various things, but it's not at the point where it's warranted any new announcements or changed trading setups. The research I'm doing now includes out-of-sample analysis of the setups. This is just one step among many in order in verifying how reliable the setups would be in real-time trading. So far, I'm happy to say the results are very positive and haven't caused me to drop any of my setups. But I'm hopeful this and other testing might lead to still-better ones in some markets and to refinements of setups in markets I haven't had a chance to revisit yet, like the agricultural commodities and currencies. Another twist on all this is testing more combined setups, of which I already use a couple - setups based on the best signals from two groups of traders (for example, the commercials and large speculators). Thanks for your patience with this process. Have a great weekend, and see you next week with a portfolio update and hopefully some further news on revisions.

Friday 11 April 2008

I Can See the Light

The stars look like they're finally lining up. After the major volatility of recent months, most of my trading setups based on the Commitments of Traders reports are now showing signs of stronger, broader trends. Always nice to see. Check the table linked on my Latest Signals page for all the fun details. Some highlights:

- This afternoon's report gave me two new bearish signals for copper and platinum. These setups both work with eight-week trade delays, so the signals don't take effect until June 9. Wow, that's something to think about. We're still digging ourselves out from the snow up here in Quebec's Eastern Townships, and it's nice of the COTs reports to bring to mind those coming balmy days. Given the long delays, there's ample room for several pending signals to stack up in a row for these setups. See my Latest Signals table for some notes on my copper setup in particular.

- My six equities setups (including the BKX Bank Index setup based on the three-month Eurodollars COTs data) seem to be strengthening their bullish alignment. All except the Dow Jones industrials are or will shortly be in bullish mode, with the S&P 500 setup going long as of the open on Monday, April 21. After a week like this one, perhaps we're finally lining up for the long-awaited rally that's been playing hide-and-seek with traders for so long.

- Trades for Monday, April 14, include going long again for gold. This setup operates with a two-week delay and has been flopping around like Gill in the dentist's office in Finding Nemo, but it now seems to have settled happily into bullish mode as the large speculators have steadily increased their net long percentage-of-open-interest position in gold futures and options.

Have a great weekend, and see you back here next week with a portfolio update and those promised revisions to my setups. Sorry not to have posted any of those this week, but rest assured that fascinating refinements are on their way!

Monday 7 April 2008

New Article: Crazy Market Volatility Drives Some Analysts Loopy

Just posted a piece I wrote for today's Montreal Gazette newspaper here. Good luck this week!

Filled!

Just updated my portfolio page with my asset mix as of this morning. I went long the NASDAQ 100 index on the open using a leveraged fund. This trade is based on my bullish signal from my trading setup for this index based on the trader data reported weekly by the U.S. Commodity Futures Trading Commission, in the Commitments of Traders reports. Good luck this week, and I hope see you back here in coming days with updates about my ongoing refinements of my COTs Timer setups.

Friday 4 April 2008

Here Comes the Bounce

Things are starting to look a little better now, aren't they. My trading setups based on the Commitments of Traders reports are looking brighter by the week. First, gold and silver turned up, as did the Russell 2000 and S&P 500. With today's data, my setup for the NASDAQ 100 index has also flipped from cash to bullish. This setup uses no trade delay, so that means I'm going long on Monday's open. Visit my Latest Signals page to see where things stand with other new signals from this week's data. Have a good weekend, and good luck next week! Also, be sure to check back here early next week for a portfolio update based on new trades for Monday and other updates from my ongoing system testing. Stay tuned for further refinements coming soon to a COTs blog near you.