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

PCF Formulas Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
kpnicholson
Posted : Wednesday, March 28, 2007 7:50:24 PM
Registered User
Joined: 11/1/2005
Posts: 78
Hello,

After my Easy Scans have completed I sort the files in different ways using the indicators I have on my TC2007 Charts...
I sort by "Value" using the following Indicators, in this Order:
ADX Prd:10;Avg:30 and select all stocks that have a value Greater then or Equal to 29
ATR and Select all stocks that have a value Greater then or Equal to 0.75
RSI Prd:14;Avg:3 and select all stocks that have a value Less then or Equal to 53
BBands: 21,20 and select all stocks that have a value Less then Equal Zero

and I also sometimes sort by:
MACD 8,3,3
MACD 5,34,5
Stochastic 8,3,3

I perform these steps manually... My Question: Is there a way to create a PCF for each of these steps and add them to my Easy Scans... This takes some time to do to in order to get down to my last indicator step... If it is possible... Can you help by providing me the PCF's or point me in the right direction...?

Thank you in advance,
Keith Nicholson
Bruce_L
Posted : Thursday, March 29, 2007 9:02:42 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (kpnicholson)
ADX Prd:10;Avg:30 and select all stocks that have a value Greater then or Equal to 29

This portion is not practical to do as a Personal Criteria Formula or EasyScan and will still need to be done using Indicator Sorting. You may wish to review the following:

PCF for Wilder's Directional Movement DMI-crossovers
PCF for Wilder's DX, and/or a CI for Wilder's ADX

QUOTE (kpnicholson)
ATR and Select all stocks that have a value Greater then or Equal to 0.75

You did not specify a Period for the Average True Range. The following would do this for a 14-Period Wilder's Smoothed Average True Range:

XAVGH27 - XAVGL27 + .0357480060263825 * (ABS(H - C1) + ABS(L - C1) - H + L + 13 / 14 * (ABS(H1 - C2) + ABS(L1 - C2) - H1 + L1 + 13 / 14 * (ABS(H2 - C3) + ABS(L2 - C3) - H2 + L2 + 13 / 14 * (ABS(H3 - C4) + ABS(L3 - C4) - H3 + L3 + 13 / 14 * (ABS(H4 - C5) + ABS(L4 - C5) - H4 + L4 + 13 / 14 * (ABS(H5 - C6) + ABS(L5 - C6) - H5 + L5 + 13 / 14 * (ABS(H6 - C7) + ABS(L6 - C7) - H6 + L6 + 13 / 14 * (ABS(H7 - C8) + ABS(L7 - C8) - H7 + L7 + 13 / 14 * (ABS(H8 - C9) + ABS(L8 - C9) - H8 + L8 + 13 / 14 * (ABS(H9 - C10) + ABS(L9 - C10) - H9 + L9 + 13 / 14 * (ABS(H10 - C11) + ABS(L10 - C11) - H10 + L10 + 13 / 14 * (ABS(H11 - C12) + ABS(L11 - C12) - H11 + L11 + 13 / 14 * (ABS(H12 - C13) + ABS(L12 - C13) - H12 + L12 + 13 / 14 * (ABS(H13 - C14) + ABS(L13 - C14) - H13 + L13 + 13 / 14 * (ABS(H14 - C15) + ABS(L14 - C15) - H14 + L14 + 13 / 14 * (ABS(H15 - C16) + ABS(L15 - C16) - H15 + L15 + 13 / 14 * (ABS(H16 - C17) + ABS(L16 - C17) - H16 + L16 + 13 / 14 * (ABS(H17 - C18) + ABS(L17 - C18) - H17 + L17 + 13 / 14 * (ABS(H18 - C19) + ABS(L18 - C19) - H18 + L18 + 13 / 14 * (ABS(H19 - C20) + ABS(L19 - C20) - H19 + L19 + 13 / 14 * (ABS(H20 - C21) + ABS(L20 - C21) - H20 + L20 + 13 / 14 * (ABS(H21 - C22) + ABS(L21 - C22) - H21 + L21 + 13 / 14 * (ABS(H22 - C23) + ABS(L22 - C23) - H22 + L22 + 13 / 14 * (ABS(H23 - C24) + ABS(L23 - C24) - H23 + L23 + 13 / 14 * (ABS(H24 - C25) + ABS(L24 - C25) - H24 + L24 + 13 / 14 * (ABS(H25 - C26) + ABS(L25 - C26) - H25 + L25 + 13 / 14 * (ABS(H26 - C27) + ABS(L26 - C27) - H26 + L26 + 13 / 14 * (ABS(H27 - C28) + ABS(L27 - C28) - H27 + L27 + 13 / 14 * (ABS(H28 - C29) + ABS(L28 - C29) - H28 + L28 + 13 / 14 * (ABS(H29 - C30) + ABS(L29 - C30) - H29 + L29 + 13 / 14 * (ABS(H30 - C31) + ABS(L30 - C31) - H30 + L30 + 13 / 14 * (ABS(H31 - C32) + ABS(L31 - C32) - H31 + L31 + 13 / 14 * (ABS(H32 - C33) + ABS(L32 - C33) - H32 + L32 + 13 / 14 * (ABS(H33 - C34) + ABS(L33 - C34) - H33 + L33 + 13 / 14 * (ABS(H34 - C35) + ABS(L34 - C35) - H34 + L34 + 13 / 14 * (ABS(H35 - C36) + ABS(L35 - C36) - H35 + L35 + 13 / 14 * (ABS(H36 - C37) + ABS(L36 - C37) - H36 + L36 + 13 / 14 * (ABS(H37 - C38) + ABS(L37 - C38) - H37 + L37 + 13 / 14 * (ABS(H38 - C39) + ABS(L38 - C39) - H38 + L38 + 13 / 14 * (ABS(H39 - C40) + ABS(L39 - C40) - H39 + L39 + 13 / 14 * (ABS(H40 - C41) + ABS(L40 - C41) - H40 + L40 + 13 / 14 * (ABS(H41 - C42) + ABS(L41 - C42) - H41 + L41 + 13 / 14 * (ABS(H42 - C43) + ABS(L42 - C43) - H42 + L42 + 13 / 14 * (ABS(H43 - C44) + ABS(L43 - C44) - H43 + L43 + 13 / 14 * (ABS(H44 - C45) + ABS(L44 - C45) - H44 + L44 + 13 / 14 * (ABS(H45 - C46) + ABS(L45 - C46) - H45 + L45 + 13 / 14 * (ABS(H46 - C47) + ABS(L46 - C47) - H46 + L46 + 13 / 14 * (ABS(H47 - C48) + ABS(L47 - C48) - H47 + L47 + 13 / 14 * (ABS(H48 - C49) + ABS(L48 - C49) - H48 + L48 + 13 / 14 * (ABS(H49 - C50) + ABS(L49 - C50) - H49 + L49 + 13 / 14 * (ABS(H50 - C51) + ABS(L50 - C51) - H50 + L50 + 13 / 14 * (ABS(H51 - C52) + ABS(L51 - C52) - H51 + L51 + 13 / 14 * (ABS(H52 - C53) + ABS(L52 - C53) - H52 + L52 + 13 / 14 * (ABS(H53 - C54) + ABS(L53 - C54) - H53 + L53 + 13 / 14 * (ABS(H54 - C55) + ABS(L54 - C55) - H54 + L54 + 13 / 14 * (ABS(H55 - C56) + ABS(L55 - C56) - H55 + L55 + 13 / 14 * (ABS(H56 - C57) + ABS(L56 - C57) - H56 + L56 + 13 / 14 * (ABS(H57 - C58) + ABS(L57 - C58) - H57 + L57 + 13 / 14 * (ABS(H58 - C59) + ABS(L58 - C59) - H58 + L58 + 13 / 14 * (ABS(H59 - C60) + ABS(L59 - C60) - H59 + L59 + 13 / 14 * (ABS(H60 - C61) + ABS(L60 - C61) - H60 + L60 + 13 / 14 * (ABS(H61 - C62) + ABS(L61 - C62) - H61 + L61 + 13 / 14 * (ABS(H62 - C63) + ABS(L62 - C63) - H62 + L62 + 13 / 14 * (ABS(H63 - C64) + ABS(L63 - C64) - H63 + L63 + 13 / 14 * (ABS(H64 - C65) + ABS(L64 - C65) - H64 + L64 + 13 / 14 * (ABS(H65 - C66) + ABS(L65 - C66) - H65 + L65 + 13 / 14 * (ABS(H66 - C67) + ABS(L66 - C67) - H66 + L66 + 13 / 14 * (ABS(H67 - C68) + ABS(L67 - C68) - H67 + L67 + 13 / 14 * (ABS(H68 - C69) + ABS(L68 - C69) - H68 + L68 + 13 / 14 * (ABS(H69 - C70) + ABS(L69 - C70) - H69 + L69 + 13 / 14 * (ABS(H70 - C71) + ABS(L70 - C71) - H70 + L70 + 13 / 14 * (ABS(H71 - C72) + ABS(L71 - C72) - H71 + L71 + 13 / 14 * (ABS(H72 - C73) + ABS(L72 - C73) - H72 + L72 + 13 / 14 * (ABS(H73 - C74) + ABS(L73 - C74) - H73 + L73 + 13 / 14 * (ABS(H74 - C75) + ABS(L74 - C75) - H74 + L74 + 13 / 14 * (ABS(H75 - C76) + ABS(L75 - C76) - H75 + L75 + 13 / 14 * (ABS(H76 - C77) + ABS(L76 - C77) - H76 + L76 + 13 / 14 * (ABS(H77 - C78) + ABS(L77 - C78) - H77 + L77 + 13 / 14 * (ABS(H78 - C79) + ABS(L78 - C79) - H78 + L78 + 13 / 14 * (ABS(H79 - C80) + ABS(L79 - C80) - H79 + L79 + 13 / 14 * (ABS(H80 - C81) + ABS(L80 - C81) - H80 + L80 + 13 / 14 * (ABS(H81 - C82) + ABS(L81 - C82) - H81 + L81 + 13 / 14 * (ABS(H82 - C83) + ABS(L82 - C83) - H82 + L82 + 13 / 14 * (ABS(H83 - C84) + ABS(L83 - C84) - H83 + L83 + 13 / 14 * (ABS(H84 - C85) + ABS(L84 - C85) - H84 + L84 + 13 / 14 * (ABS(H85 - C86) + ABS(L85 - C86) - H85 + L85 + 13 / 14 * (ABS(H86 - C87) + ABS(L86 - C87) - H86 + L86 + 13 / 14 * (ABS(H87 - C88) + ABS(L87 - C88) - H87 + L87 + 13 / 14 * (ABS(H88 - C89) + ABS(L88 - C89) - H88 + L88 + 13 / 14 * (ABS(H89 - C90) + ABS(L89 - C90) - H89 + L89 + 13 / 14 * (ABS(H90 - C91) + ABS(L90 - C91) - H90 + L90 + 13 / 14 * (ABS(H91 - C92) + ABS(L91 - C92) - H91 + L91 + 13 / 14 * (ABS(H92 - C93) + ABS(L92 - C93) - H92 + L92 + 13 / 14 * (ABS(H93 - C94) + ABS(L93 - C94) - H93 + L93)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) >= .75

You may wish to review the following:

Please provide a description and PCF for calculating an ATR value to be used as a stop loss value

QUOTE (kpnicholson)
RSI Prd:14;Avg:3 and select all stocks that have a value Less then or Equal to 53

You did not specify if the Average Type is Simple or Exponential. I'm going to assume Use Wilders Smoothing is unchecked since the Avg Period is 3.

Simple Smoothing:

RSI14.3 <= 53

Exponential Smoothing:

XAVG(RSI14,3) <= 53

QUOTE (kpnicholson)
BBands: 21,20 and select all stocks that have a value Less then Equal Zero

Please try the following:

C <= AVGC21

You may wish to review the following:

Modelling Bollinger Bands (& Standard Deviation) in a TC PCF

QUOTE (kpnicholson)
MACD 8,3,3
MACD 5,34,5

Please try the following:

Exponential Raw MACD 8,3:

XAVGC8 - XAVGC3

Exponential MACD Trigger 8,3,3:

XAVG(XAVGC8,3) - XAVG(XAVGC3,3)

Exponential MACD Histogram 8,3,3:

XAVGC8 - XAVGC3 - XAVG(XAVGC8,3) + XAVG(XAVGC3,3)

Simple Raw MACD 8,3:

AVGC8 - AVGC3

Simple MACD Trigger 8,3,3:

AVG(AVGC8,3) - AVG(AVGC3,3)

Simple MACD Histogram 8,3,3:

AVGC8 - AVGC3 - AVG(XAVGC8,3) + AVG(XAVGC3,3)

Exponential Raw MACD 5,34:

XAVGC5 - XAVGC34

Exponential MACD Trigger 5,34,5:

XAVG(XAVGC5,5) - XAVG(XAVGC34,5)

Exponential MACD Histogram 5,34,5:

XAVGC5 - XAVGC34 - XAVG(XAVGC5,5) + XAVG(XAVGC34,5)

Simple Raw MACD 5,34:

AVGC5 - AVGC34

Simple MACD Trigger 5,34,5:

AVG(AVGC5,5) - AVG(AVGC34,5)

Simple MACD Histogram 5,34,5:

AVGC5 - AVGC34 - AVG(XAVGC5,5) + AVG(XAVGC34,5)

You may wish to review the following:

Understanding MACD

QUOTE (kpnicholson)
Stochastic 8,3,3

Please try the following:

Simple Stochastic SK 8,3:

STOC8.3

Simple Stochastic SD 8,3,3:

AVG(STOC8.3,3)

Exponential Stochastic SK 8,3:

XAVG(STOC8,3)

Exponential Stochastic SD 8,3,3:

.500488758553275 * (XAVG(STOC8,3) + .5 * (XAVG(STOC8.1.1,3) + .5 * (XAVG(STOC8.1.2,3) + .5 * (XAVG(STOC8.1.3,3) + .5 * (XAVG(STOC8.1.4,3) + .5 * (XAVG(STOC8.1.5,3) + .5 * (XAVG(STOC8.1.6,3) + .5 * (XAVG(STOC8.1.7,3) + .5 * (XAVG(STOC8.1.8,3) + .5 * (XAVG(STOC8.1.9,3)))))))))))

You may wish to review the following:

Understanding Stochastics
Cascades of Moving Averages
How to create a Personal Criteria Forumula (PCF)
Using EasyScan to find stocks that meet your own criteria
Handy PCF example formulas to help you learn the syntax of PCFs!

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
kpnicholson
Posted : Thursday, April 5, 2007 1:09:34 PM
Registered User
Joined: 11/1/2005
Posts: 78
Hi Bruce,

Sorry for taking so long in time to thank you for your help... I am using your PCF's...

I am also reviewing the links you suggest to view...

Thanks,
Keith
Bruce_L
Posted : Thursday, April 5, 2007 1:16:05 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
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.