Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Predictive next bar price at fixed RSI value Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Chuck47
Posted : Monday, November 26, 2012 1:58:31 PM
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.

Bruce_L
Posted : Monday, November 26, 2012 4:37:04 PM


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
Chuck47
Posted : Monday, November 26, 2012 6:26:17 PM
Registered User
Joined: 6/10/2006
Posts: 8

Can we try an RSI value of 70?

Bruce_L
Posted : Tuesday, November 27, 2012 9:55:32 AM


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
Chuck47
Posted : Tuesday, November 27, 2012 10:50:59 AM
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. 

Bruce_L
Posted : Tuesday, November 27, 2012 11:30:45 AM


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
Chuck47
Posted : Tuesday, November 27, 2012 11:53:17 AM
Registered User
Joined: 6/10/2006
Posts: 8

Bruce,  thank you, I am truly appreciative of your work! 

BobMc
Posted : Tuesday, November 27, 2012 12:23:11 PM
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

Bruce_L
Posted : Tuesday, November 27, 2012 12:41:50 PM


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
Chuck47
Posted : Tuesday, February 19, 2013 1:46:43 PM
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

Bruce_L
Posted : Tuesday, February 19, 2013 2:39:33 PM


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
Chuck47
Posted : Tuesday, February 19, 2013 3:31:16 PM
Registered User
Joined: 6/10/2006
Posts: 8

Thanks, appreciate you taking a look at it.

Chuck

Bruce_L
Posted : Tuesday, February 19, 2013 3:32:27 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.



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