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

Boolean Condition - 4% Rule Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
kenjanson
Posted : Monday, September 15, 2014 10:55:57 AM
Registered User
Joined: 12/21/2004
Posts: 35


To find 4% weekly moves in major indexes, here is a formula. (100 * (C-C1))/C1 > .04 (Weekly)

My problem is the chart (1 week) gives signals not consistant with 4% moves.

Is ths formula not correct?

Bruce_L
Posted : Monday, September 15, 2014 10:59:37 AM


Worden Trainer

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

Your formula could be simplified to the following, but is correct as written (at least if you are using a weekly time frame and are interested in the weekly bars).

C > 1.04 * C1

Note that this only checks for price moving up between the end of the previous calendar week and now. If you want to check for moves down as well, you could use something like the following instead.

ABS(C / C1 - 1) > .04

Can you provide some specific examples of when the formulas do not match the desired results?



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
kenjanson
Posted : Monday, September 15, 2014 11:21:27 AM
Registered User
Joined: 12/21/2004
Posts: 35

For example, from 8/1 to 8/8, SPY moved only 0.38% but the formula reading on 8/8 is 100 indicating a 4% move. The chart remains positive (100) until 9/12, seems like it is registering 100 on any positive move.

Bruce_L
Posted : Monday, September 15, 2014 11:58:57 AM


Worden Trainer

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

I missed the 100 * at the beginning of your formula. If you use this, you need to change the .04 at the end of the formula to 4. If you leave the 100 * off, then you would use .04 instead.

The formula as written is only checking for a 0.4% move.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
kenjanson
Posted : Monday, September 15, 2014 12:07:55 PM
Registered User
Joined: 12/21/2004
Posts: 35

Much better, thanks alot. And thanks for the down move formula.

Bruce_L
Posted : Monday, September 15, 2014 12:57:37 PM


Worden Trainer

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

Note the "down move" formula given above checks for both up or down moves. If you just want to check for down:

C < .96 * C1

I suspect you understood, but wanted to make it clear to anybody else reading the topic.



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