NexusFi: Find Your Edge


Home Menu

 





Positioning Analysis in Commodity Markets by Mark Keenan


Discussion in Commodities

Updated
      Top Posters
    1. looks_one JohnMcClean with 3 posts (0 thanks)
    2. looks_two xplorer with 2 posts (0 thanks)
    3. looks_3 drm7 with 1 posts (0 thanks)
    4. looks_4 Quick Summary with 1 posts (0 thanks)
    1. trending_up 2,421 views
    2. thumb_up 2 thanks given
    3. group 4 followers
    1. forum 7 posts
    2. attach_file 0 attachments




 
Search this Thread

Positioning Analysis in Commodity Markets by Mark Keenan

  #1 (permalink)
JohnMcClean
Scottsdale, Arizona
 
Posts: 7 since Jun 2016
Thanks Given: 8
Thanks Received: 1

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!

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
ZombieSqueeze
Platforms and Indicators
Better Renko Gaps
The Elite Circle
How to apply profiles
Traders Hideout
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
MC PL editor upgrade
MultiCharts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Spoo-nalysis ES e-mini futures S&P 500
29 thanks
Just another trading journal: PA, Wyckoff & Trends
24 thanks
Tao te Trade: way of the WLD
24 thanks
Bigger Wins or Fewer Losses?
21 thanks
GFIs1 1 DAX trade per day journal
17 thanks
  #3 (permalink)
 
xplorer's Avatar
 xplorer 
London UK
Site Moderator
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
Posts: 5,972 since Sep 2015
Thanks Given: 15,487
Thanks Received: 15,383



JohnMcClean View Post
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?

Reply With Quote
  #4 (permalink)
JohnMcClean
Scottsdale, Arizona
 
Posts: 7 since Jun 2016
Thanks Given: 8
Thanks Received: 1

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

Reply With Quote
  #5 (permalink)
 
xplorer's Avatar
 xplorer 
London UK
Site Moderator
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
Posts: 5,972 since Sep 2015
Thanks Given: 15,487
Thanks Received: 15,383


JohnMcClean View Post
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?

Reply With Quote
  #6 (permalink)
JohnMcClean
Scottsdale, Arizona
 
Posts: 7 since Jun 2016
Thanks Given: 8
Thanks Received: 1

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.

Reply With Quote
  #7 (permalink)
 Begbie00 
New York, NY
 
Experience: Beginner
Platform: TWS
Broker: InteractiveBrokers
Trading: Gold GC
Posts: 7 since Jun 2018
Thanks Given: 3
Thanks Received: 3


JohnMcClean View Post
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

Reply With Quote
Thanked by:
  #8 (permalink)
drm7
Virginia
 
Posts: 49 since Oct 2010
Thanks Given: 192
Thanks Received: 47

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

Reply With Quote




Last Updated on March 3, 2019


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts