Announcement

Collapse

Looking for a User App or Add-On built by the NinjaTrader community?

Visit NinjaTrader EcoSystem and our free User App Share!

Have a question for the NinjaScript developer community? Open a new thread in our NinjaScript File Sharing Discussion Forum!
See more
See less

Partner 728x90

Collapse

Commitment of Traders (COT) indicator

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Commitment of Traders (COT) indicator

    Regardless of the market being traded, I think the CFTC Commitment of Traders report provides invaluable information on where the "Big Boys" are in the market. Personally, I've found using the COT data can be VERY effective as an overall directional filter in strategies. Use your system for timing, but only trade in the direction of large specs or commercials, which usually also happens to be the opposite direction as the general public. A further advantage of a COT indicator is that it makes absolutely no reference to price like every other indicator, so it gives a unique angle on the market.

    Unfortunately there is no way to use this information in NinjaTrader at the moment. There are COT indicators for other platforms but most of them seem to be subscription based, very expensive or both, and while I wouldn't mind paying a subscription fee, I'd rather not when the data itself is free.

    Example of a great COT indicator.






    I've attached a screenshot, and a non-functional skeleton indicator as an idea on how an this indicator could work. Basically a drop down menu to select the desired market, 3 lines for the Large/Small Specs and the Commercials, a bar graph for open interest and perhaps the option to displace the data back three days so it plots based on the reporting date rather than the date the data is released.

    This would be slightly advanced to program, but basically all that should be needed is knowledge/experience on how to work with comma-delimited text files (not me ).

    Data Example:
    Code:
    "Market and Exchange Names","As of Date in Form YYMMDD","As of Date in Form YYYY-MM-DD","CFTC Contract Market Code","CFTC Market Code in Initials","CFTC Region Code","CFTC Commodity Code","Open Interest (All)","Noncommercial Positions-Long (All)","Noncommercial Positions-Short (All)","Noncommercial Positions-Spreading (All)","Commercial Positions-Long (All)","Commercial Positions-Short (All)"," Total Reportable Positions-Long (All)","Total Reportable Positions-Short (All)","Nonreportable Positions-Long (All)","Nonreportable Positions-Short (All)","Open Interest (Old)","Noncommercial Positions-Long (Old)","Noncommercial Positions-Short (Old)","Noncommercial Positions-Spreading (Old)","Commercial Positions-Long (Old)","Commercial Positions-Short (Old)","Total Reportable Positions-Long (Old)","Total Reportable Positions-Short (Old)","Nonreportable Positions-Long (Old)","Nonreportable Positions-Short (Old)","Open Interest (Other)","Noncommercial Positions-Long (Other)","Noncommercial Positions-Short (Other)","Noncommercial Positions-Spreading (Other)","Commercial Positions-Long (Other)","Commercial Positions-Short (Other)","Total Reportable Positions-Long (Other)","Total Reportable Positions-Short (Other)","Nonreportable Positions-Long (Other)","Nonreportable Positions-Short (Other)","Change in Open Interest (All)","Change in Noncommercial-Long (All)","Change in Noncommercial-Short (All)","Change in Noncommercial-Spreading (All)","Change in Commercial-Long (All)","Change in Commercial-Short (All)","Change in Total Reportable-Long (All)","Change in Total Reportable-Short (All)","Change in Nonreportable-Long (All)","Change in Nonreportable-Short (All)","% of Open Interest (OI) (All)","% of OI-Noncommercial-Long (All)","% of OI-Noncommercial-Short (All)","% of OI-Noncommercial-Spreading (All)","% of OI-Commercial-Long (All)","% of OI-Commercial-Short (All)","% of OI-Total Reportable-Long (All)","% of OI-Total Reportable-Short (All)","% of OI-Nonreportable-Long (All)","% of OI-Nonreportable-Short (All)","% of Open Interest (OI)(Old)","% of OI-Noncommercial-Long (Old)","% of OI-Noncommercial-Short (Old)","% of OI-Noncommercial-Spreading (Old)","% of OI-Commercial-Long (Old)","% of OI-Commercial-Short (Old)","% of OI-Total Reportable-Long (Old)","% of OI-Total Reportable-Short (Old)","% of OI-Nonreportable-Long (Old)","% of OI-Nonreportable-Short (Old)","% of Open Interest (OI) (Other)","% of OI-Noncommercial-Long (Other)","% of OI-Noncommercial-Short (Other)","% of OI-Noncommercial-Spreading (Other)","% of OI-Commercial-Long (Other)","% of OI-Commercial-Short (Other)","% of OI-Total Reportable-Long (Other)","% of OI-Total Reportable-Short (Other)","% of OI-Nonreportable-Long (Other)","% of OI-Nonreportable-Short (Other)","Traders-Total (All)","Traders-Noncommercial-Long (All)","Traders-Noncommercial-Short (All)","Traders-Noncommercial-Spreading (All)","Traders-Commercial-Long (All)","Traders-Commercial-Short (All)","Traders-Total Reportable-Long (All)","Traders-Total Reportable-Short (All)","Traders-Total (Old)","Traders-Noncommercial-Long (Old)","Traders-Noncommercial-Short (Old)","Traders-Noncommercial-Spreading (Old)","Traders-Commercial-Long (Old)","Traders-Commercial-Short (Old)","Traders-Total Reportable-Long (Old)","Traders-Total Reportable-Short (Old)","Traders-Total (Other)","Traders-Noncommercial-Long (Other)","Traders-Noncommercial-Short (Other)","Traders-Noncommercial-Spreading (Other)","Traders-Commercial-Long (Other)","Traders-Commercial-Short (Other)","Traders-Total Reportable-Long (Other)","Traders-Total Reportable-Short (Other)","Concentration-Gross LT = 4 TDR-Long (All)","Concentration-Gross LT =4 TDR-Short (All)","Concentration-Gross LT =8 TDR-Long (All)","Concentration-Gross LT =8 TDR-Short (All)","Concentration-Net LT =4 TDR-Long (All)","Concentration-Net LT =4 TDR-Short (All)","Concentration-Net LT =8 TDR-Long (All)","Concentration-Net LT =8 TDR-Short (All)","Concentration-Gross LT =4 TDR-Long (Old)","Concentration-Gross LT =4 TDR-Short (Old)","Concentration-Gross LT =8 TDR-Long (Old)","Concentration-Gross LT =8 TDR-Short (Old)","Concentration-Net LT =4 TDR-Long (Old)","Concentration-Net LT =4 TDR-Short (Old)","Concentration-Net LT =8 TDR-Long (Old)","Concentration-Net LT =8 TDR-Short (Old)","Concentration-Gross LT =4 TDR-Long (Other)","Concentration-Gross LT =4 TDR-Short(Other)","Concentration-Gross LT =8 TDR-Long (Other)","Concentration-Gross LT =8 TDR-Short(Other)","Concentration-Net LT =4 TDR-Long (Other)","Concentration-Net LT =4 TDR-Short (Other)","Concentration-Net LT =8 TDR-Long (Other)","Concentration-Net LT =8 TDR-Short (Other)","Contract Units","CFTC Contract Market Code (Quotes)","CFTC Market Code in Initials (Quotes)","CFTC Commodity Code (Quotes)" 
    "WHEAT - CHICAGO BOARD OF TRADE" ,081118 ,2008-11-18,001602 ,CBT ,00 ,001 ,  297518,   68830,   68897,   64834,  140226,  117548,  273890,  251279,   23628,   46239,  207360,   68511,   63729,   33218,   87298,   78891,  189027,  175838,   18333,   31522,   90158,   26430,   31279,    5505,   52928,   38657,   84863,   75441,    5295,   14717,   10858,    2185,   -6017,    3918,    8058,   14771,   14161,   12672,   -3303,   -1814,  100.0,   23.1,   23.2,   21.8,   47.1,   39.5,   92.1,   84.5,    7.9,   15.5,  100.0,   33.0,   30.7,   16.0,   42.1,   38.0,   91.2,   84.8,    8.8,   15.2,  100.0,   29.3,   34.7,    6.1,   58.7,   42.9,   94.1,   83.7,    5.9,   16.3,    330,     66,    115,    136,     64,     88,    239,    280,    323,    101,    100,    104,     59,     81,    220,    249,    191,     29,     79,     30,     40,     74,     89,    166,    21.3,    12.1,    33.0,    19.0,    17.9,    10.0,    28.0,    15.9,    16.8,    13.9,    28.2,    22.2,    15.8,    12.8,    26.6,    20.7,    59.1,    14.4,    70.1,    23.7,    58.9,    13.1,    69.3,    21.7,"(CONTRACTS OF 5,000 BUSHELS)" ,"001602" ,"CBT" ,"001"
    The yearly data in text format (updated weekly) is available here:


    and the updated weekly data is available here:
    This is the viewable version of the most recent release of the CME short form futures only commitments report.


    Ideally it would be great if the indicator could grab the data from the web on its own, but as its only updated once a week, I don't see it being a big deal to manually download it every week.

    More info on COT:

    Ever wonder what the smart money is doing in the markets? You don’t need to pay big bucks to find out. Just read the Commodity Futures Trading Commission’s free weekly Commitments of Traders report. The CFTC’s COT data is a Holy Grail of market info, listing trillions of dollars in positions in 200+ markets – gold, crude oil, natural gas, silver, forex, equity indexes and lots more. My trading system, which I posted about here for seven years, gave weekly trading signals based on the COT data.


    Attached Files

    #2
    Hi Elliott Wave,

    Thanks for posting your ideas and your skeleton COT indicator.

    I will forward it promptly to our development team!

    Have a great day!
    BertrandNinjaTrader Customer Service

    Comment


      #3
      I've found a COT indicator in MetaTrader format.

      The downside is although it reads CSV files, the columns are not the same as the CFTC website, so it would need to be adapted to the CFTC format to avoid the need for any subscription.

      Comment


        #4
        Another COT indicator in TradeStation format.

        Comment


          #5
          Cot Report in NinjaTrader format

          Take a look at this post:



          thanks,
          jr.

          Comment


            #6
            Cot Report in NinjaTrader format

            Excuse me, the post is:


            regards,
            jr.

            Comment


              #7
              Hi jrbolsa,
              Great to see your persistence at work - thanks for posting!
              BertrandNinjaTrader Customer Service

              Comment


                #8
                I'm liking what I see so far.

                Does your indicator use the file format of the CFTC?

                Also, while parsing CSV files may not be my thing, I would be glad to help out in any other areas (visual improvements, translation etc), just let me know.

                ...
                An interesting interview with Larry Williams on the COT:
                Last edited by Elliott Wave; 12-14-2008, 01:52 PM.

                Comment


                  #9
                  Very much and hard work:
                  My intention is to have several indicators related to cot report:

                  - jrCotixC (Commercials net position)
                  - jrCotixN (Non-commercials net position)
                  - jrCotixS (Small spec net position)
                  - jrCotixO (Open Interest)

                  - jrCotixCP (Commercials percentualized) (the index of L. Williams)
                  - jrCotixNP (Non-commercials percent.)
                  - jrCotixSP (Small percent.)
                  - jrCotixOP (Open Interest percent.)

                  - jrCotixCL (net Commercials Long)
                  - jrCotixCS (net Commercials Short)
                  - jrCotixCLP (Commercials Long percent.)
                  - jrCotixCSP (Commercials Short percent.)

                  - jrCotixCLtoOI (Commercials Long to Open Interest)
                  - jrCotixCStoOI (Commercials Short to Open Interest)
                  - jrCotixCtoOI (net Commercials (long-short) to Open Interest)
                  - jrCotixCtoOIP (Commercials (long-short) to Open Interest percent.)

                  But first i must be sure with ninjatrader. I need to know if the same data has the same name with every vendor (it's not the same "S&P" and "SP500").

                  After that i have to check the fastest way (i have to different "jrCotixC", one faster than the other).

                  I'm now downloading the data from de cftc but my intention is to have it automatically.

                  And finally and if you know L.W. I have two great - and better - indicators than this "family": one is the seasonality (LW speaks a lot about it) - i called it "jrSeasix", and the other one, a great great indicator: it does the same like these ones but for every data you have (every index, or stock or whatever): jrCotProx (Listening the LWU in his website and with much mathematics I could imagine what he was doing). If you understand spanish you can check them in www.jrbolsa.com (since april more or less, when i discovered this all).

                  Regards,
                  jr.

                  Comment


                    #10
                    Great jrbolsa, to see which symbols are setup in our Instrument Manager, please disconnect from any datafeed / broker and go to Tools > Instrument Manager and browse the different categories of symbols.

                    BertrandNinjaTrader Customer Service

                    Comment


                      #11
                      I forgot...
                      You can see me looking for "cot report youtube" in google. These are the links (but you must understand spanish):
                      Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

                      Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.


                      thanks,
                      jr.

                      Comment


                        #12
                        Thanks a lot Bertrand. I'm very pleased to meet people like you all (Dan, Josh, you...). I haven't ever seen so quick answers.

                        regards,
                        jr.

                        Comment


                          #13
                          Thank you jrbolsa!
                          BertrandNinjaTrader Customer Service

                          Comment


                            #14
                            NINJATRADER - COT REPORT: new advance

                            This was faster than i thought.

                            jrCotixCP (commercials net percentualized):

                            (this is the cot proxy of Larry Williams).
                            It would be better understood with commodities (soybean, oat, wheat, corn, ...) but i have to programm with the SP500 (yahoo.com) until i register with a data vendor.


                            regards,
                            jr.

                            Comment


                              #15
                              Error:

                              I meant the COT INDEX of Larry Williams.

                              (The Cot Proxy is another indicator - I have it too, but only in VisualChart. Soon in Ninjatrader although i think that i'll have to stop for a couple of weeks due to Christmas holidays and modifications that i need to do in the information downloaded from cftc).

                              jr.

                              Comment

                              Latest Posts

                              Collapse

                              Topics Statistics Last Post
                              Started by Barry Milan, Today, 10:35 PM
                              1 response
                              8 views
                              0 likes
                              Last Post NinjaTrader_Manfred  
                              Started by WeyldFalcon, 12-10-2020, 06:48 PM
                              14 responses
                              1,428 views
                              0 likes
                              Last Post Handclap0241  
                              Started by DJ888, Yesterday, 06:09 PM
                              2 responses
                              9 views
                              0 likes
                              Last Post DJ888
                              by DJ888
                               
                              Started by jeronymite, 04-12-2024, 04:26 PM
                              3 responses
                              40 views
                              0 likes
                              Last Post jeronymite  
                              Started by bill2023, Today, 08:51 AM
                              2 responses
                              16 views
                              0 likes
                              Last Post bill2023  
                              Working...
                              X