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?

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?

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.

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.

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

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.