Registered User
Joined: 10/7/2004
Posts: 24
|
Would you please help me with this formula for an easy scan.
BOP >0 for the last 3 days and
RSI 15 with a RSI MA of 15 crossing or above/below RSI 75 with a RSI MA of 75 and (The MA crossing not the RSI)
Rate of change of 12 crossing or above/below TSV of 24 and
Linear Regression of 25 crossing or above/below a Linear Regression of 75 and
Moving Average crossing or above/below Moneystream
Thank You
Tristram
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (Tristram) BOP >0 for the last 3 days
BOP > 0 AND BOP1.1 > 0 AND BOP1.2 > 0
QUOTE (Tristram) RSI 15 with a RSI MA of 15 crossing or above/below RSI 75 with a RSI MA of 75 and (The MA crossing not the RSI)
I cannot think of a practical way of doing this if Use Wilders Smoothing is checked for either RSI.
If the Average Type is Simple:
RSI15,15 xUp RSI75,75:
RSI15.15 > RSI75.75 AND RSI15.15.1 <= RSI75.75.1
RSI15,15 xDn RSI75,75:
RSI15.15 < RSI75.75 AND RSI15.15.1 >= RSI75.75.1
RSI15,15 crossing RSI75,75 (either direction):
SGN(RSI15.15 - RSI75.75) <> SGN(RSI15.15.1 - RSI75.75.1)
RSI15,15 above RSI75,75:
RSI15.15 > RSI75.75
RSI15,15 Below RSI75,75:
RSI15.15 < RSI75.75
If the Average Type is Exponential:
RSI15,15 xUp RSI75,75:
XAVG(RSI15,15) > XAVG(RSI75,75) AND XAVG(RSI15.1.1,15) <= XAVG(RSI75.1.1,75)
RSI15,15 xDn RSI75,75:
XAVG(RSI15,15) < XAVG(RSI75,75) AND XAVG(RSI15.1.1,15) >= XAVG(RSI75.1.1,75)
RSI15,15 crossing RSI75,75 (either direction):
SGN(XAVG(RSI15,15) - XAVG(RSI75,75)) <> SGN(XAVG(RSI15.1.1,15) - XAVG(RSI75.1.1,75))
RSI15,15 above RSI75,75:
XAVG(RSI15,15) > XAVG(RSI75,75)
RSI15,15 Below RSI75,75:
XAVG(RSI15,15) < XAVG(RSI75,75)
QUOTE (Tristram) Rate of change of 12 crossing or above/below TSV of 24
I can't help you with this. The Rate of Change and TSV are going to be on completely different scales in TeleChart.
QUOTE (Tristram) Linear Regression of 25 crossing or above/below a Linear Regression of 75
MLR25 xUp MLR75:
AVGC25 + 12 * (12 * C + 11 * C1 + 10 * C2 + 9 * C3 + 8 * C4 + 7 * C5 + 6 * C6 + 5 * C7 + 4 * C8 + 3 * C9 + 2 * C10 + C11 - C13 - 2 * C14 - 3 * C15 - 4 * C16 - 5 * C17 - 6 * C18 - 7 * C19 - 8 * C20 - 9 * C21 - 10 * C22 - 11 * C23 - 12 * C24) / 1300 > AVGC75 + 37 * (37 * C + 36 * C1 + 35 * C2 + 34 * C3 + 33 * C4 + 32 * C5 + 31 * C6 + 30 * C7 + 29 * C8 + 28 * C9 + 27 * C10 + 26 * C11 + 25 * C12 + 24 * C13 + 23 * C14 + 22 * C15 + 21 * C16 + 20 * C17 + 19 * C18 + 18 * C19 + 17 * C20 + 16 * C21 + 15 * C22 + 14 * C23 + 13 * C24 + 12 * C25 + 11 * C26 + 10 * C27 + 9 * C28 + 8 * C29 + 7 * C30 + 6 * C31 + 5 * C32 + 4 * C33 + 3 * C34 + 2 * C35 + C36 - C38 - 2 * C39 - 3 * C40 - 4 * C41 - 5 * C42 - 6 * C43 - 7 * C44 - 8 * C45 - 9 * C46 - 10 * C47 - 11 * C48 - 12 * C49 - 13 * C50 - 14 * C51 - 15 * C52 - 16 * C53 - 17 * C54 - 18 * C55 - 19 * C56 - 20 * C57 - 21 * C58 - 22 * C59 - 23 * C60 - 24 * C61 - 25 * C62 - 26 * C63 - 27 * C64 - 28 * C65 - 29 * C66 - 30 * C67 - 31 * C68 - 32 * C69 - 33 * C70 - 34 * C71 - 35 * C72 - 36 * C73 - 37 * C74) / 35150 AND AVGC25.1 + 12 * (12 * C1 + 11 * C2 + 10 * C3 + 9 * C4 + 8 * C5 + 7 * C6 + 6 * C7 + 5 * C8 + 4 * C9 + 3 * C10 + 2 * C11 + C12 - C14 - 2 * C15 - 3 * C16 - 4 * C17 - 5 * C18 - 6 * C19 - 7 * C20 - 8 * C21 - 9 * C22 - 10 * C23 - 11 * C24 - 12 * C25) / 1300 <= AVGC75.1 + 37 * (37 * C1 + 36 * C2 + 35 * C3 + 34 * C4 + 33 * C5 + 32 * C6 + 31 * C7 + 30 * C8 + 29 * C9 + 28 * C10 + 27 * C11 + 26 * C12 + 25 * C13 + 24 * C14 + 23 * C15 + 22 * C16 + 21 * C17 + 20 * C18 + 19 * C19 + 18 * C20 + 17 * C21 + 16 * C22 + 15 * C23 + 14 * C24 + 13 * C25 + 12 * C26 + 11 * C27 + 10 * C28 + 9 * C29 + 8 * C30 + 7 * C31 + 6 * C32 + 5 * C33 + 4 * C34 + 3 * C35 + 2 * C36 + C37 - C39 - 2 * C40 - 3 * C41 - 4 * C42 - 5 * C43 - 6 * C44 - 7 * C45 - 8 * C46 - 9 * C47 - 10 * C48 - 11 * C49 - 12 * C50 - 13 * C51 - 14 * C52 - 15 * C53 - 16 * C54 - 17 * C55 - 18 * C56 - 19 * C57 - 20 * C58 - 21 * C59 - 22 * C60 - 23 * C61 - 24 * C62 - 25 * C63 - 26 * C64 - 27 * C65 - 28 * C66 - 29 * C67 - 30 * C68 - 31 * C69 - 32 * C70 - 33 * C71 - 34 * C72 - 35 * C73 - 36 * C74 - 37 * C75) / 35150
MLR25 xDn MLR75:
AVGC25 + 12 * (12 * C + 11 * C1 + 10 * C2 + 9 * C3 + 8 * C4 + 7 * C5 + 6 * C6 + 5 * C7 + 4 * C8 + 3 * C9 + 2 * C10 + C11 - C13 - 2 * C14 - 3 * C15 - 4 * C16 - 5 * C17 - 6 * C18 - 7 * C19 - 8 * C20 - 9 * C21 - 10 * C22 - 11 * C23 - 12 * C24) / 1300 < AVGC75 + 37 * (37 * C + 36 * C1 + 35 * C2 + 34 * C3 + 33 * C4 + 32 * C5 + 31 * C6 + 30 * C7 + 29 * C8 + 28 * C9 + 27 * C10 + 26 * C11 + 25 * C12 + 24 * C13 + 23 * C14 + 22 * C15 + 21 * C16 + 20 * C17 + 19 * C18 + 18 * C19 + 17 * C20 + 16 * C21 + 15 * C22 + 14 * C23 + 13 * C24 + 12 * C25 + 11 * C26 + 10 * C27 + 9 * C28 + 8 * C29 + 7 * C30 + 6 * C31 + 5 * C32 + 4 * C33 + 3 * C34 + 2 * C35 + C36 - C38 - 2 * C39 - 3 * C40 - 4 * C41 - 5 * C42 - 6 * C43 - 7 * C44 - 8 * C45 - 9 * C46 - 10 * C47 - 11 * C48 - 12 * C49 - 13 * C50 - 14 * C51 - 15 * C52 - 16 * C53 - 17 * C54 - 18 * C55 - 19 * C56 - 20 * C57 - 21 * C58 - 22 * C59 - 23 * C60 - 24 * C61 - 25 * C62 - 26 * C63 - 27 * C64 - 28 * C65 - 29 * C66 - 30 * C67 - 31 * C68 - 32 * C69 - 33 * C70 - 34 * C71 - 35 * C72 - 36 * C73 - 37 * C74) / 35150 AND AVGC25.1 + 12 * (12 * C1 + 11 * C2 + 10 * C3 + 9 * C4 + 8 * C5 + 7 * C6 + 6 * C7 + 5 * C8 + 4 * C9 + 3 * C10 + 2 * C11 + C12 - C14 - 2 * C15 - 3 * C16 - 4 * C17 - 5 * C18 - 6 * C19 - 7 * C20 - 8 * C21 - 9 * C22 - 10 * C23 - 11 * C24 - 12 * C25) / 1300 >= AVGC75.1 + 37 * (37 * C1 + 36 * C2 + 35 * C3 + 34 * C4 + 33 * C5 + 32 * C6 + 31 * C7 + 30 * C8 + 29 * C9 + 28 * C10 + 27 * C11 + 26 * C12 + 25 * C13 + 24 * C14 + 23 * C15 + 22 * C16 + 21 * C17 + 20 * C18 + 19 * C19 + 18 * C20 + 17 * C21 + 16 * C22 + 15 * C23 + 14 * C24 + 13 * C25 + 12 * C26 + 11 * C27 + 10 * C28 + 9 * C29 + 8 * C30 + 7 * C31 + 6 * C32 + 5 * C33 + 4 * C34 + 3 * C35 + 2 * C36 + C37 - C39 - 2 * C40 - 3 * C41 - 4 * C42 - 5 * C43 - 6 * C44 - 7 * C45 - 8 * C46 - 9 * C47 - 10 * C48 - 11 * C49 - 12 * C50 - 13 * C51 - 14 * C52 - 15 * C53 - 16 * C54 - 17 * C55 - 18 * C56 - 19 * C57 - 20 * C58 - 21 * C59 - 22 * C60 - 23 * C61 - 24 * C62 - 25 * C63 - 26 * C64 - 27 * C65 - 28 * C66 - 29 * C67 - 30 * C68 - 31 * C69 - 32 * C70 - 33 * C71 - 34 * C72 - 35 * C73 - 36 * C74 - 37 * C75) / 35150
MLR25 crossing MLR75 (either direction):
SGN(AVGC25 + 12 * (12 * C + 11 * C1 + 10 * C2 + 9 * C3 + 8 * C4 + 7 * C5 + 6 * C6 + 5 * C7 + 4 * C8 + 3 * C9 + 2 * C10 + C11 - C13 - 2 * C14 - 3 * C15 - 4 * C16 - 5 * C17 - 6 * C18 - 7 * C19 - 8 * C20 - 9 * C21 - 10 * C22 - 11 * C23 - 12 * C24) / 1300 - (AVGC75 + 37 * (37 * C + 36 * C1 + 35 * C2 + 34 * C3 + 33 * C4 + 32 * C5 + 31 * C6 + 30 * C7 + 29 * C8 + 28 * C9 + 27 * C10 + 26 * C11 + 25 * C12 + 24 * C13 + 23 * C14 + 22 * C15 + 21 * C16 + 20 * C17 + 19 * C18 + 18 * C19 + 17 * C20 + 16 * C21 + 15 * C22 + 14 * C23 + 13 * C24 + 12 * C25 + 11 * C26 + 10 * C27 + 9 * C28 + 8 * C29 + 7 * C30 + 6 * C31 + 5 * C32 + 4 * C33 + 3 * C34 + 2 * C35 + C36 - C38 - 2 * C39 - 3 * C40 - 4 * C41 - 5 * C42 - 6 * C43 - 7 * C44 - 8 * C45 - 9 * C46 - 10 * C47 - 11 * C48 - 12 * C49 - 13 * C50 - 14 * C51 - 15 * C52 - 16 * C53 - 17 * C54 - 18 * C55 - 19 * C56 - 20 * C57 - 21 * C58 - 22 * C59 - 23 * C60 - 24 * C61 - 25 * C62 - 26 * C63 - 27 * C64 - 28 * C65 - 29 * C66 - 30 * C67 - 31 * C68 - 32 * C69 - 33 * C70 - 34 * C71 - 35 * C72 - 36 * C73 - 37 * C74) / 35150)) <> SGN(AVGC25.1 + 12 * (12 * C1 + 11 * C2 + 10 * C3 + 9 * C4 + 8 * C5 + 7 * C6 + 6 * C7 + 5 * C8 + 4 * C9 + 3 * C10 + 2 * C11 + C12 - C14 - 2 * C15 - 3 * C16 - 4 * C17 - 5 * C18 - 6 * C19 - 7 * C20 - 8 * C21 - 9 * C22 - 10 * C23 - 11 * C24 - 12 * C25) / 1300 - SGN(AVGC75.1 + 37 * (37 * C1 + 36 * C2 + 35 * C3 + 34 * C4 + 33 * C5 + 32 * C6 + 31 * C7 + 30 * C8 + 29 * C9 + 28 * C10 + 27 * C11 + 26 * C12 + 25 * C13 + 24 * C14 + 23 * C15 + 22 * C16 + 21 * C17 + 20 * C18 + 19 * C19 + 18 * C20 + 17 * C21 + 16 * C22 + 15 * C23 + 14 * C24 + 13 * C25 + 12 * C26 + 11 * C27 + 10 * C28 + 9 * C29 + 8 * C30 + 7 * C31 + 6 * C32 + 5 * C33 + 4 * C34 + 3 * C35 + 2 * C36 + C37 - C39 - 2 * C40 - 3 * C41 - 4 * C42 - 5 * C43 - 6 * C44 - 7 * C45 - 8 * C46 - 9 * C47 - 10 * C48 - 11 * C49 - 12 * C50 - 13 * C51 - 14 * C52 - 15 * C53 - 16 * C54 - 17 * C55 - 18 * C56 - 19 * C57 - 20 * C58 - 21 * C59 - 22 * C60 - 23 * C61 - 24 * C62 - 25 * C63 - 26 * C64 - 27 * C65 - 28 * C66 - 29 * C67 - 30 * C68 - 31 * C69 - 32 * C70 - 33 * C71 - 34 * C72 - 35 * C73 - 36 * C74 - 37 * C75) / 35150))
MLR25 above MLR75:
AVGC25 + 12 * (12 * C + 11 * C1 + 10 * C2 + 9 * C3 + 8 * C4 + 7 * C5 + 6 * C6 + 5 * C7 + 4 * C8 + 3 * C9 + 2 * C10 + C11 - C13 - 2 * C14 - 3 * C15 - 4 * C16 - 5 * C17 - 6 * C18 - 7 * C19 - 8 * C20 - 9 * C21 - 10 * C22 - 11 * C23 - 12 * C24) / 1300 > AVGC75 + 37 * (37 * C + 36 * C1 + 35 * C2 + 34 * C3 + 33 * C4 + 32 * C5 + 31 * C6 + 30 * C7 + 29 * C8 + 28 * C9 + 27 * C10 + 26 * C11 + 25 * C12 + 24 * C13 + 23 * C14 + 22 * C15 + 21 * C16 + 20 * C17 + 19 * C18 + 18 * C19 + 17 * C20 + 16 * C21 + 15 * C22 + 14 * C23 + 13 * C24 + 12 * C25 + 11 * C26 + 10 * C27 + 9 * C28 + 8 * C29 + 7 * C30 + 6 * C31 + 5 * C32 + 4 * C33 + 3 * C34 + 2 * C35 + C36 - C38 - 2 * C39 - 3 * C40 - 4 * C41 - 5 * C42 - 6 * C43 - 7 * C44 - 8 * C45 - 9 * C46 - 10 * C47 - 11 * C48 - 12 * C49 - 13 * C50 - 14 * C51 - 15 * C52 - 16 * C53 - 17 * C54 - 18 * C55 - 19 * C56 - 20 * C57 - 21 * C58 - 22 * C59 - 23 * C60 - 24 * C61 - 25 * C62 - 26 * C63 - 27 * C64 - 28 * C65 - 29 * C66 - 30 * C67 - 31 * C68 - 32 * C69 - 33 * C70 - 34 * C71 - 35 * C72 - 36 * C73 - 37 * C74) / 35150
MLR25 below MLR75:
AVGC25 + 12 * (12 * C + 11 * C1 + 10 * C2 + 9 * C3 + 8 * C4 + 7 * C5 + 6 * C6 + 5 * C7 + 4 * C8 + 3 * C9 + 2 * C10 + C11 - C13 - 2 * C14 - 3 * C15 - 4 * C16 - 5 * C17 - 6 * C18 - 7 * C19 - 8 * C20 - 9 * C21 - 10 * C22 - 11 * C23 - 12 * C24) / 1300 < AVGC75 + 37 * (37 * C + 36 * C1 + 35 * C2 + 34 * C3 + 33 * C4 + 32 * C5 + 31 * C6 + 30 * C7 + 29 * C8 + 28 * C9 + 27 * C10 + 26 * C11 + 25 * C12 + 24 * C13 + 23 * C14 + 22 * C15 + 21 * C16 + 20 * C17 + 19 * C18 + 18 * C19 + 17 * C20 + 16 * C21 + 15 * C22 + 14 * C23 + 13 * C24 + 12 * C25 + 11 * C26 + 10 * C27 + 9 * C28 + 8 * C29 + 7 * C30 + 6 * C31 + 5 * C32 + 4 * C33 + 3 * C34 + 2 * C35 + C36 - C38 - 2 * C39 - 3 * C40 - 4 * C41 - 5 * C42 - 6 * C43 - 7 * C44 - 8 * C45 - 9 * C46 - 10 * C47 - 11 * C48 - 12 * C49 - 13 * C50 - 14 * C51 - 15 * C52 - 16 * C53 - 17 * C54 - 18 * C55 - 19 * C56 - 20 * C57 - 21 * C58 - 22 * C59 - 23 * C60 - 24 * C61 - 25 * C62 - 26 * C63 - 27 * C64 - 28 * C65 - 29 * C66 - 30 * C67 - 31 * C68 - 32 * C69 - 33 * C70 - 34 * C71 - 35 * C72 - 36 * C73 - 37 * C74) / 35150
QUOTE (Tristram) Moving Average crossing or above/below Moneystream
What's the Moving Average Period and Type? The following are Simple and Exponential examples for a Moving Average period of 21:
SMA21 of MS xUp MS:
MS21 > MS AND MS21.1 <= MS1.1
SMA21 of MS xDn MS:
MS21 < MS AND MS21.1 >= MS1.1
SMA21 of MS crossing MS (either direction):
SGN(MS21 - MS) <> SGN(MS21.1 - MS1.1)
SMA21 of MS above MS:
MS21 > MS
SMA21 of MS below MS:
MS21 < MS
EMA21 of MS xUp MS:
XAVG(MS,21) > MS AND XAVG(MS1.1,21) <= MS1.1
EMA21 of MS xDn MS:
XAVG(MS,21) < MS AND XAVG(MS1.1,21) >= MS1.1
EMA21 of MS crossing MS (either direction):
SGN(XAVG(MS,21) - MS) <> SGN(XAVG(MS1.1,21) - MS1.1)
EMA21 of MS above MS:
XAVG(MS,21) > MS
EMA21 of MS below MS:
XAVG(MS,21) < MS
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
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|