Login Page - Create Account

Support Board


Date/Time: Sat, 03 Oct 2026 13:37:38 +0000



Post From: Spreadsheet formula for candlestick lower or upper tail size

[2020-09-13 21:21:08]
Sawtooth - Posts: 4355
Try this:

Upper wick:
=(C3-MAX(B3,E3))/(C3-D3)

Lower tail:
=(MIN(B3,E3)-D3)/(C3-D3)