Registered User
Joined: 5/8/2005
Posts: 36
|
Hi,
Need a PCF to scan for stocks where price is within 3% of Weighted Moving Avg Weekly 30 Period.
Thank You.
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following Condition Formula with the Time Frame of the Condition Formula set to Weekly:
ABS(C / ((30 * C + 29 * C1 + 28 * C2 + 27 * C3 + 26 * C4 + 25 * C5 + 24 * C6 + 23 * C7 + 22 * C8 + 21 * C9 + 20 * C10 + 19 * C11 + 18 * C12 + 17 * C13 + 16 * C14 + 15 * C15 + 14 * C16 + 13 * C17 + 12 * C18 + 11 * C19 + 10 * C20 + 9 * C21 + 8 * C22 + 7 * C23 + 6 * C24 + 5 * C25 + 4 * C26 + 3 * C27 + 2 * C28 + C29) / 465) - 1) <= .03
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|