Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 3/31/2011 Posts: 68
|
WRSI14<30
Above will give me stocks trading below 30, and the WRSI setting is 14 period.
If I am only interested in weekly WRSI, how do I change the above syntax?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The syntax wouldn't change. PCFs are written based on bars.
There is a TimeFrame setting available which can be changed when creating and editing formulas. This changes the default time frame of the formula.
You can also change the time frame to something other than the default when you use it in your layout. For example, you can edit a WatchList column to change its time frame or edit an individual EasyScan condition to change its time frame. This will not change the time frame of the formula anyplace else in the layout and the default time frame will remain unchanged.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/31/2011 Posts: 68
|
Bruce:
I did not explain clearly.
WRSI14<30
If I use above pcf on the daily chart, that will only gives me result from the daily chart. How can I get the result from the weekly chart on the daily chart?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You can create weekly WatchList columns and scans, but you can mix time frames on the chart. There is no way to plot a weekly 14-period WRS on a daily chart.
About the best you can do is multiply the period by 5 (so use a 70-period WRSI instead), but this will not match the results of a 14-period weekly WRSI.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/31/2011 Posts: 68
|
Bruce: Thank you. I appreciate your help.
|
|
Gold Customer
Joined: 2/18/2010 Posts: 24
|
Hi Bruce,
How are you doing? Fine I hope.
How do I filter for stocks which has its current WSRI9 more than its yesterday's WRSI9 by 50?
Thank you.
Guesz2002
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following.
WRSI9 >= WRSI9.1 + 50
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Gold Customer
Joined: 2/18/2010 Posts: 24
|
QUOTE (Bruce_L)
Please try the following.
WRSI9 >= WRSI9.1 + 50
Thanks Bruce. But it returns "Formula Error" "Missing argument near +"
Appreciate yor time. Thanks.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You will need to be using TC2000 v17 or newer in order for the formula to work. The first link is for a Windows installation and the second link is for running the full version of TC2000 on other platforms.
The formula to approximate this in earlier version of TC2000 is very long.
50 * (C - XAVGC17.1) / 9 / (.11112122 * (ABS(C - C1) + 8 / 9 * (ABS(C1 - C2) + 8 / 9 * (ABS(C2 - C3) + 8 / 9 * (ABS(C3 - C4) + 8 / 9 * (ABS(C4 - C5) + 8 / 9 * (ABS(C5 - C6) + 8 / 9 * (ABS(C6 - C7) + 8 / 9 * (ABS(C7 - C8) + 8 / 9 * (ABS(C8 - C9) + 8 / 9 * (ABS(C9 - C10) + 8 / 9 * (ABS(C10 - C11) + 8 / 9 * (ABS(C11 - C12) + 8 / 9 * (ABS(C12 - C13) + 8 / 9 * (ABS(C13 - C14) + 8 / 9 * (ABS(C14 - C15) + 8 / 9 * (ABS(C15 - C16) + 8 / 9 * (ABS(C16 - C17) + 8 / 9 * (ABS(C17 - C18) + 8 / 9 * (ABS(C18 - C19) + 8 / 9 * (ABS(C19 - C20) + 8 / 9 * (ABS(C20 - C21) + 8 / 9 * (ABS(C21 - C22) + 8 / 9 * (ABS(C22 - C23) + 8 / 9 * (ABS(C23 - C24) + 8 / 9 * (ABS(C24 - C25) + 8 / 9 * (ABS(C25 - C26) + 8 / 9 * (ABS(C26 - C27) + 8 / 9 * (ABS(C27 - C28) + 8 / 9 * (ABS(C28 - C29) + 8 / 9 * (ABS(C29 - C30) + 8 / 9 * (ABS(C30 - C31) + 8 / 9 * (ABS(C31 - C32) + 8 / 9 * (ABS(C32 - C33) + 8 / 9 * (ABS(C33 - C34) + 8 / 9 * (ABS(C34 - C35) + 8 / 9 * (ABS(C35 - C36) + 8 / 9 * (ABS(C36 - C37) + 8 / 9 * (ABS(C37 - C38) + 8 / 9 * (ABS(C38 - C39) + 8 / 9 * (ABS(C39 - C40) + 8 / 9 * (ABS(C40 - C41) + 8 / 9 * (ABS(C41 - C42) + 8 / 9 * (ABS(C42 - C43) + 8 / 9 * (ABS(C43 - C44) + 8 / 9 * (ABS(C44 - C45) + 8 / 9 * (ABS(C45 - C46) + 8 / 9 * (ABS(C46 - C47) + 8 / 9 * (ABS(C47 - C48) + 8 / 9 * (ABS(C48 - C49) + 8 / 9 * (ABS(C49 - C50) + 8 / 9 * (ABS(C50 - C51) + 8 / 9 * (ABS(C51 - C52) + 8 / 9 * (ABS(C52 - C53) + 8 / 9 * (ABS(C53 - C54) + 8 / 9 * (ABS(C54 - C55) + 8 / 9 * (ABS(C55 - C56) + 8 / 9 * (ABS(C56 - C57) + 8 / 9 * (ABS(C57 - C58) + 8 / 9 * (ABS(C58 - C59) + 8 / 9 * (ABS(C59 - C60) + 8 / 9 * (ABS(C60 - C61) + 8 / 9 * (ABS(C61 - C62) + 8 / 9 * (ABS(C62 - C63) + 8 / 9 * (ABS(C63 - C64) + 8 / 9 * (ABS(C64 - C65) + 8 / 9 * (ABS(C65 - C66) + 8 / 9 * (ABS(C66 - C67) + 8 / 9 * (ABS(C67 - C68) + 8 / 9 * (ABS(C68 - C69) + 8 / 9 * (ABS(C69 - C70) + 8 / 9 * (ABS(C70 - C71) + 8 / 9 * (ABS(C71 - C72) + 8 / 9 * (ABS(C72 - C73) + 8 / 9 * (ABS(C73 - C74) + 8 / 9 * (ABS(C74 - C75) + 8 / 9 * (ABS(C75 - C76) + 8 / 9 * (ABS(C76 - C77) + 8 / 9 * (ABS(C77 - C78) + 8 / 9 * (ABS(C78 - C79))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 > 50 * (C1 - XAVGC17.2) / 9 / (.11112122 * (ABS(C1 - C2) + 8 / 9 * (ABS(C2 - C3) + 8 / 9 * (ABS(C3 - C4) + 8 / 9 * (ABS(C4 - C5) + 8 / 9 * (ABS(C5 - C6) + 8 / 9 * (ABS(C6 - C7) + 8 / 9 * (ABS(C7 - C8) + 8 / 9 * (ABS(C8 - C9) + 8 / 9 * (ABS(C9 - C10) + 8 / 9 * (ABS(C10 - C11) + 8 / 9 * (ABS(C11 - C12) + 8 / 9 * (ABS(C12 - C13) + 8 / 9 * (ABS(C13 - C14) + 8 / 9 * (ABS(C14 - C15) + 8 / 9 * (ABS(C15 - C16) + 8 / 9 * (ABS(C16 - C17) + 8 / 9 * (ABS(C17 - C18) + 8 / 9 * (ABS(C18 - C19) + 8 / 9 * (ABS(C19 - C20) + 8 / 9 * (ABS(C20 - C21) + 8 / 9 * (ABS(C21 - C22) + 8 / 9 * (ABS(C22 - C23) + 8 / 9 * (ABS(C23 - C24) + 8 / 9 * (ABS(C24 - C25) + 8 / 9 * (ABS(C25 - C26) + 8 / 9 * (ABS(C26 - C27) + 8 / 9 * (ABS(C27 - C28) + 8 / 9 * (ABS(C28 - C29) + 8 / 9 * (ABS(C29 - C30) + 8 / 9 * (ABS(C30 - C31) + 8 / 9 * (ABS(C31 - C32) + 8 / 9 * (ABS(C32 - C33) + 8 / 9 * (ABS(C33 - C34) + 8 / 9 * (ABS(C34 - C35) + 8 / 9 * (ABS(C35 - C36) + 8 / 9 * (ABS(C36 - C37) + 8 / 9 * (ABS(C37 - C38) + 8 / 9 * (ABS(C38 - C39) + 8 / 9 * (ABS(C39 - C40) + 8 / 9 * (ABS(C40 - C41) + 8 / 9 * (ABS(C41 - C42) + 8 / 9 * (ABS(C42 - C43) + 8 / 9 * (ABS(C43 - C44) + 8 / 9 * (ABS(C44 - C45) + 8 / 9 * (ABS(C45 - C46) + 8 / 9 * (ABS(C46 - C47) + 8 / 9 * (ABS(C47 - C48) + 8 / 9 * (ABS(C48 - C49) + 8 / 9 * (ABS(C49 - C50) + 8 / 9 * (ABS(C50 - C51) + 8 / 9 * (ABS(C51 - C52) + 8 / 9 * (ABS(C52 - C53) + 8 / 9 * (ABS(C53 - C54) + 8 / 9 * (ABS(C54 - C55) + 8 / 9 * (ABS(C55 - C56) + 8 / 9 * (ABS(C56 - C57) + 8 / 9 * (ABS(C57 - C58) + 8 / 9 * (ABS(C58 - C59) + 8 / 9 * (ABS(C59 - C60) + 8 / 9 * (ABS(C60 - C61) + 8 / 9 * (ABS(C61 - C62) + 8 / 9 * (ABS(C62 - C63) + 8 / 9 * (ABS(C63 - C64) + 8 / 9 * (ABS(C64 - C65) + 8 / 9 * (ABS(C65 - C66) + 8 / 9 * (ABS(C66 - C67) + 8 / 9 * (ABS(C67 - C68) + 8 / 9 * (ABS(C68 - C69) + 8 / 9 * (ABS(C69 - C70) + 8 / 9 * (ABS(C70 - C71) + 8 / 9 * (ABS(C71 - C72) + 8 / 9 * (ABS(C72 - C73) + 8 / 9 * (ABS(C73 - C74) + 8 / 9 * (ABS(C74 - C75) + 8 / 9 * (ABS(C75 - C76) + 8 / 9 * (ABS(C76 - C77) + 8 / 9 * (ABS(C77 - C78) + 8 / 9 * (ABS(C78 - C79) + 8 / 9 * (ABS(C79 - C80))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Gold Customer
Joined: 2/18/2010 Posts: 24
|
Thanks Bruce.
I'll upgrade. Sorry for the trouble.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome. It was not any trouble. I am sorry I didn't realize you needed the longer formula when I replied originally.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Gold Customer
Joined: 2/18/2010 Posts: 24
|
Hi Bruce,
I have downloaded and installed the latest version through the link given above but still got the error message. On closer look, apparently this version is 16.0.5765.24948....is this V16, which is older than the required V17 or newer in order to use the short formula?
Thanks.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
At this point it would need to be version v17, v18, v19, or v20 to be v17 or newer. If ethier link is installing or running TC2000 v16, you may want to contact technical support.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Gold Customer
Joined: 2/18/2010 Posts: 24
|
Got it reolved with the technical team.
Many thank, Bruce.
|
|
Gold Customer
Joined: 2/18/2010 Posts: 24
|
Hi Bruce,
It's me again.
Under Chart Properties>Color/Grid...
How come I cannot adjust the Date Margin to 0%?
Thanks.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You need to not show trading in order to set the date margin to 0%.
- Select Trading and uncheck Show Trading.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Gold Customer
Joined: 2/18/2010 Posts: 24
|
Thanks again!
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |