Gm, i've written this condition formula:

- Stocks between 40 - 100 with daily range > 4%

- Stocks between 100 - 200 with daily range > 3%

- Stocks over 200 with daily range > 2%

(((((H-L)/L)*100) > 4) AND (40<C<100)) OR (((((H-L)/L)*100) > 3) AND (100<C<200)) OR (((((H-L)/L)*100) > 2) AND (C>200))

but in the results i find also stocks between 40 and 100 with a daily range between 3 and 4 (it should be at least 4).

Why? I don't understand.

Thank You

V.

For starters, you can't just write 40<C<100, you need to write this as 40 < C AND C < 100 instead. In any case, please try the following.

(40 <= C AND C < 100 AND 100 * H > 104 * L) OR (100 <= C AND C < 200 AND 100 * H > 103 * L) OR (200 <= C AND 100 * H > 102 * L)

It works! n&deg; 1 Bruce.

Thank You very much.

Bruce, same problem:

- Stocks with fibonacci daily between 100 and 61,80 (at bottom) AND Close < Open

- Stocks with fibonacci daily between 38,20 and 0 (at top) AND Close > Open

I get some bad results:

((C-H)/(H-L)*100> -100 AND ((C-H)/(H-L)*100) < -61 AND C<O) OR ((C-H)/(H-L)*100> -39 AND C>0)

What's wrong?

Thank You.

V.

You didn't provide specific examples of bad results, but the formulas can be shortened.

(STOC1 <= 38.2 AND C < O) OR (STOC1 >= 61.8 AND C > O)

I did eliminate the requirement that the close be above the low from your formula in the first section since it wasn't part of your English language description or have a similar section in the second part of your formula that the close be below the low.

I also refined the results to 61.8 and 38.2 instead of 39 and 61 as that is what was in the English language description.

The last letter O in your formula actually seemed to be the number 0 (zero). This would have meant the close just needed to be positive (which is it for all stocks) instead of having to be above the open.

No words, big thank you Bruce.

I didn't really develop the formula VikinGo75 provided. I only tried to streamline it. That means I cannot really explain the original intent.

That said, the open always comes before the close. The high and low could be the open or close, but are generally between the open and close in that they cannot happen prior to the open or after the close. We cannot tell if the high or low happened first using just daily data.

So let's take a look at the first part.

10 * STOC1 <= 382 AND C < O

It checks for the close to be in the bottom 38.2% of the candle with the close between the open and low (albeit possibly at the low).

The second part checks for the reverse.

10 * STOC1 >= 618 AND C > O

This checks for the close to be in the top 38.2% of the candle with the close between the open and high (albeit possibly at the high).

Is it necessarily a fib retracement? No. But it does use fib percentages as to where the closing price is relative to the entire range of the day.

With this in mind, the value cannot be greater than 100% or less than 0%. So if you were to take this to its logical conclusion where you were looking only at extreme cases, the formulas would be:

(L = C AND C < O) OR (O < C AND C = H)

You're welcome.