| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 7/30/2009
Posts: 10
|
I would like to create a scan using wilders RSI including Wilders smoothing. Support said you can write a custom scan for me.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Welcome to the forums. A very good foundation for learning how to use TeleChart can be gained by reviewing the following:
If you are new to TeleChart READ THIS FIRST!
We can help you write a scan, but we would need the particulars of the scan as well as the setting of the RSI to do so.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 7/30/2009
Posts: 10
|
RSI 3.1< 10 but RSI is smoothed
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try using the following Personal Criteria Formula as an EasyScan Condition:
50 * (C - XAVGC5.1) / 3 / (.333363037576155 * (ABS(C - C1) + 2 / 3 * (ABS(C1 - C2) + 2 / 3 * (ABS(C2 - C3) + 2 / 3 * (ABS(C3 - C4) + 2 / 3 * (ABS(C4 - C5) + 2 / 3 * (ABS(C5 - C6) + 2 / 3 * (ABS(C6 - C7) + 2 / 3 * (ABS(C7 - C8) + 2 / 3 * (ABS(C8 - C9) + 2 / 3 * (ABS(C9 - C10) + 2 / 3 * (ABS(C10 - C11) + 2 / 3 * (ABS(C11 - C12) + 2 / 3 * (ABS(C12 - C13) + 2 / 3 * (ABS(C13 - C14) + 2 / 3 * (ABS(C14 - C15) + 2 / 3 * (ABS(C15 - C16) + 2 / 3 * (ABS(C16 - C17) + 2 / 3 * (ABS(C17 - C18) + 2 / 3 * (ABS(C18 - C19) + 2 / 3 * (ABS(C19 - C20) + 2 / 3 * (ABS(C20 - C21) + 2 / 3 * (ABS(C21 - C22) + 2 / 3 * (ABS(C22 - C23))))))))))))))))))))))))) + 50 < 10
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Using EasyScan to find stocks that meet your own criteria
Definitions of all built in scanning and sorting criteria
PCF Formula Descriptions
Cascades of Moving Averages
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 7/30/2009
Posts: 10
|
This worked. Now what would I do if I wanted to make this value crossing over 50 from one day to the next?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You'd need to add 1 to all of the Bars Ago parameters in the 3-Period Wilder's Smoothed RSI formula to create a version for yesterday and then test for them to be on opposite sides of the 50 line. For example, a Personal Criteria Formula for the 3-Period Wilder's Smoothed RSI crossing up through 50 might be written as:
50 * (C - XAVGC5.1) / 3 / (.333363037576155 * (ABS(C - C1) + 2 / 3 * (ABS(C1 - C2) + 2 / 3 * (ABS(C2 - C3) + 2 / 3 * (ABS(C3 - C4) + 2 / 3 * (ABS(C4 - C5) + 2 / 3 * (ABS(C5 - C6) + 2 / 3 * (ABS(C6 - C7) + 2 / 3 * (ABS(C7 - C8) + 2 / 3 * (ABS(C8 - C9) + 2 / 3 * (ABS(C9 - C10) + 2 / 3 * (ABS(C10 - C11) + 2 / 3 * (ABS(C11 - C12) + 2 / 3 * (ABS(C12 - C13) + 2 / 3 * (ABS(C13 - C14) + 2 / 3 * (ABS(C14 - C15) + 2 / 3 * (ABS(C15 - C16) + 2 / 3 * (ABS(C16 - C17) + 2 / 3 * (ABS(C17 - C18) + 2 / 3 * (ABS(C18 - C19) + 2 / 3 * (ABS(C19 - C20) + 2 / 3 * (ABS(C20 - C21) + 2 / 3 * (ABS(C21 - C22) + 2 / 3 * (ABS(C22 - C23))))))))))))))))))))))))) + 50 > 50 AND 50 * (C1 - XAVGC5.2) / 3 / (.333363037576155 * (ABS(C1 - C2) + 2 / 3 * (ABS(C2 - C3) + 2 / 3 * (ABS(C3 - C4) + 2 / 3 * (ABS(C4 - C5) + 2 / 3 * (ABS(C5 - C6) + 2 / 3 * (ABS(C6 - C7) + 2 / 3 * (ABS(C7 - C8) + 2 / 3 * (ABS(C8 - C9) + 2 / 3 * (ABS(C9 - C10) + 2 / 3 * (ABS(C10 - C11) + 2 / 3 * (ABS(C11 - C12) + 2 / 3 * (ABS(C12 - C13) + 2 / 3 * (ABS(C13 - C14) + 2 / 3 * (ABS(C14 - C15) + 2 / 3 * (ABS(C15 - C16) + 2 / 3 * (ABS(C16 - C17) + 2 / 3 * (ABS(C17 - C18) + 2 / 3 * (ABS(C18 - C19) + 2 / 3 * (ABS(C19 - C20) + 2 / 3 * (ABS(C20 - C21) + 2 / 3 * (ABS(C21 - C22) + 2 / 3 * (ABS(C22 - C23) + 2 / 3 * (ABS(C23 - C24))))))))))))))))))))))))) + 50 <= 50
While a PCF for the 3-Period Wilder's Smoothed RSI crossing down through 50 might be written as:
50 * (C - XAVGC5.1) / 3 / (.333363037576155 * (ABS(C - C1) + 2 / 3 * (ABS(C1 - C2) + 2 / 3 * (ABS(C2 - C3) + 2 / 3 * (ABS(C3 - C4) + 2 / 3 * (ABS(C4 - C5) + 2 / 3 * (ABS(C5 - C6) + 2 / 3 * (ABS(C6 - C7) + 2 / 3 * (ABS(C7 - C8) + 2 / 3 * (ABS(C8 - C9) + 2 / 3 * (ABS(C9 - C10) + 2 / 3 * (ABS(C10 - C11) + 2 / 3 * (ABS(C11 - C12) + 2 / 3 * (ABS(C12 - C13) + 2 / 3 * (ABS(C13 - C14) + 2 / 3 * (ABS(C14 - C15) + 2 / 3 * (ABS(C15 - C16) + 2 / 3 * (ABS(C16 - C17) + 2 / 3 * (ABS(C17 - C18) + 2 / 3 * (ABS(C18 - C19) + 2 / 3 * (ABS(C19 - C20) + 2 / 3 * (ABS(C20 - C21) + 2 / 3 * (ABS(C21 - C22) + 2 / 3 * (ABS(C22 - C23))))))))))))))))))))))))) + 50 < 50 AND 50 * (C1 - XAVGC5.2) / 3 / (.333363037576155 * (ABS(C1 - C2) + 2 / 3 * (ABS(C2 - C3) + 2 / 3 * (ABS(C3 - C4) + 2 / 3 * (ABS(C4 - C5) + 2 / 3 * (ABS(C5 - C6) + 2 / 3 * (ABS(C6 - C7) + 2 / 3 * (ABS(C7 - C8) + 2 / 3 * (ABS(C8 - C9) + 2 / 3 * (ABS(C9 - C10) + 2 / 3 * (ABS(C10 - C11) + 2 / 3 * (ABS(C11 - C12) + 2 / 3 * (ABS(C12 - C13) + 2 / 3 * (ABS(C13 - C14) + 2 / 3 * (ABS(C14 - C15) + 2 / 3 * (ABS(C15 - C16) + 2 / 3 * (ABS(C16 - C17) + 2 / 3 * (ABS(C17 - C18) + 2 / 3 * (ABS(C18 - C19) + 2 / 3 * (ABS(C19 - C20) + 2 / 3 * (ABS(C20 - C21) + 2 / 3 * (ABS(C21 - C22) + 2 / 3 * (ABS(C22 - C23) + 2 / 3 * (ABS(C23 - C24))))))))))))))))))))))))) + 50 >= 50
If the direction of the cross doesn't matter, you might use something like the following instead:
SGN(50 * (C - XAVGC5.1) / 3 / (.333363037576155 * (ABS(C - C1) + 2 / 3 * (ABS(C1 - C2) + 2 / 3 * (ABS(C2 - C3) + 2 / 3 * (ABS(C3 - C4) + 2 / 3 * (ABS(C4 - C5) + 2 / 3 * (ABS(C5 - C6) + 2 / 3 * (ABS(C6 - C7) + 2 / 3 * (ABS(C7 - C8) + 2 / 3 * (ABS(C8 - C9) + 2 / 3 * (ABS(C9 - C10) + 2 / 3 * (ABS(C10 - C11) + 2 / 3 * (ABS(C11 - C12) + 2 / 3 * (ABS(C12 - C13) + 2 / 3 * (ABS(C13 - C14) + 2 / 3 * (ABS(C14 - C15) + 2 / 3 * (ABS(C15 - C16) + 2 / 3 * (ABS(C16 - C17) + 2 / 3 * (ABS(C17 - C18) + 2 / 3 * (ABS(C18 - C19) + 2 / 3 * (ABS(C19 - C20) + 2 / 3 * (ABS(C20 - C21) + 2 / 3 * (ABS(C21 - C22) + 2 / 3 * (ABS(C22 - C23))))))))))))))))))))))))) + 50 - 50) <> SGN(50 * (C1 - XAVGC5.2) / 3 / (.333363037576155 * (ABS(C1 - C2) + 2 / 3 * (ABS(C2 - C3) + 2 / 3 * (ABS(C3 - C4) + 2 / 3 * (ABS(C4 - C5) + 2 / 3 * (ABS(C5 - C6) + 2 / 3 * (ABS(C6 - C7) + 2 / 3 * (ABS(C7 - C8) + 2 / 3 * (ABS(C8 - C9) + 2 / 3 * (ABS(C9 - C10) + 2 / 3 * (ABS(C10 - C11) + 2 / 3 * (ABS(C11 - C12) + 2 / 3 * (ABS(C12 - C13) + 2 / 3 * (ABS(C13 - C14) + 2 / 3 * (ABS(C14 - C15) + 2 / 3 * (ABS(C15 - C16) + 2 / 3 * (ABS(C16 - C17) + 2 / 3 * (ABS(C17 - C18) + 2 / 3 * (ABS(C18 - C19) + 2 / 3 * (ABS(C19 - C20) + 2 / 3 * (ABS(C20 - C21) + 2 / 3 * (ABS(C21 - C22) + 2 / 3 * (ABS(C22 - C23) + 2 / 3 * (ABS(C23 - C24))))))))))))))))))))))))) + 50 - 50)
The centerline of the RSI is actually a bit of a special case in that we can significantly shorten these formulas:
3-Period Wilder's RSI xUp 50:
C > XAVGC5.1 AND C1 <= XAVGC5.2
3-Period Wilder's RSI xDn 50:
C < XAVGC5.1 AND C1 >= XAVGC5.2
3-Period Wilder's RSI crossing through 50 (either direction):
SGN(C - XAVGC5.1) <> SGN(C1 - XAVGC5.2)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 7/30/2009
Posts: 10
|
So you are saying the centerline formula eliminates the need for all of the other values for smoothing?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
If you are only interested in position of the RSI relative to the centerline, the denominator does not matter because the magnitude of the difference from the centerline does not matter (only the direction or the sign of the result matters). The Absolute Value functions in the denominator mean the denominator cannot be negative. Dividing (or multiplying) a number by a positive number does not change the sign of original number.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |