Support Board

Date/Time: Wed, 02 Jul 2025 23:17:47 +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: 4231
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: