Support Board
Date/Time: Sun, 22 Dec 2024 16:49:45 +0000
Spreadsheet Migration
View Count: 1094
| [2015-02-10 01:24:04] |
| User23815 - Posts: 210 |
|
I am migrating to the new spreadsheets. I only use the spreadsheet alerts. I followed the instructions for opening a 2nd instance of SC and then migrating my personal data into it. Next I downloaded the update with new spreadsheets. I was pleased to see it was migrating the spreadsheets. The new ones seem to be functioning as the old and I did not get an error message when the migration was completed. But now SC takes a very long time to load, stalls when I try and use the software, and keeps trying to update historical data. I am on SC data feed with IB trading. Symbols are the ES, ZN and EUR futures. Charts are Renko. Each time I restart the new version the box that appears saying what percentage of the ZN is loaded, the percentage is more than the last time. Then it goes into Not Responding mode for an extended period, and seems to be adding functionality little by little. Is this part of the migration and will resolve if I let it sit and totally finish or do I have an issue? If so is there troubleshooting documentation or can you point me in the right direction? Thanks
|
| [2015-02-10 07:32:09] |
| |
|
It does sound as though the problem is related to New Spreadsheets and you must have large complex spreadsheets which are taking time to calculate. From our perspective we cannot say exactly what the problem is though since we do not know what you are doing. What we want to know is when you stop using Spreadsheets altogether in this other copy of Sierra Chart, do you stop noticing the problem you are describing? 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-02-10 07:32:28
|
| [2015-02-10 21:32:30] |
| User23815 - Posts: 210 |
|
You are correct. The program opens just fine and if I open Chartbooks without spreadsheets attached all works as expected. My spreadsheet alerts are just confirmations of multiple studies being < or > at the same time. I have 4 different spreadsheet alerts on one chart and 4 charts in the chartbook. They were working fine in old spreadsheets. How would you suggest I trouble shoot to find the spreadsheet(s) that are causing the problem? Thanks |
| [2015-02-10 23:11:45] |
| |
|
Attach one of the spreadsheet files, and no others, here so we can test it. Here are instructions: https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile It can be privately attached. 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 |
| [2015-02-11 02:03:59] |
| User23815 - Posts: 210 |
|
Requested file is attached
|
Private File |
| [2015-02-11 05:37:09] |
| |
|
This file is an Old Spreadsheets file. When you open it in the version of Sierra Chart supporting New Spreadsheets it is converted to this file: ZN Momentum Flow.scss In the version of Sierra Chart supporting New Spreadsheets, open the ZN Momentum Flow.scss file by selecting File >>Open Spreadsheet. Let us know how long it takes for the spreadsheet file to load. This would be when the user interface of Sierra Chart is no longer in a frozen state. 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 |
| [2015-02-11 07:42:18] |
| |
|
We have identified one performance problem where it takes a very long time to close the Spreadsheet. When this is resolved, this may also improve the general operating performance of the spreadsheets. So we are going to be looking into this.
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 |
| [2015-02-11 18:25:22] |
| User23815 - Posts: 210 |
|
Any of my Alert Spreadsheets load normally if they are not attached to a chart. I tried removing the Alert Spreadsheets one by one to see if one particular spreadsheet might be causing the stalls. It made no difference other than the time to recalculate the chart with the study change did get a little faster with each spreadsheet removed. Once all were removed functionality on the chart returned to normal. The issue seems to be in calculating the spreadsheet formulas onto the chart. Any procedure that requires checking or recalculating will stall the program. This includes study changes, replay, order placement and saving. I am attaching the proper spreadsheet file this time, in the .scss file.
|
Private File |
| [2015-02-11 21:35:01] |
| |
|
Thank you for the additional information. We are going to be working on the performance issue. A lot of progress has been made, but we can see there are still outstanding performance problems we need to resolve.
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 |
| [2015-02-11 21:46:33] |
| User23815 - Posts: 210 |
|
So would my best course of action be to continuing using the Old Spreadsheets, but also continue to update the New Spreadsheet version as updates occur and check for improvement as the updates occur? I did a little more testing. It doesn't appear it is any one spreadsheet formula that is a problem. It is just the load of the calculations. I started with a chart and my studies, without the spreadsheet alerts, and then added them, first individually and then one by one together. Even with one there was some noticeable shortfall compared to Old Spreadsheets. Once I added two it was marginal and any more than that made it un-useable. Thanks for all your good work. SC is a great charting program and I have used many. |
| [2015-02-11 23:04:55] |
| |
|
Yes, continue using "Old Spreadsheets" for your day-to-day work.
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: