Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

PCF for Higher high than current price Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
CurtisMaynor
Posted : Sunday, March 31, 2019 4:56:48 PM
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.
CurtisMaynor
Posted : Sunday, March 31, 2019 9:06:15 PM
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.

Bruce_L
Posted : Monday, April 1, 2019 9:39:04 AM


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
CurtisMaynor
Posted : Tuesday, April 2, 2019 2:14:54 PM
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?

Bruce_L
Posted : Tuesday, April 2, 2019 2:35:44 PM


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
CurtisMaynor
Posted : Tuesday, April 2, 2019 8:14:18 PM
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?

Bruce_L
Posted : Wednesday, April 3, 2019 10:28:34 AM


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
CurtisMaynor
Posted : Wednesday, April 3, 2019 2:24:54 PM
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.

 

 

 

Bruce_L
Posted : Wednesday, April 3, 2019 3:03:44 PM


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
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.