Bruce:

I often miss buy & sell signals that I have setup in columns. Can I display the date the condition triggered, OR would the better way to approach it be to alter the condition formula to ask if the condition was met within the last couple of trading days, or to just rely on alerts?  Thanks, Fred

Thank you Bruce.  Can you tell me the formula to show VolZoneOsc 14 is in a positive uptrend?

To add to my post above, my aim to to look for breakout using DI, so I would want the spread to occur after a positive XO.  Would introducing ADX into formual be valuable to indicate the strength of the trend?

Hi-I am looking for help with a formula using Directional Movement where the green line is above the red line and the spread between them is greater than 3 and VolZoneOsc 14 value is above 0.

Thanks, Fred

Hi:

What is the difference please between Price Change and Price Growth?

Also, what are the formulas please for Price Change-1 Yr and Avg Price Change-3 Yr

Thanks, Fred

Hi:

I ran into a term/measurement I hadn't seen before called positive weighted alpha (that Zacks uses), and read the definition is: The exact formula for weighted alpha can be modified based on the preferences or objectives of the individual analyst. One version of weighted alpha might apply a weight of 1.5 to all activity within the past three months and a factor of 0.5 to all activity between nine and 12 months ago. Others may apply a gradually declining weight to all price movements as they stretch further back in time.

Hi:
This produces a signal when the price goes below the bottom Bollinger Band and then is followed by the next green candle.  I've used it successfully as a buy signal & need help making it now do the opposite (price goes above top Bollinger Band followed by next red candle).  Thanks, Fred

C > O AND ((L1 <= AVGC20.1 - 2 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 20 * AVGC20.1 ^ 2) / 20) AND L2 > AVGC20.2 - 2 * SQR(ABS(C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 - 20 * AVGC20.2 ^ 2) / 20)) OR (C1 <= O1 AND L2 <= AVGC20.2 - 2 * SQR(ABS(C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 - 20 * AVGC20.2 ^ 2) / 20) AND L3 > AVGC20.3 - 2 * SQR(ABS(C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 + C22 ^ 2 - 20 * AVGC20.3 ^ 2) / 20)) OR (C1 <= O1 AND C2 <= O2 AND L3 <= AVGC20.3 - 2 * SQR(ABS(C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 + C22 ^ 2 - 20 * AVGC20.3 ^ 2) / 20) AND L4 > AVGC20.4 - 2 * SQR(ABS(C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 - 20 * AVGC20.4 ^ 2) / 20)))

Bruce:

I took out CMF just to simplify & it&#39;s working well with the C <= .93 *C10 so I think it must be in the CMF formula...still need to work that in.

Getting inaccurate results in plot as soon as I add the C <= .93 *C10 (I&#39;m plotting vs. using EasyScan)

Also don&#39;t know how to program And clarifying CMF, want it be either be under 50 or have been under 50 within the last 3-4 closes.

And clarifying CMF, want it be either be under 50 or have been under 50 within the last 3-4 closes.  Thx