Support Board
Date/Time: Sat, 10 May 2025 07:39:16 +0000
Post From: Basic Examples of How You Use INDEX, MATCH / Spreadsheet Performance Improvements Now Available
| [2016-01-07 01:40:29] |
| |
|
The basic reason we were able to make such a dramatic difference so quickly is the fact that the MATCH function was never optimized previously. It was performing a long iteration to do a search. And also using a single function purpose built for what you want, also has performance improvements. One thing we want to make clear, there has never been anything fundamentally wrong with New Spreadsheets regarding performance. The particular performance problems that existed when using the MATCH function and the full recalculations that were taking place when using the Spreadsheet Study were problems that were easily identified and addressed. We are confident with the changes we have made, and coming improvements, including enhanced error reporting to make understanding errors and locating exactly where they are in a formula much easier, that you are going to recognize New Spreadsheets as superior to Old Spreadsheets. At least in regards to speed and calculation capabilities. So what we would need from you, is further information about new functions and enhancements to existing functions to accomplish what you need in a simpler and efficient way. When it comes to visual formatting capabilities, New Spreadsheets are not expected to have all of the capabilities of Old Spreadsheets but that is not our main objective with spreadsheet functionality in Sierra Chart anyway. 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 02:15:09
|