Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 3/8/2005 Posts: 8
|
Does any one have a PCF for Wilders RSI13 using Wilders smoothing?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following:
50 * (C - XAVGC25.1) / 13 / (.0769302168313179 * (ABS(C - C1) + 12 / 13 * (ABS(C1 - C2) + 12 / 13 * (ABS(C2 - C3) + 12 / 13 * (ABS(C3 - C4) + 12 / 13 * (ABS(C4 - C5) + 12 / 13 * (ABS(C5 - C6) + 12 / 13 * (ABS(C6 - C7) + 12 / 13 * (ABS(C7 - C8) + 12 / 13 * (ABS(C8 - C9) + 12 / 13 * (ABS(C9 - C10) + 12 / 13 * (ABS(C10 - C11) + 12 / 13 * (ABS(C11 - C12) + 12 / 13 * (ABS(C12 - C13) + 12 / 13 * (ABS(C13 - C14) + 12 / 13 * (ABS(C14 - C15) + 12 / 13 * (ABS(C15 - C16) + 12 / 13 * (ABS(C16 - C17) + 12 / 13 * (ABS(C17 - C18) + 12 / 13 * (ABS(C18 - C19) + 12 / 13 * (ABS(C19 - C20) + 12 / 13 * (ABS(C20 - C21) + 12 / 13 * (ABS(C21 - C22) + 12 / 13 * (ABS(C22 - C23) + 12 / 13 * (ABS(C23 - C24) + 12 / 13 * (ABS(C24 - C25) + 12 / 13 * (ABS(C25 - C26) + 12 / 13 * (ABS(C26 - C27) + 12 / 13 * (ABS(C27 - C28) + 12 / 13 * (ABS(C28 - C29) + 12 / 13 * (ABS(C29 - C30) + 12 / 13 * (ABS(C30 - C31) + 12 / 13 * (ABS(C31 - C32) + 12 / 13 * (ABS(C32 - C33) + 12 / 13 * (ABS(C33 - C34) + 12 / 13 * (ABS(C34 - C35) + 12 / 13 * (ABS(C35 - C36) + 12 / 13 * (ABS(C36 - C37) + 12 / 13 * (ABS(C37 - C38) + 12 / 13 * (ABS(C38 - C39) + 12 / 13 * (ABS(C39 - C40) + 12 / 13 * (ABS(C40 - C41) + 12 / 13 * (ABS(C41 - C42) + 12 / 13 * (ABS(C42 - C43) + 12 / 13 * (ABS(C43 - C44) + 12 / 13 * (ABS(C44 - C45) + 12 / 13 * (ABS(C45 - C46) + 12 / 13 * (ABS(C46 - C47) + 12 / 13 * (ABS(C47 - C48) + 12 / 13 * (ABS(C48 - C49) + 12 / 13 * (ABS(C49 - C50) + 12 / 13 * (ABS(C50 - C51) + 12 / 13 * (ABS(C51 - C52) + 12 / 13 * (ABS(C52 - C53) + 12 / 13 * (ABS(C53 - C54) + 12 / 13 * (ABS(C54 - C55) + 12 / 13 * (ABS(C55 - C56) + 12 / 13 * (ABS(C56 - C57) + 12 / 13 * (ABS(C57 - C58) + 12 / 13 * (ABS(C58 - C59) + 12 / 13 * (ABS(C59 - C60) + 12 / 13 * (ABS(C60 - C61) + 12 / 13 * (ABS(C61 - C62) + 12 / 13 * (ABS(C62 - C63) + 12 / 13 * (ABS(C63 - C64) + 12 / 13 * (ABS(C64 - C65) + 12 / 13 * (ABS(C65 - C66) + 12 / 13 * (ABS(C66 - C67) + 12 / 13 * (ABS(C67 - C68) + 12 / 13 * (ABS(C68 - C69) + 12 / 13 * (ABS(C69 - C70) + 12 / 13 * (ABS(C70 - C71) + 12 / 13 * (ABS(C71 - C72) + 12 / 13 * (ABS(C72 - C73) + 12 / 13 * (ABS(C73 - C74) + 12 / 13 * (ABS(C74 - C75) + 12 / 13 * (ABS(C75 - C76) + 12 / 13 * (ABS(C76 - C77) + 12 / 13 * (ABS(C77 - C78) + 12 / 13 * (ABS(C78 - C79) + 12 / 13 * (ABS(C79 - C80) + 12 / 13 * (ABS(C80 - C81) + 12 / 13 * (ABS(C81 - C82) + 12 / 13 * (ABS(C82 - C83) + 12 / 13 * (ABS(C83 - C84) + 12 / 13 * (ABS(C84 - C85) + 12 / 13 * (ABS(C85 - C86) + 12 / 13 * (ABS(C86 - C87) + 12 / 13 * (ABS(C87 - C88) + 12 / 13 * (ABS(C88 - C89) + 12 / 13 * (ABS(C89 - C90) + 12 / 13 * (ABS(C90 - C91) + 12 / 13 * (ABS(C91 - C92) + 12 / 13 * (ABS(C92 - C93) + 12 / 13 * (ABS(C93 - C94) + 12 / 13 * (ABS(C94 - C95) + 12 / 13 * (ABS(C95 - C96) + 12 / 13 * (ABS(C96 - C97) + 12 / 13 * (ABS(C97 - C98) + 12 / 13 * (ABS(C98 - C99) + 12 / 13 * (ABS(C99 - C100) + 12 / 13 * (ABS(C100 - C101) + 12 / 13 * (ABS(C101 - C102) + 12 / 13 * (ABS(C102 - C103) + 12 / 13 * (ABS(C103 - C104) + 12 / 13 * (ABS(C104 - C105) + 12 / 13 * (ABS(C105 - C106) + 12 / 13 * (ABS(C106 - C107) + 12 / 13 * (ABS(C107 - C108) + 12 / 13 * (ABS(C108 - C109) + 12 / 13 * (ABS(C109 - C110) + 12 / 13 * (ABS(C110 - C111) + 12 / 13 * (ABS(C111 - C112) + 12 / 13 * (ABS(C112 - C113) + 12 / 13 * (ABS(C113 - C114) + 12 / 13 * (ABS(C114 - C115) + 12 / 13 * (ABS(C115 - C116)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Cascades of Moving Averages
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/8/2005 Posts: 8
|
Thanks Bruce.
Now one last question, to get the number for yesterday where do I place a minus 1 at the end of the formula after placing parathenses (sp?) around the whole formula or do I need ask you to write a complete new formula?
Thanks in advance
Paul
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
To get the formula for yesterday, you would need to add 1 to all of the Bars Ago parameters in the formula as follows:
50 * (C1 - XAVGC25.2) / 13 / (.0769302168313179 * (ABS(C1 - C2) + 12 / 13 * (ABS(C2 - C3) + 12 / 13 * (ABS(C3 - C4) + 12 / 13 * (ABS(C4 - C5) + 12 / 13 * (ABS(C5 - C6) + 12 / 13 * (ABS(C6 - C7) + 12 / 13 * (ABS(C7 - C8) + 12 / 13 * (ABS(C8 - C9) + 12 / 13 * (ABS(C9 - C10) + 12 / 13 * (ABS(C10 - C11) + 12 / 13 * (ABS(C11 - C12) + 12 / 13 * (ABS(C12 - C13) + 12 / 13 * (ABS(C13 - C14) + 12 / 13 * (ABS(C14 - C15) + 12 / 13 * (ABS(C15 - C16) + 12 / 13 * (ABS(C16 - C17) + 12 / 13 * (ABS(C17 - C18) + 12 / 13 * (ABS(C18 - C19) + 12 / 13 * (ABS(C19 - C20) + 12 / 13 * (ABS(C20 - C21) + 12 / 13 * (ABS(C21 - C22) + 12 / 13 * (ABS(C22 - C23) + 12 / 13 * (ABS(C23 - C24) + 12 / 13 * (ABS(C24 - C25) + 12 / 13 * (ABS(C25 - C26) + 12 / 13 * (ABS(C26 - C27) + 12 / 13 * (ABS(C27 - C28) + 12 / 13 * (ABS(C28 - C29) + 12 / 13 * (ABS(C29 - C30) + 12 / 13 * (ABS(C30 - C31) + 12 / 13 * (ABS(C31 - C32) + 12 / 13 * (ABS(C32 - C33) + 12 / 13 * (ABS(C33 - C34) + 12 / 13 * (ABS(C34 - C35) + 12 / 13 * (ABS(C35 - C36) + 12 / 13 * (ABS(C36 - C37) + 12 / 13 * (ABS(C37 - C38) + 12 / 13 * (ABS(C38 - C39) + 12 / 13 * (ABS(C39 - C40) + 12 / 13 * (ABS(C40 - C41) + 12 / 13 * (ABS(C41 - C42) + 12 / 13 * (ABS(C42 - C43) + 12 / 13 * (ABS(C43 - C44) + 12 / 13 * (ABS(C44 - C45) + 12 / 13 * (ABS(C45 - C46) + 12 / 13 * (ABS(C46 - C47) + 12 / 13 * (ABS(C47 - C48) + 12 / 13 * (ABS(C48 - C49) + 12 / 13 * (ABS(C49 - C50) + 12 / 13 * (ABS(C50 - C51) + 12 / 13 * (ABS(C51 - C52) + 12 / 13 * (ABS(C52 - C53) + 12 / 13 * (ABS(C53 - C54) + 12 / 13 * (ABS(C54 - C55) + 12 / 13 * (ABS(C55 - C56) + 12 / 13 * (ABS(C56 - C57) + 12 / 13 * (ABS(C57 - C58) + 12 / 13 * (ABS(C58 - C59) + 12 / 13 * (ABS(C59 - C60) + 12 / 13 * (ABS(C60 - C61) + 12 / 13 * (ABS(C61 - C62) + 12 / 13 * (ABS(C62 - C63) + 12 / 13 * (ABS(C63 - C64) + 12 / 13 * (ABS(C64 - C65) + 12 / 13 * (ABS(C65 - C66) + 12 / 13 * (ABS(C66 - C67) + 12 / 13 * (ABS(C67 - C68) + 12 / 13 * (ABS(C68 - C69) + 12 / 13 * (ABS(C69 - C70) + 12 / 13 * (ABS(C70 - C71) + 12 / 13 * (ABS(C71 - C72) + 12 / 13 * (ABS(C72 - C73) + 12 / 13 * (ABS(C73 - C74) + 12 / 13 * (ABS(C74 - C75) + 12 / 13 * (ABS(C75 - C76) + 12 / 13 * (ABS(C76 - C77) + 12 / 13 * (ABS(C77 - C78) + 12 / 13 * (ABS(C78 - C79) + 12 / 13 * (ABS(C79 - C80) + 12 / 13 * (ABS(C80 - C81) + 12 / 13 * (ABS(C81 - C82) + 12 / 13 * (ABS(C82 - C83) + 12 / 13 * (ABS(C83 - C84) + 12 / 13 * (ABS(C84 - C85) + 12 / 13 * (ABS(C85 - C86) + 12 / 13 * (ABS(C86 - C87) + 12 / 13 * (ABS(C87 - C88) + 12 / 13 * (ABS(C88 - C89) + 12 / 13 * (ABS(C89 - C90) + 12 / 13 * (ABS(C90 - C91) + 12 / 13 * (ABS(C91 - C92) + 12 / 13 * (ABS(C92 - C93) + 12 / 13 * (ABS(C93 - C94) + 12 / 13 * (ABS(C94 - C95) + 12 / 13 * (ABS(C95 - C96) + 12 / 13 * (ABS(C96 - C97) + 12 / 13 * (ABS(C97 - C98) + 12 / 13 * (ABS(C98 - C99) + 12 / 13 * (ABS(C99 - C100) + 12 / 13 * (ABS(C100 - C101) + 12 / 13 * (ABS(C101 - C102) + 12 / 13 * (ABS(C102 - C103) + 12 / 13 * (ABS(C103 - C104) + 12 / 13 * (ABS(C104 - C105) + 12 / 13 * (ABS(C105 - C106) + 12 / 13 * (ABS(C106 - C107) + 12 / 13 * (ABS(C107 - C108) + 12 / 13 * (ABS(C108 - C109) + 12 / 13 * (ABS(C109 - C110) + 12 / 13 * (ABS(C110 - C111) + 12 / 13 * (ABS(C111 - C112) + 12 / 13 * (ABS(C112 - C113) + 12 / 13 * (ABS(C113 - C114) + 12 / 13 * (ABS(C114 - C115) + 12 / 13 * (ABS(C115 - C116) + 12 / 13 * (ABS(C116 - C117)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/8/2005 Posts: 8
|
Thanks Bruce
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |