NexusFi: Find Your Edge


Home Menu

 





How do I chart the CFTC COT Excel data in NinjaTrader?


Discussion in NinjaTrader

Updated
      Top Posters
    1. looks_one JohnPS with 3 posts (5 thanks)
    2. looks_two Prtester with 2 posts (1 thanks)
    3. looks_3 Quick Summary with 1 posts (0 thanks)
    4. looks_4 GridKing with 1 posts (2 thanks)
      Best Posters
    1. looks_one cme4pif with 4 thanks per post
    2. looks_two GridKing with 2 thanks per post
    3. looks_3 JohnPS with 1.7 thanks per post
    4. looks_4 Prtester with 0.5 thanks per post
    1. trending_up 8,210 views
    2. thumb_up 12 thanks given
    3. group 6 followers
    1. forum 8 posts
    2. attach_file 1 attachments




 
Search this Thread

How do I chart the CFTC COT Excel data in NinjaTrader?

  #1 (permalink)
 JohnPS 
Dewitt Mi
 
Experience: Intermediate
Platform: NinjaTrader
Broker: Amp/CQG and Infinity
Trading: Futures
Posts: 52 since Sep 2009
Thanks Given: 52
Thanks Received: 18

How do I import the CFTC COT Excel data in NinjaTrader to make a line chart?

This is the data from the CFTC:
http://www.cftc.gov/dea/futures/financial_lf.htm

I can take the weekly data and get it into Excel, I have done that part, I would like to take this data and import it into Ninja as a chart. Has any one this or know how?
I am looking for a line chart of the Commercials, Large traders and Small traders and Open Interest.

Started this thread Reply With Quote
Thanked by:

Can you help answer these questions
from other members on NexusFi?
Are there any eval firms that allow you to sink to your …
Traders Hideout
Exit Strategy
NinjaTrader
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
ZombieSqueeze
Platforms and Indicators
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
61 thanks
Funded Trader platforms
39 thanks
Battlestations: Show us your trading desks!
26 thanks
NexusFi site changelog and issues/problem reporting
26 thanks
The Program
18 thanks
  #3 (permalink)
 
cme4pif's Avatar
 cme4pif 
Near Vancouver BC CANADA
 
Experience: Intermediate
Platform: NinjaTrader -- IB
Trading: Futures
Posts: 32 since Mar 2011
Thanks Given: 28
Thanks Received: 58


First off the answer is yes you can do this. You can import any excel data into NT there are article on the NT support form. This is the help screen on how to do it:
NinjaTrader Version 7

You also can pay a service I think it is like $39 a month for the feed they are in the official NT suppler list, I also found this one on goggle
COT Report
but I think that would be crazy since this data only comes out once a week.

I can warn you before you go down this path, that the correlation of the CoT data and the markets is very weak.
You can view some graphs here:
https://www.timingcharts.com/
Notice they lag the commodities by quite a bit, about the best you can do is take the weekly data on a 20 week SMA and get a sense of market direction. That is almost no use, a renko chart of the SPY tells about the same story. In short -- the lag on this indicator makes it nearly useless for trading in any real time frame.

Reply With Quote
  #4 (permalink)
 
GridKing's Avatar
 GridKing 
San Diego, CA USA
 
Experience: Intermediate
Platform: NinjaTrader
Trading: ES
Posts: 3,630 since May 2011
Thanks Given: 584
Thanks Received: 881

Also as a reference "Barchart provides charts for all three COT Reports. The Financial Traders (TFF) Report divides the financial futures market participants into the "sell" and "buy" side, focusing on their respective roles in the marketplace, not whether they are buyers or sellers of futures/option contracts."


Futures - Commitment of Traders Reports (COT)

just remember they come out on Friday for Tuesday *

"Successful trading is one long journey, not a destination" Peter Borish Former Head of Research for Paul Tudor Jones speaking on conversations with John F. Carter
Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #5 (permalink)
 JohnPS 
Dewitt Mi
 
Experience: Intermediate
Platform: NinjaTrader
Broker: Amp/CQG and Infinity
Trading: Futures
Posts: 52 since Sep 2009
Thanks Given: 52
Thanks Received: 18

Yes CME4,
COT is not optimal - it does not give perfect cause and effect, the correlation is weak as you say. But I am looking for something other than price and volume to evaluate the markets. COT and Open Interest are showing what the Commercials are doing, with this a scenario can be built that reduces risk. This is a swing trade scenario in terms of 5 to 40 days, depending on the exit strategy. In the case of commodities, yearly cycles and current consumptions, some very good trades can be setup.
Thank you for the links to the help section,
John

Started this thread Reply With Quote
  #6 (permalink)
 Prtester 
SE-Asia
 
Experience: Intermediate
Platform: NinjaTrader
Broker: Amp
Trading: ES
Posts: 151 since Jun 2009
Thanks Given: 66
Thanks Received: 124

I found this in the ninja forum, I don't use it, I don't know how to use it, and don't know if it work. But maybe help someone to start his/her own.

Attached Files
Elite Membership required to download: COTReport_EW.zip
Reply With Quote
Thanked by:
  #7 (permalink)
 JohnPS 
Dewitt Mi
 
Experience: Intermediate
Platform: NinjaTrader
Broker: Amp/CQG and Infinity
Trading: Futures
Posts: 52 since Sep 2009
Thanks Given: 52
Thanks Received: 18


Prtester View Post
I found this in the ninja forum ...

This looks very promising! would you please post a link to the Ninja Forum page so I can read how they use it? The data comes from the CFTC and there may be info on how to merge this into this indicator.
Thanks for posting the zip file!

Started this thread Reply With Quote
  #8 (permalink)
 Prtester 
SE-Asia
 
Experience: Intermediate
Platform: NinjaTrader
Broker: Amp
Trading: ES
Posts: 151 since Jun 2009
Thanks Given: 66
Thanks Received: 124


JohnPS View Post
would you please post a link to the Ninja Forum page ...

COT Report - [AUTOLINK]NinjaTrader[/AUTOLINK] Support Forum

Reply With Quote
  #9 (permalink)
 
aventeren's Avatar
 aventeren 
Bellingham, WA USA
 
Experience: Beginner
Platform: NT
Broker: Mirus (Broker), Continuum (Data), Dorman (Clearing)
Trading: Futures
Posts: 202 since Mar 2013
Thanks Given: 428
Thanks Received: 202

Did anyone figure out how to import COT data for use in NT?

Reply With Quote




Last Updated on September 2, 2014


© 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