Gold Customer
Joined: 10/7/2004 Posts: 76

dear trainer, I want to know how to write todays Close is lower than yesterdays Low, thank you.


Administration
Joined: 9/30/2004 Posts: 8,803

C < L1


Gold Customer
Joined: 10/7/2004 Posts: 76

dear trainer, Can you check if my formula is correct for the break up or down of 90 days.
C >= MAXH90.1 OR C <= MINL90.1
THANK YOU.


Worden Trainer
Joined: 10/7/2004 Posts: 59,682

Your formula checks for the current price to be at or above the maximum high over the previous ninety bars or the current price to be at or below the minimum low over the previous ninety bars. It should return true if either is true.
Bruce Personal Criteria Formulas TC2000 Support Articles


Gold Customer
Joined: 10/7/2004 Posts: 76

great thank you.


Gold Customer
Joined: 10/7/2004 Posts: 76

hi Bruce, how do I write the pcf for money stream just cross (down) moving average today, thanks


Worden Trainer
Joined: 10/7/2004 Posts: 59,682

It would depend on the period and type of Moving Average. For example, MS crossing down through its own 10Period Simple Moving Average would be:
MS < MS10 AND MS1.1 >= MS10.1
While MS crossing down through its own 20Period Exponential Moving Average would be:
MS < XAVG(MS,20) AND MS1.1 >= XAVG(MS1.1,20)
Dealing with OBV & MS in PCF's  how to interp their "values"
PCF Formula Descriptions
Bruce Personal Criteria Formulas TC2000 Support Articles


Gold Customer
Joined: 10/7/2004 Posts: 76

ok, thanks.


Gold Customer
Joined: 10/7/2004 Posts: 76

Hi Bruce, forgot to ask you about the PSAR, is possible to write pcf for PSAR? like PSAR reversal, AF increase 0.02 Max 0.20, thanks.


Worden Trainer
Joined: 10/7/2004 Posts: 59,682

No, it is not possible to create a Condition Formula for PSAR, but you can click on PSAR and select Create Condition to check for PSAR to cross through price, which would indicate a reversal.
Indicators, Sorting & Scanning
Bruce Personal Criteria Formulas TC2000 Support Articles


Gold Customer
Joined: 10/7/2004 Posts: 76

ok, thank you.


Gold Customer
Joined: 10/7/2004 Posts: 76

hi bruce, I have question on this MS < XAVG(MS,20) AND MS1.1 >= XAVG(MS1.1,20), what is meaning of MS1.1 ? thanks


Worden Trainer
Joined: 10/7/2004 Posts: 59,682

MSy.z > Cumulative MoneyStream
Where y is a the Period of an additional Simple Moving Average.
Where z is the number of Periods Ago.
 z can also be a date. May 3, 2007 would be (single quotes required): '05/03/07'
The arguments in indicators are separated by periods.
So MS1.1 is the 1Period Simple Moving Average of MoneyStream of 1Bar Ago.
Bruce Personal Criteria Formulas TC2000 Support Articles


Gold Customer
Joined: 10/7/2004 Posts: 76

hi bruce, Can you help me on this pcf? I'm trying to write this: last 3 day average volume is 2 time more than last 10 day average volume ( the last 10 day is not include the last 3 day, the last 10 day it should be after the last 3 day) what would be the formula? thanks.


Worden Trainer
Joined: 10/7/2004 Posts: 59,682

Please try the following Condition Formula:
AVGV3 >= 2 * AVGV10.3
Bruce Personal Criteria Formulas TC2000 Support Articles


Gold Customer
Joined: 10/7/2004 Posts: 76

hi, can you help me with this PCF, i want to find a volume 3x on any day in past 90 day. thank you.


Worden Trainer
Joined: 10/7/2004 Posts: 59,682

So volume today is at least 3 times the volume of at least one of the bars in the previous 90 days?
V >= 3 * MINV90.1
Or volume today is more than 3 times the average volume of any bar in the previous 90 days?
V > 3 * AVGV90.1
Or volume today is more than 3 times the volume of every single bar in the previous 90 days?
V > 3 * MAXV90.1
Or something else entirely?
Bruce Personal Criteria Formulas TC2000 Support Articles


Gold Customer
Joined: 10/7/2004 Posts: 76

hi, i have question, can you help me to write this formula?
RSI 14
condition, today RSI is higher than yesterday and below value20
thank you.


Worden Trainer
Joined: 10/7/2004 Posts: 59,682

Well if it is the plain RSI without Wilder's smoothing.
RSI14 > RSI14.1.1 AND RSI14 < 20
If it is a Wilder's smoothed RSI.
C > C1 AND 50 * (C  XAVGC27.1) / 14 / (.071435345 * (ABS(C  C1) + 13 / 14 * (ABS(C1  C2) + 13 / 14 * (ABS(C2  C3) + 13 / 14 * (ABS(C3  C4) + 13 / 14 * (ABS(C4  C5) + 13 / 14 * (ABS(C5  C6) + 13 / 14 * (ABS(C6  C7) + 13 / 14 * (ABS(C7  C8) + 13 / 14 * (ABS(C8  C9) + 13 / 14 * (ABS(C9  C10) + 13 / 14 * (ABS(C10  C11) + 13 / 14 * (ABS(C11  C12) + 13 / 14 * (ABS(C12  C13) + 13 / 14 * (ABS(C13  C14) + 13 / 14 * (ABS(C14  C15) + 13 / 14 * (ABS(C15  C16) + 13 / 14 * (ABS(C16  C17) + 13 / 14 * (ABS(C17  C18) + 13 / 14 * (ABS(C18  C19) + 13 / 14 * (ABS(C19  C20) + 13 / 14 * (ABS(C20  C21) + 13 / 14 * (ABS(C21  C22) + 13 / 14 * (ABS(C22  C23) + 13 / 14 * (ABS(C23  C24) + 13 / 14 * (ABS(C24  C25) + 13 / 14 * (ABS(C25  C26) + 13 / 14 * (ABS(C26  C27) + 13 / 14 * (ABS(C27  C28) + 13 / 14 * (ABS(C28  C29) + 13 / 14 * (ABS(C29  C30) + 13 / 14 * (ABS(C30  C31) + 13 / 14 * (ABS(C31  C32) + 13 / 14 * (ABS(C32  C33) + 13 / 14 * (ABS(C33  C34) + 13 / 14 * (ABS(C34  C35) + 13 / 14 * (ABS(C35  C36) + 13 / 14 * (ABS(C36  C37) + 13 / 14 * (ABS(C37  C38) + 13 / 14 * (ABS(C38  C39) + 13 / 14 * (ABS(C39  C40) + 13 / 14 * (ABS(C40  C41) + 13 / 14 * (ABS(C41  C42) + 13 / 14 * (ABS(C42  C43) + 13 / 14 * (ABS(C43  C44) + 13 / 14 * (ABS(C44  C45) + 13 / 14 * (ABS(C45  C46) + 13 / 14 * (ABS(C46  C47) + 13 / 14 * (ABS(C47  C48) + 13 / 14 * (ABS(C48  C49) + 13 / 14 * (ABS(C49  C50) + 13 / 14 * (ABS(C50  C51) + 13 / 14 * (ABS(C51  C52) + 13 / 14 * (ABS(C52  C53) + 13 / 14 * (ABS(C53  C54) + 13 / 14 * (ABS(C54  C55) + 13 / 14 * (ABS(C55  C56) + 13 / 14 * (ABS(C56  C57) + 13 / 14 * (ABS(C57  C58) + 13 / 14 * (ABS(C58  C59) + 13 / 14 * (ABS(C59  C60) + 13 / 14 * (ABS(C60  C61) + 13 / 14 * (ABS(C61  C62) + 13 / 14 * (ABS(C62  C63) + 13 / 14 * (ABS(C63  C64) + 13 / 14 * (ABS(C64  C65) + 13 / 14 * (ABS(C65  C66) + 13 / 14 * (ABS(C66  C67) + 13 / 14 * (ABS(C67  C68) + 13 / 14 * (ABS(C68  C69) + 13 / 14 * (ABS(C69  C70) + 13 / 14 * (ABS(C70  C71) + 13 / 14 * (ABS(C71  C72) + 13 / 14 * (ABS(C72  C73) + 13 / 14 * (ABS(C73  C74) + 13 / 14 * (ABS(C74  C75) + 13 / 14 * (ABS(C75  C76) + 13 / 14 * (ABS(C76  C77) + 13 / 14 * (ABS(C77  C78) + 13 / 14 * (ABS(C78  C79) + 13 / 14 * (ABS(C79  C80) + 13 / 14 * (ABS(C80  C81) + 13 / 14 * (ABS(C81  C82) + 13 / 14 * (ABS(C82  C83) + 13 / 14 * (ABS(C83  C84) + 13 / 14 * (ABS(C84  C85) + 13 / 14 * (ABS(C85  C86) + 13 / 14 * (ABS(C86  C87) + 13 / 14 * (ABS(C87  C88) + 13 / 14 * (ABS(C88  C89) + 13 / 14 * (ABS(C89  C90) + 13 / 14 * (ABS(C90  C91) + 13 / 14 * (ABS(C91  C92) + 13 / 14 * (ABS(C92  C93) + 13 / 14 * (ABS(C93  C94) + 13 / 14 * (ABS(C94  C95) + 13 / 14 * (ABS(C95  C96) + 13 / 14 * (ABS(C96  C97) + 13 / 14 * (ABS(C97  C98) + 13 / 14 * (ABS(C98  C99) + 13 / 14 * (ABS(C99  C100) + 13 / 14 * (ABS(C100  C101) + 13 / 14 * (ABS(C101  C102) + 13 / 14 * (ABS(C102  C103) + 13 / 14 * (ABS(C103  C104) + 13 / 14 * (ABS(C104  C105) + 13 / 14 * (ABS(C105  C106) + 13 / 14 * (ABS(C106  C107) + 13 / 14 * (ABS(C107  C108) + 13 / 14 * (ABS(C108  C109) + 13 / 14 * (ABS(C109  C110) + 13 / 14 * (ABS(C110  C111) + 13 / 14 * (ABS(C111  C112) + 13 / 14 * (ABS(C112  C113) + 13 / 14 * (ABS(C113  C114) + 13 / 14 * (ABS(C114  C115) + 13 / 14 * (ABS(C115  C116) + 13 / 14 * (ABS(C116  C117) + 13 / 14 * (ABS(C117  C118) + 13 / 14 * (ABS(C118  C119) + 13 / 14 * (ABS(C119  C120) + 13 / 14 * (ABS(C120  C121) + 13 / 14 * (ABS(C121  C122) + 13 / 14 * (ABS(C122  C123) + 13 / 14 * (ABS(C123  C124) + 13 / 14 * (ABS(C124  C125))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 < 20
Bruce Personal Criteria Formulas TC2000 Support Articles


Gold Customer
Joined: 10/7/2004 Posts: 76

hi bruce, can you check see if my formula is correct, I want to write the last 5 trading day low is lower than previous 60 day but the 60 day should compare with after the 5 day. can you make correction for me thank you.
MINL5.5 <= MINL60.60


Worden Trainer
Joined: 10/7/2004 Posts: 59,682

I think you want the following based on your description.
MINL5 < MINL60.5
So that MINL5 is the low of the 5 most recent bars and the MINL60.5 is the lowest low of the 60 bars ending 5 bars ago (so ending the bar before the 5 most recent bars).
Bruce Personal Criteria Formulas TC2000 Support Articles


Gold Customer
Joined: 10/7/2004 Posts: 76

yes. thank you.


Gold Customer
Joined: 10/7/2004 Posts: 76

hi, may I ask how do I write pcf for stochastic that was below oversold 30 day ago? and use Stochastic 21 %7k . thank you.


Worden Trainer
Joined: 10/7/2004 Posts: 59,682

Please try the following Condition Formula.
STOC21.7.30 < 20
Full Stochastic
Bruce Personal Criteria Formulas TC2000 Support Articles


Gold Customer
Joined: 10/7/2004 Posts: 76

thank for your reply bruce.
and how do i write the condition if i want today Stochastic %k move up higher then yesterday %K, i try this STOC21.7 > STOC21.7.1 but doesn't look right when i do the scan, some show lower then yesterday.


Worden Trainer
Joined: 10/7/2004 Posts: 59,682

Your Condition Formula would check for the %K of a simple Stochastic 21, 7 being higher during the current bar than during the previous bar.
What are the exact settings of the stochastic? Is it simple or exponential? Are you interested in the %K or the %D
Bruce Personal Criteria Formulas TC2000 Support Articles


Gold Customer
Joined: 10/7/2004 Posts: 76

is STOC21 %k 7 exponential, just interested in the %K.


Worden Trainer
Joined: 10/7/2004 Posts: 59,682

If the stochastic is exponential, then you would want to use the following for the 20, 7 %K.
XAVG(STOC20, 7)
And the following for the %K moving up.
XAVG(STOC20, 7) > XAVG(STOC20.1.1, 7)
Bruce Personal Criteria Formulas TC2000 Support Articles


Gold Customer
Joined: 10/7/2004 Posts: 76

got it, thank you.


Worden Trainer
Joined: 10/7/2004 Posts: 59,682

You're welcome.
Bruce Personal Criteria Formulas TC2000 Support Articles


Guest1 