| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 1/15/2006
Posts: 19
|
I am trying to write a PCF for an RSI(3) of the ROC(1). No idea how to incorporate them. I know the ROC(1) is just Today's Close - Yesterday's Close. I just need to calculate an RSI(3) of this short term Rate of Change.
Thanks.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I don't have anything to use for comparison, but you might wish to try the following:
100 - (100 / (1 + (((C0 + C2 > 2 * C1) * (2 * C1 - C0 - C2) + 2 / 3 * ((C1 + C3 > 2 * C2) * (2 * C2 - C1 - C3) + 2 / 3 * ((C2 + C4 > 2 * C3) * (2 * C3 - C2 - C4) + 2 / 3 * ((C3 + C5 > 2 * C4) * (2 * C4 - C3 - C5) + 2 / 3 * ((C4 + C6 > 2 * C5) * (2 * C5 - C4 - C6) + 2 / 3 * ((C5 + C7 > 2 * C6) * (2 * C6 - C5 - C7) + 2 / 3 * ((C6 + C8 > 2 * C7) * (2 * C7 - C6 - C8) + 2 / 3 * ((C7 + C9 > 2 * C8) * (2 * C8 - C7 - C9) + 2 / 3 * ((C8 + C10 > 2 * C9) * (2 * C9 - C8 - C10) + 2 / 3 * ((C9 + C11 > 2 * C10) * (2 * C10 - C9 - C11) + 2 / 3 * ((C10 + C12 > 2 * C11) * (2 * C11 - C10 - C12) + 2 / 3 * ((C11 + C13 > 2 * C12) * (2 * C12 - C11 - C13) + 2 / 3 * ((C12 + C14 > 2 * C13) * (2 * C13 - C12 - C14) + 2 / 3 * ((C13 + C15 > 2 * C14) * (2 * C14 - C13 - C15) + 2 / 3 * ((C14 + C16 > 2 * C15) * (2 * C15 - C14 - C16) + 2 / 3 * ((C15 + C17 > 2 * C16) * (2 * C16 - C15 - C17) + 2 / 3 * ((C16 + C18 > 2 * C17) * (2 * C17 - C16 - C18) + 2 / 3 * ((C17 + C19 > 2 * C18) * (2 * C18 - C17 - C19))))))))))))))))))) / ((C0 + C2 < 2 * C1) * (C0 + C2 - 2 * C1) + 2 / 3 * ((C1 + C3 < 2 * C2) * (C1 + C3 - 2 * C2) + 2 / 3 * ((C2 + C4 < 2 * C3) * (C2 + C4 - 2 * C3) + 2 / 3 * ((C3 + C5 < 2 * C4) * (C3 + C5 - 2 * C4) + 2 / 3 * ((C4 + C6 < 2 * C5) * (C4 + C6 - 2 * C5) + 2 / 3 * ((C5 + C7 < 2 * C6) * (C5 + C7 - 2 * C6) + 2 / 3 * ((C6 + C8 < 2 * C7) * (C6 + C8 - 2 * C7) + 2 / 3 * ((C7 + C9 < 2 * C8) * (C7 + C9 - 2 * C8) + 2 / 3 * ((C8 + C10 < 2 * C9) * (C8 + C10 - 2 * C9) + 2 / 3 * ((C9 + C11 < 2 * C10) * (C9 + C11 - 2 * C10) + 2 / 3 * ((C10 + C12 < 2 * C11) * (C10 + C12 - 2 * C11) + 2 / 3 * ((C11 + C13 < 2 * C12) * (C11 + C13 - 2 * C12) + 2 / 3 * ((C12 + C14 < 2 * C13) * (C12 + C14 - 2 * C13) + 2 / 3 * ((C13 + C15 < 2 * C14) * (C13 + C15 - 2 * C14) + 2 / 3 * ((C14 + C16 < 2 * C15) * (C14 + C16 - 2 * C15) + 2 / 3 * ((C15 + C17 < 2 * C16) * (C15 + C17 - 2 * C16) + 2 / 3 * ((C16 + C18 < 2 * C17) * (C16 + C18 - 2 * C17) + 2 / 3 * ((C17 + C19 < 2 * C18) * (C17 + C19 - 2 * C18))))))))))))))))))))))
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/15/2006
Posts: 19
|
Thanks. I'm not much for writing formulas or interpreting them. Just to clarify what I am looking for:
We are using the 1-Period ROC (C - C1). I want to calculate the 3-Period RSI of the series of these Rates of Change. So if:
C = 50 ROC = 2
C1 = 48 ROC = 4
C2 = 44 ROC = -3
C3 = 47 ROC = 6
C4 = 41 ROC = -1
C5 = 42
I want to calculate the RSI of those single digit change numbers, not the RSI of closing prices, if you catch what I am saying.
Thanks.
|
|
Registered User
Joined: 1/15/2006
Posts: 19
|
WOW!!!! I think that is exactly what I am looking for. Thanks!!!!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I understand, I'm just not sure the formula is correct because I don't have any charts or other implementations to use as a comparison. The formula for the Wilder's Smoothed RSI of Price on which the formula I presented is based would be:
100 - (100 / (1 + (((C0 > C1) * (C1 - C0) + 2 / 3 * ((C1 > C2) * (C2 - C1) + 2 / 3 * ((C2 > C3) * (C3 - C2) + 2 / 3 * ((C3 > C4) * (C4 - C3) + 2 / 3 * ((C4 > C5) * (C5 - C4) + 2 / 3 * ((C5 > C6) * (C6 - C5) + 2 / 3 * ((C6 > C7) * (C7 - C6) + 2 / 3 * ((C7 > C8) * (C8 - C7) + 2 / 3 * ((C8 > C9) * (C9 - C8) + 2 / 3 * ((C9 > C10) * (C10 - C9) + 2 / 3 * ((C10 > C11) * (C11 - C10) + 2 / 3 * ((C11 > C12) * (C12 - C11) + 2 / 3 * ((C12 > C13) * (C13 - C12) + 2 / 3 * ((C13 > C14) * (C14 - C13) + 2 / 3 * ((C14 > C15) * (C15 - C14) + 2 / 3 * ((C15 > C16) * (C16 - C15) + 2 / 3 * ((C16 > C17) * (C17 - C16) + 2 / 3 * ((C17 > C18) * (C18 - C17))))))))))))))))))) / ((C0 < C1) * (C0 - C1) + 2 / 3 * ((C1 < C2) * (C1 - C2) + 2 / 3 * ((C2 < C3) * (C2 - C3) + 2 / 3 * ((C3 < C4) * (C3 - C4) + 2 / 3 * ((C4 < C5) * (C4 - C5) + 2 / 3 * ((C5 < C6) * (C5 - C6) + 2 / 3 * ((C6 < C7) * (C6 - C7) + 2 / 3 * ((C7 < C8) * (C7 - C8) + 2 / 3 * ((C8 < C9) * (C8 - C9) + 2 / 3 * ((C9 < C10) * (C9 - C10) + 2 / 3 * ((C10 < C11) * (C10 - C11) + 2 / 3 * ((C11 < C12) * (C11 - C12) + 2 / 3 * ((C12 < C13) * (C12 - C13) + 2 / 3 * ((C13 < C14) * (C13 - C14) + 2 / 3 * ((C14 < C15) * (C14 - C15) + 2 / 3 * ((C15 < C16) * (C15 - C16) + 2 / 3 * ((C16 < C17) * (C16 - C17) + 2 / 3 * ((C17 < C18) * (C17 - C18))))))))))))))))))))))
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome. Do you have something to compare it to so you know it works correctly?
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/15/2006
Posts: 19
|
I do. I have a study on eSignal that I use. The study you gave me and my eSignal study are within decimal points of each other. Perfect. Thanks.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Great! It's nice to know it works correctly. Thank you for the feedback.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |