Support Board
Date/Time: Sun, 16 Mar 2025 00:10:06 +0000
[Programming Help] - How to get the last value in a column which is not zero in spreadsheet?
View Count: 379
| [2022-08-04 12:03:00] |
| artmaan - Posts: 26 |
|
Hello, i am using the swing high/low study from zyp. the study shows the high and low in differrent columns. i am trying to access the last swing value, but i am not sure how to do it since the value keeps moving down . can you tell me please how to get the last value which is not zero? attached is a screeshot of the columns thank you Date Time Of Last Edit: 2022-08-04 12:03:32
|
 swing spreadsheet.png / V - Attached On 2022-08-04 11:58:23 UTC - Size: 43.53 KB - 92 views |
| [2022-08-04 14:14:56] |
| John - SC Support - Posts: 38678 |
|
EARLIESTNONZEROVALUE(Range) Refer to the information for this function here: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#EARLIESTNONZEROVALUE_Function For the most reliable, advanced, and zero cost futures order routing, use 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: