| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 12/2/2004
Posts: 29
|
I want to sort stocks by RSI 7 for daily, weekly, and monthly charts. Is there a way to have all 3 RSI's be incorporated into a scan that would tell me which stocks are below 30 or above 70 for all three measures?
I don't understand why RSI here asks for a period, and an averaging period. Can't I just do RSI 7 period and not average?
Thanks in advance. jfgunter
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (jfgunter) I don't understand why RSI here asks for a period, and an averaging period. Can't I just do RSI 7 period and not average?
Yes. This is normally done if Use Wilders Smoothing is checked. Set the Avg Period to 1 and it won't matter if the Average Type is set to Simple or Exponential.
QUOTE (jfgunter) I want to sort stocks by RSI 7 for daily, weekly, and monthly charts. Is there a way to have all 3 RSI's be incorporated into a scan that would tell me which stocks are below 30 or above 70 for all three measures?
I'm going to provide Daily, Weekly and Monthly Wilder's Smoothed versions of a 7-Period RSI:
Wilders Smoothed RSI7:
100 - (100 / (1 + (((C > C1) * (C1 - C) + 6 / 7 * ((C1 > C2) * (C2 - C1) + 6 / 7 * ((C2 > C3) * (C3 - C2) + 6 / 7 * ((C3 > C4) * (C4 - C3) + 6 / 7 * ((C4 > C5) * (C5 - C4) + 6 / 7 * ((C5 > C6) * (C6 - C5) + 6 / 7 * ((C6 > C7) * (C7 - C6) + 6 / 7 * ((C7 > C8) * (C8 - C7) + 6 / 7 * ((C8 > C9) * (C9 - C8) + 6 / 7 * ((C9 > C10) * (C10 - C9) + 6 / 7 * ((C10 > C11) * (C11 - C10) + 6 / 7 * ((C11 > C12) * (C12 - C11) + 6 / 7 * ((C12 > C13) * (C13 - C12) + 6 / 7 * ((C13 > C14) * (C14 - C13) + 6 / 7 * ((C14 > C15) * (C15 - C14) + 6 / 7 * ((C15 > C16) * (C16 - C15) + 6 / 7 * ((C16 > C17) * (C17 - C16) + 6 / 7 * ((C17 > C18) * (C18 - C17) + 6 / 7 * ((C18 > C19) * (C19 - C18) + 6 / 7 * ((C19 > C20) * (C20 - C19) + 6 / 7 * ((C20 > C21) * (C21 - C20) + 6 / 7 * ((C21 > C22) * (C22 - C21) + 6 / 7 * ((C22 > C23) * (C23 - C22) + 6 / 7 * ((C23 > C24) * (C24 - C23) + 6 / 7 * ((C24 > C25) * (C25 - C24) + 6 / 7 * ((C25 > C26) * (C26 - C25) + 6 / 7 * ((C26 > C27) * (C27 - C26) + 6 / 7 * ((C27 > C28) * (C28 - C27) + 6 / 7 * ((C28 > C29) * (C29 - C28) + 6 / 7 * ((C29 > C30) * (C30 - C29) + 6 / 7 * ((C30 > C31) * (C31 - C30) + 6 / 7 * ((C31 > C32) * (C32 - C31) + 6 / 7 * ((C32 > C33) * (C33 - C32) + 6 / 7 * ((C33 > C34) * (C34 - C33) + 6 / 7 * ((C34 > C35) * (C35 - C34) + 6 / 7 * ((C35 > C36) * (C36 - C35) + 6 / 7 * ((C36 > C37) * (C37 - C36) + 6 / 7 * ((C37 > C38) * (C38 - C37) + 6 / 7 * ((C38 > C39) * (C39 - C38) + 6 / 7 * ((C39 > C40) * (C40 - C39) + 6 / 7 * ((C40 > C41) * (C41 - C40) + 6 / 7 * ((C41 > C42) * (C42 - C41) + 6 / 7 * ((C42 > C43) * (C43 - C42) + 6 / 7 * ((C43 > C44) * (C44 - C43) + 6 / 7 * ((C44 > C45) * (C45 - C44)))))))))))))))))))))))))))))))))))))))))))))) / ((C < C1) * (C - C1) + 6 / 7 * ((C1 < C2) * (C1 - C2) + 6 / 7 * ((C2 < C3) * (C2 - C3) + 6 / 7 * ((C3 < C4) * (C3 - C4) + 6 / 7 * ((C4 < C5) * (C4 - C5) + 6 / 7 * ((C5 < C6) * (C5 - C6) + 6 / 7 * ((C6 < C7) * (C6 - C7) + 6 / 7 * ((C7 < C8) * (C7 - C8) + 6 / 7 * ((C8 < C9) * (C8 - C9) + 6 / 7 * ((C9 < C10) * (C9 - C10) + 6 / 7 * ((C10 < C11) * (C10 - C11) + 6 / 7 * ((C11 < C12) * (C11 - C12) + 6 / 7 * ((C12 < C13) * (C12 - C13) + 6 / 7 * ((C13 < C14) * (C13 - C14) + 6 / 7 * ((C14 < C15) * (C14 - C15) + 6 / 7 * ((C15 < C16) * (C15 - C16) + 6 / 7 * ((C16 < C17) * (C16 - C17) + 6 / 7 * ((C17 < C18) * (C17 - C18) + 6 / 7 * ((C18 < C19) * (C18 - C19) + 6 / 7 * ((C19 < C20) * (C19 - C20) + 6 / 7 * ((C20 < C21) * (C20 - C21) + 6 / 7 * ((C21 < C22) * (C21 - C22) + 6 / 7 * ((C22 < C23) * (C22 - C23) + 6 / 7 * ((C23 < C24) * (C23 - C24) + 6 / 7 * ((C24 < C25) * (C24 - C25) + 6 / 7 * ((C25 < C26) * (C25 - C26) + 6 / 7 * ((C26 < C27) * (C26 - C27) + 6 / 7 * ((C27 < C28) * (C27 - C28) + 6 / 7 * ((C28 < C29) * (C28 - C29) + 6 / 7 * ((C29 < C30) * (C29 - C30) + 6 / 7 * ((C30 < C31) * (C30 - C31) + 6 / 7 * ((C31 < C32) * (C31 - C32) + 6 / 7 * ((C32 < C33) * (C32 - C33) + 6 / 7 * ((C33 < C34) * (C33 - C34) + 6 / 7 * ((C34 < C35) * (C34 - C35) + 6 / 7 * ((C35 < C36) * (C35 - C36) + 6 / 7 * ((C36 < C37) * (C36 - C37) + 6 / 7 * ((C37 < C38) * (C37 - C38) + 6 / 7 * ((C38 < C39) * (C38 - C39) + 6 / 7 * ((C39 < C40) * (C39 - C40) + 6 / 7 * ((C40 < C41) * (C40 - C41) + 6 / 7 * ((C41 < C42) * (C41 - C42) + 6 / 7 * ((C42 < C43) * (C42 - C43) + 6 / 7 * ((C43 < C44) * (C43 - C44) + 6 / 7 * ((C44 < C45) * (C44 - C45)))))))))))))))))))))))))))))))))))))))))))))))))
Wilders Smoothed RSI7 Weekly:
100 - (100 / (1 + (((C > C5) * (C5 - C) + 6 / 7 * ((C5 > C10) * (C10 - C5) + 6 / 7 * ((C10 > C15) * (C15 - C10) + 6 / 7 * ((C15 > C20) * (C20 - C15) + 6 / 7 * ((C20 > C25) * (C25 - C20) + 6 / 7 * ((C25 > C30) * (C30 - C25) + 6 / 7 * ((C30 > C35) * (C35 - C30) + 6 / 7 * ((C35 > C40) * (C40 - C35) + 6 / 7 * ((C40 > C45) * (C45 - C40) + 6 / 7 * ((C45 > C50) * (C50 - C45) + 6 / 7 * ((C50 > C55) * (C55 - C50) + 6 / 7 * ((C55 > C60) * (C60 - C55) + 6 / 7 * ((C60 > C65) * (C65 - C60) + 6 / 7 * ((C65 > C70) * (C70 - C65) + 6 / 7 * ((C70 > C75) * (C75 - C70) + 6 / 7 * ((C75 > C80) * (C80 - C75) + 6 / 7 * ((C80 > C85) * (C85 - C80) + 6 / 7 * ((C85 > C90) * (C90 - C85) + 6 / 7 * ((C90 > C95) * (C95 - C90) + 6 / 7 * ((C95 > C100) * (C100 - C95) + 6 / 7 * ((C100 > C105) * (C105 - C100) + 6 / 7 * ((C105 > C110) * (C110 - C105) + 6 / 7 * ((C110 > C115) * (C115 - C110) + 6 / 7 * ((C115 > C120) * (C120 - C115) + 6 / 7 * ((C120 > C125) * (C125 - C120) + 6 / 7 * ((C125 > C130) * (C130 - C125) + 6 / 7 * ((C130 > C135) * (C135 - C130) + 6 / 7 * ((C135 > C140) * (C140 - C135) + 6 / 7 * ((C140 > C145) * (C145 - C140) + 6 / 7 * ((C145 > C150) * (C150 - C145) + 6 / 7 * ((C150 > C155) * (C155 - C150) + 6 / 7 * ((C155 > C160) * (C160 - C155) + 6 / 7 * ((C160 > C165) * (C165 - C160) + 6 / 7 * ((C165 > C170) * (C170 - C165) + 6 / 7 * ((C170 > C175) * (C175 - C170) + 6 / 7 * ((C175 > C180) * (C180 - C175) + 6 / 7 * ((C180 > C185) * (C185 - C180) + 6 / 7 * ((C185 > C190) * (C190 - C185) + 6 / 7 * ((C190 > C195) * (C195 - C190) + 6 / 7 * ((C195 > C200) * (C200 - C195) + 6 / 7 * ((C200 > C205) * (C205 - C200) + 6 / 7 * ((C205 > C210) * (C210 - C205) + 6 / 7 * ((C210 > C215) * (C215 - C210) + 6 / 7 * ((C215 > C220) * (C220 - C215) + 6 / 7 * ((C220 > C225) * (C225 - C220)))))))))))))))))))))))))))))))))))))))))))))) / ((C < C5) * (C - C5) + 6 / 7 * ((C5 < C10) * (C5 - C10) + 6 / 7 * ((C10 < C15) * (C10 - C15) + 6 / 7 * ((C15 < C20) * (C15 - C20) + 6 / 7 * ((C20 < C25) * (C20 - C25) + 6 / 7 * ((C25 < C30) * (C25 - C30) + 6 / 7 * ((C30 < C35) * (C30 - C35) + 6 / 7 * ((C35 < C40) * (C35 - C40) + 6 / 7 * ((C40 < C45) * (C40 - C45) + 6 / 7 * ((C45 < C50) * (C45 - C50) + 6 / 7 * ((C50 < C55) * (C50 - C55) + 6 / 7 * ((C55 < C60) * (C55 - C60) + 6 / 7 * ((C60 < C65) * (C60 - C65) + 6 / 7 * ((C65 < C70) * (C65 - C70) + 6 / 7 * ((C70 < C75) * (C70 - C75) + 6 / 7 * ((C75 < C80) * (C75 - C80) + 6 / 7 * ((C80 < C85) * (C80 - C85) + 6 / 7 * ((C85 < C90) * (C85 - C90) + 6 / 7 * ((C90 < C95) * (C90 - C95) + 6 / 7 * ((C95 < C100) * (C95 - C100) + 6 / 7 * ((C100 < C105) * (C100 - C105) + 6 / 7 * ((C105 < C110) * (C105 - C110) + 6 / 7 * ((C110 < C115) * (C110 - C115) + 6 / 7 * ((C115 < C120) * (C115 - C120) + 6 / 7 * ((C120 < C125) * (C120 - C125) + 6 / 7 * ((C125 < C130) * (C125 - C130) + 6 / 7 * ((C130 < C135) * (C130 - C135) + 6 / 7 * ((C135 < C140) * (C135 - C140) + 6 / 7 * ((C140 < C145) * (C140 - C145) + 6 / 7 * ((C145 < C150) * (C145 - C150) + 6 / 7 * ((C150 < C155) * (C150 - C155) + 6 / 7 * ((C155 < C160) * (C155 - C160) + 6 / 7 * ((C160 < C165) * (C160 - C165) + 6 / 7 * ((C165 < C170) * (C165 - C170) + 6 / 7 * ((C170 < C175) * (C170 - C175) + 6 / 7 * ((C175 < C180) * (C175 - C180) + 6 / 7 * ((C180 < C185) * (C180 - C185) + 6 / 7 * ((C185 < C190) * (C185 - C190) + 6 / 7 * ((C190 < C195) * (C190 - C195) + 6 / 7 * ((C195 < C200) * (C195 - C200) + 6 / 7 * ((C200 < C205) * (C200 - C205) + 6 / 7 * ((C205 < C210) * (C205 - C210) + 6 / 7 * ((C210 < C215) * (C210 - C215) + 6 / 7 * ((C215 < C220) * (C215 - C220) + 6 / 7 * ((C220 < C225) * (C220 - C225)))))))))))))))))))))))))))))))))))))))))))))))))
Wilders Smoothed RSI Monthly:
100 - (100 / (1 + (((C > C21) * (C21 - C) + 6 / 7 * ((C21 > C42) * (C42 - C21) + 6 / 7 * ((C42 > C63) * (C63 - C42) + 6 / 7 * ((C63 > C84) * (C84 - C63) + 6 / 7 * ((C84 > C105) * (C105 - C84) + 6 / 7 * ((C105 > C126) * (C126 - C105) + 6 / 7 * ((C126 > C147) * (C147 - C126) + 6 / 7 * ((C147 > C168) * (C168 - C147) + 6 / 7 * ((C168 > C189) * (C189 - C168) + 6 / 7 * ((C189 > C210) * (C210 - C189) + 6 / 7 * ((C210 > C231) * (C231 - C210) + 6 / 7 * ((C231 > C252) * (C252 - C231) + 6 / 7 * ((C252 > C273) * (C273 - C252) + 6 / 7 * ((C273 > C294) * (C294 - C273) + 6 / 7 * ((C294 > C315) * (C315 - C294) + 6 / 7 * ((C315 > C336) * (C336 - C315) + 6 / 7 * ((C336 > C357) * (C357 - C336) + 6 / 7 * ((C357 > C378) * (C378 - C357) + 6 / 7 * ((C378 > C399) * (C399 - C378) + 6 / 7 * ((C399 > C420) * (C420 - C399) + 6 / 7 * ((C420 > C441) * (C441 - C420) + 6 / 7 * ((C441 > C462) * (C462 - C441) + 6 / 7 * ((C462 > C483) * (C483 - C462) + 6 / 7 * ((C483 > C504) * (C504 - C483) + 6 / 7 * ((C504 > C525) * (C525 - C504) + 6 / 7 * ((C525 > C546) * (C546 - C525) + 6 / 7 * ((C546 > C567) * (C567 - C546) + 6 / 7 * ((C567 > C588) * (C588 - C567) + 6 / 7 * ((C588 > C609) * (C609 - C588) + 6 / 7 * ((C609 > C630) * (C630 - C609) + 6 / 7 * ((C630 > C651) * (C651 - C630) + 6 / 7 * ((C651 > C672) * (C672 - C651) + 6 / 7 * ((C672 > C693) * (C693 - C672) + 6 / 7 * ((C693 > C714) * (C714 - C693) + 6 / 7 * ((C714 > C735) * (C735 - C714) + 6 / 7 * ((C735 > C756) * (C756 - C735) + 6 / 7 * ((C756 > C777) * (C777 - C756) + 6 / 7 * ((C777 > C798) * (C798 - C777) + 6 / 7 * ((C798 > C819) * (C819 - C798) + 6 / 7 * ((C819 > C840) * (C840 - C819) + 6 / 7 * ((C840 > C861) * (C861 - C840) + 6 / 7 * ((C861 > C882) * (C882 - C861) + 6 / 7 * ((C882 > C903) * (C903 - C882) + 6 / 7 * ((C903 > C924) * (C924 - C903) + 6 / 7 * ((C924 > C945) * (C945 - C924)))))))))))))))))))))))))))))))))))))))))))))) / ((C < C21) * (C - C21) + 6 / 7 * ((C21 < C42) * (C21 - C42) + 6 / 7 * ((C42 < C63) * (C42 - C63) + 6 / 7 * ((C63 < C84) * (C63 - C84) + 6 / 7 * ((C84 < C105) * (C84 - C105) + 6 / 7 * ((C105 < C126) * (C105 - C126) + 6 / 7 * ((C126 < C147) * (C126 - C147) + 6 / 7 * ((C147 < C168) * (C147 - C168) + 6 / 7 * ((C168 < C189) * (C168 - C189) + 6 / 7 * ((C189 < C210) * (C189 - C210) + 6 / 7 * ((C210 < C231) * (C210 - C231) + 6 / 7 * ((C231 < C252) * (C231 - C252) + 6 / 7 * ((C252 < C273) * (C252 - C273) + 6 / 7 * ((C273 < C294) * (C273 - C294) + 6 / 7 * ((C294 < C315) * (C294 - C315) + 6 / 7 * ((C315 < C336) * (C315 - C336) + 6 / 7 * ((C336 < C357) * (C336 - C357) + 6 / 7 * ((C357 < C378) * (C357 - C378) + 6 / 7 * ((C378 < C399) * (C378 - C399) + 6 / 7 * ((C399 < C420) * (C399 - C420) + 6 / 7 * ((C420 < C441) * (C420 - C441) + 6 / 7 * ((C441 < C462) * (C441 - C462) + 6 / 7 * ((C462 < C483) * (C462 - C483) + 6 / 7 * ((C483 < C504) * (C483 - C504) + 6 / 7 * ((C504 < C525) * (C504 - C525) + 6 / 7 * ((C525 < C546) * (C525 - C546) + 6 / 7 * ((C546 < C567) * (C546 - C567) + 6 / 7 * ((C567 < C588) * (C567 - C588) + 6 / 7 * ((C588 < C609) * (C588 - C609) + 6 / 7 * ((C609 < C630) * (C609 - C630) + 6 / 7 * ((C630 < C651) * (C630 - C651) + 6 / 7 * ((C651 < C672) * (C651 - C672) + 6 / 7 * ((C672 < C693) * (C672 - C693) + 6 / 7 * ((C693 < C714) * (C693 - C714) + 6 / 7 * ((C714 < C735) * (C714 - C735) + 6 / 7 * ((C735 < C756) * (C735 - C756) + 6 / 7 * ((C756 < C777) * (C756 - C777) + 6 / 7 * ((C777 < C798) * (C777 - C798) + 6 / 7 * ((C798 < C819) * (C798 - C819) + 6 / 7 * ((C819 < C840) * (C819 - C840) + 6 / 7 * ((C840 < C861) * (C840 - C861) + 6 / 7 * ((C861 < C882) * (C861 - C882) + 6 / 7 * ((C882 < C903) * (C882 - C903) + 6 / 7 * ((C903 < C924) * (C903 - C924) + 6 / 7 * ((C924 < C945) * (C924 - C945)))))))))))))))))))))))))))))))))))))))))))))))))
You can then create two EasyScans:
RSI7 < 30 for DWM:
Select New | New EasyScan:
- Watchlist: All Stocks
- Wilders Smoothed RSI7: Value: Min to 30
- Wilders Smoothed RSI7 Weekly: Value: Min to 30
- Wilders Smoothed RSI7 Monthly: Value: Min to 30
RSI7 > 70 for DWM
Select New | New EasyScan:
- Watchlist: All Stocks
- Wilders Smoothed RSI7: Value: 70 to Max
- Wilders Smoothed RSI7 Weekly: Value: 70 to Max
- Wilders Smoothed RSI7 Monthly: Value: 70 to Max
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
Constructing more versatile and reusable Personal Criteria Formulas
Handy PCF example formulas to help you learn the syntax of PCFs!
Personal Criteria Language Function List
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/2/2004
Posts: 29
|
Wow, Thanks! - I take it I paste each one of these long formulae in as a PCF, and having created the PCF's I simply build them into the two easyscans. Is that correct?
Thanks again....
jfgunter
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
That's correct.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 8/6/2005
Posts: 40
|
Hi Bruce,
I tried to plot Wilder's RSI indicator (RSI=7, Use smoothing, Avg=1) and your daily RSI7 as a custom indicator. The indicators do not quite fit together. Is this because of rounding issues or some other problems?
Thanks!
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
They are on different scales. The Custom Indictator scales to the highest and lowest values of the visible chart. The RSI built-in indicator is forced on a 0 to 100 scale.
- Craig
Here to Help!
|
|
Registered User
Joined: 8/6/2005
Posts: 40
|
Craig,
The values for the current day are also different. Is this due to way Custom Indicator is scaled?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Eternum,
There are two issues. Craig has already talked about the scaling issue. This issue only applies to how the lines are displayed, and not to the actual values.
The other issue is that a Wilder's Smoothed RSI uses Exponential Moving Averages in the calculation of the numerator and denominator portions of the RSI calculation. The charted RSI does not use the all of the available history to calculate these EMAs. The provided formula does not use all of the available history to calculate these EMAs. They use different amounts of history. Even if they didn't, the methods used to create these EMA approximations are different. There can be a significant difference in the amount of weight given the oldest data used for each calculation (if "enough" data is used for both formulas, this stops making a difference).
You may wish to try this longer version that uses more data to see if it meets your needs better (it's also been re-arranged a bit to make the formula more efficient):
100 * ((C > C1) * (C1 - C) + 6 / 7 * ((C1 > C2) * (C2 - C1) + 6 / 7 * ((C2 > C3) * (C3 - C2) + 6 / 7 * ((C3 > C4) * (C4 - C3) + 6 / 7 * ((C4 > C5) * (C5 - C4) + 6 / 7 * ((C5 > C6) * (C6 - C5) + 6 / 7 * ((C6 > C7) * (C7 - C6) + 6 / 7 * ((C7 > C8) * (C8 - C7) + 6 / 7 * ((C8 > C9) * (C9 - C8) + 6 / 7 * ((C9 > C10) * (C10 - C9) + 6 / 7 * ((C10 > C11) * (C11 - C10) + 6 / 7 * ((C11 > C12) * (C12 - C11) + 6 / 7 * ((C12 > C13) * (C13 - C12) + 6 / 7 * ((C13 > C14) * (C14 - C13) + 6 / 7 * ((C14 > C15) * (C15 - C14) + 6 / 7 * ((C15 > C16) * (C16 - C15) + 6 / 7 * ((C16 > C17) * (C17 - C16) + 6 / 7 * ((C17 > C18) * (C18 - C17) + 6 / 7 * ((C18 > C19) * (C19 - C18) + 6 / 7 * ((C19 > C20) * (C20 - C19) + 6 / 7 * ((C20 > C21) * (C21 - C20) + 6 / 7 * ((C21 > C22) * (C22 - C21) + 6 / 7 * ((C22 > C23) * (C23 - C22) + 6 / 7 * ((C23 > C24) * (C24 - C23) + 6 / 7 * ((C24 > C25) * (C25 - C24) + 6 / 7 * ((C25 > C26) * (C26 - C25) + 6 / 7 * ((C26 > C27) * (C27 - C26) + 6 / 7 * ((C27 > C28) * (C28 - C27) + 6 / 7 * ((C28 > C29) * (C29 - C28) + 6 / 7 * ((C29 > C30) * (C30 - C29) + 6 / 7 * ((C30 > C31) * (C31 - C30) + 6 / 7 * ((C31 > C32) * (C32 - C31) + 6 / 7 * ((C32 > C33) * (C33 - C32) + 6 / 7 * ((C33 > C34) * (C34 - C33) + 6 / 7 * ((C34 > C35) * (C35 - C34) + 6 / 7 * ((C35 > C36) * (C36 - C35) + 6 / 7 * ((C36 > C37) * (C37 - C36) + 6 / 7 * ((C37 > C38) * (C38 - C37) + 6 / 7 * ((C38 > C39) * (C39 - C38) + 6 / 7 * ((C39 > C40) * (C40 - C39) + 6 / 7 * ((C40 > C41) * (C41 - C40) + 6 / 7 * ((C41 > C42) * (C42 - C41) + 6 / 7 * ((C42 > C43) * (C43 - C42) + 6 / 7 * ((C43 > C44) * (C44 - C43) + 6 / 7 * ((C44 > C45) * (C45 - C44) + 6 / 7 * ((C45 > C46) * (C46 - C45) + 6 / 7 * ((C46 > C47) * (C47 - C46) + 6 / 7 * ((C47 > C48) * (C48 - C47) + 6 / 7 * ((C48 > C49) * (C49 - C48) + 6 / 7 * ((C49 > C50) * (C50 - C49) + 6 / 7 * ((C50 > C51) * (C51 - C50) + 6 / 7 * ((C51 > C52) * (C52 - C51) + 6 / 7 * ((C52 > C53) * (C53 - C52) + 6 / 7 * ((C53 > C54) * (C54 - C53) + 6 / 7 * ((C54 > C55) * (C55 - C54) + 6 / 7 * ((C55 > C56) * (C56 - C55) + 6 / 7 * ((C56 > C57) * (C57 - C56) + 6 / 7 * ((C57 > C58) * (C58 - C57) + 6 / 7 * ((C58 > C59) * (C59 - C58) + 6 / 7 * ((C59 > C60) * (C60 - C59) + 6 / 7 * ((C60 > C61) * (C61 - C60) + 6 / 7 * ((C61 > C62) * (C62 - C61) + 6 / 7 * ((C62 > C63) * (C63 - C62) + 6 / 7 * ((C63 > C64) * (C64 - C63) + 6 / 7 * ((C64 > C65) * (C65 - C64)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(C - C1) + 6 / 7 * (ABS(C1 - C2) + 6 / 7 * (ABS(C2 - C3) + 6 / 7 * (ABS(C3 - C4) + 6 / 7 * (ABS(C4 - C5) + 6 / 7 * (ABS(C5 - C6) + 6 / 7 * (ABS(C6 - C7) + 6 / 7 * (ABS(C7 - C8) + 6 / 7 * (ABS(C8 - C9) + 6 / 7 * (ABS(C9 - C10) + 6 / 7 * (ABS(C10 - C11) + 6 / 7 * (ABS(C11 - C12) + 6 / 7 * (ABS(C12 - C13) + 6 / 7 * (ABS(C13 - C14) + 6 / 7 * (ABS(C14 - C15) + 6 / 7 * (ABS(C15 - C16) + 6 / 7 * (ABS(C16 - C17) + 6 / 7 * (ABS(C17 - C18) + 6 / 7 * (ABS(C18 - C19) + 6 / 7 * (ABS(C19 - C20) + 6 / 7 * (ABS(C20 - C21) + 6 / 7 * (ABS(C21 - C22) + 6 / 7 * (ABS(C22 - C23) + 6 / 7 * (ABS(C23 - C24) + 6 / 7 * (ABS(C24 - C25) + 6 / 7 * (ABS(C25 - C26) + 6 / 7 * (ABS(C26 - C27) + 6 / 7 * (ABS(C27 - C28) + 6 / 7 * (ABS(C28 - C29) + 6 / 7 * (ABS(C29 - C30) + 6 / 7 * (ABS(C30 - C31) + 6 / 7 * (ABS(C31 - C32) + 6 / 7 * (ABS(C32 - C33) + 6 / 7 * (ABS(C33 - C34) + 6 / 7 * (ABS(C34 - C35) + 6 / 7 * (ABS(C35 - C36) + 6 / 7 * (ABS(C36 - C37) + 6 / 7 * (ABS(C37 - C38) + 6 / 7 * (ABS(C38 - C39) + 6 / 7 * (ABS(C39 - C40) + 6 / 7 * (ABS(C40 - C41) + 6 / 7 * (ABS(C41 - C42) + 6 / 7 * (ABS(C42 - C43) + 6 / 7 * (ABS(C43 - C44) + 6 / 7 * (ABS(C44 - C45) + 6 / 7 * (ABS(C45 - C46) + 6 / 7 * (ABS(C46 - C47) + 6 / 7 * (ABS(C47 - C48) + 6 / 7 * (ABS(C48 - C49) + 6 / 7 * (ABS(C49 - C50) + 6 / 7 * (ABS(C50 - C51) + 6 / 7 * (ABS(C51 - C52) + 6 / 7 * (ABS(C52 - C53) + 6 / 7 * (ABS(C53 - C54) + 6 / 7 * (ABS(C54 - C55) + 6 / 7 * (ABS(C55 - C56) + 6 / 7 * (ABS(C56 - C57) + 6 / 7 * (ABS(C57 - C58) + 6 / 7 * (ABS(C58 - C59) + 6 / 7 * (ABS(C59 - C60) + 6 / 7 * (ABS(C60 - C61) + 6 / 7 * (ABS(C61 - C62) + 6 / 7 * (ABS(C62 - C63) + 6 / 7 * (ABS(C63 - C64) + 6 / 7 * (ABS(C64 - C65))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 8/6/2005
Posts: 40
|
Bruce,
The result is absolutely beautiful (biggest difference I found so far is 0.01)! Would you be able to do the same magic to RSI7 Weekly and RSI7 Monthly you posted earlier (when you have a chance)?
Thanks!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Eternum,
Please try the following:
Weekly:
100 * ((C > C5) * (C5 - C) + 6 / 7 * ((C5 > C10) * (C10 - C5) + 6 / 7 * ((C10 > C15) * (C15 - C10) + 6 / 7 * ((C15 > C20) * (C20 - C15) + 6 / 7 * ((C20 > C25) * (C25 - C20) + 6 / 7 * ((C25 > C30) * (C30 - C25) + 6 / 7 * ((C30 > C35) * (C35 - C30) + 6 / 7 * ((C35 > C40) * (C40 - C35) + 6 / 7 * ((C40 > C45) * (C45 - C40) + 6 / 7 * ((C45 > C50) * (C50 - C45) + 6 / 7 * ((C50 > C55) * (C55 - C50) + 6 / 7 * ((C55 > C60) * (C60 - C55) + 6 / 7 * ((C60 > C65) * (C65 - C60) + 6 / 7 * ((C65 > C70) * (C70 - C65) + 6 / 7 * ((C70 > C75) * (C75 - C70) + 6 / 7 * ((C75 > C80) * (C80 - C75) + 6 / 7 * ((C80 > C85) * (C85 - C80) + 6 / 7 * ((C85 > C90) * (C90 - C85) + 6 / 7 * ((C90 > C95) * (C95 - C90) + 6 / 7 * ((C95 > C100) * (C100 - C95) + 6 / 7 * ((C100 > C105) * (C105 - C100) + 6 / 7 * ((C105 > C110) * (C110 - C105) + 6 / 7 * ((C110 > C115) * (C115 - C110) + 6 / 7 * ((C115 > C120) * (C120 - C115) + 6 / 7 * ((C120 > C125) * (C125 - C120) + 6 / 7 * ((C125 > C130) * (C130 - C125) + 6 / 7 * ((C130 > C135) * (C135 - C130) + 6 / 7 * ((C135 > C140) * (C140 - C135) + 6 / 7 * ((C140 > C145) * (C145 - C140) + 6 / 7 * ((C145 > C150) * (C150 - C145) + 6 / 7 * ((C150 > C155) * (C155 - C150) + 6 / 7 * ((C155 > C160) * (C160 - C155) + 6 / 7 * ((C160 > C165) * (C165 - C160) + 6 / 7 * ((C165 > C170) * (C170 - C165) + 6 / 7 * ((C170 > C175) * (C175 - C170) + 6 / 7 * ((C175 > C180) * (C180 - C175) + 6 / 7 * ((C180 > C185) * (C185 - C180) + 6 / 7 * ((C185 > C190) * (C190 - C185) + 6 / 7 * ((C190 > C195) * (C195 - C190) + 6 / 7 * ((C195 > C200) * (C200 - C195) + 6 / 7 * ((C200 > C205) * (C205 - C200) + 6 / 7 * ((C205 > C210) * (C210 - C205) + 6 / 7 * ((C210 > C215) * (C215 - C210) + 6 / 7 * ((C215 > C220) * (C220 - C215) + 6 / 7 * ((C220 > C225) * (C225 - C220) + 6 / 7 * ((C225 > C230) * (C230 - C225) + 6 / 7 * ((C230 > C235) * (C235 - C230) + 6 / 7 * ((C235 > C240) * (C240 - C235) + 6 / 7 * ((C240 > C245) * (C245 - C240) + 6 / 7 * ((C245 > C250) * (C250 - C245) + 6 / 7 * ((C250 > C255) * (C255 - C250) + 6 / 7 * ((C255 > C260) * (C260 - C255) + 6 / 7 * ((C260 > C265) * (C265 - C260) + 6 / 7 * ((C265 > C270) * (C270 - C265) + 6 / 7 * ((C270 > C275) * (C275 - C270) + 6 / 7 * ((C275 > C280) * (C280 - C275) + 6 / 7 * ((C280 > C285) * (C285 - C280) + 6 / 7 * ((C285 > C290) * (C290 - C285) + 6 / 7 * ((C290 > C295) * (C295 - C290) + 6 / 7 * ((C295 > C300) * (C300 - C295) + 6 / 7 * ((C300 > C305) * (C305 - C300) + 6 / 7 * ((C305 > C310) * (C310 - C305) + 6 / 7 * ((C310 > C315) * (C315 - C310) + 6 / 7 * ((C315 > C320) * (C320 - C315) + 6 / 7 * ((C320 > C325) * (C325 - C320)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(C - C5) + 6 / 7 * (ABS(C5 - C10) + 6 / 7 * (ABS(C10 - C15) + 6 / 7 * (ABS(C15 - C20) + 6 / 7 * (ABS(C20 - C25) + 6 / 7 * (ABS(C25 - C30) + 6 / 7 * (ABS(C30 - C35) + 6 / 7 * (ABS(C35 - C40) + 6 / 7 * (ABS(C40 - C45) + 6 / 7 * (ABS(C45 - C50) + 6 / 7 * (ABS(C50 - C55) + 6 / 7 * (ABS(C55 - C60) + 6 / 7 * (ABS(C60 - C65) + 6 / 7 * (ABS(C65 - C70) + 6 / 7 * (ABS(C70 - C75) + 6 / 7 * (ABS(C75 - C80) + 6 / 7 * (ABS(C80 - C85) + 6 / 7 * (ABS(C85 - C90) + 6 / 7 * (ABS(C90 - C95) + 6 / 7 * (ABS(C95 - C100) + 6 / 7 * (ABS(C100 - C105) + 6 / 7 * (ABS(C105 - C110) + 6 / 7 * (ABS(C110 - C115) + 6 / 7 * (ABS(C115 - C120) + 6 / 7 * (ABS(C120 - C125) + 6 / 7 * (ABS(C125 - C130) + 6 / 7 * (ABS(C130 - C135) + 6 / 7 * (ABS(C135 - C140) + 6 / 7 * (ABS(C140 - C145) + 6 / 7 * (ABS(C145 - C150) + 6 / 7 * (ABS(C150 - C155) + 6 / 7 * (ABS(C155 - C160) + 6 / 7 * (ABS(C160 - C165) + 6 / 7 * (ABS(C165 - C170) + 6 / 7 * (ABS(C170 - C175) + 6 / 7 * (ABS(C175 - C180) + 6 / 7 * (ABS(C180 - C185) + 6 / 7 * (ABS(C185 - C190) + 6 / 7 * (ABS(C190 - C195) + 6 / 7 * (ABS(C195 - C200) + 6 / 7 * (ABS(C200 - C205) + 6 / 7 * (ABS(C205 - C210) + 6 / 7 * (ABS(C210 - C215) + 6 / 7 * (ABS(C215 - C220) + 6 / 7 * (ABS(C220 - C225) + 6 / 7 * (ABS(C225 - C230) + 6 / 7 * (ABS(C230 - C235) + 6 / 7 * (ABS(C235 - C240) + 6 / 7 * (ABS(C240 - C245) + 6 / 7 * (ABS(C245 - C250) + 6 / 7 * (ABS(C250 - C255) + 6 / 7 * (ABS(C255 - C260) + 6 / 7 * (ABS(C260 - C265) + 6 / 7 * (ABS(C265 - C270) + 6 / 7 * (ABS(C270 - C275) + 6 / 7 * (ABS(C275 - C280) + 6 / 7 * (ABS(C280 - C285) + 6 / 7 * (ABS(C285 - C290) + 6 / 7 * (ABS(C290 - C295) + 6 / 7 * (ABS(C295 - C300) + 6 / 7 * (ABS(C300 - C305) + 6 / 7 * (ABS(C305 - C310) + 6 / 7 * (ABS(C310 - C315) + 6 / 7 * (ABS(C315 - C320) + 6 / 7 * (ABS(C320 - C325))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
Monthly:
100 * ((C > C21) * (C21 - C0) + 6 / 7 * ((C21 > C42) * (C42 - C21) + 6 / 7 * ((C42 > C63) * (C63 - C42) + 6 / 7 * ((C63 > C84) * (C84 - C63) + 6 / 7 * ((C84 > C105) * (C105 - C84) + 6 / 7 * ((C105 > C126) * (C126 - C105) + 6 / 7 * ((C126 > C147) * (C147 - C126) + 6 / 7 * ((C147 > C168) * (C168 - C147) + 6 / 7 * ((C168 > C189) * (C189 - C168) + 6 / 7 * ((C189 > C210) * (C210 - C189) + 6 / 7 * ((C210 > C231) * (C231 - C210) + 6 / 7 * ((C231 > C252) * (C252 - C231) + 6 / 7 * ((C252 > C273) * (C273 - C252) + 6 / 7 * ((C273 > C294) * (C294 - C273) + 6 / 7 * ((C294 > C315) * (C315 - C294) + 6 / 7 * ((C315 > C336) * (C336 - C315) + 6 / 7 * ((C336 > C357) * (C357 - C336) + 6 / 7 * ((C357 > C378) * (C378 - C357) + 6 / 7 * ((C378 > C399) * (C399 - C378) + 6 / 7 * ((C399 > C420) * (C420 - C399) + 6 / 7 * ((C420 > C441) * (C441 - C420) + 6 / 7 * ((C441 > C462) * (C462 - C441) + 6 / 7 * ((C462 > C483) * (C483 - C462) + 6 / 7 * ((C483 > C504) * (C504 - C483) + 6 / 7 * ((C504 > C525) * (C525 - C504) + 6 / 7 * ((C525 > C546) * (C546 - C525) + 6 / 7 * ((C546 > C567) * (C567 - C546) + 6 / 7 * ((C567 > C588) * (C588 - C567) + 6 / 7 * ((C588 > C609) * (C609 - C588) + 6 / 7 * ((C609 > C630) * (C630 - C609) + 6 / 7 * ((C630 > C651) * (C651 - C630) + 6 / 7 * ((C651 > C672) * (C672 - C651) + 6 / 7 * ((C672 > C693) * (C693 - C672) + 6 / 7 * ((C693 > C714) * (C714 - C693) + 6 / 7 * ((C714 > C735) * (C735 - C714) + 6 / 7 * ((C735 > C756) * (C756 - C735) + 6 / 7 * ((C756 > C777) * (C777 - C756) + 6 / 7 * ((C777 > C798) * (C798 - C777) + 6 / 7 * ((C798 > C819) * (C819 - C798) + 6 / 7 * ((C819 > C840) * (C840 - C819) + 6 / 7 * ((C840 > C861) * (C861 - C840) + 6 / 7 * ((C861 > C882) * (C882 - C861) + 6 / 7 * ((C882 > C903) * (C903 - C882) + 6 / 7 * ((C903 > C924) * (C924 - C903) + 6 / 7 * ((C924 > C945) * (C945 - C924) + 6 / 7 * ((C945 > C966) * (C966 - C945) + 6 / 7 * ((C966 > C987) * (C987 - C966) + 6 / 7 * ((C987 > C1008) * (C1008 - C987) + 6 / 7 * ((C1008 > C1029) * (C1029 - C1008) + 6 / 7 * ((C1029 > C1050) * (C1050 - C1029) + 6 / 7 * ((C1050 > C1071) * (C1071 - C1050) + 6 / 7 * ((C1071 > C1092) * (C1092 - C1071) + 6 / 7 * ((C1092 > C1113) * (C1113 - C1092) + 6 / 7 * ((C1113 > C1134) * (C1134 - C1113) + 6 / 7 * ((C1134 > C1155) * (C1155 - C1134) + 6 / 7 * ((C1155 > C1176) * (C1176 - C1155) + 6 / 7 * ((C1176 > C1197) * (C1197 - C1176) + 6 / 7 * ((C1197 > C1218) * (C1218 - C1197) + 6 / 7 * ((C1218 > C1239) * (C1239 - C1218) + 6 / 7 * ((C1239 > C1260) * (C1260 - C1239) + 6 / 7 * ((C1260 > C1281) * (C1281 - C1260) + 6 / 7 * ((C1281 > C1302) * (C1302 - C1281) + 6 / 7 * ((C1302 > C1323) * (C1323 - C1302) + 6 / 7 * ((C1323 > C1344) * (C1344 - C1323) + 6 / 7 * ((C1344 > C1365) * (C1365 - C1344)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(C - C21) + 6 / 7 * (ABS(C21 - C42) + 6 / 7 * (ABS(C42 - C63) + 6 / 7 * (ABS(C63 - C84) + 6 / 7 * (ABS(C84 - C105) + 6 / 7 * (ABS(C105 - C126) + 6 / 7 * (ABS(C126 - C147) + 6 / 7 * (ABS(C147 - C168) + 6 / 7 * (ABS(C168 - C189) + 6 / 7 * (ABS(C189 - C210) + 6 / 7 * (ABS(C210 - C231) + 6 / 7 * (ABS(C231 - C252) + 6 / 7 * (ABS(C252 - C273) + 6 / 7 * (ABS(C273 - C294) + 6 / 7 * (ABS(C294 - C315) + 6 / 7 * (ABS(C315 - C336) + 6 / 7 * (ABS(C336 - C357) + 6 / 7 * (ABS(C357 - C378) + 6 / 7 * (ABS(C378 - C399) + 6 / 7 * (ABS(C399 - C420) + 6 / 7 * (ABS(C420 - C441) + 6 / 7 * (ABS(C441 - C462) + 6 / 7 * (ABS(C462 - C483) + 6 / 7 * (ABS(C483 - C504) + 6 / 7 * (ABS(C504 - C525) + 6 / 7 * (ABS(C525 - C546) + 6 / 7 * (ABS(C546 - C567) + 6 / 7 * (ABS(C567 - C588) + 6 / 7 * (ABS(C588 - C609) + 6 / 7 * (ABS(C609 - C630) + 6 / 7 * (ABS(C630 - C651) + 6 / 7 * (ABS(C651 - C672) + 6 / 7 * (ABS(C672 - C693) + 6 / 7 * (ABS(C693 - C714) + 6 / 7 * (ABS(C714 - C735) + 6 / 7 * (ABS(C735 - C756) + 6 / 7 * (ABS(C756 - C777) + 6 / 7 * (ABS(C777 - C798) + 6 / 7 * (ABS(C798 - C819) + 6 / 7 * (ABS(C819 - C840) + 6 / 7 * (ABS(C840 - C861) + 6 / 7 * (ABS(C861 - C882) + 6 / 7 * (ABS(C882 - C903) + 6 / 7 * (ABS(C903 - C924) + 6 / 7 * (ABS(C924 - C945) + 6 / 7 * (ABS(C945 - C966) + 6 / 7 * (ABS(C966 - C987) + 6 / 7 * (ABS(C987 - C1008) + 6 / 7 * (ABS(C1008 - C1029) + 6 / 7 * (ABS(C1029 - C1050) + 6 / 7 * (ABS(C1050 - C1071) + 6 / 7 * (ABS(C1071 - C1092) + 6 / 7 * (ABS(C1092 - C1113) + 6 / 7 * (ABS(C1113 - C1134) + 6 / 7 * (ABS(C1134 - C1155) + 6 / 7 * (ABS(C1155 - C1176) + 6 / 7 * (ABS(C1176 - C1197) + 6 / 7 * (ABS(C1197 - C1218) + 6 / 7 * (ABS(C1218 - C1239) + 6 / 7 * (ABS(C1239 - C1260) + 6 / 7 * (ABS(C1260 - C1281) + 6 / 7 * (ABS(C1281 - C1302) + 6 / 7 * (ABS(C1302 - C1323) + 6 / 7 * (ABS(C1323 - C1344) + 6 / 7 * (ABS(C1344 - C1365))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |