Login Page - Create Account

Support Board


Date/Time: Mon, 20 May 2024 18:06:42 +0000



Post From: Candle body size comparison

[2023-02-02 17:56:57]
DKtrades - Posts: 33
I have a larger formula I'm trying to create, which in part, compares the current candle to the previous candle, in terms of the size of the body (I'm wanting to be alerted when the body size is shrinking and momentum is slowing).

For example, here I want to see that the current candle (which I'm assuming is GREEN with O < C) is smaller in body size than the -1 RED candle (this is just one part of my formula, as this candle may be RED, GREEN or DOJI, but the previous candle here MUST be RED).

I am using:

=AND (O < C, C - O < (O[-1] - C[-1] + (2*TICKSIZE)))

To show that:

* The candle is GREEN (O < C)
and its body is smaller in size than the previous candle ... C - O < (O[-1] - C[-1] + (2*TICKSIZE))

However this is giving me alerts where the -1 candle is SMALLER or equal body size compared to the current candle, and I want it to be BIGGER.

If I can get some help with this part of the formula, I should be able to figure out the rest of it (as I want to also compare the -1 and -2 candles, which both must be RED, and the -2 candle bigger than the -1 candle in body size (OC, ignoring HL tails).

Any help would be very much appreciated. I have searched the forums and was trying to reference another thread I found (Formula for check between H and L of last three bars) but at the moment my alerts are showing some -1 candles that are the same size body or smaller than the current candle, not bigger.