Support Board
Date/Time: Sun, 29 Dec 2024 14:13:34 +0000
Post From: Basic Examples of How You Use INDEX, MATCH / Spreadsheet Performance Improvements Now Available
| [2015-12-27 08:07:32] |
| |
|
This is the new function that we are proposing to add: GetCorrespondingMatch(SearchColumn, SearchNumber, NearestOrExact, SearchRangeOrderingFlag, ReturnResultColumn, ReturnResultRowOffset)
SearchColumn: The column range to be searched. SearchNumber: The number to search for in the SearchColumn. NearestOrExact: 0 = exact match. 1 = nearest match. SearchRangeOrderingFlag: 1 = SearchColumn values are ascending. (Lowest numbered row has the lowest numbers. Highest numbered row has higher numbers). 0 = SearchColumn is unordered (Has negative performance impact when used). -1 = SearchColumn values are descending. (Lowest numbered row has the highest numbers. Highest numbered row has lowest numbers). ReturnResultColumn: The column range where a reference will be returned for the corresponding row where the match was found. ReturnResultRowOffset: A positive or negative row offset for the row returned by ReturnResultColumn. Also in your example Spreadsheet you are performing an exact match and according to the definition of the MATCH function we would assume that there cannot be any optimization because the elements are assumed to not be ordered. So we are not sure why Old Spreadsheets are performing such extensive searches so fast. There must be an assumption that the elements are ordered. Perhaps that is automatically detected. Column K is clearly ordered. We will have to test Old Spreadsheets and see that if Column K is randomly ordered, that it would be so fast. It does not make sense that it would be. Otherwise, there is some unknown optimization that Old Spreadsheets is using. 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-27 08:08:30
|