Support Board

Date/Time: Tue, 04 Nov 2025 18:53:09 +0000

[Programming Help] - Spreadsheet formula for candlestick lower or upper tail size

[2020-09-13 18:45:19] #1 [Go To First Post]
rchtx794426 - Posts: 3
Can anyone show me a spreadsheet formula to get a candle bar's lower or upper tail size as a percentage of the bar's height? Thanks.

[2020-09-13 21:21:08] #2 [Go To First Post]
Sawtooth - Posts: 4285
Try this: Upper wick: =(C3-MAX(B3,E3))/(C3-D3) Lower tail: =(MIN(B3,E3)-D3)/(C3-D3)

To post a message in this thread, you need to log in with your Sierra Chart account: