Support Board

Date/Time: Sat, 18 May 2024 04:37:15 +0000

Post From: Help with a Spreadsheet Sum column upon a condition then start from 0

[2020-12-06 02:36:45] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4000
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.