Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 8/25/2006 Posts: 12
|
Hi, Is there any way to write a PCF to the following:
10 bar daily MA > 30 bar daily MA AND 10 bar weekly MA > 30 bar weekly MA
Thanks, Siya
|
|
Registered User Joined: 10/23/2004 Posts: 251
|
Try This: i will assume you are using a SIMPLE MA
1)10 bar daily MA > 30 bar daily MA
AVGC10 > AVGC30
2)10 bar weekly MA > 30 bar weekly MA
(C0 + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45) / 10 > (C0 + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100 + C105 + C110 + C115 + C120 + C125 + C130 + C135 + C140 + C145) / 30
Thanks Naresh
|
|
Registered User Joined: 8/25/2006 Posts: 12
|
Thanks, Naresh !! It works but a bit slow.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The second Personal Criteria Formula can be shortened somewhat to:
C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 > (C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100 + C105 + C110 + C115 + C120 + C125 + C130 + C135 + C140 + C145) / 2
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |