Home >> Support Board

Support Board

Date/Time: Fri, 03 May 2024 08:57:33 +0000

How to Post a Message for Support

Post From: New Spreadsheets INDEX function

[2014-11-23 23:00:46] Link To Thread - Link To Post [Go To First Post]
Sierra Chart Engineering - Posts: 104368
The INDEX function had a bug where the row and column offset parameters were switched around. This will be fixed in the next release coming out in a couple of days. Yes, I am used to doing things a certain way, which happens to be the same way the rest of the world uses Excel-compatible spreadsheets. Now I must reinvent the wheel, re-engineering things that are not directly convertible. The way that the world uses Excel compatible spreadsheets in certain kinds of ways is not necessarily the optimal way. We want to create a more optimal way. There is no doubt there are roundabout ways of doing things which could be a whole lot more efficient with dedicated functions to accomplish the same task. Once INDEX is fixed, will I be able to do this?: MAX(INDEX(MATCH)):INDEX(MATCH))) No. It is not possible to construct a range reference in this way. What we will need to do is create a two-part INDEX function that will return a range reference to give the same result. We will work on that. 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-11-23 23:01:00