Home >> Support Board

Support Board

Date/Time: Fri, 26 Apr 2024 20:14:17 +0000

How to Post a Message for Support

MEDIAN() of range in SC non-CLR spreadsheet

View Count: 1460

[2014-05-22 13:29:54] #1 [Go To First Post]
joshtrader - Posts: 439
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] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
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] #3 [Go To First Post]
joshtrader - Posts: 439
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] #4 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
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] #5 [Go To First Post]
joshtrader - Posts: 439
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] #6 [Go To First Post]
Sawtooth - Posts: 3976
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] #7 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
IMO, the new spreadsheets are still a long way from being a viable alternative. Possibly for advanced users yes. But we think for most users they are more than sufficient. 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] #8 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
IMO, the new spreadsheets are still a long way from being a viable alternative. When you actually see what they are capable of and the new features they have, we think that you may take it different view. Give them a chance. Soon the new spreadsheets will be part of the main release. 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] #9 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
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] #10 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
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: