Commitment of traders comma delimited data - futures io
futures io futures trading



Commitment of traders comma delimited data


Discussion in Commodities

Updated
    1. trending_up 757 views
    2. thumb_up 1 thanks given
    3. group 2 followers
    1. forum 4 posts
    2. attach_file 0 attachments




Welcome to futures io: the largest futures trading community on the planet, with well over 125,000 members
  • Genuine reviews from real traders, not fake reviews from stealth vendors
  • Quality education from leading professional traders
  • We are a friendly, helpful, and positive community
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts
  • We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

(If you already have an account, login at the top of the page)

 
Search this Thread
 

Commitment of traders comma delimited data

(login for full post details)
  #1 (permalink)
st. louis missouri
 
Experience: Intermediate
Platform: tradestation
Trading: futures
 
Posts: 46 since Jun 2014
Thanks: 29 given, 22 received

I would like to play around with the Disaggregated COT report. I haven't found any charting software that will pull that data in, just the legacy. The raw data is available on the cftc website as comma delimited text and I have been trying to maneuver it into a spread sheet. My problem is that when I import the text I have 209 columns of data. The columns aren't labeled. The key to the columns is available on the cftc website but it only has 129 columns listed. I think that my import separator options might be the problem but I'm not real familiar with the process. Have any of you used this raw data? Have any guesses how I'm screwing it up?


update:
....never mind. I found the actual historical excel format files here https://www.cftc.gov/MarketReports/CommitmentsofTraders/HistoricalCompressed/index.htm

But while your here I'm curious if you are doing anything with the extra data that isn't in all the canned indicators. I mean there are over 100 data points in the report but most people concentrate on the net long/short of the 3 legacy groups.

Started this thread Reply With Quote

Journal Challenge February 2021 results (so far):
Competing for $1500 in prizes from Topstep
looks_oneSBtrader82 's Trading Journalby SBtrader82
(169 thanks from 31 posts)
looks_twoJust BEING a Trader: Letting Go!!by iqgod
(116 thanks from 33 posts)
looks_3Wisdom is Emptinessby Mtype
(68 thanks from 25 posts)
looks_4Deetee’s DAX Trading Journal (time based)by Deetee
(31 thanks from 17 posts)
looks_5Journal for peanuts1956by peanuts1956
(23 thanks from 13 posts)
 
 
(login for full post details)
  #3 (permalink)
Market Wizard
Linz Austria
 
Experience: Advanced
Platform: Zaner360, TWS, Vantage
Broker: DeCarley, IAB, RJO
Trading: Commodities
 
Posts: 1,764 since Nov 2014
Thanks: 2,894 given, 2,378 received



harryguy View Post
I would like to play around with the Disaggregated COT report. I haven't found any charting software that will pull that data in, just the legacy. The raw data is available on the cftc website as comma delimited text and I have been trying to maneuver it into a spread sheet. My problem is that when I import the text I have 209 columns of data. The columns aren't labeled. The key to the columns is available on the cftc website but it only has 129 columns listed. I think that my import separator options might be the problem but I'm not real familiar with the process. Have any of you used this raw data? Have any guesses how I'm screwing it up?


update:
....never mind. I found the actual historical excel format files here https://www.cftc.gov/MarketReports/CommitmentsofTraders/HistoricalCompressed/index.htm

But while your here I'm curious if you are doing anything with the extra data that isn't in all the canned indicators. I mean there are over 100 data points in the report but most people concentrate on the net long/short of the 3 legacy groups.

I never worked with the original COT data.

I used the charts of Floyd Upperman for some time, which he publishes on his website. Access has to be paid for.

Best regards, Myrrdin

Reply With Quote
The following user says Thank You to myrrdin for this post:
 
(login for full post details)
  #4 (permalink)
st. louis missouri
 
Experience: Intermediate
Platform: tradestation
Trading: futures
 
Posts: 46 since Jun 2014
Thanks: 29 given, 22 received


myrrdin View Post
I never worked with the original COT data.

I used the charts of Floyd Upperman for some time, which he publishes on his website. Access has to be paid for.

Best regards, Myrrdin

This guy has an interesting site but he doesn't show you anything different from all other COT indicators/websites. His sales video just shows analysis using the commercial position and the large spec position and isn't any different than the books I have read on the subject. The website does mention the new disaggregated report but the examples and sales video showed only the legacy analysis. It was extremely similar to COTbase. But he does provide market entry signals with his "plungers" that sound like a slightly modified turtle system. For $99/month I think I'll pass though.

Started this thread Reply With Quote
 
(login for full post details)
  #5 (permalink)
Market Wizard
Linz Austria
 
Experience: Advanced
Platform: Zaner360, TWS, Vantage
Broker: DeCarley, IAB, RJO
Trading: Commodities
 
Posts: 1,764 since Nov 2014
Thanks: 2,894 given, 2,378 received


harryguy View Post
This guy has an interesting site but he doesn't show you anything different from all other COT indicators/websites. His sales video just shows analysis using the commercial position and the large spec position and isn't any different than the books I have read on the subject. The website does mention the new disaggregated report but the examples and sales video showed only the legacy analysis. It was extremely similar to COTbase. But he does provide market entry signals with his "plungers" that sound like a slightly modified turtle system. For $99/month I think I'll pass though.

I was his customer many years ago. If I remember correctly he shows charts unsing the disaggregated reports as well. I think he offers a free trial for some weeks. Of course his data is the same than the data in the original COT report. But drawing nice charts is some work, and this is what I paid him for.

The plungers - as you certainly read in his book - are not at all rocket science, and not worth the price.

Best regards, Myrrdin

Reply With Quote


futures io Trading Community Traders Hideout Commodities > Commitment of traders comma delimited data


Last Updated on October 13, 2018


Upcoming Webinars and Events
 

NinjaTrader Indicator Challenge!

Ongoing
 

Journal Challenge w/$1500 prizes from Topstep!

February
 

Battlestations! Show us your trading desk - $1,500 in prizes!

March
 

Call Option Buying: The New Pain Trade? w/Carley Garner

Elite only
     



Copyright © 2021 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
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.
no new posts