Registered User Joined: 9/7/2017 Posts: 1
|
Hi,
Sorry i am new to TC 2000, I am trying to create a formula to track trend using pivot points.
(C+H+L)/3 for this week should be greater than last and week before that
Similarly
(C+H+L)/3 for this week should be greater than monthly
Can someone please help. Thanks in advance.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Just greater than the previous week would be the following.
C + H + L > C1 + H1 + L1
Checking this for at least two bars in a row would be the following.
TrueInRow(C + H + L > C1 + H1 + L1, 2) = 2
Checking for the current bar to be greater than the previous 2 bars would be the following.
C + H + L > GREATEST(C1 + H1 + L1, C2 + H2 + L2)
You can change the time frame of the formula to check for weeks or months as desired. It is not possible to mix time frames in order to compare calendar weeks to calendar months.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|