SMART MONEY AND DUMB

The COT reports give data on trillions of dollars of futures and options holdings in over 90 markets - everything from crude oil to the U.S. dollar, gold and the NASDAQ. The reports are issued every week by the U.S. Commodity Futures Trading Commission. They can be downloaded for free from the CFTC's website each Friday at 3:30 p.m. (Eastern Standard Time).

But the data in its raw form is hard to make use of - or even understand. Each weekly report gives the total position held in each market by three groups of traders.

First are the commodity producers. Analysts call them the "smart money." Also known as commercial hedgers or just "the commercials," they are seen as the folks with the best market information. When they are increasing their positions in crude oil, for example, it's probably a good time to get some energy stocks.

Then there is the dumb money - the "non-commercial" category. These are the large speculative investment funds, usually called the "large speculators" or simply the "large specs" - or just the "dumb money." They are trend-followers. Analysts say they are usually wrong at market extremes. If they are buying oil, it's probably a good time to sell your energy stocks.

The third group is the "non-reportable" category. These guys are seen as the really dumb money. They are the small-time traders who apparently don't know what they're doing at all and don't provide any meaningful market information. Or so say most analysts.

WHAT TO DO?

To make any sense of all this data, analysts say, you have to compare each group's position in a market to what it held last week. So that's what I started to do.

I wrote down the weekly positions for all three groups for a couple of dozen markets - the S&P 500, the NASDAQ, crude oil, gold, silver, the U.S. dollar, the Yen, the 10-year Treasury and others.

But then I was stumped. What should I do with all this information? The price of gold, for example, rarely went up just because the commercials had bought more gold or because the large specs had sold it. And sometimes, the commercials and large specs were both buying the NASDAQ at the same time. What would I do then?

The data looked interesting, but there didn't seem to be any clear way to use it.

LOOKING FOR TRENDS

After doing this for a while, I started to download the data into Microsoft Excel and make charts out of it to see if I could spot trends. I still couldn't get much use out of it. I tried to find correlations between the COT data and underlying cash prices. I couldn't find much of any use.

(One bizarre discovery I made was that some equity indexes have very high correlations with subsequent COT data many months later. However intriguing, that didn't seem like very useful information for investing.)

To my knowledge - despite many studies by economists and statisticians - no one has found any correlations you can bank money on and made this research public. (If I'm wrong on that, let me know. I'd love to see the study.)

Just then, a couple of fascinating books came out by COT gurus Larry Williams (who wrote the classic book on the subject Trade Stocks and Commodities with the Insiders) and Floyd Upperman (author of Commitments of Traders). Both analysts suggested the COT data was most useful when the commercials or large specs had accumulated historically extreme positions.

In other words, if the commercials have a multi-year high net long NASDAQ position, it's probably a good time to buy. This was a major breakthrough in public understanding of the previously difficult-to-interpret COT data.

I put my own twist on this idea and started to think about ways of testing what happened when traders hit certain extreme positions. I would sometimes watch the commercial hedgers or large specs accumulate record positions for weeks and even months, without any change in the underlying markets. Relying solely on such "signals" would probably lose lots of money.

The same problem exists with many technical analysis tools. A market can be overbought or oversold for weeks without a change in trend. You can be right, but if your timing is wrong, well, you won't be trading for long.

As a result, some COT analysts caution against relying solely on the data to time trades. They suggest the data is most useful as a guidepost for possible future market turns, but it must be combined with technical analysis for a signal.

Here was another problem that occurred to me: Let's say the commercial traders are indeed the smart money. When do you buy? When the commercials start accumulating (i.e. when they start getting less net short or more net long)? Or only when their bullishness has peaked?

The dilemma is this: If it's the former case, then aren't we often buying near a market top, right after the commercials have had on their most bearish position? But if it's latter, then aren't we really trading opposite to the commercials?

A REVELATION

While I was on paternity leave with our second baby, I had one of those revelations that sometimes comes when changing a poopy diaper or sitting in a rocking chair well past midnight with a sleeping baby on your shoulder.

Why not use technical analysis to study the COT data? There must be a way, I thought, to examine rigorously how extreme COT positions impact subsequent cash prices. Could the tools of technical analysis help?

I looked again at the S&P 500 data going back to 1995 (when the weekly COT data first came out for free in electronic form). I wanted to see what happened to the index after traders acquired an extreme net position. I defined "extreme" as two standard deviations or more from the 27-week moving average.

The results were pretty exciting. An extreme net position usually led to returns that beat the market. For example, if you bought the S&P 500 index when the commercials were at an extreme net long - or when the large specs or small traders were at an extreme net short - your returns over the next weeks and months were usually better on average than if you had just bought the market at any random moment.

For example, the return for the subsequent week was 0.6 percent, compared to the S&P 500's average one-week return of 0.2 since 1995. For the subsequent three weeks, the average return was 2.5 percent, compared to 0.5 percent for the S&P 500. Over the subsequent 10 weeks, the average return was 6.6 percent, compared to 1.7 percent for the S&P 500 since 1995.

I kept checking further and further after the signal to see what the optimal holding period would be. I found that the superior returns continued for up to 40 weeks after the extreme position was first registered - as far out as I measured.

And there were superior returns in most time frames for both the large specs - and even the usually-ignored small traders.

What it meant was the data could be the basis for a trading system after all.

TIMING SYSTEM

There were still a bunch of questions to resolve. Which group of traders should I follow? What if they give contradictory signals? And I still needed to figure out the best way to measure an extreme position in the first place, since I had picked the two standard deviations and 27-week moving average arbitrarily. Were better results possible with another definition of "extreme"?

Using Excel, I started to test returns with various combinations of moving averages and standard deviations. I was stunned at the results. With many of the combinations, a simple switching system of buying the S&P 500 when the commercials were at an extreme net long position and selling when they were at an extreme net short would have given market-beating profits. The returns were in some cases more than double those of buying and holding the index.

The results were just as interesting fading - or trading opposite to - the large specs. But the biggest surprise was that the best results came from fading the small traders - the guys everyone was ignoring.

I found a way to automate the testing with help from a clever journalist colleague, Mike Gordon, who is an expert in computer-assisted reporting.

MARKET-BEATING

In every index or commodity I analyzed, I found that a market-beating trading system could be found. I discovered that it was possible to increase profitability, in some cases, by delaying the trade for one or more weeks after a signal was given.

Also, I found the most profitable results came from using not the net number of contracts of each group of traders, but rather their net-percentage-of-open-interest position. This makes sense, I believe, because of the explosion of futures and options trading in recent years. The net-percentage-of-open-interest numbers have probably preserved their internal consistency better during this time.

The best news for me is that the system requires only one or two trades a week at most - and often none at all. It can certainly be exhilarating to swing or day trade. It feels like you can actually behold the entire world - all its people, their anxieties, their hopes, the events that shape their lives - in motion at once, like a raging and crashing ocean. It can be so preoccupying, it may turn into a struggle to focus on anything else.

But with my COTs Timer system, I need no longer fret about daily market ups and downs. All I have to do is spend just a few minutes each week downloading the latest COT data and executing any trades, then sit back and relax. Hopefully, by a beach somewhere with the bambinos!

AR: Note that since writing this in mid-2008, I've added extensive new steps to my backtesting system. A detailed description of my backtesting is available on my FAQs page.

33 comments:

Anonymous said...

Alex,
Did you use futures-only or cumulated futures and options COT data?

Alex Roslin said...

Hi Probtrader,

Thanks for your message. I've used the combined futures and options data, except in the case of the US and Canadian dollar setups. For more details, please check the notes to the table at the "Latest Signals & Results" page, which explains this.

Regards,
Alex

Unknown said...

Hi Alex, You have a good heart to share your information to us. I found that many experts to post a chart of COTS. You can click the link as below: http://news.goldseek.com/CliveMaund/1192998000.php I would like to know if you know where to get those charts or we need to do it by ourselves? Do you mind to send your COTS files to me, so I can update the COTS reports every week. my email is mrkcchan@gmail.com. Thanks! Ka

Alex Roslin said...

Hi Andrew,

Thanks for your comment. You should probably ask Clive where he gets the chart. I know I've seen similar charts on the internet, but I can't recall the original source. A good site to generate your own charts is TimingChart.com. I'll email you a sample spreadsheet in a short while.

Regards,
Alex

Unknown said...

Hi Alex.

Thanks for sharing your COT analysis. I too am starting to follow the COT experts, Williams, Upperman, Breise and now you. You mentioned you wait 1-4 weeks before entering a trade. Do you wait for a trend to be in place to confirm the signal...for example 2-3 consecutive up days for bullish signals? Finally, can you kindly send me your sample spreadsheet?

Thanks.

tradergal

Alex Roslin said...

Hi Tradergal,

Thanks for writing. It's certainly a valid approach to wait for the trend to confirm a COTs signal. I follow the COTs signals purely. The time delay is based on my test results for each setup. I found varying the trade execution often led to interesting variations in setup results. Each setup has its own trade delay, as indicated in the table on the "Latest Signals" page.

Take care,
Alex

Alex Roslin said...
This comment has been removed by the author.
Anonymous said...

Hi Alex,

How many weeks of data should I use to calculate the average and standard deviation.

Regards,
Biren

Alex Roslin said...
This comment has been removed by the author.
Unknown said...

Hi Alex,

Thanks for writing about this in Active Trader. That's how I got here. Just to make sure I've got this straight, when you say "net percentage of open interest" for a particular group that would be:
(Commericial Longs - Commericial Shorts) / Market's Total Open Interest?

-Pablo

Alex Roslin said...

Hi Pablo,

Thanks for your question. I actually simplify things for myself and use the columns AW through BE in the COTs reports, where the net positions as a percentage of the total open interest are already conveniently calculated for us.

Regards,
Alex

Alex Roslin said...

To clarify that last post of mine, I should add that the net long and short positions are already calculated in those columns as a percentage of the open interest, but we still need to subtract the short position from the long to arrive at the net number.

Regards,
Alex

Unknown said...

Hi Alex,

Thanks for your clear and speedy reply!

I meant to say your article in SFO from November and the one from TASC in May. Great stuff!

Before I got your second post I checked the two ways of computing the net % of open interest and they come out the same. (Subtracting the two published percentages vs. computing the net contracts and dividing my total open interest. It has to come out the same mathematically.) =)

I was reading and thinking about this today and wondering if you tested various holding periods after the signals come on, or do you have a set holding period of X weeks for all the futures?

Anyway, great blog. Thanks for sharing.

Best,

Paul

Alex Roslin said...

Hi again Paul,

The holding period depends on when a new and opposite signal is generated. It can be one week or as much as a couple of years, but the average seems to be a couple of trades a year. At first I tested much shorter holding periods to see which one would prove to be ideal, but I quickly found that when an extreme net position was hit, you'd get superior returns up to a year out - the longest I tested for. So I figured there was a lasting impact from such positioning, which made me think I should test holding until the opposing signal comes. I'm sure there could be other approaches worth testing though.

Regards,
Alex

Anonymous said...

Hi Alex

In september I found myself in charge of my Retirement funds. Based on inflation and the falling dollar I figured gold and silver is the best bet. So I bought some Silver eagles and invested in mining stocks. Read all the advise from all the garus.

Was feelin pretty cocky I was up 3 grand ( not bad for a newby) Last wensday I saw you warned the HUI had turned bearish. In the last couple months I had noticed you was pretty much right on in your forcast. But yet I held on to those minning stocks. Friday afternoon I was sellin them fast as I could...but held onto a couple of them..got to admit I ain't feelin so cocky, lol. Point is I think I found a garu that knows his stuff and although I am not all that good with numbers (weak mind) I am gonna try to use the info on this page and figure out your cots system. Plus pay closer attention to your observations.

I too would like to obtain your sample spreadsheet, if I may.

It is very kind of you to supply us with the info you have obtained through your hard work in finding a system that works well.

BTw I have suscribed to a couple of news letters with the promise of good advise.. I canceled my subscriptions after reading the first letter...Yours I would keep as it would have value.

Thanks again
Terry
tmiller5087@zoominternet.net

Alex Roslin said...

Thanks for your kind words, Terry. I've just fired off a spreadsheet for you.

Best regards,
Alex

Anonymous said...

Alex,

Another "thank you" for sharing this.

Could you please send a copy of your sample spreadsheet (with historical data, if possible) to

TraderJSP@yahoo.com

I've used commercial COT (net long vs. net short) with the S&P 500 for some time. One simple system has never had a loss since the late 1980s (if you hold with the commercials, you always seem to win), but has sat through some ugly drawdowns (about 20% in 1990 and 10% this year and several others). I haven't done anything with small or large speculator data, however, and don't have any historical data.

Thanks,

John

Unknown said...

Hi Alex,

I've been doing some more research of my own on COT data and got around to investigating your concept. (I like to test and evaluate everything myself.)

I was wondering two things that I couldn't find on any of your blogs:
1) Did you optimize the moving average / standard deviation band lengths as well as the number of standard deviations for the bands?

2) Do you use the same length / band number values for all markets, and if so, what is the general length and band number you use.

I'm going to do my own optimization on these values and I can send you my results when finished. I have written some indicators in TradeStation to do this. I figure if this works as you say it does, it could be a great filter for shorter term trading systems.

Thanks much and again, great blog!

Pablo

Unknown said...

Alex,

Also one other thing I was wondering about while looking at your published spreadsheet:

When you say "trader to watch" = Small Trader, that would mean to trade against the small trader in that market? (since that is your default: trade with commericials and against small+large traders). Just wondering if that is what you mean.

Alex Roslin said...

Hi Pablo,

Each setup has a different moving average/standard deviation period. Check my "Latest Signals" main table to see the ones I've published already. They are optimized for each setup. You can download the SP500 one at my "S&P 500 Spreadsheet" page.

Regards,
Alex

Alex Roslin said...

Hi again Pablo,

As you say, "trader to watch" usually - but not always - means I fade the small traders. In a few exceptional cases, I'm trading on the same side - as in the Treasuries.

Regards,
Alex

proscllc said...

This is very fascinating, Alex. On two levels
1) what COTs can do for my trading, and
2) how refreshing it is to see you share for FREE!. You are to be commended. Thank you!

As I study this more I wonder how my limited Excel knowledge might limit me. I am familiar with spreadsheets in their more basic functions. The more advanced formulas mystify me a little. Does that pose a problem with your system? Do I need to put some time into learning more regarding Excel?

Thanks.

BTW, I found you through Kitco.

Alex Roslin said...

Hi Proscllc,

A basic knowledge of Excel is all that's needed to download and update the COTs data each week and to create charts with it. Doing that will help show you how the data is moving against the price. There are several websites that offer tools that let you create the same charts. See my links box on the main page. But doing it for yourself in Excel helps you get the insights that only hands-on working with the data gives.

That kind of exploration will be a good basis for learning more about Excel so you can continue on to more advanced tests, if that's of interest. Use the "help" function to learn more about Excel's many useful formulas.

Good luck,
Alex

Anonymous said...

Alex, really like to thank you for this blog. I am a newbie and started to be aware of COT. I am also trying to learn from some old books more about Price/Volume/Open Interest. I hope to be following yr blog asap. Best Wishes, James (bonder.bond@yahoo.com)

ARM said...

Hi alex, i apreciated your effort to make yourself clear and been able to share what you see and know in the COT report. I just wanted to ask you if you considered using the 56 weeks index to identify extreme levels and then look technical analysis reasons to identify a reversal? I will send you an email, so if you kindly can send me a copy of your spreadsheet.

Greetings

artemtheterrible said...

Hello Alex!

First of, I want to express my deep appreciation for the fact that you share your findings so openly. This truly speaks of a great mind not constrained by the vices such as greed and egoism.

I recently got very involved in the development of the automated trading system using COT. I am using TradeStation, since I believe that it is one of the most premier software available for development of trading systems, and there are a great number of things that I was capable to do with TradeStation, that are not possible or very time consuming in Excel.

I was wondering if it would be possible to get your sample spreadsheet. A lot of the concepts that you mention, I already tried implementing in one way or another, but so far I have not been able to strike the precise thing that I would be comfortable putting my money in. If you are interested, I would be more than happy to send you my code with everything I've worked on so far.

My email is agg5001@gmail.com, again I would gladly share with you all my code, since, as I said before, I truly value people like you.

Thank you!

Artem

Anonymous said...

Hi Alex,
Just now I sent a comment to ask you about the COTs data catalog. After read this article, I figure it out now.
Could you please send me your spreadsheet, historical data and formulas? If it may. I would very appreciated for it
email : xdong212@hotmail.com
Amy

Alex Roslin said...

Hi Artem,

Thanks for your kind words! Please visit my "S&P 500 Spreadsheet & DIY" page for the spreadsheet. I'd be interested in seeing what you've come up with. I'll send an email...

Best regards,
Alex

Alex Roslin said...

Hi Amy,

Thanks for writing. Please visit my "S&P 500 Spreadsheet and DIY Guide" page for the spreadsheet.

Regards,
Alex

Unknown said...

Hi,my name is Kaoru
excuse me.
I'm interested in your COTs methods.

Could you please send me your spreadsheet, historical data and formulas?
my mail address sakagamijiro@gmail.com

arigato!

Alex Roslin said...

Dear Kaoru,

Thanks for your email. The spreadsheet for my S&P 500 trading setup is available on this website at the "DIY" page. Other information is available at my "latest signals" page table.

Regards,
Alex

Anonymous said...

you misspelled Revelation.

Alex Roslin said...

Oops - thanks!