Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

3 Period ExpMA crossing up 50 Period ExpMA Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
shawnpwilson
Posted : Tuesday, February 27, 2018 7:37:07 PM
Gold Customer Gold Customer

Joined: 9/29/2012
Posts: 13
I am hoping someone can help me with scan.
I am looking for on 30 minute chart where a 3 period ExpMA crosses up a 50 period ExpMA today where the 3 period ExpMA has been under the 50 period ExpMA for at least 5 days and Wilders RSI Today is near 60.
If it's possible and someone has something similar they can share I am very thankful.

 

Bruce_L
Posted : Wednesday, February 28, 2018 9:45:17 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

There really isn't a way to check for the EMA3 crossing up EMA50 on a 30 minute chart today. Nor is there a way to check that it was below during the previous 5 days if you mean calendar days.

What you can do is write a formula for the crossup during the current bar with price having been below for at least the previous 65 bars (about 5 trading days in a 30 minute time frame. This is a relatively short formula in TC2000 v17 or the TC2000 v18 beta.

XAVGC3 > XAVGC50 AND TrueInRow(XAVGC3.1 < XAVGC50.1, 65) = 65

But is quite a bit longer in earlier versions of TC2000.

XAVGC3 > XAVGC50 AND XAVGC3.1 < XAVGC50.1 AND XAVGC3.2 < XAVGC50.2 AND XAVGC3.3 < XAVGC50.3 AND XAVGC3.4 < XAVGC50.4 AND XAVGC3.5 < XAVGC50.5 AND XAVGC3.6 < XAVGC50.6 AND XAVGC3.7 < XAVGC50.7 AND XAVGC3.8 < XAVGC50.8 AND XAVGC3.9 < XAVGC50.9 AND XAVGC3.10 < XAVGC50.10 AND XAVGC3.11 < XAVGC50.11 AND XAVGC3.12 < XAVGC50.12 AND XAVGC3.13 < XAVGC50.13 AND XAVGC3.14 < XAVGC50.14 AND XAVGC3.15 < XAVGC50.15 AND XAVGC3.16 < XAVGC50.16 AND XAVGC3.17 < XAVGC50.17 AND XAVGC3.18 < XAVGC50.18 AND XAVGC3.19 < XAVGC50.19 AND XAVGC3.20 < XAVGC50.20 AND XAVGC3.21 < XAVGC50.21 AND XAVGC3.22 < XAVGC50.22 AND XAVGC3.23 < XAVGC50.23 AND XAVGC3.24 < XAVGC50.24 AND XAVGC3.25 < XAVGC50.25 AND XAVGC3.26 < XAVGC50.26 AND XAVGC3.27 < XAVGC50.27 AND XAVGC3.28 < XAVGC50.28 AND XAVGC3.29 < XAVGC50.29 AND XAVGC3.30 < XAVGC50.30 AND XAVGC3.31 < XAVGC50.31 AND XAVGC3.32 < XAVGC50.32 AND XAVGC3.33 < XAVGC50.33 AND XAVGC3.34 < XAVGC50.34 AND XAVGC3.35 < XAVGC50.35 AND XAVGC3.36 < XAVGC50.36 AND XAVGC3.37 < XAVGC50.37 AND XAVGC3.38 < XAVGC50.38 AND XAVGC3.39 < XAVGC50.39 AND XAVGC3.40 < XAVGC50.40 AND XAVGC3.41 < XAVGC50.41 AND XAVGC3.42 < XAVGC50.42 AND XAVGC3.43 < XAVGC50.43 AND XAVGC3.44 < XAVGC50.44 AND XAVGC3.45 < XAVGC50.45 AND XAVGC3.46 < XAVGC50.46 AND XAVGC3.47 < XAVGC50.47 AND XAVGC3.48 < XAVGC50.48 AND XAVGC3.49 < XAVGC50.49 AND XAVGC3.50 < XAVGC50.50 AND XAVGC3.51 < XAVGC50.51 AND XAVGC3.52 < XAVGC50.52 AND XAVGC3.53 < XAVGC50.53 AND XAVGC3.54 < XAVGC50.54 AND XAVGC3.55 < XAVGC50.55 AND XAVGC3.56 < XAVGC50.56 AND XAVGC3.57 < XAVGC50.57 AND XAVGC3.58 < XAVGC50.58 AND XAVGC3.59 < XAVGC50.59 AND XAVGC3.60 < XAVGC50.60 AND XAVGC3.61 < XAVGC50.61 AND XAVGC3.62 < XAVGC50.62 AND XAVGC3.63 < XAVGC50.63 AND XAVGC3.64 < XAVGC50.64 AND XAVGC3.65 < XAVGC50.65

You could start checking for being below 13 bars ago instead of 1 bar ago.

XAVGC3 > XAVGC50 AND TrueInRow(XAVGC3.13 < XAVGC50.13, 65) = 65

But that still wouldn't be "today", just within the last thirteen 30 minute bars (about a day).

As far as the Wilder's RSI today being near 60, what are the exact settings? How near is near? The following checks for the 14 period Wilder's RSI being within 5 of 60 in either direction in TC2000 v17 or the TC2000 v18 beta.

ABS(WRSI14 - 60) <= 5

But this would be a lot longer in earlier versions of TC2000.

ABS((50 * (C - XAVGC27.1) / 14 / (.071435345 * (ABS(C - C1) + 13 / 14 * (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))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50) - 60) <= 5



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
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.