Login Page - Create Account

Support Board


Date/Time: Sat, 15 Mar 2025 22:59:24 +0000



[Programming Help] - How to get the last value in a column which is not zero in spreadsheet?

View Count: 378

[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
imageswing 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:

Login

Login Page - Create Account