| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 3/6/2005
Posts: 25
|
Hi Bruce,
I see the math exprssion for Wilder's RSI is quite complex. Can you please give me the PCF code for the condition:
Wilders RSI crosses above its value of 30 in the last one day.
Many Thanks,
Jim
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
In the current production release of TeleChart, we would need to know the settings of the Wilder's RSI to help you create a formula:
- RSI Period: ?
- Use Wilders Smoothing: Checked or Unchecked?
- Avg Period: ?
- Average Type: Simple or Exponential?
In the TC2000.com version 11 beta, you can click on the Wilder's RSI Indicator and select Quick Sort (or Add Column) | Based On: Crossing Up Value | Crossing up through: 30.
EasyScans and Column Sorting
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 3/6/2005
Posts: 25
|
Hi Bruce,
Sorry about that, I forgot that you are not a mindreader :>).
The parameters I am interested in are:
Avg Type = simple
Avg Period = 1
RSI Period = 10
As for smoothing, I would have to say that this should be unchecked. In stockfinder where I have used a condition on this Wilders in the past, there is no smoothing parameter in the setup window that I can see, just the above three parameters, unless it is smoothed by default.
Jim
|
|
Registered User
Joined: 3/6/2005
Posts: 25
|
BTW, I have used the quicksort feature in version 11 to sort on the cross of the 30 value, but it would be desirable for me to have this condition as part of the scan (as a PCF).
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
In the TC2000.com version 11 beta, there are actually two different Indicators provided instead of having a Use Wilders Smoothing setting. Neither Indicator has an Avg Period or Avg Type setting, but both have Moving Averages as Child Indicators by default when they are added to the Chart.
If it is a 10-Period RSI (the same as having Wilder's Smoothing unchecked in TeleChart), the formula would be:
RSI10 > 30 AND RSI10.1.1 <= 30
If it is a 10-Period Wilder's RSI (the same as having Wilder's Smoothing checked in TeleChart), the formula would be:
50 * (C - XAVGC19.1) / 10 / (.10000940549542 * (ABS(C - C1) + .9 * (ABS(C1 - C2) + .9 * (ABS(C2 - C3) + .9 * (ABS(C3 - C4) + .9 * (ABS(C4 - C5) + .9 * (ABS(C5 - C6) + .9 * (ABS(C6 - C7) + .9 * (ABS(C7 - C8) + .9 * (ABS(C8 - C9) + .9 * (ABS(C9 - C10) + .9 * (ABS(C10 - C11) + .9 * (ABS(C11 - C12) + .9 * (ABS(C12 - C13) + .9 * (ABS(C13 - C14) + .9 * (ABS(C14 - C15) + .9 * (ABS(C15 - C16) + .9 * (ABS(C16 - C17) + .9 * (ABS(C17 - C18) + .9 * (ABS(C18 - C19) + .9 * (ABS(C19 - C20) + .9 * (ABS(C20 - C21) + .9 * (ABS(C21 - C22) + .9 * (ABS(C22 - C23) + .9 * (ABS(C23 - C24) + .9 * (ABS(C24 - C25) + .9 * (ABS(C25 - C26) + .9 * (ABS(C26 - C27) + .9 * (ABS(C27 - C28) + .9 * (ABS(C28 - C29) + .9 * (ABS(C29 - C30) + .9 * (ABS(C30 - C31) + .9 * (ABS(C31 - C32) + .9 * (ABS(C32 - C33) + .9 * (ABS(C33 - C34) + .9 * (ABS(C34 - C35) + .9 * (ABS(C35 - C36) + .9 * (ABS(C36 - C37) + .9 * (ABS(C37 - C38) + .9 * (ABS(C38 - C39) + .9 * (ABS(C39 - C40) + .9 * (ABS(C40 - C41) + .9 * (ABS(C41 - C42) + .9 * (ABS(C42 - C43) + .9 * (ABS(C43 - C44) + .9 * (ABS(C44 - C45) + .9 * (ABS(C45 - C46) + .9 * (ABS(C46 - C47) + .9 * (ABS(C47 - C48) + .9 * (ABS(C48 - C49) + .9 * (ABS(C49 - C50) + .9 * (ABS(C50 - C51) + .9 * (ABS(C51 - C52) + .9 * (ABS(C52 - C53) + .9 * (ABS(C53 - C54) + .9 * (ABS(C54 - C55) + .9 * (ABS(C55 - C56) + .9 * (ABS(C56 - C57) + .9 * (ABS(C57 - C58) + .9 * (ABS(C58 - C59) + .9 * (ABS(C59 - C60) + .9 * (ABS(C60 - C61) + .9 * (ABS(C61 - C62) + .9 * (ABS(C62 - C63) + .9 * (ABS(C63 - C64) + .9 * (ABS(C64 - C65) + .9 * (ABS(C65 - C66) + .9 * (ABS(C66 - C67) + .9 * (ABS(C67 - C68) + .9 * (ABS(C68 - C69) + .9 * (ABS(C69 - C70) + .9 * (ABS(C70 - C71) + .9 * (ABS(C71 - C72) + .9 * (ABS(C72 - C73) + .9 * (ABS(C73 - C74) + .9 * (ABS(C74 - C75) + .9 * (ABS(C75 - C76) + .9 * (ABS(C76 - C77) + .9 * (ABS(C77 - C78) + .9 * (ABS(C78 - C79) + .9 * (ABS(C79 - C80) + .9 * (ABS(C80 - C81) + .9 * (ABS(C81 - C82) + .9 * (ABS(C82 - C83) + .9 * (ABS(C83 - C84) + .9 * (ABS(C84 - C85) + .9 * (ABS(C85 - C86) + .9 * (ABS(C86 - C87) + .9 * (ABS(C87 - C88)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 > 30 AND 50 * (C1 - XAVGC19.2) / 10 / (.10000940549542 * (ABS(C1 - C2) + .9 * (ABS(C2 - C3) + .9 * (ABS(C3 - C4) + .9 * (ABS(C4 - C5) + .9 * (ABS(C5 - C6) + .9 * (ABS(C6 - C7) + .9 * (ABS(C7 - C8) + .9 * (ABS(C8 - C9) + .9 * (ABS(C9 - C10) + .9 * (ABS(C10 - C11) + .9 * (ABS(C11 - C12) + .9 * (ABS(C12 - C13) + .9 * (ABS(C13 - C14) + .9 * (ABS(C14 - C15) + .9 * (ABS(C15 - C16) + .9 * (ABS(C16 - C17) + .9 * (ABS(C17 - C18) + .9 * (ABS(C18 - C19) + .9 * (ABS(C19 - C20) + .9 * (ABS(C20 - C21) + .9 * (ABS(C21 - C22) + .9 * (ABS(C22 - C23) + .9 * (ABS(C23 - C24) + .9 * (ABS(C24 - C25) + .9 * (ABS(C25 - C26) + .9 * (ABS(C26 - C27) + .9 * (ABS(C27 - C28) + .9 * (ABS(C28 - C29) + .9 * (ABS(C29 - C30) + .9 * (ABS(C30 - C31) + .9 * (ABS(C31 - C32) + .9 * (ABS(C32 - C33) + .9 * (ABS(C33 - C34) + .9 * (ABS(C34 - C35) + .9 * (ABS(C35 - C36) + .9 * (ABS(C36 - C37) + .9 * (ABS(C37 - C38) + .9 * (ABS(C38 - C39) + .9 * (ABS(C39 - C40) + .9 * (ABS(C40 - C41) + .9 * (ABS(C41 - C42) + .9 * (ABS(C42 - C43) + .9 * (ABS(C43 - C44) + .9 * (ABS(C44 - C45) + .9 * (ABS(C45 - C46) + .9 * (ABS(C46 - C47) + .9 * (ABS(C47 - C48) + .9 * (ABS(C48 - C49) + .9 * (ABS(C49 - C50) + .9 * (ABS(C50 - C51) + .9 * (ABS(C51 - C52) + .9 * (ABS(C52 - C53) + .9 * (ABS(C53 - C54) + .9 * (ABS(C54 - C55) + .9 * (ABS(C55 - C56) + .9 * (ABS(C56 - C57) + .9 * (ABS(C57 - C58) + .9 * (ABS(C58 - C59) + .9 * (ABS(C59 - C60) + .9 * (ABS(C60 - C61) + .9 * (ABS(C61 - C62) + .9 * (ABS(C62 - C63) + .9 * (ABS(C63 - C64) + .9 * (ABS(C64 - C65) + .9 * (ABS(C65 - C66) + .9 * (ABS(C66 - C67) + .9 * (ABS(C67 - C68) + .9 * (ABS(C68 - C69) + .9 * (ABS(C69 - C70) + .9 * (ABS(C70 - C71) + .9 * (ABS(C71 - C72) + .9 * (ABS(C72 - C73) + .9 * (ABS(C73 - C74) + .9 * (ABS(C74 - C75) + .9 * (ABS(C75 - C76) + .9 * (ABS(C76 - C77) + .9 * (ABS(C77 - C78) + .9 * (ABS(C78 - C79) + .9 * (ABS(C79 - C80) + .9 * (ABS(C80 - C81) + .9 * (ABS(C81 - C82) + .9 * (ABS(C82 - C83) + .9 * (ABS(C83 - C84) + .9 * (ABS(C84 - C85) + .9 * (ABS(C85 - C86) + .9 * (ABS(C86 - C87) + .9 * (ABS(C87 - C88) + .9 * (ABS(C88 - C89)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 <= 30
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
Cascades of Moving Averages
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 3/6/2005
Posts: 25
|
Thanks, a LOT, Bruce.
I was not aware of the RSI smoothing in Telechart as being associated with Wilders and I will look into how that is done. But in any case, I really appreciate having the PCF.
Jim
|
|
Registered User
Joined: 3/6/2005
Posts: 25
|
Hi Bruce,
I just used the Wilders RSI PCF expression which you defined for me in your post on Wednesday, March 23, 2011.
For Friday's update April 29, the scan I use the expression in gave me the results I was expecting with one exception, ie, it did not return symbol DMD because the Wilder's PCF did not return DMD. I am also plotting the Widers RSI graph in a lower pane (Period 10, Moving Average 1 smoothing applies), and I can see that for this symbol the curve does indeed cross over the value of 30 in the last one day.
So I wonder why this Wilders PCF did not return DMD. It did nicely return the 11 other stocks I was looking for in the composite scan.
Any ideas?
Jim
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
In general, there are a variety of possibilities as the formula is just an approximation of the calculations happening on the Chart.
EMAs (and I assume Wilder's Smoothing) in the TC2000.com version 11 beta are initialized at the left edge of the Chart with an SMA (one of at least three common initialization methods used for the normal way of calculating an EMA of which I am aware) and then a fairly standard algorithm is used to calculate the new Value of the EMA based on the previous Value of the EMA.
This means both the initialization method and the number of bars of data used can affect the Value of the EMA. If there is "enough" data used in the calculation, both the initialization method and the number of Bars of data used in the calculation no longer matter as the contribution of older Bars approaches (but never reaches) zero.
The algorithm used on the Chart however works from right to left. Because we are going the other direction, we aren't taking into account whatever initialization methed is being used by the EMA.
The ratio used for the contribution of a Bar to the Value versus the previous Bar to the Value is constant. This would only be true of the "normal" algorithm for an EMA if the number of Bars used in the calculation was infinite. While this ratio is approached by the normaly algorithm rather quickly, it is never actually reached.
Again, this doesn't matter much if there is "enough" data used in the calculations, as the different algorithms converge on the same results.
In the case of DMD, there isn't enough data. The PCF approximation requires Closing Prices from 89 Bars back to even calculate. We could shorten it to the point where it would calculate for DMD, but then it might not be using "enough" data for other symbols (and in some cases, this might be true even with the existing formula):
50 * (C - XAVGC19.1) / 10 / (.100106224377651 * (ABS(C - C1) + .9 * (ABS(C1 - C2) + .9 * (ABS(C2 - C3) + .9 * (ABS(C3 - C4) + .9 * (ABS(C4 - C5) + .9 * (ABS(C5 - C6) + .9 * (ABS(C6 - C7) + .9 * (ABS(C7 - C8) + .9 * (ABS(C8 - C9) + .9 * (ABS(C9 - C10) + .9 * (ABS(C10 - C11) + .9 * (ABS(C11 - C12) + .9 * (ABS(C12 - C13) + .9 * (ABS(C13 - C14) + .9 * (ABS(C14 - C15) + .9 * (ABS(C15 - C16) + .9 * (ABS(C16 - C17) + .9 * (ABS(C17 - C18) + .9 * (ABS(C18 - C19) + .9 * (ABS(C19 - C20) + .9 * (ABS(C20 - C21) + .9 * (ABS(C21 - C22) + .9 * (ABS(C22 - C23) + .9 * (ABS(C23 - C24) + .9 * (ABS(C24 - C25) + .9 * (ABS(C25 - C26) + .9 * (ABS(C26 - C27) + .9 * (ABS(C27 - C28) + .9 * (ABS(C28 - C29) + .9 * (ABS(C29 - C30) + .9 * (ABS(C30 - C31) + .9 * (ABS(C31 - C32) + .9 * (ABS(C32 - C33) + .9 * (ABS(C33 - C34) + .9 * (ABS(C34 - C35) + .9 * (ABS(C35 - C36) + .9 * (ABS(C36 - C37) + .9 * (ABS(C37 - C38) + .9 * (ABS(C38 - C39) + .9 * (ABS(C39 - C40) + .9 * (ABS(C40 - C41) + .9 * (ABS(C41 - C42) + .9 * (ABS(C42 - C43) + .9 * (ABS(C43 - C44) + .9 * (ABS(C44 - C45) + .9 * (ABS(C45 - C46) + .9 * (ABS(C46 - C47) + .9 * (ABS(C47 - C48) + .9 * (ABS(C48 - C49) + .9 * (ABS(C49 - C50) + .9 * (ABS(C50 - C51) + .9 * (ABS(C51 - C52) + .9 * (ABS(C52 - C53) + .9 * (ABS(C53 - C54) + .9 * (ABS(C54 - C55) + .9 * (ABS(C55 - C56) + .9 * (ABS(C56 - C57) + .9 * (ABS(C57 - C58) + .9 * (ABS(C58 - C59) + .9 * (ABS(C59 - C60) + .9 * (ABS(C60 - C61) + .9 * (ABS(C61 - C62) + .9 * (ABS(C62 - C63) + .9 * (ABS(C63 - C64) + .9 * (ABS(C64 - C65))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 > 30 AND 50 * (C1 - XAVGC19.2) / 10 / (.100118041018317 * (ABS(C1 - C2) + .9 * (ABS(C2 - C3) + .9 * (ABS(C3 - C4) + .9 * (ABS(C4 - C5) + .9 * (ABS(C5 - C6) + .9 * (ABS(C6 - C7) + .9 * (ABS(C7 - C8) + .9 * (ABS(C8 - C9) + .9 * (ABS(C9 - C10) + .9 * (ABS(C10 - C11) + .9 * (ABS(C11 - C12) + .9 * (ABS(C12 - C13) + .9 * (ABS(C13 - C14) + .9 * (ABS(C14 - C15) + .9 * (ABS(C15 - C16) + .9 * (ABS(C16 - C17) + .9 * (ABS(C17 - C18) + .9 * (ABS(C18 - C19) + .9 * (ABS(C19 - C20) + .9 * (ABS(C20 - C21) + .9 * (ABS(C21 - C22) + .9 * (ABS(C22 - C23) + .9 * (ABS(C23 - C24) + .9 * (ABS(C24 - C25) + .9 * (ABS(C25 - C26) + .9 * (ABS(C26 - C27) + .9 * (ABS(C27 - C28) + .9 * (ABS(C28 - C29) + .9 * (ABS(C29 - C30) + .9 * (ABS(C30 - C31) + .9 * (ABS(C31 - C32) + .9 * (ABS(C32 - C33) + .9 * (ABS(C33 - C34) + .9 * (ABS(C34 - C35) + .9 * (ABS(C35 - C36) + .9 * (ABS(C36 - C37) + .9 * (ABS(C37 - C38) + .9 * (ABS(C38 - C39) + .9 * (ABS(C39 - C40) + .9 * (ABS(C40 - C41) + .9 * (ABS(C41 - C42) + .9 * (ABS(C42 - C43) + .9 * (ABS(C43 - C44) + .9 * (ABS(C44 - C45) + .9 * (ABS(C45 - C46) + .9 * (ABS(C46 - C47) + .9 * (ABS(C47 - C48) + .9 * (ABS(C48 - C49) + .9 * (ABS(C49 - C50) + .9 * (ABS(C50 - C51) + .9 * (ABS(C51 - C52) + .9 * (ABS(C52 - C53) + .9 * (ABS(C53 - C54) + .9 * (ABS(C54 - C55) + .9 * (ABS(C55 - C56) + .9 * (ABS(C56 - C57) + .9 * (ABS(C57 - C58) + .9 * (ABS(C58 - C59) + .9 * (ABS(C59 - C60) + .9 * (ABS(C60 - C61) + .9 * (ABS(C61 - C62) + .9 * (ABS(C62 - C63) + .9 * (ABS(C63 - C64) + .9 * (ABS(C64 - C65)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 <= 30
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |