Login Page - Create Account

Support Board


Date/Time: Fri, 10 May 2024 10:37:04 +0000



Post From: Is it possible for the SUM function to not add data from the previous day?

[2020-07-29 19:48:55]
Sierra Chart Engineering - Posts: 104368
To do what you want, you would need to create a new column of data that displays the data if it is part of Today's trading day and would output a 0 otherwise. Refer to the IF statement for Spreadsheets here:
https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#IF_Function

And refer to the following for working with Dates and Time:
Spreadsheet Functions: Serial DateTime Values

Also post #2 is a good solution.
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
Date Time Of Last Edit: 2020-07-29 19:49:14