COT Data Excel Sheet

 

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

Enjoy!

Files:
 

This is great thanks!!!

Galen

 

Same here, thanks!

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

Enjoy!

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

 

All instructions are contained in the spreadsheet///

DOMIANDR000:
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.

 

Todays COT data

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"

Files:
cot060425.zip  20 kb
 

Commitments of Traders - macro

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!!!

 

Anyone have COT data saved?

Excellent tool. I've been paying $4.95 per month for this same information and charts.

Does anyone have the COT data for 4/4 (came out on 4/7/06), 4/11 (4/14/06), and 4/18 (4/21/06)? They're not in the downloaded spreadsheet. I was able to start with the 4/24 (4/28/06) data.

Thanks.

Reason: