Login Page - Create Account

Support Board


Date/Time: Tue, 11 Feb 2025 19:19:42 +0000



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

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

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

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