| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 7/11/2005
Posts: 12
|
Hello:
I have written an PCF with the following formula: RSI14.1 < 25. I'm looking for stocks with a current RSI(14) less than 25. However, this scan most often returns stocks with an RSI reading nowhere near 25 so I end up having to manually go through a list of 50-60 stocks to come out with 5 or 6 within my criteria. What do you think I can do differently to get a more accurate PCF?
Thanks!
|
|
Registered User
Joined: 10/23/2004
Posts: 251
|
Let's try this:
RSI14.1 Up through 30
SGN(RSI14.1.0 - 30) - SGN(RSI14.1.1 - 30) > 0
RSI14.1 Down through 30
SGN(RSI14.1.0 - 30) - SGN(RSI14.1.1 - 30) < 0
RSI14.1 Up through 70
SGN(RSI14.1.0 - 70) - SGN(RSI14.1.1 - 70) > 0
RSI14.1 Down through 70
SGN(RSI14.1.0 - 70) - SGN(RSI14.1.1 - 70) < 0
|
|
Registered User
Joined: 10/23/2004
Posts: 251
|
Yep you got it right pcf. RSI14.1 < 25
plot RSI in one of your chart windows.
RSI is plotted on a vertical scale from 0 to 100
Values above 70 and below 30 are the ones you want
Based on friday close only 338 of the 6839 stocks met the condition.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Is your RSI using Wilder's smoothing?
- Craig
Here to Help!
|
|
Registered User
Joined: 2/12/2005
Posts: 28
|
I used SGN(RSI8.3.0 - 70) - SGN(RSI8.3.1 - 70) > 0 for PCF to find RSI8.3 crossing up thru 70. I received stocks that are not crossing, such as CME & BDK. What am I doing wrong? thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
jaybird1,
The settings for a charted RSI matching your Personal Criteria Formula would be:
RSI Period: 8
Use Wilders Smoothing: Unchecked
Avg Period: 3
Average Type: Simple
I'm updated through 09/12/2006 Market Close. CME returned True for your PCF, but BDK did not. With the listed RSI settings, CME crossed 70, BDK did not. If you provide your RSI settings, we should be able to provide a PCF to match.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 2/12/2005
Posts: 28
|
My settings is RSI8.3 I have written it with SGN, etc and RSI8.3.1 < 0 and RSI8.3 > 0. It still shows CME as crossing 70 and CME is actually around 50.
I don't see what I am doing wrong. Thanks
|
|
Registered User
Joined: 2/12/2005
Posts: 28
|
Sorry, I thought smoothing was unchecked, but it wasn't. When I unchecked it CME shows crossing 70.
I know smoothing slows the RSI down, but is one better than the other. Which one is used more? Thanks
|
|
Registered User
Joined: 7/11/2005
Posts: 12
|
I am using Wilder's smoothing so I guess that that's the reason why the discrepancy exists. Is there any way to do the scan with Wilder's smoothing or is it just possible without?
A related question is what is the mathematical difference between Wilder's smoothing and without?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (jaybird1) I know smoothing slows the RSI down, but is one better than the other. Which one is used more?
The trainers cannot give settings, interpretation or investment advice. When Wilder's Smoothing is checked, you will normally wish to have the Avg Period set to one if you want your charts to match other technical analysis software.
QUOTE ( jbalesh01) A related question is what is the mathematical difference between Wilder's smoothing and without?
Wilder's Smoothing is a type of Exponential Moving Average. You can normally calculate Wilder's Smoothing using an Exponential Moving Average by multiplying the Wilder's Period by two and then substracting one. In the case of Wilder's RSI however, the Wilder's Smoothing is applied while the RSI is being calculated while Simple or Exponential Smoothing is applied to the RSI after it is calculated so this cannot be done.
QUOTE ( jbalesh01) Is there any way to do the scan with Wilder's smoothing or is it just possible without?
It is possible to write Personal Criteria Formulas for a Wilder's RSI with Wilders Smoothing Checked. The PCF for the following settings:
RSI Period: 14
Use Wilders Smoothing: Checked
Avg Period: 1
Average Type: Doesn't matter
Would be:
100 - (100 / (1 + (((C > C1) * (C1 - C) + 13 / 14 * ((C1 > C2) * (C2 - C1) + 13 / 14 * ((C2 > C3) * (C3 - C2) + 13 / 14 * ((C3 > C4) * (C4 - C3) + 13 / 14 * ((C4 > C5) * (C5 - C4) + 13 / 14 * ((C5 > C6) * (C6 - C5) + 13 / 14 * ((C6 > C7) * (C7 - C6) + 13 / 14 * ((C7 > C8) * (C8 - C7) + 13 / 14 * ((C8 > C9) * (C9 - C8) + 13 / 14 * ((C9 > C10) * (C10 - C9) + 13 / 14 * ((C10 > C11) * (C11 - C10) + 13 / 14 * ((C11 > C12) * (C12 - C11) + 13 / 14 * ((C12 > C13) * (C13 - C12) + 13 / 14 * ((C13 > C14) * (C14 - C13) + 13 / 14 * ((C14 > C15) * (C15 - C14) + 13 / 14 * ((C15 > C16) * (C16 - C15) + 13 / 14 * ((C16 > C17) * (C17 - C16) + 13 / 14 * ((C17 > C18) * (C18 - C17) + 13 / 14 * ((C18 > C19) * (C19 - C18) + 13 / 14 * ((C19 > C20) * (C20 - C19) + 13 / 14 * ((C20 > C21) * (C21 - C20) + 13 / 14 * ((C21 > C22) * (C22 - C21) + 13 / 14 * ((C22 > C23) * (C23 - C22) + 13 / 14 * ((C23 > C24) * (C24 - C23) + 13 / 14 * ((C24 > C25) * (C25 - C24) + 13 / 14 * ((C25 > C26) * (C26 - C25) + 13 / 14 * ((C26 > C27) * (C27 - C26) + 13 / 14 * ((C27 > C28) * (C28 - C27) + 13 / 14 * ((C28 > C29) * (C29 - C28) + 13 / 14 * ((C29 > C30) * (C30 - C29) + 13 / 14 * ((C30 > C31) * (C31 - C30) + 13 / 14 * ((C31 > C32) * (C32 - C31) + 13 / 14 * ((C32 > C33) * (C33 - C32) + 13 / 14 * ((C33 > C34) * (C34 - C33) + 13 / 14 * ((C34 > C35) * (C35 - C34) + 13 / 14 * ((C35 > C36) * (C36 - C35) + 13 / 14 * ((C36 > C37) * (C37 - C36) + 13 / 14 * ((C37 > C38) * (C38 - C37) + 13 / 14 * ((C38 > C39) * (C39 - C38) + 13 / 14 * ((C39 > C40) * (C40 - C39) + 13 / 14 * ((C40 > C41) * (C41 - C40) + 13 / 14 * ((C41 > C42) * (C42 - C41) + 13 / 14 * ((C42 > C43) * (C43 - C42) + 13 / 14 * ((C43 > C44) * (C44 - C43) + 13 / 14 * ((C44 > C45) * (C45 - C44) + 13 / 14 * ((C45 > C46) * (C46 - C45) + 13 / 14 * ((C46 > C47) * (C47 - C46) + 13 / 14 * ((C47 > C48) * (C48 - C47) + 13 / 14 * ((C48 > C49) * (C49 - C48) + 13 / 14 * ((C49 > C50) * (C50 - C49) + 13 / 14 * ((C50 > C51) * (C51 - C50) + 13 / 14 * ((C51 > C52) * (C52 - C51) + 13 / 14 * ((C52 > C53) * (C53 - C52) + 13 / 14 * ((C53 > C54) * (C54 - C53) + 13 / 14 * ((C54 > C55) * (C55 - C54) + 13 / 14 * ((C55 > C56) * (C56 - C55) + 13 / 14 * ((C56 > C57) * (C57 - C56) + 13 / 14 * ((C57 > C58) * (C58 - C57) + 13 / 14 * ((C58 > C59) * (C59 - C58) + 13 / 14 * ((C59 > C60) * (C60 - C59) + 13 / 14 * ((C60 > C61) * (C61 - C60) + 13 / 14 * ((C61 > C62) * (C62 - C61) + 13 / 14 * ((C62 > C63) * (C63 - C62) + 13 / 14 * ((C63 > C64) * (C64 - C63) + 13 / 14 * ((C64 > C65) * (C65 - C64) + 13 / 14 * ((C65 > C66) * (C66 - C65) + 13 / 14 * ((C66 > C67) * (C67 - C66) + 13 / 14 * ((C67 > C68) * (C68 - C67) + 13 / 14 * ((C68 > C69) * (C69 - C68) + 13 / 14 * ((C69 > C70) * (C70 - C69) + 13 / 14 * ((C70 > C71) * (C71 - C70) + 13 / 14 * ((C71 > C72) * (C72 - C71) + 13 / 14 * ((C72 > C73) * (C73 - C72) + 13 / 14 * ((C73 > C74) * (C74 - C73) + 13 / 14 * ((C74 > C75) * (C75 - C74) + 13 / 14 * ((C75 > C76) * (C76 - C75) + 13 / 14 * ((C76 > C77) * (C77 - C76) + 13 / 14 * ((C77 > C78) * (C78 - C77) + 13 / 14 * ((C78 > C79) * (C79 - C78) + 13 / 14 * ((C79 > C80) * (C80 - C79) + 13 / 14 * ((C80 > C81) * (C81 - C80) + 13 / 14 * ((C81 > C82) * (C82 - C81) + 13 / 14 * ((C82 > C83) * (C83 - C82) + 13 / 14 * ((C83 > C84) * (C84 - C83) + 13 / 14 * ((C84 > C85) * (C85 - C84) + 13 / 14 * ((C85 > C86) * (C86 - C85) + 13 / 14 * ((C86 > C87) * (C87 - C86) + 13 / 14 * ((C87 > C88) * (C88 - C87) + 13 / 14 * ((C88 > C89) * (C89 - C88) + 13 / 14 * ((C89 > C90) * (C90 - C89) + 13 / 14 * ((C90 > C91) * (C91 - C90) + 13 / 14 * ((C91 > C92) * (C92 - C91) + 13 / 14 * ((C92 > C93) * (C93 - C92) + 13 / 14 * ((C93 > C94) * (C94 - C93))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / ((C < C1) * (C - C1) + 13 / 14 * ((C1 < C2) * (C1 - C2) + 13 / 14 * ((C2 < C3) * (C2 - C3) + 13 / 14 * ((C3 < C4) * (C3 - C4) + 13 / 14 * ((C4 < C5) * (C4 - C5) + 13 / 14 * ((C5 < C6) * (C5 - C6) + 13 / 14 * ((C6 < C7) * (C6 - C7) + 13 / 14 * ((C7 < C8) * (C7 - C8) + 13 / 14 * ((C8 < C9) * (C8 - C9) + 13 / 14 * ((C9 < C10) * (C9 - C10) + 13 / 14 * ((C10 < C11) * (C10 - C11) + 13 / 14 * ((C11 < C12) * (C11 - C12) + 13 / 14 * ((C12 < C13) * (C12 - C13) + 13 / 14 * ((C13 < C14) * (C13 - C14) + 13 / 14 * ((C14 < C15) * (C14 - C15) + 13 / 14 * ((C15 < C16) * (C15 - C16) + 13 / 14 * ((C16 < C17) * (C16 - C17) + 13 / 14 * ((C17 < C18) * (C17 - C18) + 13 / 14 * ((C18 < C19) * (C18 - C19) + 13 / 14 * ((C19 < C20) * (C19 - C20) + 13 / 14 * ((C20 < C21) * (C20 - C21) + 13 / 14 * ((C21 < C22) * (C21 - C22) + 13 / 14 * ((C22 < C23) * (C22 - C23) + 13 / 14 * ((C23 < C24) * (C23 - C24) + 13 / 14 * ((C24 < C25) * (C24 - C25) + 13 / 14 * ((C25 < C26) * (C25 - C26) + 13 / 14 * ((C26 < C27) * (C26 - C27) + 13 / 14 * ((C27 < C28) * (C27 - C28) + 13 / 14 * ((C28 < C29) * (C28 - C29) + 13 / 14 * ((C29 < C30) * (C29 - C30) + 13 / 14 * ((C30 < C31) * (C30 - C31) + 13 / 14 * ((C31 < C32) * (C31 - C32) + 13 / 14 * ((C32 < C33) * (C32 - C33) + 13 / 14 * ((C33 < C34) * (C33 - C34) + 13 / 14 * ((C34 < C35) * (C34 - C35) + 13 / 14 * ((C35 < C36) * (C35 - C36) + 13 / 14 * ((C36 < C37) * (C36 - C37) + 13 / 14 * ((C37 < C38) * (C37 - C38) + 13 / 14 * ((C38 < C39) * (C38 - C39) + 13 / 14 * ((C39 < C40) * (C39 - C40) + 13 / 14 * ((C40 < C41) * (C40 - C41) + 13 / 14 * ((C41 < C42) * (C41 - C42) + 13 / 14 * ((C42 < C43) * (C42 - C43) + 13 / 14 * ((C43 < C44) * (C43 - C44) + 13 / 14 * ((C44 < C45) * (C44 - C45) + 13 / 14 * ((C45 < C46) * (C45 - C46) + 13 / 14 * ((C46 < C47) * (C46 - C47) + 13 / 14 * ((C47 < C48) * (C47 - C48) + 13 / 14 * ((C48 < C49) * (C48 - C49) + 13 / 14 * ((C49 < C50) * (C49 - C50) + 13 / 14 * ((C50 < C51) * (C50 - C51) + 13 / 14 * ((C51 < C52) * (C51 - C52) + 13 / 14 * ((C52 < C53) * (C52 - C53) + 13 / 14 * ((C53 < C54) * (C53 - C54) + 13 / 14 * ((C54 < C55) * (C54 - C55) + 13 / 14 * ((C55 < C56) * (C55 - C56) + 13 / 14 * ((C56 < C57) * (C56 - C57) + 13 / 14 * ((C57 < C58) * (C57 - C58) + 13 / 14 * ((C58 < C59) * (C58 - C59) + 13 / 14 * ((C59 < C60) * (C59 - C60) + 13 / 14 * ((C60 < C61) * (C60 - C61) + 13 / 14 * ((C61 < C62) * (C61 - C62) + 13 / 14 * ((C62 < C63) * (C62 - C63) + 13 / 14 * ((C63 < C64) * (C63 - C64) + 13 / 14 * ((C64 < C65) * (C64 - C65) + 13 / 14 * ((C65 < C66) * (C65 - C66) + 13 / 14 * ((C66 < C67) * (C66 - C67) + 13 / 14 * ((C67 < C68) * (C67 - C68) + 13 / 14 * ((C68 < C69) * (C68 - C69) + 13 / 14 * ((C69 < C70) * (C69 - C70) + 13 / 14 * ((C70 < C71) * (C70 - C71) + 13 / 14 * ((C71 < C72) * (C71 - C72) + 13 / 14 * ((C72 < C73) * (C72 - C73) + 13 / 14 * ((C73 < C74) * (C73 - C74) + 13 / 14 * ((C74 < C75) * (C74 - C75) + 13 / 14 * ((C75 < C76) * (C75 - C76) + 13 / 14 * ((C76 < C77) * (C76 - C77) + 13 / 14 * ((C77 < C78) * (C77 - C78) + 13 / 14 * ((C78 < C79) * (C78 - C79) + 13 / 14 * ((C79 < C80) * (C79 - C80) + 13 / 14 * ((C80 < C81) * (C80 - C81) + 13 / 14 * ((C81 < C82) * (C81 - C82) + 13 / 14 * ((C82 < C83) * (C82 - C83) + 13 / 14 * ((C83 < C84) * (C83 - C84) + 13 / 14 * ((C84 < C85) * (C84 - C85) + 13 / 14 * ((C85 < C86) * (C85 - C86) + 13 / 14 * ((C86 < C87) * (C86 - C87) + 13 / 14 * ((C87 < C88) * (C87 - C88) + 13 / 14 * ((C88 < C89) * (C88 - C89) + 13 / 14 * ((C89 < C90) * (C89 - C90) + 13 / 14 * ((C90 < C91) * (C90 - C91) + 13 / 14 * ((C91 < C92) * (C91 - C92) + 13 / 14 * ((C92 < C93) * (C92 - C93) + 13 / 14 * ((C93 < C94) * (C93 - C94))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 7/11/2005
Posts: 12
|
Whoa! I'll have to spend some time to go through that one.
Anyway, Bruce, thank you very much for your help.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |