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 |

Need help writing scan. Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
jonedyer
Posted : Monday, November 29, 2010 11:17:35 PM
Registered User
Joined: 12/10/2004
Posts: 14
Need help writing a scan to find (C-XAVGC20) crossing signal line (XAVGC9). 
  THANK YOU!!    jonedyer
Bruce_L
Posted : Tuesday, November 30, 2010 9:05:38 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
I'm going to assume "signal line (XAVGC9)" means a 9-Period Exponential Moving Average of (C-XAVGC20) and not an EMA9 of Price since otherwise the lines should rarely even be near each other for most symbols. If so, a formula for C - XAVGC20 crossing up through its own 9-Period EMA could be written as:

11 * C + 8 * XAVGC20 > 19 * XAVGC9 AND 11 * C1 + 8 * XAVGC20.1 <= 19 * XAVGC9.1

A formula for C - XAVGC20 crossing down through its own 9-Period EMA could be written as:

11 * C + 8 * XAVGC20 < 19 * XAVGC9 AND 11 * C1 + 8 * XAVGC20.1 >= 19 * XAVGC9.1

And a formula for C - XAVGC20 crossing through its own 9-Period EMA in either direction could be written as:

SGN(11 * C + 8 * XAVGC20 - 19 * XAVGC9) <> SGN(11 * C1 + 8 * XAVGC20.1 - 19 * XAVGC9.1)

How to create a Personal Criteria Forumula (PCF)
Cascades of Moving Averages
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

-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.