Support Board
Date/Time: Tue, 26 Nov 2024 17:14:52 +0000
Post From: MEDIAN() of range in SC non-CLR spreadsheet
| [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
|