Bruce i know the formula for body as % of candle using Open close candlesticks

But if i wish to know wick percentage in relation  to the Candle Size , so how to do that math ?

for Green candles ( OPEN < CLOSE)

a) wick on top of candle as %

b) wick on bottom of candle as %

for red candles ( OPEN > CLOSE)

a) wick on top of candle as %

b) wick on bottom of candle as %

thanks 

Please try the following for both green and red candles.

a)

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

b)

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

Thanks bruce for the above formulas

one more question 

Abs(H + L) / 2 gives me 50 % of the candle ,so what will be 33% formula of the candle

(H + L) / 2 gives you the midpoint in the candle.

(H - L) / 2 gives you half the width of the candle.

(2 * H + L) / 3 gives you the point a third of the way down the candle from the top.

(H + 2 * L) / 3 gives you the point a third of the way up the candle from the bottom.

(H - L) / 3 gives you a third of the width of the candle.