Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Gold Customer
Joined: 6/23/2015 Posts: 20
|
Hi Bruce,
Can you please provide a pcf for price above 8 EMA for more than 1 % from the 34 EMA for a minimum of 4 days to max of 9 day period.
Can we also create a second scan such that the above criteria is about 1% below a 50 DMA.
Thanks,
MK
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The first formula is fairly straightforward is TC2000 v18.
ABS(TrueInRow(C > XAVGC8 AND ABS(C / XAVGC34 - 1) > .01, 10) - 6.5) < 3
But a bit more complicated in TC2000 v12.5.
C > XAVGC8 AND ABS(C / XAVGC34 - 1) > .01 AND C1 > XAVGC8.1 AND ABS(C1 / XAVGC34.1 - 1) > .01 AND C2 > XAVGC8.2 AND ABS(C2 / XAVGC34.2 - 1) > .01 AND C3 > XAVGC8.3 AND ABS(C3 / XAVGC34.3 - 1) > .01 AND NOT(C4 > XAVGC8.4 AND ABS(C4 / XAVGC34.4 - 1) > .01 AND C5 > XAVGC8.5 AND ABS(C5 / XAVGC34.5 - 1) > .01 AND C6 > XAVGC8.6 AND ABS(C6 / XAVGC34.6 - 1) > .01 AND C7 > XAVGC8.7 AND ABS(C7 / XAVGC34.7 - 1) > .01 AND C8 > XAVGC8.8 AND ABS(C8 / XAVGC34.8 - 1) > .01 AND C9 > XAVGC8.9 AND ABS(C9 / XAVGC34.9 - 1) > .01)
Adding the criteria of price being at least 1% below the 50 period simple moving average results in the following for TC2000 v18.
ABS(TrueInRow(C > XAVGC8 AND ABS(C / XAVGC34 - 1) > .01 AND C <= .99 * AVGC50, 10) - 6.5) < 3
And the following for TC2000 v12.5.
C > XAVGC8 AND ABS(C / XAVGC34 - 1) > .01 AND C <= .99 * AVGC50 AND C1 > XAVGC8.1 AND ABS(C1 / XAVGC34.1 - 1) > .01 AND C1 <= .99 * AVGC50.1 AND C2 > XAVGC8.2 AND ABS(C2 / XAVGC34.2 - 1) > .01 AND C2 <= .99 * AVGC50.2 AND C3 > XAVGC8.3 AND ABS(C3 / XAVGC34.3 - 1) > .01 AND C3 <= .99 * AVGC50.3 AND NOT(C4 > XAVGC8.4 AND ABS(C4 / XAVGC34.4 - 1) > .01 AND C4 <= .99 * AVGC50.4 AND C5 > XAVGC8.5 AND ABS(C5 / XAVGC34.5 - 1) > .01 AND C5 <= .99 * AVGC50.5 AND C6 > XAVGC8.6 AND ABS(C6 / XAVGC34.6 - 1) > .01 AND C6 <= .99 * AVGC50.6 AND C7 > XAVGC8.7 AND ABS(C7 / XAVGC34.7 - 1) > .01 AND C7 <= .99 * AVGC50.7 AND C8 > XAVGC8.8 AND ABS(C8 / XAVGC34.8 - 1) > .01 AND C8 <= .99 * AVGC50.8 AND C9 > XAVGC8.9 AND ABS(C9 / XAVGC34.9 - 1) > .01 AND C9 <= .99 * AVGC50.9)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Gold Customer
Joined: 6/23/2015 Posts: 20
|
Thanks Bruce. Now with the first formula for price above 8 EMA for more than 1 % from the 34 EMA for a minimum of 4 days to max of 9 day period.can you create a scan with these conditions that it is 1-3% above 50 EMA and the 50 EMA is 1-3 % above 150 EMA.
Not sure if this can be done. Adding a critero of volume 1.4 times MA60 in the past month before price conolidating with the 8 EMA criteria with 34 EMA.
Thanks,
MK
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following.
ABS(TrueInRow(C > 1.01 * XAVGC8 AND ABS(XAVGC8 / XAVGC50 - 1.02) <= .01 AND ABS(XAVGC50 / XAVGC150 - 1.02) <= .01, 10) - 6.5) < 3
I do not know what is being requested in the second paragraph.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Gold Customer
Joined: 6/23/2015 Posts: 20
|
Thanks Bruce. For the above request, what I was looking for is that price is above 8 EMA for more than 1 % from the 34 EMA for a minimum of 4 days to max of 9 day period and this criteria
1.1-3% above 50 EMA and the 50 EMA is 1-3 % above 150 EMA
2. Volume was about 1.4 times average MA60 in any of the past 30 days
Not sure if the second criteria can be written along with the first one.
Regards,
MK
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following condition formula.
ABS(TrueInRow(C > 1.01 * XAVGC8 <= .01, 10) - 6.5) < 3 AND ABS(XAVGC8 / XAVGC50 - 1.02) <= .01 AND ABS(XAVGC50 / XAVGC150 - 1.02) <= .01 AND CountTrue(V >= 1.4 * AVGV60, 30) > 0
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Gold Customer
Joined: 6/23/2015 Posts: 20
|
Thanks Bruce. It generates a formula error when I try to create a new condition.
Regards,
Mk
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I have eliminated a space in the syntax near the end of the formula. Please try the new version (as corrected above).
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Gold Customer
Joined: 6/23/2015 Posts: 20
|
Thanks Bruce. So far it gives me 0 results. Let me work on it and get back to you.
Regards,
Mk
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |