Support Board
Date/Time: Sat, 28 Dec 2024 07:18:22 +0000
Post From: Basic Examples of How You Use INDEX, MATCH / Spreadsheet Performance Improvements Now Available
| [2016-01-07 01:32:41] |
| |
|
We have been successful with a major performance improvement involving your test spreadsheet which makes extensive use of INDEX and MATCH: scss speed test 2.scss On our test system your original test spreadsheet took 26 seconds to calculate. You mentioned about 100 seconds previously, but your system may not be as fast and also we have been working on other performance improvements which are probably making a difference as well. Using the new optimized function to implement what you are doing, this now drops to under 1 second. Therefore, we have reduced calculation time by 96%. This is the new function we are testing: =GETCORRESPONDINGMATCH($K3:$K1002, L$1, 0, 1, 0, $E3:$E1002, 0) We will have a new release out tomorrow along with documentation for the function. However, keep in mind this function is still being implemented and is not likely to be fully implemented until the end of this week. At this time it supports your particular test spreadsheet scenario or scenarios involving exact matches in an array of ascending elements. The documentation for GetCorrespondingMatch is now here: http://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetFunctions.html The function is designed to work with columns and not multicolumn ranges. But we can add that capability. 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: 2016-01-07 04:21:32
|