Support Board
Date/Time: Sat, 10 May 2025 07:20:44 +0000
Post From: Basic Examples of How You Use INDEX, MATCH / Spreadsheet Performance Improvements Now Available
| [2015-12-16 17:27:54] |
| |
|
In Excel, HLOOKUP and VLOOKUP require the lookup row/column to be in ascending order,
This is so easy for us to change. And we also have to look at whether this is even a requirement in the SC implementation of these. These functions can easily be designed to work with data which is not in any particular order. These functions can also be given a hint flag indicating if the data is in a particular order to optimize them. However, our objective, is to create new functions which are purpose built. The objective is to create the functions that users require which are efficient, logical and orderly. The objective is not Excel compatibility. If anything, we should have a complete review of all functions, and optimize them for logic and efficiency. It only makes sense that SC Spreadsheets are implemented as logically and as efficiently as they can be and at most are "Excel like". 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: 2015-12-16 17:30:58
|