Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Scan for multiple moving averages modeled after the Guppy method Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Kneissl
Posted : Wednesday, April 2, 2014 10:17:48 PM
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. 

Bruce_L
Posted : Thursday, April 3, 2014 1:33:47 PM


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
Kneissl
Posted : Thursday, April 3, 2014 2:33:47 PM
Registered User
Joined: 4/20/2013
Posts: 13

Thank you Bruce!

Bruce_L
Posted : Thursday, April 3, 2014 3:24:41 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.