Registered User Joined: 10/7/2004 Posts: 87
|
dear trainer, I want to know how to write todays Close is lower than yesterdays Low, thank you.
|
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
C < L1
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
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: 65,138
|
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
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
great thank you.
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
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: 65,138
|
It would depend on the period and type of Moving Average. For example, MS crossing down through its own 10-Period Simple Moving Average would be:
MS < MS10 AND MS1.1 >= MS10.1
While MS crossing down through its own 20-Period 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
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
ok, thanks.
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
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: 65,138
|
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
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
ok, thank you.
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
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: 65,138
|
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 1-Period Simple Moving Average of MoneyStream of 1-Bar Ago.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
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: 65,138
|
Please try the following Condition Formula:
AVGV3 >= 2 * AVGV10.3
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
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: 65,138
|
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
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
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: 65,138
|
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
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
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: 65,138
|
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
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
yes. thank you.
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
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: 65,138
|
Please try the following Condition Formula.
STOC21.7.30 < 20
Full Stochastic
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
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: 65,138
|
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
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
is STOC21 %k 7 exponential, just interested in the %K.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
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
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
got it, thank you.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |