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


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

3-Period RSI of the 1-Period Rate of Change Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
mjbaniewicz
Posted : Thursday, June 1, 2006 5:33:46 PM
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.
Bruce_L
Posted : Thursday, June 1, 2006 5:43:24 PM


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
mjbaniewicz
Posted : Thursday, June 1, 2006 6:16:54 PM
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.
mjbaniewicz
Posted : Thursday, June 1, 2006 6:19:30 PM
Registered User
Joined: 1/15/2006
Posts: 19
WOW!!!! I think that is exactly what I am looking for. Thanks!!!!
Bruce_L
Posted : Thursday, June 1, 2006 6:22:53 PM


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
Bruce_L
Posted : Thursday, June 1, 2006 6:28:18 PM


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
mjbaniewicz
Posted : Thursday, June 1, 2006 7:22:53 PM
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.
Bruce_L
Posted : Thursday, June 1, 2006 7:24:08 PM


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