Registered User Joined: 3/13/2015 Posts: 14

Hi Bruce,
What is wrong in this PCF in terms of syntax?
(STOC10 < 80 AND STOC260 < 80) OR (STOC10.1.1 100< 80 AND STOC260.1.1 100< 80) AND L>L1 AND C>H1 AND C>O AND O1>C1 AND AVGV60 >100000
Thanks
PS

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

STOC10 can't be < 80 because stochastics runs from 0 to 100.
So it is either going to be:
STOC10 < 80
Or it is going to be:
STOC10  100 < 80
I suspect you want to subtract 100 because I suspect you are interested in Williams %R and not stochastics or you wouldn't have the 100 in the next section.
I also suspect you want an extra set of parantheses around all of the stochastics tests (although this is not strictly necessary since OR should calculate before AND).
So maybe something like the following?
((STOC10 < 20 AND STOC260 < 20) OR (STOC10.1.1 < 20 AND STOC260.1.1 < 20)) AND L > L1 AND C > H1 AND C > O AND O1 > C1 AND AVGV60 > 100000
Bruce Personal Criteria Formulas TC2000 Support Articles

Registered User Joined: 3/13/2015 Posts: 14

Thanks Bruce! Initially I have found that PCF while watching one of the videos. Below is the screenshot I have captured from that video
http://tinypic.com/usermedia.php?uo=jJm7XUcEEIwhOX7lo7lAsIh4l5k2TGxc

Registered User Joined: 3/13/2015 Posts: 14

Yes, I am interested in both Williams %R 10 and Williams %R 260 should be below 80

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

Do you know which video it is?
The formula given should test for Williams %R being below 80. The reason this works is that:
STOC10  100 < 80
Is the same thing as:
STOC10 < 20
Because you can just add 100 to both sides of the first formula to get the second formula.
Bruce Personal Criteria Formulas TC2000 Support Articles
