Menu
Sister Sites

Options

Bookmark Thread

First Page First Unread Last Page Last Post

Printable Version

Similar Threads

favorite journal tool: app, web, excel, google? 1 reply

Is there a tool for transferring MT4 trade history into excel? 13 replies

MT4-Excel Price Alert Tool By Binyamin 18 replies

Spread tool in excel 0 replies

COT data to Excel. 4 replies

Attachments: COT Excel Tool - desegregated data
Exit Attachments

COT Excel Tool - desegregated data

Hello there, I just keep on trying to find the historical forex cot data in the form of "Disaggregated Futures-Only Commitments of Traders Comma Delimited", but have no luck. Can somebody help me here?
here you are .
they are in Excell but you can save theme as csv .

http://www.mediafire.com/?pgdh86de5xww2p3
Thank you, lucifer. Still, in my case I only need the forex data of the previous week (19th release). I noticed that after the new report comes out, there is no way to find the "Disaggregated Futures-Only Commitments of Traders Comma Delimited" of the previous report. I thought maybe its only me who cannot find it..
You can get the historical data from this link: http://www.cftc.gov/MarketReports/Co...ssed/index.htm

Choose the excel file under Traders in Financial Futures ; Futures-and-Options Combined Reports:
Then open the excel file and copy the rows you want to import historically, I haven't worked on this project in a while but it still works.
I 've got runtime error 1004. (Excel 2003)

Is there any solution for it?

Has someone new excel tool for 2013? Pls, upload it.

ths
Does anyone know what each column is in this file:
http://www.cftc.gov/dea/newcot/f_disagg.txt

I am looking to use the report not as an indicator but to help scaling and allocation, so I'm looking to import that file and that convert number of holdings to a %. I'm using Google docs though.
Anyone with historical Data or spreadsheet updated to share?
Ok, Here is Updated by hands.... (15/04/2014)
Attached File
File Type: rar Commitment of Traders (Deseg data v 2.0002a).rar   1,021 KB | 1,319 download
Hi,

After some computer problem do I need a version of this excel with updated data.

or

I need to get where I can get history in correct format

Any advice ?
Hi there,

Thanks very much for this brilliant piece of kit, however I'm struggling to load the .csv file as when I click on the update button I get this message in the screenshot.

Could anyone kindly lend any advice?

Many thanks!!
Attached Image (click to enlarge)
Click to Enlarge Name: Screenshot 2015-01-31 09.32.34.png Size: 585 KB
Hello

Does anyone have the latest COT Excel spreadsheet please? I tried to run the excel on 2013 version but received an error number 9 (though the data updated with a gap in data. Thanks
Hello guys,

First of all,hats go off to Hordane for this amazing tool!

Would anyone be willing to walk me through how to add new underlyings that are out of existence in the spreadsheet(ES-Mini,DJ,etc)?

Appreciate your time and assistance!
Quoting Hordane
I'm going to post this tool I updated for those interested in the COT data. As you may or may not know, CTFC now desegregates Swap dealers from COT data. Swaps have become so large that they actually skew what is occurring, not all data services use the new desegregated data but the old data format with the swaps included. The tool is simple, it requires Excel 2003 or greater. I rewrote most of this on 2007 and can't test on 2003. The data is preloaded for the Aussie, Cable, Loonie, Fiber, Yen, Franc, Dollar Index. Instructions on how to add the...

Hi Hordane,

any updates for the tool?

Thanks
Any updates for the lastest file? i loaded the csv
and everything seems fked up lol
One Punch, One Kill
One Punch Trader All Time Return: -3.2%
Back in the 90's I put together an Excel spreadsheet to chart the Briese or COT index. Overtime that got dis-used and dissaapeared and now I am back looking to to the same thing.

Discovered the work done here by Hordane and it is great. I'll need to expand it to cover the futures I want but what a great start for me.

I see the posts on this subject are getting very old but if Hordane is out there - Thanks.
Quoting Hordane
You can get the historical data from this link: http://www.cftc.gov/MarketReports/Co...ssed/index.htm Choose the excel file under Traders in Financial Futures ; Futures-and-Options Combined Reports: Then open the excel file and copy the rows you want to import historically, I haven't worked on this project in a while but it still works.
Appreciate the great tool. Could anyone please send me a link to the latest updated version with COT data for this tool?
Many Thanks in advance
Buddy
Quoting Bddbolden
{quote} Appreciate the great tool. Could anyone please send me a link to the latest updated version with COT data for this tool? Many Thanks in advance Buddy
Yes, could we get updated version, please!
Quoting Bddbolden
{quote} Appreciate the great tool. Could anyone please send me a link to the latest updated version with COT data for this tool? Many Thanks in advance Buddy
In case nobody responds to you,feel free to use mine. http://bit.ly/CFTCMM
It contains the full history for the Legacy,Disaggregated and Traders in Financial Futures reports along with charts for most contracts contained within.
There is also a refreshable query to obtain weekly data and a macro to sort it to the appropriate sheet.
Make sure you read the ReadMe file too.
Quoting MoshiM
{quote} In case nobody responds to you,feel free to use mine. http://bit.ly/CFTCMM It contains the full history for the Legacy,Disaggregated and Traders in Financial Futures reports along with charts for most contracts contained within. There is also a refreshable query to obtain weekly data and a macro to sort it to the appropriate sheet. Make sure you read the ReadMe file too.
Hi MoshiM.

Would love to thank you for the Great Tools for analysis and follow up the marketts you ve attached .

Thanks Hordane for the thread and your tool.

Kind regards,
how to update excel file correctly
Attached Image (click to enlarge)
Click to Enlarge Name: Picture6.jpg Size: 127 KB
sameone try copy me?
1 trader viewing now