Support Board
Date/Time: Tue, 26 Nov 2024 19:37:54 +0000
Spreadsheet Speed / Logic Issue
View Count: 1267
| [2014-06-10 14:44:18] |
| drywater0 - Posts: 85 |
|
SC Chart, I created a spreadsheet study in Version 1137. The real time outputs are working fine but the processing of some Excel functions appears to be slow enough to cause errors. From a list of 35 different price levels, 20 of them change by small increments based on the last traded price and the others change much less frequently. I think my hardware is up to the task as I'm using a laptop with Intel quad-core i-7 @ 2.2Ghz and 8 GB RAM. I have used the LARGE function to place them in descending order, and then VLOOKUP to grab text information associated with the price levels. It appears that the LARGE function does not update / re-order components of the original list that are changing on a tick by tick basis. Hence, with stale values the VLOOKUP or INDEX & MATCH functions return a #N/A output. One solution I attempted was to round the quickly changing values to only two decimal places before they are sorted by the LARGE function. Unfortunately, the problem of stuck / stale values re-appeared within a couple price ticks. If I manually go into any blank cell on the sheet and hit enter, all the values in the list are updated and re-ordered but then quickly become stale. Much effort was expended in building the spreadsheet so I would be very grateful for your assistance. |
| [2014-06-10 20:57:07] |
| |
|
For an issue like this, we are no longer providing this kind of support for the Spreadsheet functionality in the main release of Sierra Chart. There is new spreadsheet functionality currently being developed in the non-CLR version. We recommend testing your formulas in that version. The development is a point now where you should be able to safely do your spreadsheet work in that version. However, there are still some performance improvements being made. You can update with Help >> Download Latest Non-CLR Version 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 |
| [2014-06-11 15:50:01] |
| drywater0 - Posts: 85 |
|
SC Support, Could you please help with these follow up questions. 1a) If I download the Latest Non-CLR Version, can I revert old CLR Version if I encounter problems? 1b) If this is possible, can you please provide instructions on how to access the old CLR Version as contingency? 2) Do you have an estimate for when the Non-CLR Version will incorporated into the "official" Release of Sierra Charts? 3) Is it possible to hide certain spreadsheet columns? 4) Is there a keyboard shortcut for changing relative references into absolute references similar to F4 in Excel? |
| [2014-06-11 16:40:03] |
| |
|
1. Yes. But the best approach is to install the non-CLR version into a separate folder on your system for testing this problem. You can download it from here: https://www.sierrachart.com/index.php?l=doc/download.php 2. We expect this will be done in July. 3. No. 4. We can add this. We will check on it. 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 |
To post a message in this thread, you need to log in with your Sierra Chart account: