New version 18 available now


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


New account application Trading resources
Margin rates Stock & option commissions

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

Question about WRSI Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
tkamada
Posted : Tuesday, August 28, 2018 10:17:35 AM
Gold Customer Gold Customer

Joined: 3/31/2011
Posts: 65

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?

Bruce_L
Posted : Tuesday, August 28, 2018 10:41:07 AM


Worden Trainer

Joined: 10/7/2004
Posts: 64,759

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
tkamada
Posted : Tuesday, August 28, 2018 11:01:14 AM
Gold Customer Gold Customer

Joined: 3/31/2011
Posts: 65

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?

 

Bruce_L
Posted : Tuesday, August 28, 2018 11:12:43 AM


Worden Trainer

Joined: 10/7/2004
Posts: 64,759

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
tkamada
Posted : Tuesday, August 28, 2018 11:17:08 AM
Gold Customer Gold Customer

Joined: 3/31/2011
Posts: 65

Bruce: Thank you. I appreciate your help. 

guestz2002
Posted : Saturday, February 09, 2019 7:52:25 AM
Gold Customer 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

Bruce_L
Posted : Monday, February 11, 2019 11:14:43 AM


Worden Trainer

Joined: 10/7/2004
Posts: 64,759

Please try the following.

WRSI9 >= WRSI9.1 + 50



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
guestz2002
Posted : Monday, February 11, 2019 12:15:52 PM
Gold Customer 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.

Bruce_L
Posted : Monday, February 11, 2019 12:36:32 PM


Worden Trainer

Joined: 10/7/2004
Posts: 64,759

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
guestz2002
Posted : Monday, February 11, 2019 12:46:52 PM
Gold Customer Gold Customer

Joined: 2/18/2010
Posts: 24

Thanks Bruce.

 

I'll upgrade.  Sorry for the trouble.

Bruce_L
Posted : Monday, February 11, 2019 1:13:46 PM


Worden Trainer

Joined: 10/7/2004
Posts: 64,759

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
guestz2002
Posted : Monday, February 11, 2019 1:34:01 PM
Gold Customer 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.

Bruce_L
Posted : Monday, February 11, 2019 1:51:00 PM


Worden Trainer

Joined: 10/7/2004
Posts: 64,759

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
guestz2002
Posted : Monday, February 11, 2019 2:44:58 PM
Gold Customer Gold Customer

Joined: 2/18/2010
Posts: 24

Got it reolved with the technical team.

Many thank, Bruce.

guestz2002
Posted : Monday, February 11, 2019 4:29:56 PM
Gold Customer 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.

Bruce_L
Posted : Monday, February 11, 2019 4:41:32 PM


Worden Trainer

Joined: 10/7/2004
Posts: 64,759

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
guestz2002
Posted : Monday, February 11, 2019 6:23:02 PM
Gold Customer Gold Customer

Joined: 2/18/2010
Posts: 24

Thanks again!

Bruce_L
Posted : Tuesday, February 12, 2019 8:54:26 AM


Worden Trainer

Joined: 10/7/2004
Posts: 64,759

You're welcome.



-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.