Support Board
Date/Time: Sun, 08 Sep 2024 01:41:19 +0000
SUM spreadsheet column by date
View Count: 1332
[2017-05-03 21:59:23] |
User98657 - Posts: 313 |
i'd like to know if there's a way to sum, Average, and find the Max and Min for a column in a spreadsheet but only for the values for today. My spreadsheet includes all the dates loaded on the chart of course, but i want to base a formula on certain parameter relative to today's trading only. I've looked through the documentation and i'm not seeing any way to construct a formula to provide, for instance, a sum of values from today's date. in Excel this would be akin to SUMIF, AVERAGEIF, MAXIFS, AND MINIFS. |
[2017-05-04 01:08:22] |
|
Refer to: Spreadsheet Functions: Using the Equivalent of COUNTIF, AVERAGEIF, MAXIF, MINIF, SUMIF 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 |
[2017-05-04 12:47:26] |
User98657 - Posts: 313 |
yes, i see how i could use other columns to manipulate the counting of values, but it was the sum by date that i was trying to work around. But i'll figure out some work around based on 'IF(A3=A$3....)
|
[2017-05-04 13:07:43] |
User98657 - Posts: 313 |
I do have a follow up question to this. How can i extract the date from column A? I need to total a value by today's date. i cant' simply ask the formula to check A3 against A$3 because it contains the time. The "Date" function doesn't return the date. I guess I could use the "DAY" function for this purpose, but it would be better if i could work with the date.
|
[2017-05-04 16:39:02] |
|
This is the function you will want to use with the Date-Time values in column A to get only the Date: http://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#INTDATE_Function 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 |
To post a message in this thread, you need to log in with your Sierra Chart account: