Registered User Joined: 9/16/2012 Posts: 8
|
Dear Bruce,
Could you please provide to me a formula for the following conditions:
1. close price above 5$
2. average volume(21 days) > 1000000
3. Rsi(2) < 5 two days ago
4. Rsi(2) < 5 one day ago
5. the stock opens today below yesterday's low (gap down)
and
1. close price above 5$
2. average volume (21 days) > 1000000
3. Rsi (2) >95 two days ago
4. Rsi(2)>95 one day ago
5. the stock opens today above yesterday's high (gap up)
many thanks for your help
diamantis
|

 Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The first formula could be written as:
C > 5 AND AVGV21 > 1000000 AND 50 * (C2 - XAVGC3.3) / 2 / (.500030519440884 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14) + .5 * (ABS(C14 - C15) + .5 * (ABS(C15 - C16)))))))))))))))) + 50 < 5 AND 50 * (C1 - XAVGC3.2) / 2 / (.500030519440884 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14) + .5 * (ABS(C14 - C15)))))))))))))))) + 50 < 5 AND O < L1
And the second formula could be written as:
C > 5 AND AVGV21 > 1000000 AND 50 * (C2 - XAVGC3.3) / 2 / (.500030519440884 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14) + .5 * (ABS(C14 - C15) + .5 * (ABS(C15 - C16)))))))))))))))) + 50 > 95 AND 50 * (C1 - XAVGC3.2) / 2 / (.500030519440884 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14) + .5 * (ABS(C14 - C15)))))))))))))))) + 50 > 95 AND O > H1
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
Cascades of Moving Averages
-Bruce Personal Criteria Formulas TC2000 Support Articles
|