Support Board
Date/Time: Sat, 28 Dec 2024 09:10:21 +0000
Post From: SPREADSHEET - MOSTRECENTNONZEROVALUE(Range)
| [2016-02-19 22:26:38] |
| bekitz3 - Posts: 83 |
|
Thx for your input but this analysis is incorrect. Because SC's spreadsheets are in descending order by default, the traits of conventional spreadsheets (Excel, etc) do not apply. Because of the descending order, row 3 is always the most recent event and any ranges cited need to be treated in an inverse fashion. G3 is the last value & G10 is the first. Also, in my case, column G would always have a value because I'm using an activity based bar (renko, range, reversal, etc) and by default this column is "# of Trades" |