Login Page - Create Account

Support Board


Date/Time: Sun, 22 Dec 2024 06:02:21 +0000



Post From: New Spreadsheets INDEX function

[2014-11-23 23:00:46]
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