Support Board
Date/Time: Sat, 01 Nov 2025 00:38:38 +0000
Post From: Help with a Spreadsheet Sum column upon a condition then start from 0
| [2020-12-06 02:36:45] |
| Sawtooth - Posts: 4281 |
|
The spreadsheet study's array is in descending order: the current price bar is in row 3, and earlier bars are in rows below. The Close prices are in column E, which is in descending order, so it's not possible to do what you want in a Formula Column. If you could reverse it to ascending order, it would have no relationship to the chart bars. The formula I offered does what you want, but in descending order. |