Support Board
Date/Time: Tue, 26 Nov 2024 17:36:45 +0000
MEDIAN() of range in SC non-CLR spreadsheet
View Count: 1542
| [2014-05-22 13:29:54] |
| joshtrader - Posts: 488 |
|
In the old SC spreadsheet, I can do: =MEDIAN($A:$A5000) In the new SC spreadsheet, I get a "Value!" error if there are blank cells in the range. How should I get the value of all cells which are in a range, even if it contains empty cells? |
| [2014-05-22 16:26:09] |
| |
|
We will work on the function to support this.
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 |
| [2014-05-22 17:06:22] |
| joshtrader - Posts: 488 |
|
Thank you. Also note that I get a "Syntax" error when I do: =MEDIAN($A:$A) which worked in the old version. This should take the median of every value in the column. And I don't want to rush you too much as I know you have a lot on your plate, but I would greatly appreciate this if you could do it relatively soon, for what that's worth. Date Time Of Last Edit: 2014-05-22 17:08:15
|
| [2014-05-22 17:08:03] |
| |
|
That is a syntax error. This is not considered valid in Sierra Chart spreadsheets. We will not support this. We will make that clear now. 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 |
| [2014-05-22 17:09:01] |
| joshtrader - Posts: 488 |
|
Ok thanks for clarifying, I can just use a large value like $A$3:$A$10000 ... it did work in the old version but it's no big deal.
|
| [2014-05-22 17:29:37] |
| Sawtooth - Posts: 4120 |
|
In the CLR spreadsheets, I use the INDIRECT function to get all rows, relative to the Number of Rows setting: =MEDIAN(A3:INDIRECT("A"&$J$30+2)) But apparently INDIRECT is not a supported function in the non-CLR spreadsheets. IMO, the new spreadsheets are still a long way from being a viable alternative. |
| [2014-05-22 21:50:37] |
| |
|
IMO, the new spreadsheets are still a long way from being a viable alternative. In regards to something like this: =MEDIAN(A3:INDIRECT("A"&$J$30+2)) We think we can support this, but probably the syntax has to be different. So let us think about how to do this. In general we think we can provide all of the needed functionality but probably in different kinds of ways. 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 |
| [2014-05-23 22:48:24] |
| |
|
IMO, the new spreadsheets are still a long way from being a viable alternative. 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 |
| [2014-05-23 22:56:22] |
| |
|
We will add support for a column reference like this $A, which will mean the entire column.
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 |
| [2014-05-23 23:12:14] |
| |
|
Rather than supporting this which is massively complicated: =MEDIAN(A3:INDIRECT("A"&$J$30+2)) What we will instead do is support the ability to specify a column using the alternative column reference like this: ID0.SG1 If the Spreadsheet is set to use 1000 rows, this would be equivalent to: A3:A1002 You need to understand the engineering and development perspective of what you are doing. While something may seem simple like this: =MEDIAN(A3:INDIRECT("A"&$J$30+2)) This is very complicated to manage this internally and ensure the spreadsheet functions in a correct and logical way. Instead our objective is to provide alternative ways of doing things which accomplish what you need in a more straightforward way. So this is really the advantage of having our own spreadsheets. Rather than doing something a certain way because the old spreadsheets force you to do it that way, we will find a better and more efficient and orderly way to do that. So for this reason, we are certain that in the longer-term this is not going to be valid: IMO, the new spreadsheets are still a long way from being a viable alternative. 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: 2014-05-23 23:13:43
|
To post a message in this thread, you need to log in with your Sierra Chart account: