Please provide an indicator (value) for candlestick body percent.

So the body as a percentage of the entire candle?

IIF(H > L, 100 * ABS(O - C) / (H - L), 0)

The above arbitrarily defines a body where the high and low is the same as having a body which is 0% of the candle, but you could change it to another value if desired (such as 50 or 100).

When I use the above formula for Body % below along with the two older formulas below for Lower Wick and Upper Wick no longer add up to 100%.  Previously, I had been given a formula for Body % without the IFF capability (which I had deleted).

IIF(H > L, 100 * ABS(O - C) / (H - L), 0

Can you please revise these so the total of the three adds up to 100%?

Lower Wick %:

100 * ((O + C - ABS(O - C)) / 2 - L) / (H - L + .00001)

Body %:

IIF(H > L, 100 * ABS(O - C) / (H - L), 0

Upper Wick %:

100 * (H - (O + C + ABS(O - C)) / 2) / (H - L + .00001)

You can just use the following for Body% if you don't want to use the IIF() structure, but it is actually a worse way to deal with the division by zero issue when the candle doesn't have any range.

100 * ABS(O - C) / (H - L + .00001)

If the IFF formula for Body % is better, then can you change the formulas for Lower Wick % and Upper Wick % using IFF capabilities?

Then, would three IFF formulas equal 100 percent?

Well I guess I could force it to total 100% even if the candle has no range by making all three formulas return 33.33% instead of 0% or 100%.

Upper%:

IIF(H > L, 100 * (H - GREATEST(O, C)) / (H - L), 100 / 3)

Body%:

IIF(H > L, 100 * ABS(O - C) / (H - L), 100 / 3)

Lower%:

IIF(H > L, 100 * (LEAST(O, C) - L) / (H - L), 100 / 3)

But you probably should replace that 100 / 3 with something like 0, 100 or possibly even -1 to make sure you know that neither the body nor the candle has any range at all.

Thanks for these new formulas, Bruce.

 You're welcome.