Has anyone read Positioning Analysis in Commodity Markets by Mark Keenan. The book had great reviews on amazon so I picked it up. It's by far the most comprehensive and well thought out book on creating trading frameworks I've ever read. Some particular points of interest are his Dry Powder Analysis, Dry Powder bubbles and Overbought/Oversold indicators.

I'm wondering if anyone else has read this book and implemented any of the frameworks he lays out. Without easy access to a Bloomberg terminal I'm wondering where you are getting the data from. I essentially need the COT data in a .csv file. On the COT website I'm only seeing a text file.

If anyone has read this book or knows how to easily get the COT text data transferred to Excel I'd love to know how you do it.

Thanks!

JohnMcClean 

Has anyone read Positioning Analysis in Commodity Markets by Mark Keenan. The book had great reviews on amazon so I picked it up. It's by far the most comprehensive and well thought out book on creating trading frameworks I've ever read. Some particular points of interest are his Dry Powder Analysis, Dry Powder bubbles and Overbought/Oversold indicators. I'm wondering if anyone else has read this book and implemented any of the frameworks he lays out. Without easy access to a Bloomberg terminal I'm wondering where you are getting the data from. I essentially need the COT data in a .csv file. On the COT website I'm only seeing a text file. If anyone has read this book or knows how to easily get the COT text data transferred to Excel I'd love to know how you do it. Thanks!

Hi John

Do you have a copy of the text file?


Alternatively, can you point me to the site where the data you're referring to is?

Hello!

Below is the link to the main site which is the Commodity Futures Trading Commission website. The second link is to the Long Format of the Disaggregated COT report for agriculture. The text on that page is what I'm trying to get into Microsoft Excel.

https://www.cftc.gov/MarketReports/CommitmentsofTraders/index.htm

https://www.cftc.gov/dea/futures/ag_lf.htm

Thanks for taking a look. Much appreciated!


-John

JohnMcClean 

Hello! Below is the link to the main site which is the Commodity Futures Trading Commission website. The second link is to the Long Format of the Disaggregated COT report for agriculture. The text on that page is what I'm trying to get into Microsoft Excel. https://www.cftc.gov/MarketReports/CommitmentsofTraders/index.htm https://www.cftc.gov/dea/futures/ag_lf.htm Thanks for taking a look. Much appreciated! -John

Hi John

You're going to have a hard time attempting to convert the format shown in the second link you provided into CSV, given it has multiple headings.

On the main page, under "Other Available Formats" there's a handful of CSV files, are those not suitable?

Hello,

Those other formats would probably be suitable for someone with better Excel skills than myself. Currently I'm able to save that text as a text file using Mac "Text Edit" which is the equivalent of Microsoft NotePad. From there I'm able to import the file into Excel. While importing I select "Delimited" and then select the "comma" check box. This produces a fairly clean Excel file but its missing the heading of what each column of data is. I've been trouble shooting it but haven't been successful. I'm starting to think that info isn't listed.

Thanks again for the reply.

JohnMcClean 

Hello, Those other formats would probably be suitable for someone with better Excel skills than myself. Currently I'm able to save that text as a text file using Mac "Text Edit" which is the equivalent of Microsoft NotePad. From there I'm able to import the file into Excel. While importing I select "Delimited" and then select the "comma" check box. This produces a fairly clean Excel file but its missing the heading of what each column of data is. I've been trouble shooting it but haven't been successful. I'm starting to think that info isn't listed. Thanks again for the reply.

For the data itself, use this link: https://www.cftc.gov/MarketReports/CommitmentsofTraders/HistoricalCompressed/index.htm

The easiest way to do it is compile it from 4 files:
1) 2006-2016
2) 2017
3) 2018
4) 2019

Headers appear here:
Disaggregated COT -https://www.cftc.gov/MarketReports/CommitmentsofTraders/HistoricalViewable/CFTC_023168.html

Supplemental Report - https://www.cftc.gov/MarketReports/CommitmentsofTraders/HistoricalViewable/cotvariablescitsupplement.html

This might help.

You can export this data to a .csv file.

https://www.barchart.com/futures/disaggregated-cot-reports/all?view=producer&report=summary