Here you go Boys and Girls, a nifty little tool you can use.

Enjoy!

Attached Files

Commitments of Traders.zip (208.5 KB, 4860 views)

__________________
Im on the run, I kill to eat, Im starving now, and feeling dead on me feet. Going all the way, I'm nature's beast.

This is great thanks!!!
Galen

Same here, thanks!

Hi, Techtrader!

Can you tell me what did they say this week?

What were they: $ bullish or bearish?

Nina

Hi!


Any answer yet? Ummmm

I'm anxious.

Nina

Hi TechTrader,
Is there any data source to update this sheet??

Thanks

Look under the start here tab, there are simple and easy to use instructions on how to use this program.

__________________
Im on the run, I kill to eat, Im starving now, and feeling dead on me feet. Going all the way, I'm nature's beast.

Here is an excel sheet u can use with the most current COT data.

Data is available every friday @ 3pm EST at this site:
http://www.cftc.gov/dea/newcot/deafut.txt

Simple and detailed instructions on how to save and import data are located under the tab labeled "Start Here"

Attached Files

COT060425.zip (19.3 KB, 534 views)

__________________
Im on the run, I kill to eat, Im starving now, and feeling dead on me feet. Going all the way, I'm nature's beast.

TechTrader,

The COT excel workbook looks like a great tool. Very impressive!

I have gone through the instructions on the Start Here sheet. Changed my Macro Security setting to low and checked both "Trust all installed add-ins and templates and "Trust access to Visual Basic Project".

When I click the "COT Update" I get a warning window with the text -- The macro "Commitments of Traders.xls'!importCOTcsv' cannot be found.

I don't know much about working with macros so I would appreciate any suggestions on getting this to work.

I am running Excel 2003 SP2.

hap

great informative tool.
many thanks to techtrader!!!