Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 27 Apr 2024 19:41:38 +0000
Is it possible for the SUM function to not add data from the previous day?
View Count: 443
| [2020-07-29 14:22:34] |
| User484096 - Posts: 9 |
|
Is it possible for the SUM function to not add data from the previous day?
|
| [2020-07-29 14:53:44] |
| User90125 - Posts: 715 |
|
Look at the Cumulative Sum of Study and set Reset at Start of Trading Day to Yes.
|
| [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
|
To post a message in this thread, you need to log in with your Sierra Chart account: