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))) 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
|