Support Board
Date/Time: Sat, 28 Dec 2024 09:22:06 +0000
SPREADSHEET - MOSTRECENTNONZEROVALUE(Range)
View Count: 1346
| [2016-02-19 16:49:01] |
| bekitz3 - Posts: 83 |
|
Can you please check the functionality of this spreadsheet function: MOSTRECENTNONZEROVALUE(Range) In an attempt to understand & test this function I entered a simple formula in static cell G1 ('# of Trades' column). G1=MOSTRECENTNONZEROVALUE(G3:G10) I suspected this to constantly return the value in G3, but it always returns G10. Date Time Of Last Edit: 2016-02-19 17:09:22
|
| [2016-02-19 18:19:17] |
| |
|
We will check on this.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2016-02-19 22:01:51] |
| Jeffrey - Posts: 2187 |
|
This is the documented functionality of the MOSTRECENTNONZEROVALUE formula function, as listed on the Spreadsheet Functions page: Returns the last non-zero value in the given Range. Empty cells are considered equivalent to zero. Returns a null value if all of the values in the Range are either null or zero.
Given the range G3:G10, and assuming the value at G10 is not 0 or empty, the function will return the value at G10. If all of the cells from G4 to G10 were empty, or had a value of 0, and G3 had some other value in it, then only in that case would the function return the value in G3. |
| [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" |
| [2016-02-19 23:48:51] |
| |
|
We see the problem and we are correcting the function and creating another one to work as this one currently does. Apparently though this function was programmed to work as was required for the purpose for which it was written for. But the naming of it is inconsistent with what it is actually doing. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: