Registered User Joined: 4/20/2013 Posts: 13
|
Hello, I would like to know if it is possible to create a scan that would display Expotential Moving Averages (EMA's) merging, intersecting or at least grouping together. The idea comes from the Guppy Trader technique.
The first set of EMA's could be 5, 10, 20 for the shorter time period.
The second set of EMA's could be 30, 40, 50 for the longer time period.
Thank you for any help offered and I hope my question is not too ambiguous.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You can check to see if the first 3 moving averages are all within 1% of each other using something like:
XAVGC10 <= 1.01 * XAVGC5 AND XAVGC20 <= 1.01 * XAVGC5 AND XAVGC5 <= 1.01 * XAVGC10 AND XAVGC20 <= 1.01 * XAVGC10 AND XAVGC5 <= 1.01 * XAVGC20 AND XAVGC20 <= 1.01 * XAVGC20
You can check to see if the last 3 moving averages are all within 1% of each other using something like:
XAVGC40 <= 1.01 * XAVGC30 AND XAVGC50 <= 1.01 * XAVGC30 AND XAVGC30 <= 1.01 * XAVGC40 AND XAVGC50 <= 1.01 * XAVGC40 AND XAVGC30 <= 1.01 * XAVGC50 AND XAVGC50 <= 1.01 * XAVGC50
You can check to see if all 6 moving averages are within 1% of each other using something like:
XAVGC5 <= 1.01 * XAVGC10 AND XAVGC5 <= 1.01 * XAVGC20 AND XAVGC5 <= 1.01 * XAVGC30 AND XAVGC5 <= 1.01 * XAVGC40 AND XAVGC5 <= 1.01 * XAVGC50 AND XAVGC10 <= 1.01 * XAVGC5 AND XAVGC10 <= 1.01 * XAVGC20 AND XAVGC10 <= 1.01 * XAVGC30 AND XAVGC10 <= 1.01 * XAVGC40 AND XAVGC10 <= 1.01 * XAVGC50 AND XAVGC20 <= 1.01 * XAVGC5 AND XAVGC20 <= 1.01 * XAVGC10 AND XAVGC20 <= 1.01 * XAVGC30 AND XAVGC20 <= 1.01 * XAVGC40 AND XAVGC20 <= 1.01 * XAVGC50 AND XAVGC30 <= 1.01 * XAVGC5 AND XAVGC30 <= 1.01 * XAVGC10 AND XAVGC30 <= 1.01 * XAVGC20 AND XAVGC30 <= 1.01 * XAVGC40 AND XAVGC30 <= 1.01 * XAVGC50 AND XAVGC40 <= 1.01 * XAVGC5 AND XAVGC40 <= 1.01 * XAVGC10 AND XAVGC40 <= 1.01 * XAVGC20 AND XAVGC40 <= 1.01 * XAVGC30 AND XAVGC40 <= 1.01 * XAVGC50 AND XAVGC50 <= 1.01 * XAVGC5 AND XAVGC50 <= 1.01 * XAVGC10 AND XAVGC50 <= 1.01 * XAVGC20 AND XAVGC50 <= 1.01 * XAVGC30 AND XAVGC50 <= 1.01 * XAVGC40
The <= 1.01 * parts in the formulas are what checks for 1% and can be changed. For example 2% would be <= 1.02 * and 1/2% would use <= 1.005 * at each location.
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 4/20/2013 Posts: 13
|
Thank you Bruce!
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|