Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 6/10/2006 Posts: 8
|
I use selected values of Wilder's 2 period RSI for swing trading entry and exists. Can you share a pcf formula that calculates the next bar price needed to achieve a selected RSI value using Wilder's 2 period RSI? Thank you.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I think we can probably do something similar to what we did in the RSI Solver? topic. That said, I would actually need the target RSI to create the Indicator Formula because TC2000's Personal Criteria Formula Language does not have user inputs like RealCode.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 6/10/2006 Posts: 8
|
Can we try an RSI value of 70?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following Indicator Formula for the price during the next bar for the next bar's 2-Period Wilder's RSI to be 70:
ABS(50 * (C - XAVGC3.1) / 2 / (.500030519440884 * (ABS(C - C1) + .5 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14)))))))))))))))) + 50 < 70) * (C + 1.1667378786954 * (ABS(C - C1) + .5 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14))))))))))))))) - 1.66676839813628 * ((C > C1) * (C1 - C) + .5 * ((C1 > C2) * (C2 - C1) + .5 * ((C2 > C3) * (C3 - C2) + .5 * ((C3 > C4) * (C4 - C3) + .5 * ((C4 > C5) * (C5 - C4) + .5 * ((C5 > C6) * (C6 - C5) + .5 * ((C6 > C7) * (C7 - C6) + .5 * ((C7 > C8) * (C8 - C7) + .5 * ((C8 > C9) * (C9 - C8) + .5 * ((C9 > C10) * (C10 - C9) + .5 * ((C10 > C11) * (C11 - C10) + .5 * ((C11 > C12) * (C12 - C11) + .5 * ((C12 > C13) * (C13 - C12) + .5 * ((C13 > C14) * (C14 - C13)))))))))))))))) + ABS(50 * (C - XAVGC3.1) / 2 / (.500030519440884 * (ABS(C - C1) + .5 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14)))))))))))))))) + 50 > 70) * (C - .714329313486977 * ((C > C1) * (C1 - C) + .5 * ((C1 > C2) * (C2 - C1) + .5 * ((C2 > C3) * (C3 - C2) + .5 * ((C3 > C4) * (C4 - C3) + .5 * ((C4 > C5) * (C5 - C4) + .5 * ((C5 > C6) * (C6 - C5) + .5 * ((C6 > C7) * (C7 - C6) + .5 * ((C7 > C8) * (C8 - C7) + .5 * ((C8 > C9) * (C9 - C8) + .5 * ((C9 > C10) * (C10 - C9) + .5 * ((C10 > C11) * (C11 - C10) + .5 * ((C11 > C12) * (C12 - C11) + .5 * ((C12 > C13) * (C13 - C12) + .5 * ((C13 > C14) * (C14 - C13))))))))))))))) + .500030519440884 * (ABS(C - C1) + .5 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 6/10/2006 Posts: 8
|
Wow! Thank you! May I ask for 2 more formulations, one at RSI 30 and one at RSI 50. Thanks.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following Indicator Formula for the price for the next bar for the next bar's 2-Period Wilder's RSI to be 30:
ABS(50 * (C - XAVGC3.1) / 2 / (.500030519440884 * (ABS(C - C1) + .5 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14)))))))))))))))) + 50 < 30) * (C + .214298794046093 * (ABS(C - C1) + .5 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14))))))))))))))) - .714329313486977 * ((C > C1) * (C1 - C) + .5 * ((C1 > C2) * (C2 - C1) + .5 * ((C2 > C3) * (C3 - C2) + .5 * ((C3 > C4) * (C4 - C3) + .5 * ((C4 > C5) * (C5 - C4) + .5 * ((C5 > C6) * (C6 - C5) + .5 * ((C6 > C7) * (C7 - C6) + .5 * ((C7 > C8) * (C8 - C7) + .5 * ((C8 > C9) * (C9 - C8) + .5 * ((C9 > C10) * (C10 - C9) + .5 * ((C10 > C11) * (C11 - C10) + .5 * ((C11 > C12) * (C12 - C11) + .5 * ((C12 > C13) * (C13 - C12) + .5 * ((C13 > C14) * (C14 - C13)))))))))))))))) + ABS(50 * (C - XAVGC3.1) / 2 / (.500030519440884 * (ABS(C - C1) + .5 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14)))))))))))))))) + 50 > 30) * (C - 1.66676839813628 * ((C > C1) * (C1 - C) + .5 * ((C1 > C2) * (C2 - C1) + .5 * ((C2 > C3) * (C3 - C2) + .5 * ((C3 > C4) * (C4 - C3) + .5 * ((C4 > C5) * (C5 - C4) + .5 * ((C5 > C6) * (C6 - C5) + .5 * ((C6 > C7) * (C7 - C6) + .5 * ((C7 > C8) * (C8 - C7) + .5 * ((C8 > C9) * (C9 - C8) + .5 * ((C9 > C10) * (C10 - C9) + .5 * ((C10 > C11) * (C11 - C10) + .5 * ((C11 > C12) * (C12 - C11) + .5 * ((C12 > C13) * (C13 - C12) + .5 * ((C13 > C14) * (C14 - C13))))))))))))))) + .500030519440884 * (ABS(C - C1) + .5 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14))))))))))))))))
Please try the following Indicator Formula for the price for the next bar for the next bar's 2-Period Wilder's RSI to be 50:
ABS(50 * (C - XAVGC3.1) / 2 / (.500030519440884 * (ABS(C - C1) + .5 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14)))))))))))))))) + 50 < 50) * (C + .500030519440884 * (ABS(C - C1) + .5 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14))))))))))))))) - 1.00006103888177 * ((C > C1) * (C1 - C) + .5 * ((C1 > C2) * (C2 - C1) + .5 * ((C2 > C3) * (C3 - C2) + .5 * ((C3 > C4) * (C4 - C3) + .5 * ((C4 > C5) * (C5 - C4) + .5 * ((C5 > C6) * (C6 - C5) + .5 * ((C6 > C7) * (C7 - C6) + .5 * ((C7 > C8) * (C8 - C7) + .5 * ((C8 > C9) * (C9 - C8) + .5 * ((C9 > C10) * (C10 - C9) + .5 * ((C10 > C11) * (C11 - C10) + .5 * ((C11 > C12) * (C12 - C11) + .5 * ((C12 > C13) * (C13 - C12) + .5 * ((C13 > C14) * (C14 - C13)))))))))))))))) + ABS(50 * (C - XAVGC3.1) / 2 / (.500030519440884 * (ABS(C - C1) + .5 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14)))))))))))))))) + 50 > 50) * (C - 1.00006103888177 * ((C > C1) * (C1 - C) + .5 * ((C1 > C2) * (C2 - C1) + .5 * ((C2 > C3) * (C3 - C2) + .5 * ((C3 > C4) * (C4 - C3) + .5 * ((C4 > C5) * (C5 - C4) + .5 * ((C5 > C6) * (C6 - C5) + .5 * ((C6 > C7) * (C7 - C6) + .5 * ((C7 > C8) * (C8 - C7) + .5 * ((C8 > C9) * (C9 - C8) + .5 * ((C9 > C10) * (C10 - C9) + .5 * ((C10 > C11) * (C11 - C10) + .5 * ((C11 > C12) * (C12 - C11) + .5 * ((C12 > C13) * (C13 - C12) + .5 * ((C13 > C14) * (C14 - C13))))))))))))))) + .500030519440884 * (ABS(C - C1) + .5 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 6/10/2006 Posts: 8
|
Bruce, thank you, I am truly appreciative of your work!
|
|
Registered User Joined: 10/7/2004 Posts: 816
|
Bruce,
I was looking at the formulas to see how to adjust them to other values and I have a question regarding the last formula you gave - for the RSI to be 50.
Shouldn't the <30 on the third line be 50 instead and the >30 on the 12th line be 50 also?
Regards
BobMc
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Yes, they should. I will adjust them in the original post. Thank you for bringing it to my attention.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 6/10/2006 Posts: 8
|
Bruce,
Can you please post the formula to determine the next bar price for the value of the 8 period Wilder's RSI to be at 50.
Thank you!
Chuck
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The resulting formula is too long and slow to be practical or post in the forums.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 6/10/2006 Posts: 8
|
Thanks, appreciate you taking a look at it.
Chuck
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |