Support Board
Date/Time: Sun, 09 Feb 2025 01:20:24 +0000
Post From: Is it possible for the SUM function to not add data from the previous day?
| [2020-07-29 19:48:55] |
| |
|
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
|