Login Page - Create Account

Support Board


Date/Time: Tue, 04 Nov 2025 21:47:59 +0000



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

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

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

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