| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 8/21/2006
Posts: 15
|
I'M CURRENTLY USING A DAILY PCF (AVGC10/AVGC20)*100 AND (AVGC10.3/AVGC20.3)*100 . I NEED A PCF TO TELL ME WHEN A 10 WEEK SMA CROSSES ABOVE A 20 WEEK SMA I GUESS 3 WEEK'S AGO. I ALSO USE VOLUME 90 DAY SET AT MARKET RANK AT 75 ON THE RANGE SELECTOR. WHAT WOULD BE THE PROPER SETTING FOR A WEEKLY SCAN.I WIIL APPRECIATE ANY HELP I CAN GET.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
One way to write a Weekly version of (AVGC10/AVGC20)*100 would be:
200 * (C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45) / (C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95)
One way to write a Weekly version of (AVGC10.3/AVGC20.3)*100 would be:
200 * (C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60) / (C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100 + C105 + C110)
The trainers cannot give settings, interpretation or investment advice, but I'll ask a question. Is there a reason you would want to change your settings for Volume 90 Days?
If you want to detect a crossover between the current week and three weeks ago, you may wish to try the following Boolean Personal Criteria Formula:
SGN(C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 - C50 - C55 - C60 - C65 - C70 - C75 - C80 - C85 - C90 - C95) - SGN(C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 - C65 - C70 - C75 - C80 - C85 - C90 - C95 - C100 - C105 - C110) > 0
If you are interested in crossovers between the current week and the previous week, you may wish to try the following PCF instead:
SGN(C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 - C50 - C55 - C60 - C65 - C70 - C75 - C80 - C85 - C90 - C95) - SGN(C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 - C55 - C60 - C65 - C70 - C75 - C80 - C85 - C90 - C95 - C100) > 0
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Understanding Moving Averages - Part I, The Basics
Understanding Moving Averages - Part II, Using Multiple Averages
Handy PCF example formulas to help you learn the syntax of PCFs!
Personal Criteria Language Function List
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 8/21/2006
Posts: 15
|
I FORGOT TO MENTION I WILL BE USING A WEEKLY CHART TO VIEW THE SCAN DOES THAT CHANGE ANYTHING? THANK'S FOR YOUR TIME AND HELP....
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The formulas given are based on Weekly charts.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |