Hello Bruce:

Can we write PCF to calculate the difference between today price and the lowest price in past 5 years, place the scan as a column on a watchlist and sort it by the difference. So if values is positive it would indicate that the current price is above the lowest low of last 5 years and vice versa

Thanks

Deepak

On the same lines as this post...Is it possibe to create a watchlist of stocks in which each stock is in turn linked to a component watchlist displaying  set of stocks which one may wish to watch/trade . E.G if we create a watchlist containing GOOG,AAPL can this watchlist be linked to a component watchlist so when we choose GOOG the linked component watchlist will show a list of stocks that I may wish to trade based on what I see in GOOG..The component watchlist would be user defined..

Thanks

Deepak

Hello Bruce:

I have created a PCF based on the the above post for BB Period 15 and StdDev 1.5 and have a condition(formula)  to show stocks with the Low Price being less than the Lower BB  as follows

L < (AVGC15 - 1.5 * SQR(ABS(C1 ^ 1.5 + C2 ^ 1.5 + C3 ^ 1.5 + C4 ^ 1.5 + C5 ^ 1.5 + C6 ^ 1.5 + C7 ^ 1.5 + C8 ^ 1.5 + C9 ^ 1.5 + C10 ^ 1.5 + C11 ^ 1.5 + C12 ^ 1.5 + C13 ^ 1.5 + C14 ^ 1.5 + C15 ^ 1.5  - 15 * AVGC15 ^ 1.5) / 14))

Thanks Bruce:

Do you think this concept merits sharing with the developers for inclusion in a future version.

Deepak

Hello Bruce:

I am a platinum user. Is it possible to write a PCF to detect the max close as of the day before from 1:00 pm ET (line in sand)  and thereby use it to scan charts in any time frame for the following 3 conditions.

1. Price crossing over the "line in sand" as described above.

2. Price above the "line in sand"

3. Price below the "line in sand"

I see that we can get the max close based on any period and any period ago, but how do we incorporate the time function ?

Thanks for your feedback

Deepak

Thanks a million Bruce..You are the best ..

Deepak

My mistake : Settings are Period: 15 Std Dev 1.5 Average Type: Exponential.  How can we change the PCF to reflect Exponential and/or Front Weighted MA&#39;s

Thanks

Hello Bruce:

Take a look at the following at Sept 10 10:29CT on a 10 minute chart for discrepencies using PCF as suggested in your post Sept 10 9:37:03 am above.

CRUS - Low 42.42 Lower BB 42.33 but showed up in Live Results.

Thanks

Hello Bruce:

Wrote this PCF further to my post Sept 9 3:18:05 pm - Still results not accurate..Please review for Lower Bollinger Band Period 15 and Std Dev 1.5 - Daily on SP-500 watchlist

(O <= AVGC15 - 1.5 * SQR(ABS(C ^ 2 + 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  - 15 * AVGC15 ^ 2) / 15)
OR
L <= AVGC15 - 1.5 * SQR(ABS(C ^ 2 + 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  - 15 * AVGC15 ^ 2) / 15))
AND
C >= AVGC15 - 1.5 * SQR(ABS(C ^ 2 + 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  - 15 * AVGC15 ^ 2) / 15)

Thanks

Further to my post of Sept 09 3:11:13 pm .....

What I am looking for is the close to be above the Bollinger Band Period 15 and StdDev 1.5, while the O or L any one of these two prices to be possibly under the Lower BB , since if the C is within the BB then by default the H will be within the BB as well even in cases where C=H.

Thanks