I'm using "color bar based on alert condition."

Numbers Bars Calculated Values

NBCV is ID 5 and SG 37 is selling COT (in a nutshell) specifically it is "high pullback ask volume and bid volume difference." SG 38 is buying COT.

I'm using the following logic for selling (SG37) =and((ABS(ID5.SG37))>8*(ABS(ID5.SG38))) and this for buying =and((ABS(ID5.SG38))>8*(ABS(ID5.SG37)))

The logic works fine with the following exception

If SG37 or SG38 is zero it returns a positive or meets criteria and colors bar ie SG37 is zero(0) and SG38 is nine(9.) If not a zero the logic works as it should

Any help very much appreciated

-William

Hi

(SG37) =and((ABS(ID5.SG37))>8*(ABS(ID5.SG38)),ID5.SG37<>0)

buying =and((ABS(ID5.SG38))>8*(ABS(ID5.SG37)),ID5.SG38<>0)

Thank you for the help

For what I'm using this for ie color bar based on SG37 & 38 of the NBCV study I'm using this to eliminate having to show the NBCV study itself (takes up too much real estate on an M1 Bar chart

= abs (ID5.SG37) > abs (ID5.SG38 )*5

= abs (ID5.SG38) > abs (ID5.SG37 )*5

-William

Hi William

sorry i don't understand if you want to skip calculation when ID5.SG37 == 0 or ID5.SG38==0

Thank you

I'm trading /CL

The problem is the COT data (SG37 & 38) has different thresholds of significance between 0200AM ET through 0900AM and 0900AM through the pit close. The majority of the time SG37 will be zero and 38 will have a number greater than zero, vice versa SG37 will have a negative number and 38 will be zero.

I'm still dialing this in. I have set the multiplier to as high as 20X but 20 times zero is obviously zero.

Are you versed/ skilled in SC syntax? I can pick away at it, more of a hack. I don't have access to spreadsheet studies through my SC platform

-William

i'm not so skilled but i can try .
can you explain what do you want to calc?

I'm good for now, I was curious

I think I'm going to have to go with using numbers bars in conjunction with my M1 standard deviation bars I started in another thread

Thank you

-William

crazybears 

i'm not so skilled but i can try . can you explain what do you want to calc?

I am such a dumbass

I finally dug into your code, thank you

Sometimes I'm not worth shooting

Works perfect



-William