Login Page - Create Account

Support Board


Date/Time: Thu, 03 Jul 2025 06:44:41 +0000



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

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

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

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