• Download software • Tutorial videos
• Subscription & data-feed pricing • Class schedule


• New account application • Trading resources
• Margin rates • Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 7 » Easy Scan

Easy Scan Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
cbejet
Posted : Tuesday, October 17, 2006 10:22:20 AM
Gold Customer Gold Customer

Joined: 3/8/2005
Posts: 3
 Hi,

I am using your TC2000 Platinum. I was trying to make a scan by RSI value. I've choosed
Watchlist: All Items in System
RSI Yesterday (and the values between 85 and max).
When I execute that scan, in my result list I get symbols which had value superior to 85 but from 2002 until yesterday. Since I am interested in symbols which had those values but only yesterday (and there should be at most 10 symbols in my result list), how can I eliminate those symbols with old values (now I have a list of more than 200 symbols)?

Thanking you in advance

Claude
Back to top
Bruce_L
Posted : Tuesday, October 17, 2006 11:07:49 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
 The formula for RSI Yesterday in the example Personal Criteria Formula available when TeleChart is first installed is:

RSI14.1.1

This is the 14-Period unsmoothed RSI for yesterday only. It doesn't have anything to do with 2002 until yesterday. It is calculated using just the 14-Periods prior to the current period. 305 symbols return True for this formula being >= 85 on my system when using All Items in System as the Watchlist to scan. This matches the following chart settings:

Wilder's RSI Settings:
- RSI Period: 14
- Use Wilders Smoothing: Unchecked
- Avg Period: 1
- Average Type: Doesn't matter (because the Avg Period is 1).

If this does not match your chart settings, we would need to use different formulas. For example:

Wilder's RSI Settings:
- RSI Period: 14
- Use Wilders Smoothing: Unchecked
- Avg Period: 14
- Average Type: Simple

Would use a formula of:

RSI14.14.1

While:

Wilder's RSI Settings:
- RSI Period: 14
- Use Wilders Smoothing: Unchecked
- Avg Period: 14
- Average Type: Exponential

Would use a formula of:

XAVG(RSI14.1.1,14)

And:

Wilder's RSI Settings:
- RSI Period: 14
- Use Wilders Smoothing: Checked
- Avg Period: 1
- Average Type: Doesn't matter (because the Avg Period is 1).

Would use something more like (I'm guessing this is what you want):

100 * ((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) + 13 / 14 * ((C94 > C95) * (C95 - C94) + 13 / 14 * ((C95 > C96) * (C96 - C95) + 13 / 14 * ((C96 > C97) * (C97 - C96) + 13 / 14 * ((C97 > C98) * (C98 - C97) + 13 / 14 * ((C98 > C99) * (C99 - C98) + 13 / 14 * ((C99 > C100) * (C100 - C99) + 13 / 14 * ((C100 > C101) * (C101 - C100) + 13 / 14 * ((C101 > C102) * (C102 - C101) + 13 / 14 * ((C102 > C103) * (C103 - C102) + 13 / 14 * ((C103 > C104) * (C104 - C103) + 13 / 14 * ((C104 > C105) * (C105 - C104) + 13 / 14 * ((C105 > C106) * (C106 - C105) + 13 / 14 * ((C106 > C107) * (C107 - C106) + 13 / 14 * ((C107 > C108) * (C108 - C107) + 13 / 14 * ((C108 > C109) * (C109 - C108) + 13 / 14 * ((C109 > C110) * (C110 - C109) + 13 / 14 * ((C110 > C111) * (C111 - C110) + 13 / 14 * ((C111 > C112) * (C112 - C111) + 13 / 14 * ((C112 > C113) * (C113 - C112) + 13 / 14 * ((C113 > C114) * (C114 - C113) + 13 / 14 * ((C114 > C115) * (C115 - C114) + 13 / 14 * ((C115 > C116) * (C116 - C115) + 13 / 14 * ((C116 > C117) * (C117 - C116) + 13 / 14 * ((C117 > C118) * (C118 - C117) + 13 / 14 * ((C118 > C119) * (C119 - C118) + 13 / 14 * ((C119 > C120) * (C120 - C119) + 13 / 14 * ((C120 > C121) * (C121 - C120) + 13 / 14 * ((C121 > C122) * (C122 - C121) + 13 / 14 * ((C122 > C123) * (C123 - C122) + 13 / 14 * ((C123 > C124) * (C124 - C123) + 13 / 14 * ((C124 > C125) * (C125 - C124) + 13 / 14 * ((C125 > C126) * (C126 - C125) + 13 / 14 * ((C126 > C127) * (C127 - C126) + 13 / 14 * ((C127 > C128) * (C128 - C127) + 13 / 14 * ((C128 > C129) * (C129 - C128) + 13 / 14 * ((C129 > C130) * (C130 - C129) + 13 / 14 * ((C130 > C131) * (C131 - C130) + 13 / 14 * ((C131 > C132) * (C132 - C131) + 13 / 14 * ((C132 > C133) * (C133 - C132) + 13 / 14 * ((C133 > C134) * (C134 - C133) + 13 / 14 * ((C134 > C135) * (C135 - C134) + 13 / 14 * ((C135 > C136) * (C136 - C135)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(C1 - C2) + 13 / 14 * (ABS(C2 - C3) + 13 / 14 * (ABS(C3 - C4) + 13 / 14 * (ABS(C4 - C5) + 13 / 14 * (ABS(C5 - C6) + 13 / 14 * (ABS(C6 - C7) + 13 / 14 * (ABS(C7 - C8) + 13 / 14 * (ABS(C8 - C9) + 13 / 14 * (ABS(C9 - C10) + 13 / 14 * (ABS(C10 - C11) + 13 / 14 * (ABS(C11 - C12) + 13 / 14 * (ABS(C12 - C13) + 13 / 14 * (ABS(C13 - C14) + 13 / 14 * (ABS(C14 - C15) + 13 / 14 * (ABS(C15 - C16) + 13 / 14 * (ABS(C16 - C17) + 13 / 14 * (ABS(C17 - C18) + 13 / 14 * (ABS(C18 - C19) + 13 / 14 * (ABS(C19 - C20) + 13 / 14 * (ABS(C20 - C21) + 13 / 14 * (ABS(C21 - C22) + 13 / 14 * (ABS(C22 - C23) + 13 / 14 * (ABS(C23 - C24) + 13 / 14 * (ABS(C24 - C25) + 13 / 14 * (ABS(C25 - C26) + 13 / 14 * (ABS(C26 - C27) + 13 / 14 * (ABS(C27 - C28) + 13 / 14 * (ABS(C28 - C29) + 13 / 14 * (ABS(C29 - C30) + 13 / 14 * (ABS(C30 - C31) + 13 / 14 * (ABS(C31 - C32) + 13 / 14 * (ABS(C32 - C33) + 13 / 14 * (ABS(C33 - C34) + 13 / 14 * (ABS(C34 - C35) + 13 / 14 * (ABS(C35 - C36) + 13 / 14 * (ABS(C36 - C37) + 13 / 14 * (ABS(C37 - C38) + 13 / 14 * (ABS(C38 - C39) + 13 / 14 * (ABS(C39 - C40) + 13 / 14 * (ABS(C40 - C41) + 13 / 14 * (ABS(C41 - C42) + 13 / 14 * (ABS(C42 - C43) + 13 / 14 * (ABS(C43 - C44) + 13 / 14 * (ABS(C44 - C45) + 13 / 14 * (ABS(C45 - C46) + 13 / 14 * (ABS(C46 - C47) + 13 / 14 * (ABS(C47 - C48) + 13 / 14 * (ABS(C48 - C49) + 13 / 14 * (ABS(C49 - C50) + 13 / 14 * (ABS(C50 - C51) + 13 / 14 * (ABS(C51 - C52) + 13 / 14 * (ABS(C52 - C53) + 13 / 14 * (ABS(C53 - C54) + 13 / 14 * (ABS(C54 - C55) + 13 / 14 * (ABS(C55 - C56) + 13 / 14 * (ABS(C56 - C57) + 13 / 14 * (ABS(C57 - C58) + 13 / 14 * (ABS(C58 - C59) + 13 / 14 * (ABS(C59 - C60) + 13 / 14 * (ABS(C60 - C61) + 13 / 14 * (ABS(C61 - C62) + 13 / 14 * (ABS(C62 - C63) + 13 / 14 * (ABS(C63 - C64) + 13 / 14 * (ABS(C64 - C65) + 13 / 14 * (ABS(C65 - C66) + 13 / 14 * (ABS(C66 - C67) + 13 / 14 * (ABS(C67 - C68) + 13 / 14 * (ABS(C68 - C69) + 13 / 14 * (ABS(C69 - C70) + 13 / 14 * (ABS(C70 - C71) + 13 / 14 * (ABS(C71 - C72) + 13 / 14 * (ABS(C72 - C73) + 13 / 14 * (ABS(C73 - C74) + 13 / 14 * (ABS(C74 - C75) + 13 / 14 * (ABS(C75 - C76) + 13 / 14 * (ABS(C76 - C77) + 13 / 14 * (ABS(C77 - C78) + 13 / 14 * (ABS(C78 - C79) + 13 / 14 * (ABS(C79 - C80) + 13 / 14 * (ABS(C80 - C81) + 13 / 14 * (ABS(C81 - C82) + 13 / 14 * (ABS(C82 - C83) + 13 / 14 * (ABS(C83 - C84) + 13 / 14 * (ABS(C84 - C85) + 13 / 14 * (ABS(C85 - C86) + 13 / 14 * (ABS(C86 - C87) + 13 / 14 * (ABS(C87 - C88) + 13 / 14 * (ABS(C88 - C89) + 13 / 14 * (ABS(C89 - C90) + 13 / 14 * (ABS(C90 - C91) + 13 / 14 * (ABS(C91 - C92) + 13 / 14 * (ABS(C92 - C93) + 13 / 14 * (ABS(C93 - C94) + 13 / 14 * (ABS(C94 - C95) + 13 / 14 * (ABS(C95 - C96) + 13 / 14 * (ABS(C96 - C97) + 13 / 14 * (ABS(C97 - C98) + 13 / 14 * (ABS(C98 - C99) + 13 / 14 * (ABS(C99 - C100) + 13 / 14 * (ABS(C100 - C101) + 13 / 14 * (ABS(C101 - C102) + 13 / 14 * (ABS(C102 - C103) + 13 / 14 * (ABS(C103 - C104) + 13 / 14 * (ABS(C104 - C105) + 13 / 14 * (ABS(C105 - C106) + 13 / 14 * (ABS(C106 - C107) + 13 / 14 * (ABS(C107 - C108) + 13 / 14 * (ABS(C108 - C109) + 13 / 14 * (ABS(C109 - C110) + 13 / 14 * (ABS(C110 - C111) + 13 / 14 * (ABS(C111 - C112) + 13 / 14 * (ABS(C112 - C113) + 13 / 14 * (ABS(C113 - C114) + 13 / 14 * (ABS(C114 - C115) + 13 / 14 * (ABS(C115 - C116) + 13 / 14 * (ABS(C116 - C117) + 13 / 14 * (ABS(C117 - C118) + 13 / 14 * (ABS(C118 - C119) + 13 / 14 * (ABS(C119 - C120) + 13 / 14 * (ABS(C120 - C121) + 13 / 14 * (ABS(C121 - C122) + 13 / 14 * (ABS(C122 - C123) + 13 / 14 * (ABS(C123 - C124) + 13 / 14 * (ABS(C124 - C125) + 13 / 14 * (ABS(C125 - C126) + 13 / 14 * (ABS(C126 - C127) + 13 / 14 * (ABS(C127 - C128) + 13 / 14 * (ABS(C128 - C129) + 13 / 14 * (ABS(C129 - C130) + 13 / 14 * (ABS(C130 - C131) + 13 / 14 * (ABS(C131 - C132) + 13 / 14 * (ABS(C132 - C133) + 13 / 14 * (ABS(C133 - C134) + 13 / 14 * (ABS(C134 - C135) + 13 / 14 * (ABS(C135 - C136))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
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.