Login Page - Create Account

Support Board


Date/Time: Fri, 07 Nov 2025 13:03:34 +0000



Post From: How to get the last value in a column which is not zero in spreadsheet?

[2022-08-04 14:14:56]
John - SC Support - Posts: 42830
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