bjbuckley

_CM_COT Commercial Net Interest_V2

COT
85
cot
This builds off of the work of Greeny and ChrisMoody and incorporates more symbol overrides to bring in a wider array of instruments
Open-source script

In true TradingView spirit, the author of this script has published it open-source, so traders can understand and verify it. Cheers to the author! You may use it for free, but reuse of this code in a publication is governed by House Rules. You can favorite it to use it on a chart.

Disclaimer

The information and publications are not meant to be, and do not constitute, financial, investment, trading, or other types of advice or recommendations supplied or endorsed by TradingView. Read more in the Terms of Use.

Want to use this script on a chart?
//Created by ChrisMoody on 3-30-2015
//Modified by BJBuckley on 8-22-2015
//Shows Net Commercials
//Full Credit goes to Greeny fo rcreating original code.  Chris only made slight modifications.
//Chris's Modifications include - Taking away Net Longs and Shorts, Adding Background Highlighting when Commercials go from Long to Short
//My Modifications include - increasing the instrument force codes to the commodities set from just the currencies
//Methodology Is from Jake Bernstein at www.Trade-Futures.com and www.2Chimps.net

study("_CM_COT Commercial Net Interest_V1", shorttitle="_CM_COT Commercial Net Int_V1", precision=0)
force_root = input("", title="Override Product")
is_includeoptions = input(false, type=bool, title="Include Options")
si = input(false, type=bool, title="Show Inverse")
sbc = input(false, type=bool, title="Color Price Bars?")
sbg = input(true, type=bool, title="Show Background Highlight when Commercials Change From Buying to Selling?")
sa1 = input(true, type=bool, title="Alert If Commercials Change From Buying to Selling?")
sa2 = input(true, type=bool, title="Alert If Commercials Change From Selling to Buying?")

fxroot =
	  ticker == "USDCAD" ? "CD" : 
	  ticker == "USDCAD" ? "CD" : 
	  ticker == "USDCHF" ? "SF" : 
	  ticker == "USDCZK" ? "CZ" : 
	  ticker == "USDHUF" ? "FR" : 
	  ticker == "USDILS" ? "IS" : 
	  ticker == "USDJPY" ? "JY" : 
	  ticker == "USDMXN" ? "MP" : 
	  ticker == "USDNOK" ? "UN" : 
	  ticker == "USDPLN" ? "PZ" : 
	  ticker == "USDRUB" ? "RU" : 
	  ticker == "USDSEK" ? "SE" : 
	  ticker == "USDZAR" ? "RA" : 
	  ticker == "EURUSD" ? "EC" :
	  ticker == "E61!" ? "EC" :
	  ticker == "S61!" ? "SF" :
	  ticker == "J61!" ? "JY" :
	  ticker == "D61!" ? "CD" :
	  ticker == "A61!" ? "AD" :
	  ticker == "N61!" ? "NE" :
	  ticker == "B61!" ? "BP" :
	  ticker == "M61!" ? "MP" :
	  ticker == "AUDUSD" ? "AD" : 
	  ticker == "GBPUSD" ? "BP" : 
	  ticker == "NZDUSD" ? "NE" : 
	  ticker == "BRLUSD" ? "BR" : 
	  ticker == "COPPER" ? "HG" :
	  ticker == "LE1!" ? "LC" : 
	  ticker == "GF1!" ? "FC" : 
	  ticker == "HE1!" ? "LH" : 
	  ticker == "ZN1!" ? "TY" : 
	  ticker == "ZB1!" ? "US" : 
	  ticker == "ES1!" ? "SP" : 
	  ticker == "NY1!" ? "NK" :
	  ticker == "USOIL" ? "CL" :
	  ticker == "ZC1!" ? "C" :
	  ticker == "ZS1!" ? "S" :
	  ticker == "ZM1!" ? "SM" :
	  ticker == "ZL1!" ? "BO" :
	  ticker == "ZW1!" ? "W" :
	  ticker == "KE1!" ? "KW" :
	  ticker == "ZO1!" ? "O" :
	  ticker == "ZR1!" ? "RR" :
	  ""
root = force_root == "" ? fxroot == "" ? syminfo.root : fxroot : force_root
code = root + (is_includeoptions ? "_FO_L_ALL" : "_F_L_ALL")

is_inversed = 
	  ticker == "USDCAD" ? true : 
	  ticker == "USDCAD" ? true : 
	  ticker == "USDCHF" ? true : 
	  ticker == "USDCZK" ? true : 
	  ticker == "USDHUF" ? true : 
	  ticker == "USDILS" ? true : 
	  ticker == "USDJPY" ? true : 
	  ticker == "USDMXN" ? true : 
	  ticker == "USDNOK" ? true : 
	  ticker == "USDPLN" ? true : 
	  ticker == "USDRUB" ? true : 
	  ticker == "USDSEK" ? true : 
	  ticker == "USDZAR" ? true : 
	  false

long_total = security("QUANDL:CFTC/"+code+"|4", "W", close)
short_total = security("QUANDL:CFTC/"+code+"|5", "W", close)
//Code for Commercials Net Totals
long = is_inversed ? short_total : long_total
short = is_inversed ? long_total : short_total
net = long - short
//Alert criteria
alert1 = net[1] > 0 and net < 0 ? 1 : 0
alert2 = net[1] < 0 and net >= 0 ? 1 : 0
//Code for Histogram Color
col= net > 0 ? green : red

plot(si and long-short ? (long-short)*-1 : long-short, color = col, title="Net", style=columns)
hline(0, color=black, linestyle=dashed)
barcolor(sbc and (net[1] > 0 and net < 0) ? orange : na)
bgcolor(sbg and (net[1] > 0 and net < 0) ? lime : na, transp=20)

plot(sa1 and alert1 ? alert1 : 0, title="Alert If Commercials Go From Net Buy to Sell", style=line, linewidth=2, color=lime)
plot(sa2 and alert2 ? alert2 : 0, title="Alert If Commercials Go From Net Sell to Buy", style=line, linewidth=2, color=orange)