Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 3/13/2006 Posts: 25
|
Hi,
How to write in PCF the following:
7- periods RSI one bar ago have crossed 50 up
|
|
Registered User Joined: 10/18/2012 Posts: 40
|
Just to speed up the answer, Wilder RSI or non-Wilder RSI?
|
|
Registered User Joined: 6/10/2009 Posts: 8
|
PCF for non wilder RSI13<69.1 last week having just crossed >69.1 this week
Thanks Doug
|
|
Registered User Joined: 10/18/2012 Posts: 40
|
Do you need a PCF? You can set up a scan condition from the weekly chart. Click on RSI, and on the drop down is Create Scan Condition. Then select Cross Above, set value to 70, and then add to Watch List as either column or Scan Condition
|
|
Registered User Joined: 3/13/2006 Posts: 25
|
Thanks for the replies. I need wilder RSI (7 periods) crossing 50 and I need PCF because I will scan intraday
|
|
Registered User Joined: 10/18/2012 Posts: 40
|
The procedure I outlined above will wotk from an intraday chart, I don't think you need a PCF
|
|
Registered User Joined: 3/13/2006 Posts: 25
|
Thanks, however I still need PCF for 7 period wilder RSI
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If you just want the formula I will provide it below. That said, you are better off using the technique outlined by BillCochrane. You will still need to set the time frame of the Condition Formula just like you would need to set the time frame of the condition created by selecting Create Scan Condition. The Condition Formula will be less efficient than the condition created by selecting Create Scan Condition. For example in most cases, a WatchList Column will have a longer minimum refresh rate than the same condition created by clicking on the chart.
50 * (C - XAVGC13.1) / 7 / (.14287089 * (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)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 > 50 AND 50 * (C1 - XAVGC13.2) / 7 / (.14287089 * (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)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 <= 50
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/13/2006 Posts: 25
|
Thanks Bruce. Kindly answer my following questions:
1- I need to scan 60 min bars, so the idea I will scan for setups after the 60 min bar close. What I recall the only way to do that is to come say 5 min after the bar close and run the scan for the previous bar. Is it possible to scan one bar ago with the scan condition? if yes how
2- Is the provided formula for wilder RSI cross up or down? I need separate one for each condition; one wilder RSI one bar ago cross 50 up and one wilder RSI one bar ago cross 50 down
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The original condition is for a crossup through 50 for the current bar. The crossdown for the current bar would reverse the > and < signs.
50 * (C - XAVGC13.1) / 7 / (.14287089 * (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)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 < 50 AND 50 * (C1 - XAVGC13.2) / 7 / (.14287089 * (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)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 >= 50
A crossup formula for the previous bar can be written as follows.
50 * (C1 - XAVGC13.2) / 7 / (.14287089 * (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)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 > 50 AND 50 * (C2 - XAVGC13.3) / 7 / (.14287089 * (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)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 <= 0
With the crossdown formula again just reverse the > and < signs.
50 * (C1 - XAVGC13.2) / 7 / (.14287089 * (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)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 < 50 AND 50 * (C2 - XAVGC13.3) / 7 / (.14287089 * (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)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 >= 0
Even in this case however you are probably better off clicking on the chart. You just need to add a 1-period exponential moving average to the RSI indicator with the Offset setting set to 1. This will plot the previous value of the RSI on the current bar. You can then click on the 1-period 1-offset exponential moving average and select Create Scan Condition to create the desired condition.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/9/2011 Posts: 485
|
Would be good to have an function like RSI(), CCI() etc so we can use that function directly.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Thank you for your suggestion.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |