New version 18 available now


Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Candle Wick percentage Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
dhirenshah
Posted : Wednesday, August 08, 2018 1:19:07 AM
Registered User
Joined: 3/10/2012
Posts: 372

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 

 

Bruce_L
Posted : Wednesday, August 08, 2018 9:16:50 AM


Worden Trainer

Joined: 10/7/2004
Posts: 63,971

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)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Friday, August 10, 2018 10:24:55 AM
Registered User
Joined: 3/10/2012
Posts: 372

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

Bruce_L
Posted : Friday, August 10, 2018 10:29:06 AM


Worden Trainer

Joined: 10/7/2004
Posts: 63,971

(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.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.