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))
The other PCF created as a condition (formula) is for a hammer candlestick pattern as follows:
(H-C)<=(H-L)/3 AND (H-O)<=(H-L)/3
As of close on April 5th , a scan on a 4 hour chart using both the above conditions against the S&P500 list displays the following 5 symbols
MDT,FIS,APH,VRSN & APPL
APH & VRSN appear correctly on the 4 hour chart .
MDT,FIS, AAPL are all incorrect see data below (based on 4 hour chart)
MDT Low 38.85 Lower BB 38.83 - Violates L to be lower than Lower BB
FIS Low 38.85 Lower BB 38.83 - Violates L to be Lower than Lower BB
AAPL Low 419.68 Lower BB 417.93 - Violates L to be lower than lower BB
Are my PCF's written correctly ? Any help debugging will be appreciated.
Thanks so much
Deepak
|
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'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
|