Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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?
|
|
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
|
|
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.
|
|
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
|
|
Registered User Joined: 12/21/2004 Posts: 35
|
Much better, thanks alot. And thanks for the down move formula.
|
|
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
|
|
Guest-1 |