Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Formula help please Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
JustJewels
Posted : Tuesday, August 15, 2017 2:01:16 PM
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?

Bruce_L
Posted : Tuesday, August 15, 2017 2:04:22 PM


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
JustJewels
Posted : Tuesday, August 15, 2017 2:07:19 PM
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?

 

Bruce_L
Posted : Tuesday, August 15, 2017 2:13:26 PM


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
JustJewels
Posted : Tuesday, August 15, 2017 2:15:26 PM
Registered User
Joined: 7/8/2008
Posts: 14

Bruce,

Thats perfect! Thanks

Bruce_L
Posted : Tuesday, August 15, 2017 2:17:14 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.