Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 7/8/2008 Posts: 14
|
I guess I'm trying to figure out if I can use the max function with the ppo?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
There really isn't a good way to use the MAX() function with PPO in version 12 (and it isn't possible at all unless the MAX and PPO periods are both fairly short), but it is fairly straightforward in TC2000 v17.
MAX(100 * (XAVGC12 / XAVGC26 - 1), 10)
Or the slightly more efficient:
100 * (MAX(XAVGC12 / XAVGC26, 10) - 1)
Would both return the high exponential PPO 12,26 over the most recent 10 bars.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 7/8/2008 Posts: 14
|
Thanks Bruce,
Is there a way to do a boolean formula for the max ppo below the zero line for x number of periods?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Well the number of periods in the above (and below) formulas written for TC2000 v17 is 10.
MAX(100 * (XAVGC12 / XAVGC26 - 1), 10) < 0
Or:
100 * (MAX(XAVGC12 / XAVGC26, 10) - 1) < 0
Or:
TrueInRow(XAVGC12 < XAVGC26, 10) = 10
Or (this version will work in earlier versions of TC2000):
XAVGC12 < XAVGC26 AND XAVGC12.1 < XAVGC26.1 AND XAVGC122. < XAVGC26.2 AND XAVGC12.3 < XAVGC26.3 AND XAVGC12.4 < XAVGC26.4 AND XAVGC12.5 < XAVGC26.5 AND XAVGC12.6 < XAVGC26.6 AND XAVGC12.7 < XAVGC26.7 AND XAVGC12.8 < XAVGC26.8 AND XAVGC12.9 < XAVGC26.9
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 7/8/2008 Posts: 14
|
Bruce,
Thats perfect! Thanks
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |