Sunday 15 July 2007

Blog Update: COTs & CFTC in the News

I've just added a new feature to this blog with news items on the Commitments of Traders and Commodity Futures Trading Commission (see new link in the Table of Contents above). I'll update it regularly, so check back often. I hope to make it a fairly comprehensive listing of items of interest.

18 comments:

JGilly said...

Hi Alex,

Where do I get your spreadsheet to get started? Why isn't this on the site, am I missing something?

Thanks for the great site,

-john

JGilly said...

Great. I sent you an email. Can't wait to look over your work.

Thanks again.

-John

Richard said...

Hi Alex,

Can I also have a copy of your XLS?
(richpach@gmail.com)

Charting in XLS is very difficult. Is there a toll to take column input (date, OI, %Long, etc) from XLS and create a line chart?

Kind Regards

Richard

Richard said...

Alex,

Can I also have a copy of your spreadsheet please?
(richpach@gmail.com)

Is there a tool to create charts from spreadsheet data? Doing it in XLS is very clumsy.

Regards
Richard

Anonymous said...

The COT is still bearish on the NASDAQ Composite? That's not consistent with the current market, is it?

Alex Roslin said...

Hi Richard,

Thanks for your interest. No problem for a line chart, but I've found they're not as precise when the data is right at or very close to the signal line. If you can devise one that gives the needed precision, the chart is certainly useful because of the added visual input.

Regards,
Alex

JGilly said...

Hi Alex,

I didn't seem to receive the excel spreadhsheet email. I'm wondering if my email didn't go through to you, my email is jgilly97@gmail.com.

If you haven't had time to send it yet, I apologize, I'm just a bit exctied about this COT thing.

Sincerely,

-John

Alex Roslin said...

Hi John,

Thanks for your interest. Probably just hadn't gotten to it yet. Just sent it now.

Regards,
Alex

JGilly said...

Wow. This is very interesting. One question: Do the calculations apply for all indexes and commodities? Same buy/sell signals etc? Great work.

Thanks so much,

-John

Alex Roslin said...

Hi John,

Thanks. Each setup has somewhat different parameter values. Please check out the explanatory links up top for more details, including "The Trading Setups," which gives the parameter values for several other setups.

Regards,
Alex

JGilly said...

I looked that over, and I'm trying to make sense of how to apply it to the excel spreadsheet. For example, I'm most interested in natural gas, since most other COT sites are very bullish on it, while you are bearish.

It says to go with Large specs. Now, what do I need to change on the original sp500 spreadsheet you sent to make it work with natural gas.

I'm guessing I would change the calculation in column EA to reflect the Large traders. From there it will calculate the standard deviation and moving averages. Now, are the buy/sell signals in column EG correct, or do I have to change the parameters, or read the opposite parameters since I'm going with the Large traders.

I apologize if this question has been already asked.

Thanks,

-John

Alex Roslin said...

Hi John,

For the natural gas setup, I haven't posted the details yet. I'm still contemplating when and how to release the details of the remaining setups. Should I write a book? Should I just post them here?

For now, I've taken the go-slow approach. I've been publishing new setup details regularly in magazine stories in the past couple of months as well as on this blog - most recently the gold and HUI setups. A new magazine story is coming out in Active Trader's next issue, followed by one in the journal of the International Federation of Technical Analysts.

Until then, you'll have to be patient. Apologies!

In relation to the natural gas setup, please read the table notes and results carefully. This setup wasn't historically profitable on the short side, so I'm in cash on a bearish signal - even though the current sell seems to have worked out quite nicely!

Regards,
Alex

JGilly said...

What about the other indexes: nas, djia, rut? Will those work with the sp500 spreadsheet as long as I put in the correct trader. Do the SD Index signal still work for the buy/sell signals?

Alex Roslin said...

Hi John,

Please check the notes for "The Trading Setups" table, above. The details of the setups I've published so far are all there. I should post soon the details for the Russell 2000 setup, which are also the subject of the Active Trader story.

Take care,
Alex

Alex Roslin said...

Forgot to respond to an earlier comment left by "Anonymous," who noted that the bearish NASDAQ signal isn't reflected in recent market action.

This is a good question, and it applies to all my signals. No mechanical system is perfect. As you can see from my "Trading Setups" table, none of my setups has a 100-percent win record. I don't believe any trader or investor has ever won all the time. If you find one who claims to, run away! The goal is to be as profitable as possible over the long run, while preserving your capital.

Also please take a look at the column in that table that gives the largest past intratrade drawdowns for each setup. As you can see, some of the setups had rather large drawdowns (though this wasn't necessarily the final loss for the trade).

This is why any trader who wants to stay in business uses risk-management systems to control their maximum loss in any one trade. Please read the explanatory links above for how I approach risk management in my own system.

All the best,
Alex

Anonymous said...

Dear Alex,

I am one of the readers of your excellent COT Timer blog.

I would like to take a look at the spreadsheet you work with to entertain some ideas your blog inspired, like looking for any pre-crash/pre-correction anomalies.

Thank you in advance,
Alex Wertheim

alexw@iloveartdeco.com

Anonymous said...

Alex,

Your work is very interesting... I've always wondered how best to use COT data. Would it be possible for you to send a copy of your spreadsheet to me? Also, where do you find OIH and SMH ($SOX) futures data? What exchange do they trade on?

Great site!

Jonathan Herz
jonathancherz@hotmail.com

Anonymous said...

sir,
Can I also have a copy of your spreadsheet .
thanks in anticipation
manojap99@gmail.com