Login Page - Create Account

Support Board


Date/Time: Sat, 20 Dec 2025 05:52:28 +0000



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

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

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

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