| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 12/10/2004
Posts: 25
|
Where do I find the answer to my question yesterday?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please see the answer in PCF Formulas. The Learn how to use the forums: post a new topic, reply, Search existing topics topic has information on tracking the topics in which you have participated.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/10/2004
Posts: 25
|
Bruce L - I have been a Worden user for 14 years and am 83 years old. I have been all through PCF material and I cannot find an answer to my question, which to a guru is elmentary, but not to me. How do I write the formula where TSV 27 was below the 10 day moving average 2 days ago, AND TSV 27 was above the 10 day moving average 5 days ago. I have written the PCF AND it works, but does not get the desired results. Give me the answer and not a reference to Worden material.
Charles Baxter 484752
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
Bruce answered your question where you originally asked it:
PCF Formulas
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I'll repeat my answer here (in case there is a problem following the link to the original topic and response provided in our posts):
If the TSV is Simple and the MA is Simple:
TSV27.2 < AVG(TSV27.2,10) AND TSV27.5 > AVG(TSV27.5,10)
If the TSV is Simple and the MA is Exponential:
TSV27.2 < XAVG(TSV27.2,10) AND TSV27.5 > XAVG(TSV27.5,10)
If the TSV is Exponential and the MA is Simple:
XAVG(TSV1.2,27) < XAVG(TSV10.2,27) AND XAVG(TSV1.5,27) > XAVG(TSV10.5,27)
If the TSV is Exponential and the MA is Exponential:
XAVG(TSV1.2,27) > XAVG(TSV1.2,10) AND XAVG(TSV1.5,27) < XAVG(TSV1.5,10)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |