Support Board
Date/Time: Fri, 16 May 2025 13:46:28 +0000
Sierra Charts Crashes When Using SpreadSheets
View Count: 2066
| [2018-08-21 19:22:40] |
| User606491 - Posts: 164 |
|
Folks, Both '85 and '91 keep crashing on me. I can make changes to my studies without a crash occurring. Also, '91 shows a horizontal line at price = 0, which I have exist nowhere in my calculations. This renders '91 unusable to me. The last stable version for me was '81. However, for whatever reason, I am no longer able to revert back to '81 via the installer. How can I fix the situation? |
| [2018-08-21 19:31:48] |
| |
|
The first thing we want you to do is to run Sierra Chart in Safe Mode to see if this resolves the issue: Sierra Chart - Software Login Instructions: Using Safe Mode This could also be due to a Windows 10 issue related to graphics. Also what do you mean by "crash". We need a clear description. Also, '91 shows a horizontal line at price = 0, which I have exist nowhere in my calculations. This renders '91 unusable to me. To go back to a prior version just follow the instructions here: Software Download: Software Rollback Procedure 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: 2018-08-21 19:32:36
|
| [2018-08-22 06:13:46] |
| |
|
Another question we have is whether you are using the Spreadsheet Study or Spreadsheets?
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: 2018-08-22 06:13:55
|
| [2018-08-22 13:27:23] |
| User606491 - Posts: 164 |
|
Thanks for the responses. Safe mode: no change '85 and '91 still crash crash: defined as SC shuts down and does not restart. This only happens when I adjust parameters in my studies (i.e. add/delete a study, click apply to register changes, click OK) horizontal line at price = 0: I am confident that I do not have a study/spreadsheet/horizontal line here. In fact, '91 prints a line and p=0, and '85 prints another combination of lines. spreadsheet studies: yes, i use multiple spreadsheet studies and spreadsheets for trade management. I overlay studies from one time frame onto another time frame (ie. 1D study overlayed on 15M chart). As an FYI: I reverted back to 1781 and all problems above are cleared. No issues. |
| [2018-08-22 17:29:32] |
| |
|
We want you to provide the particular Spreadsheets and Chartbook files you are using when this condition occurs and we will test. Here are instructions: https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile They can all be privately attached so only we have access to them. You can also put them in a zip file and attach that. It is important that we get these files so we can determine what the problem is. 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: 2018-08-22 17:32:37
|
| [2018-08-22 17:31:03] |
| |
|
horizontal line at price = 0: I am confident that I do not have a study/spreadsheet/horizontal line here. In fact, '91 prints a line and p=0, and '85 prints another combination of lines. https://www.sierrachart.com/UserControlPanel.php?page=ManageAccountInfo Let us know and then we can call. Also refer to the prior post. 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: 2018-08-22 17:32:51
|
| [2018-08-23 17:20:12] |
| |
|
We are waiting for the files requested in post #5 above. It is important for us to resolve the issue. We are just going to test the problem and then we will delete the files. 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 |
| [2018-08-24 00:29:16] |
| User606491 - Posts: 164 |
|
Apologies for the delay. Busy couple of days. Please see the attached file. As an FYI, I run the same file across multiple symbols. Hence this is my chartbook for the British Pound. |
Private File |
| [2018-08-24 01:58:23] |
| |
|
Okay good. We will work on 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 |
| [2018-08-26 19:24:45] |
| User606491 - Posts: 164 |
|
Any update here would be much appreciated.
|
| [2018-08-26 22:12:09] |
| |
|
We are testing your Chartbook and spreadsheet files now. So far no exception encountered during a replay. crash: defined as SC shuts down and does not restart. This only happens when I adjust parameters in my studies (i.e. add/delete a study, click apply to register changes, click OK) horizontal line at price = 0: I am confident that I do not have a study/spreadsheet/horizontal line here. In fact, '91 prints a line and p=0, and '85 prints another combination of lines. 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 |
| [2018-08-26 22:29:15] |
| |
|
When you say "defined as SC shuts down and does not restart. ", does Sierra Chart just completely disappear, or do you get a message from Windows that says something like "Sierra Chart has encountered a problem and needs to shut down"? This is an important distinction for us. If it completely disappears, this would indicate a stack corruption in our experience. And when you add or remove a study can you tell us what study that is and on what chart number, so that we can reproduce 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 Date Time Of Last Edit: 2018-08-26 23:28:46
|
| [2018-08-26 22:33:25] |
| |
|
horizontal line at price = 0: I am confident that I do not have a study/spreadsheet/horizontal line here. In fact, '91 prints a line and p=0, and '85 prints another combination of lines. This is from the new Sum of Alerts Subgraph with the Color Bar Based on Alert Condition study which should by default be hidden. We will solve that. But you can just set its Draw Style to Ignore.Also take note of our prior posts. It is important for us to know what exactly the type of shutdown you encountered is. 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: 2018-08-26 22:34:52
|
| [2018-08-27 07:44:13] |
| |
|
Still no problem with the testing after about half a day of testing. Your charts and spreadsheets are running just fine. We are testing with the Sierra Chart 64-bit build under the debugger. We will also use our release build after a day or two. So not really sure what the problem is at this point. Update: Still no problem after running throughout the entire day. The last time we heard about a problem like this and were not able to reproduce it, it was due to an unhandled out of memory condition. But all out of memory conditions should be properly handled. Another possibility is the issue has been resolved in the latest code we are running now which has not yet been released. 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: 2018-08-27 18:46:12
|
| [2018-08-27 22:00:23] |
| User606491 - Posts: 164 |
|
Perhaps we can skype and I can show you want I see on my end. I just tried '93 and the issue of a horizontal line appearing at P=0 still remains. Yes, I have erased all drawing from each chart tab. Also, this line does not appear in 1781. can we skype? |
| [2018-08-27 22:23:16] |
| |
|
We have not yet done a new release. Just give us another day. And if you still have a problem after testing the latest release then we will have a look at what you are seeing.
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 |
| [2018-08-28 18:51:56] |
| |
|
Set your Skype Username here: https://www.sierrachart.com/UserControlPanel.php?page=ManageAccountInfo Let us know when that is done. We have continued to test your Chartbook and spreadsheets and 100% stable for more than two days now. We are also testing on the standard 64-bit release build. 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 |
| [2018-08-28 23:32:41] |
| |
|
We are going to put out a new release later today. We think the problem is related to optimizations in the internal spreadsheet component. We have now reverted that most recent change which occurred about a month ago. So we will want you to test with the latest version coming out later today.
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 |
| [2018-08-29 01:10:54] |
| |
|
Prerelease version 1794 has been released. We would like you to test with that. This is a prerelease and here are the instructions to update: Software Download: Fast Update If you want to just test this as a separate installation you can do that. Follow the instructions here to make a copy of your existing installation: Transferring Sierra Chart Settings and Data From Existing Installation to New Installation: Simple Transfer/Copy of Sierra Chart Installation to Another Folder or Computer System After that, just update that installation to the latest prerelease. 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 |
| [2018-08-29 02:41:28] |
| User606491 - Posts: 164 |
|
Thus far through my testing, version '94 seems to have corrected all the issues I was having. I'll continue to test this version through my live trading tomorrow to confirm that no issues arise. Whatever reversion was done on the spreadsheets seems to have worked. Horizontal lines at P=0 (and elsewhere) no longer appear. I've also noticed several performance improvements throughout SC - thank you. All that said, one issue arose during my initial tests. I mention this last because I haven't been able to replicate the issue, but it's worth mentioning: upon recalculating spreadsheets (and also after clicking Apply on Tools/Studies), I've noticed that SC deleted formulas from one of my spreadsheets. I copy/pasted the formulas from a prior version of the spreadsheet and SC accepted the insertion. I'm uncertain as to why SC would have deleted the formulas in the first place. This may be worth noting. Again, repasting the formulas worked, so this is not currently an issue. |
| [2018-08-29 02:43:17] |
| |
|
All that said, one issue arose during my initial tests. I mention this last because I haven't been able to replicate the issue, but it's worth mentioning: upon recalculating spreadsheets (and also after clicking Apply on Tools/Studies), I've noticed that SC deleted formulas from one of my spreadsheets. I copy/pasted the formulas from a prior version of the spreadsheet and SC accepted the insertion. I'm uncertain as to why SC would have deleted the formulas in the first place. This may be worth noting. Again, repasting the formulas worked, so this is not currently an issue. 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: 2018-08-29 03:15:25
|
| [2018-08-29 11:08:23] |
| User606491 - Posts: 164 |
|
Good question. No. Typically, when I make that mistake the referencing spreadsheet is entirely blank. In this instance, the formula source sheet remained consistent with prior versions, but simply deleted all the formulas that previously existed. Said differently, i did not change the formula source sheet upon reloading into '94. However, you are right. It's as if SC recognized another sheet as the formula source sheet, then deleted my formulas, and left the spreadsheet blank.
|
| [2018-08-31 14:18:45] |
| User606491 - Posts: 164 |
|
Checking in to see when a fix for the "data deleting from spreadsheets" will be released?
|
| [2018-08-31 16:37:21] |
| |
|
We are going to be looking into this with a user today. We are not able to reproduce it so we need to observe this during a remote assistance session to see what we can determine.
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 |
| [2018-08-31 18:21:41] |
| User606491 - Posts: 164 |
|
Happy to do the same if helpful for your purposes. For me, this happens upon: 1) Clicking Apply/OK on Tools/Studies 2) Reload and Recalculating the chart (Insert) My initial explanation was that SC somehow "switched" or "misread" the Formula Source Sheet, and hence deleted all formulas upon refresh. However, this explanation fails as the issue still occurs when I delete all spreadsheets except for the correct Formula Source Sheet. 64b version. |
To post a message in this thread, you need to log in with your Sierra Chart account: