| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 9/18/2006
Posts: 1
|
Looking to create PCFs for the following:
MACD (12,26,9) that is above the centerline
RSI 14 that is between 50 and 70
Thank you.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following:
XAVGC12 - XAVGC26 - XAVG(XAVGC12,9) + XAVG(XAVGC26,9) > 0 AND ABS(100 * ((C > C1) * (C1 - C) + 13 / 14 * ((C1 > C2) * (C2 - C1) + 13 / 14 * ((C2 > C3) * (C3 - C2) + 13 / 14 * ((C3 > C4) * (C4 - C3) + 13 / 14 * ((C4 > C5) * (C5 - C4) + 13 / 14 * ((C5 > C6) * (C6 - C5) + 13 / 14 * ((C6 > C7) * (C7 - C6) + 13 / 14 * ((C7 > C8) * (C8 - C7) + 13 / 14 * ((C8 > C9) * (C9 - C8) + 13 / 14 * ((C9 > C10) * (C10 - C9) + 13 / 14 * ((C10 > C11) * (C11 - C10) + 13 / 14 * ((C11 > C12) * (C12 - C11) + 13 / 14 * ((C12 > C13) * (C13 - C12) + 13 / 14 * ((C13 > C14) * (C14 - C13) + 13 / 14 * ((C14 > C15) * (C15 - C14) + 13 / 14 * ((C15 > C16) * (C16 - C15) + 13 / 14 * ((C16 > C17) * (C17 - C16) + 13 / 14 * ((C17 > C18) * (C18 - C17) + 13 / 14 * ((C18 > C19) * (C19 - C18) + 13 / 14 * ((C19 > C20) * (C20 - C19) + 13 / 14 * ((C20 > C21) * (C21 - C20) + 13 / 14 * ((C21 > C22) * (C22 - C21) + 13 / 14 * ((C22 > C23) * (C23 - C22) + 13 / 14 * ((C23 > C24) * (C24 - C23) + 13 / 14 * ((C24 > C25) * (C25 - C24) + 13 / 14 * ((C25 > C26) * (C26 - C25) + 13 / 14 * ((C26 > C27) * (C27 - C26) + 13 / 14 * ((C27 > C28) * (C28 - C27) + 13 / 14 * ((C28 > C29) * (C29 - C28) + 13 / 14 * ((C29 > C30) * (C30 - C29) + 13 / 14 * ((C30 > C31) * (C31 - C30) + 13 / 14 * ((C31 > C32) * (C32 - C31) + 13 / 14 * ((C32 > C33) * (C33 - C32) + 13 / 14 * ((C33 > C34) * (C34 - C33) + 13 / 14 * ((C34 > C35) * (C35 - C34) + 13 / 14 * ((C35 > C36) * (C36 - C35) + 13 / 14 * ((C36 > C37) * (C37 - C36) + 13 / 14 * ((C37 > C38) * (C38 - C37) + 13 / 14 * ((C38 > C39) * (C39 - C38) + 13 / 14 * ((C39 > C40) * (C40 - C39) + 13 / 14 * ((C40 > C41) * (C41 - C40) + 13 / 14 * ((C41 > C42) * (C42 - C41) + 13 / 14 * ((C42 > C43) * (C43 - C42) + 13 / 14 * ((C43 > C44) * (C44 - C43) + 13 / 14 * ((C44 > C45) * (C45 - C44) + 13 / 14 * ((C45 > C46) * (C46 - C45) + 13 / 14 * ((C46 > C47) * (C47 - C46) + 13 / 14 * ((C47 > C48) * (C48 - C47) + 13 / 14 * ((C48 > C49) * (C49 - C48) + 13 / 14 * ((C49 > C50) * (C50 - C49) + 13 / 14 * ((C50 > C51) * (C51 - C50) + 13 / 14 * ((C51 > C52) * (C52 - C51) + 13 / 14 * ((C52 > C53) * (C53 - C52) + 13 / 14 * ((C53 > C54) * (C54 - C53) + 13 / 14 * ((C54 > C55) * (C55 - C54) + 13 / 14 * ((C55 > C56) * (C56 - C55) + 13 / 14 * ((C56 > C57) * (C57 - C56) + 13 / 14 * ((C57 > C58) * (C58 - C57) + 13 / 14 * ((C58 > C59) * (C59 - C58) + 13 / 14 * ((C59 > C60) * (C60 - C59) + 13 / 14 * ((C60 > C61) * (C61 - C60) + 13 / 14 * ((C61 > C62) * (C62 - C61) + 13 / 14 * ((C62 > C63) * (C63 - C62) + 13 / 14 * ((C63 > C64) * (C64 - C63) + 13 / 14 * ((C64 > C65) * (C65 - C64) + 13 / 14 * ((C65 > C66) * (C66 - C65) + 13 / 14 * ((C66 > C67) * (C67 - C66) + 13 / 14 * ((C67 > C68) * (C68 - C67) + 13 / 14 * ((C68 > C69) * (C69 - C68) + 13 / 14 * ((C69 > C70) * (C70 - C69) + 13 / 14 * ((C70 > C71) * (C71 - C70) + 13 / 14 * ((C71 > C72) * (C72 - C71) + 13 / 14 * ((C72 > C73) * (C73 - C72) + 13 / 14 * ((C73 > C74) * (C74 - C73) + 13 / 14 * ((C74 > C75) * (C75 - C74) + 13 / 14 * ((C75 > C76) * (C76 - C75) + 13 / 14 * ((C76 > C77) * (C77 - C76) + 13 / 14 * ((C77 > C78) * (C78 - C77) + 13 / 14 * ((C78 > C79) * (C79 - C78) + 13 / 14 * ((C79 > C80) * (C80 - C79) + 13 / 14 * ((C80 > C81) * (C81 - C80) + 13 / 14 * ((C81 > C82) * (C82 - C81) + 13 / 14 * ((C82 > C83) * (C83 - C82) + 13 / 14 * ((C83 > C84) * (C84 - C83) + 13 / 14 * ((C84 > C85) * (C85 - C84) + 13 / 14 * ((C85 > C86) * (C86 - C85) + 13 / 14 * ((C86 > C87) * (C87 - C86) + 13 / 14 * ((C87 > C88) * (C88 - C87) + 13 / 14 * ((C88 > C89) * (C89 - C88) + 13 / 14 * ((C89 > C90) * (C90 - C89) + 13 / 14 * ((C90 > C91) * (C91 - C90) + 13 / 14 * ((C91 > C92) * (C92 - C91) + 13 / 14 * ((C92 > C93) * (C93 - C92) + 13 / 14 * ((C93 > C94) * (C94 - C93) + 13 / 14 * ((C94 > C95) * (C95 - C94) + 13 / 14 * ((C95 > C96) * (C96 - C95) + 13 / 14 * ((C96 > C97) * (C97 - C96) + 13 / 14 * ((C97 > C98) * (C98 - C97) + 13 / 14 * ((C98 > C99) * (C99 - C98) + 13 / 14 * ((C99 > C100) * (C100 - C99) + 13 / 14 * ((C100 > C101) * (C101 - C100) + 13 / 14 * ((C101 > C102) * (C102 - C101) + 13 / 14 * ((C102 > C103) * (C103 - C102) + 13 / 14 * ((C103 > C104) * (C104 - C103) + 13 / 14 * ((C104 > C105) * (C105 - C104) + 13 / 14 * ((C105 > C106) * (C106 - C105) + 13 / 14 * ((C106 > C107) * (C107 - C106) + 13 / 14 * ((C107 > C108) * (C108 - C107) + 13 / 14 * ((C108 > C109) * (C109 - C108) + 13 / 14 * ((C109 > C110) * (C110 - C109) + 13 / 14 * ((C110 > C111) * (C111 - C110) + 13 / 14 * ((C111 > C112) * (C112 - C111) + 13 / 14 * ((C112 > C113) * (C113 - C112) + 13 / 14 * ((C113 > C114) * (C114 - C113) + 13 / 14 * ((C114 > C115) * (C115 - C114) + 13 / 14 * ((C115 > C116) * (C116 - C115) + 13 / 14 * ((C116 > C117) * (C117 - C116) + 13 / 14 * ((C117 > C118) * (C118 - C117) + 13 / 14 * ((C118 > C119) * (C119 - C118) + 13 / 14 * ((C119 > C120) * (C120 - C119) + 13 / 14 * ((C120 > C121) * (C121 - C120) + 13 / 14 * ((C121 > C122) * (C122 - C121) + 13 / 14 * ((C122 > C123) * (C123 - C122) + 13 / 14 * ((C123 > C124) * (C124 - C123) + 13 / 14 * ((C124 > C125) * (C125 - C124)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (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)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - 60) <= 10
The above will only work if you have the following settings:
MACD Settings:
- Short: 12
- Long: 26
- Period: 9
- Average Type: Exponential
- Plot MACD as Histogram: Checked
Wilder's RSI Settings:
- RSI Period: 14
- Use Wilders Smoothing: Checked
- Avg Period: 1
- Average Type: Doesn't matter (because the Avg Period is 1)
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Understanding MACD
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 11/8/2004
Posts: 6
|
Bruce,
Thank you, that worked.
Gary
|
|
Registered User
Joined: 9/1/2012
Posts: 4
|
Need a pcf for rsi(14) between 20 and 30
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
If it is the plain RSI indicator which is not Wilder's smoothed:
20 <= RSI14 AND RSI14 <= 30
Or the slight shorter:
ABS(25 - RSI14) <= 5
If it is the RSI - Wilder's indicator which is Wilder's smoothed (this is based on the second of the two formulas above):
ABS(25 - (50 * (C - XAVGC27.1) / 14 / (.07143535 * (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)) <= 5
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |