Great Tool.

Same Question, does anybody has the data back for 4, 11, 18 April or
an actual spreadsheet.

Regards, Chris

Here is a copy of my current spreadsheet updated to the last report ( May 9, 2006).

I have adjusted the macro "CopyDataToSheet" for 2003 XL. It comes set for 2000 XL which works fine with 2003 XL. If you have 2000 XL or before and encounter any problems with the data copy then go to the macro and reset to 2000 XL. It is easy to do, just a matter of removing or adding the remark apostrophe on the appropriate statements.

Attached Files

Commitments of Traders_to_20060509.zip (223.3 KB, 110 views)

Thanks for doing this. Great work.

Out of curiosity, what are the benefits/consequences of having compatible with 2000 or 2003 Excel?

67-17454
Thanks for your question. It made me think about issues involved with my uploading a modified program.

The BENEFITS: For this finished application, I doubt there are any benefits of using the Excel 2003 code in place of the Excel 2000 code. The code in question only has to find one record in the weekly COT report. For a developer who would like to extend the data read capabilities of future versions of this workbook, the newer commands might be more efficient and flexible. Future development might address the issue of the unavailability of previous weekly reports after the issue of a new COT report. At the same time that the weekly report is issued an annual report is updated in the same format. The data read capabilities could be extended to process this annual report thus eliminating the need to find or recreate the weekly reports to update the data contained in the COT workbook.

The issue is about compatibility. Since 1997 macros for Excel (and the other Office products) have been written in Visual Basic for Applications (VBA). Periodically VBA is upgraded with new capabilities. From the programmer’s notes on the “Start Here” sheet it is apparent that he originally wrote the macros with the version of VBA which comes with Excel 2003. Some users were experiencing problems so the programmer added code that is compatible with earlier versions of VBA. He left the newer VBA code in place but set remark apostrophes in front of it to disable it.

The CONSEQUENCES: As I was going through the code to understand it, I changed my macro to use the newer version. Does this do anything better or faster? I doubt it. Should I have changed the macro to run with the newer commands? Probably not. The programmer had effectively addressed the issue of backward compatibility and probably left the new code in place as a courtesy to developers and others who might like to see the difference. By changing to the newer commands and uploading my modified workbook, I subverted his work. For users of Excel 2003 the new commands are fine but for someone with a previous version of Excel who downloads my workbook I have created an unnecessary problem.

At least at the time I did the upload I was aware enough to note the changes but I did not think it through or I would have changed the code back to the original. To make amends I am attaching the workbook with the original code and the COT records through May 9, 2006.

Attached Files

Commitments of Traders_to_20060509_original_macro.zip (223.3 KB, 111 views)

Here you go folks! Looks like the euro big dogs are extremely short, and cable does not look to far behind.

Attached Files

060516.zip (19.4 KB, 83 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.

Have you guys checked out this - http://www.commitmentoftraders.com/cotexamples.htm

they plot the MA(20) of the speculaters and MA(14) of the commercial traders, the crossover provides a Buy/Sell signal which seems good...this wud be gr8 if anyone could program the same in MT4......

Thx

here ya go.

Attached Files

060523.zip (19.5 KB, 61 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.

badda bing

Attached Files

060530.zip (19.7 KB, 68 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 this is a great tools.
Thanks

__________________
www.EffectiveFX.com

Here's a better deal. Get the COT data on your MetaTrader charts.

www.cot4metatrader.com

TheImperialOne