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) |
