Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 9/28/2018 Posts: 5
|
I need a formula to scan through a combo list that would be able to find charts with the past three bars at the same level or higher than the highest bar 10 to 21 bars previously and ignore the price comparison of bars 2-9.
ultimately, I want to know if the current or past two two bars are at a higher level than any bar 10 to 21 bars from the current price.
|
|
Registered User Joined: 9/28/2018 Posts: 5
|
Correction to the last sentence.
ultimately, I want to know if the current or past two two bars are at a higher level than the highest bar 10 to 21 bars from the current price.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following condition formula.
MAXH3 > MAAXH12.10
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 9/28/2018 Posts: 5
|
Thanks Bruce. Does the "12.10" mean the max high 12 bars previously from the 10th bar is the area that it is scanning?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
It is the highest high of the 12 bars ending 10 bars ago (so bars 10 through 21 bars ago).
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 9/28/2018 Posts: 5
|
Can you create another formula that would show results of 3 consecutive days of the price going down anytime between bars 4 and 21?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I am not sure I understand the question.
So there needs to be at least one bar between 4 and 21 bars ago that goes down? That is going to be really, really common.
CountTrue(C4 < C5, 18) > 0
Even when you need this to be true for 3 bars in a row.
TrueInRow(CountTrue(C4 < C5. 18) > 0, 3) = 3
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 9/28/2018 Posts: 5
|
Since that is such a common occurance it might be better to have 3 consecutive days of the price going down (anytime between 4 and 21 bars) but with each bar having a lower low and lower high. sorry for being such a pain.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Now that does seem like it would be a bit less likely.
I am going to actually give you two possibilities. The first is that the three bars end within the range of 4 through 21 bars ago.
CountTrue(TrueInRow(H4 < H5 AND L4 < L5 AND C4 < C5, 3) = 3, 18) > 0
And the other is that those three bars must actually be part of the range of 4 through 21 bars ago.
CountTrue(TrueInRow(H4 < H5 AND L4 < L5 AND C4 < C5, 3) = 3, 16) > 0
Note this second version only checks 16 bars instead of 18 bars because the oldest 3 bar span would run from 19 through 21 bars ago instead of from 21 through 23 bars ago as in the first version.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |