| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
 Gold Customer
Joined: 11/25/2004
Posts: 79
Location: Illinois
|
I'm trying to come up with a pcf : (a 5dy high of TSV14 8dy sma) TSV14 8dy sma > 4dy MAX TSV14 8dy sma 1day ago.
So far I have : AVG(TSV14,8) > MAX ............
Any suggestions?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
If the TSV is Simple:
AVG(TSV14,8) > AVG(TSV14.1,8) AND AVG(TSV14,8) > AVG(TSV14.2,8) AND AVG(TSV14,8) > AVG(TSV14.3,8) AND AVG(TSV14,8) > AVG(TSV14.4,8)
If the TSV is Exponential:
XAVG(TSV8,14) > XAVG(TSV8.1,14) AND XAVG(TSV8,14) > XAVG(TSV8.2,14) AND XAVG(TSV8,14) > XAVG(TSV8.3,14) AND XAVG(TSV8,14) > XAVG(TSV8.4,14)
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Gold Customer
Joined: 11/25/2004
Posts: 79
Location: Illinois
|
Thanks Bruce - that should do the trick.
Can I assume that there is no MIN or MAX expression since this involves a ma of a ma?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Yes. We can't use the Min or Max functions because they only work on individual Indicators and not formulas or other functions. We could have duplicated the functionality using the technique outlined in Min Max PCFs, but that would have been overkill.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |