New version 17 available now


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


New account application Trading resources
Margin rates Stock & option commissions

Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

pcf help Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
rchen
Posted : Thursday, July 28, 2011 4:36:24 PM
Gold Customer 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.
StockGuy
Posted : Thursday, July 28, 2011 4:37:43 PM

Administration

Joined: 9/30/2004
Posts: 8,797
C < L1
rchen
Posted : Tuesday, August 02, 2011 10:43:48 AM
Gold Customer 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.

Bruce_L
Posted : Tuesday, August 02, 2011 10:49:31 AM


Worden Trainer

Joined: 10/7/2004
Posts: 59,601
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
rchen
Posted : Tuesday, August 02, 2011 10:52:25 AM
Gold Customer Gold Customer

Joined: 10/7/2004
Posts: 76
great thank you.
rchen
Posted : Thursday, December 15, 2011 3:41:45 PM
Gold Customer 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

Bruce_L
Posted : Thursday, December 15, 2011 3:53:02 PM


Worden Trainer

Joined: 10/7/2004
Posts: 59,601
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
rchen
Posted : Thursday, December 15, 2011 4:05:17 PM
Gold Customer Gold Customer

Joined: 10/7/2004
Posts: 76

ok, thanks.

rchen
Posted : Thursday, December 15, 2011 4:49:51 PM
Gold Customer 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.
Bruce_L
Posted : Thursday, December 15, 2011 4:54:44 PM


Worden Trainer

Joined: 10/7/2004
Posts: 59,601
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
rchen
Posted : Thursday, December 15, 2011 5:00:47 PM
Gold Customer Gold Customer

Joined: 10/7/2004
Posts: 76

ok, thank you.

rchen
Posted : Wednesday, December 28, 2011 11:49:28 AM
Gold Customer 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
Bruce_L
Posted : Thursday, December 29, 2011 9:13:20 AM


Worden Trainer

Joined: 10/7/2004
Posts: 59,601
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
rchen
Posted : Thursday, November 21, 2013 6:24:39 PM
Gold Customer 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.

Bruce_L
Posted : Friday, November 22, 2013 9:04:58 AM


Worden Trainer

Joined: 10/7/2004
Posts: 59,601

Please try the following Condition Formula:

AVGV3 >= 2 * AVGV10.3



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
rchen
Posted : Thursday, September 22, 2016 6:39:57 PM
Gold Customer 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.

Bruce_L
Posted : Friday, September 23, 2016 9:37:31 AM


Worden Trainer

Joined: 10/7/2004
Posts: 59,601

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
rchen
Posted : Thursday, January 05, 2017 10:16:58 AM
Gold Customer 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.

Bruce_L
Posted : Thursday, January 05, 2017 10:19:59 AM


Worden Trainer

Joined: 10/7/2004
Posts: 59,601

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
rchen
Posted : Tuesday, January 17, 2017 1:18:24 PM
Gold Customer 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

Bruce_L
Posted : Tuesday, January 17, 2017 1:25:35 PM


Worden Trainer

Joined: 10/7/2004
Posts: 59,601

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
rchen
Posted : Tuesday, January 17, 2017 1:28:01 PM
Gold Customer Gold Customer

Joined: 10/7/2004
Posts: 76

yes. thank you.

rchen
Posted : Sunday, March 19, 2017 2:53:30 PM
Gold Customer 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.

Bruce_L
Posted : Monday, March 20, 2017 11:13:59 AM


Worden Trainer

Joined: 10/7/2004
Posts: 59,601

Please try the following Condition Formula.

STOC21.7.30 < 20

Full Stochastic



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
rchen
Posted : Friday, March 31, 2017 2:39:47 PM
Gold Customer 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. 

Bruce_L
Posted : Friday, March 31, 2017 2:49:35 PM


Worden Trainer

Joined: 10/7/2004
Posts: 59,601

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
rchen
Posted : Friday, March 31, 2017 2:59:34 PM
Gold Customer Gold Customer

Joined: 10/7/2004
Posts: 76

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

Bruce_L
Posted : Friday, March 31, 2017 3:22:50 PM


Worden Trainer

Joined: 10/7/2004
Posts: 59,601

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
rchen
Posted : Friday, March 31, 2017 3:30:31 PM
Gold Customer Gold Customer

Joined: 10/7/2004
Posts: 76

got it, thank you.

Bruce_L
Posted : Friday, March 31, 2017 3:37:14 PM


Worden Trainer

Joined: 10/7/2004
Posts: 59,601

You're welcome.



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