Login Page - Create Account

Support Board


Date/Time: Wed, 17 Oct 2018 13:13:05 +0000



[Locked] - Spreadsheets lose formulas

Support Request:
[2017-12-04 15:29:14]
User98657 - Posts: 144
This is the second time my spreadsheets have lost all their formulas and I'd like to learn why it keeps happening so i can avoid it.

Going forward i will try to save the final product under a different name so as to have a backup (hopefully).

I'm guess the loss occurred when i duplicated the chart or changed the symbol on the chart.
[2017-12-04 18:18:28]
Sierra Chart Engineering - Posts: 64895
There are two potential reasons here.

If this occurred when you have opened the Spreadsheet or the Chartbook making reference to the Spreadsheet it might have been due to a problem with saving it. If there was an out of memory condition while saving it, that kind of issue is going to be resolved in a week or so.

The other more likely issue has to do with the Formula Source Sheet Number Input:
https://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html#FormulaSourceSheetNumber


I'm guess the loss occurred when i duplicated the chart or changed the symbol on the chart.
Not sure why it would happen with either of these. But we would have to go through that scenario with the particular Chartbook you have and see.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
Date Time Of Last Edit: 2017-12-04 18:19:52
[2017-12-04 18:19:16]
Sporken - Posts: 81
There is a /Backups folder in your Sierra Charts folder. The scss files might be there.
[2017-12-05 04:35:48]
Sierra Chart Engineering - Posts: 64895
Yes that is absolutely true. There is a backup of Spreadsheet files in the /Backups subfolder in the folder Sierra Chart is installed to.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2017-12-05 23:20:48]
User98657 - Posts: 144
I think i figured it out. I may have duplicated this chart to a different CB. When i did, I didn't catch the fact that the newly created chart had the same chart number as the original chart (coincidence). When i opened the second CB and new chart, the spreadsheet now had a new chart to reference. I think this caused the issue. I have now created a second spreadsheet for trading study and newly named spreadsheet for the second chart. They seem to be working fine now. I've also created backups. Thank you all for the support.
[2017-12-07 04:15:55]
Sierra Chart Engineering - Posts: 64895
Yes this does make sense and this is now explained here:

https://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html#ChartDataOutputSheetNumber
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2017-12-08 14:46:07]
User98657 - Posts: 144
so it happened again this morning. i lost all the current formulas an alert spreadsheet. i did not duplicate the chart this time. For some reason, it reverted back to a much earlier version of the sheet. i can tell it reverted back because there are only two formulas left in the sheet as opposed to the 6 columns i had working last night when i went to bed.

Also, while running in safe mode, SC locked up. Just sat there with a spinning wheel and a (program is not responding) on the title bar of the main window. I was eventually able to shut it down and restart it.

When i did restart and noticed the spreadhseet issue i tried to us "Save As" to see if i had renamed it as a back up. So i reattached the spreadsheet to the main window, clicked on Save As, and immediately got a "SierraChart.exe has stopped working" error.

This is all while in safe mode. I'm running in safe mode at your suggestion to ferret out another issue on "unhandled exceptions" - which, while running in safe mode, has not occurred.

There is a back up file from yesterday for my spreadsheet. The time stamp puts it a couple of hours before i stopped working, but it would be better than the one i have. i will try to shut down, restart in safe mode, and access the backup file from yesterday.
[2017-12-08 14:55:02]
User98657 - Posts: 144
The backup file from yesterday was completely empty.

i tried loading the backup chartbook. it had the same two formulas as the current version.

i then tried replacing the spreadsheet in the study with the spreadsheet saved yesterday from the backup folder. That spreadsheet was completely blank, no formulas at all.
[2017-12-08 18:12:36]
Sierra Chart Engineering - Posts: 64895
If this issue is happening when you get these exception errors in the log, even at least one of them, then it is probably related to that indirectly.

Otherwise, from our perspective it is hard for us to comment on this without seeing precisely what is happening and the Spreadsheet Study settings and any interaction you had with Sierra Chart at that time.

And there are backups available for 30 days, so go back further in time. As long as the spreadsheet was properly saved, it should contain what you saw in it at the time.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
Date Time Of Last Edit: 2017-12-08 18:13:49
[2017-12-08 18:37:51]
User98657 - Posts: 144
i agree that its probably connected to the Win10 compatibility issue.
[2017-12-10 22:17:15]
Sierra Chart Engineering - Posts: 64895
Part of the problem could be related to memory allocation errors when saving and opening spreadsheets due to an out of memory condition.

This potential issue is going to be resolved with a new release coming out the week of December 18.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
Date Time Of Last Edit: 2017-12-10 22:17:48
[2017-12-11 09:32:21]
wetro - Posts: 59
i have the same problem of disappearing formulas..that happens when windows crashes or when i shut down and restart ...
i tidy tile file-save but still lose formula ... this is some problem with sc?
thanks
[2017-12-11 18:19:32]
Sierra Chart Engineering - Posts: 64895
Most likely the issue has to do with memory allocation errors. This problem will be solved with a new release next week.

Try to minimize the amount of data in Spreadsheets.

Refer to:
https://www.sierrachart.com/index.php?page=doc/UsingTheSpreadsheetStudy.php#ClearingOldStudyAndOtherDataFromSpreadsheets

Back up spreadsheets are available.

Refer to:
https://www.sierrachart.com/index.php?page=doc/WorkingWithSpreadsheets.php#AccessingABackupSpreadsheetFile
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2017-12-11 21:22:08]
wetro - Posts: 59
make a priority or something to ...
please contact me for a new release please ... the formulas are only two
thx
[2017-12-13 05:18:32]
Sierra Chart Engineering - Posts: 64895
We will have a new release for testing the new streaming format for saving and reading spreadsheets, out tomorrow.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
Date Time Of Last Edit: 2017-12-13 05:18:58
[2017-12-14 15:11:23]
wetro - Posts: 59
1663 vers. also the last two versions often stoped work sierra constantly
dtc
Date Time Of Last Edit: 2017-12-14 15:12:49
[2017-12-15 10:17:13]
Sierra Chart Engineering - Posts: 64895
We have released version 1670. Test with that version and let us know.

It sounds like there could still be an out of memory condition occurring. This really is the only reasonable explanation because Sierra Chart is very solid and reliable software.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2017-12-20 11:31:16]
wetro - Posts: 59
i am 1670 update version and now i do not connect platform ... can not connect?
Is there a problem with that version?
[2017-12-20 11:45:20]
wetro - Posts: 59
Reading Internal Order ID file. | 2017-12-20 12:02:06
HTTPS connection to www.sierrachart.com:443 (3) | Socket gracefully closed by remote side. | 2017-12-20 12:02:06
HTTPS connection to www.sierrachart.com:443 (3) | Received socket Close event. | 2017-12-20 12:02:06
Reading Trade Orders file. | 2017-12-20 12:02:06
Reading Trade Positions file. | 2017-12-20 12:02:06
Listening on UDP port 22903. | 2017-12-20 12:02:06
Software version: 1670 | 2017-12-20 12:02:06
Enabled for: Advanced Features. | 2017-12-20 12:02:06
Enabled for: Sierra Chart Historical Data Service. | 2017-12-20 12:02:06
Allow Support for Sierra Chart Data Feeds is enabled. | 2017-12-20 12:02:06
Current selected Data/Trading service: Rithmic Trading | 2017-12-20 12:02:06
Chart Update Interval: 500 | 2017-12-20 12:02:06
Data/Trade Service Settings automatically set. | 2017-12-20 12:02:06
Time Zone: +01:00:00 (CET+01CEST+01,M3.5.0/02:00,M10.5.0/03:00) | 2017-12-20 12:02:06
2017-12-20 12:03:30 Local computer time | 2017-12-20 12:02:06
2017-12-20 11:03:30 Local computer time in UTC | 2017-12-20 12:02:06
2017-12-20 12:03:30 Local computer time in SC Time Zone | 2017-12-20 12:02:06
2017-12-20 11:02:40 Server time in UTC | 2017-12-20 12:02:06
Local computer UTC time and Server UTC time difference: 7 seconds. | 2017-12-20 12:02:06
Program path: C:\SierraChart\ | 2017-12-20 12:02:06
Data Files path: C:\SierraChart\Data\ | 2017-12-20 12:02:06
OS Version Number: 6.1 | 2017-12-20 12:02:06
Locale Setting: C | 2017-12-20 12:02:06


Rithmic Trading | Port for executable: 64208 | 2017-12-20 12:40:29
Listening socket (1184). Port 64208 | Closed. | 2017-12-20 12:40:29
Rithmic Trading | Starting server: C:\SierraChart\Rim\DTCBridge.exe | 2017-12-20 12:40:29
Rithmic Trading | Bridge process is not running! | 2017-12-20 12:40:31
Rithmic Trading | Connecting to the server 127.0.0.1. Port 64208 | 2017-12-20 12:40:31
DTC Client socket (216) | Creating socket. | 2017-12-20 12:40:31
DTC Client socket (216) | Connecting to IP: 127.0.0.1. | 2017-12-20 12:40:31
DTC Client socket (216) | Connect event error. Windows error code 10061: No connection could be made because the target machine actively refused it. | 2017-12-20 12:40:32 *
DTC Client socket (216) | Initiating close of socket by core. | 2017-12-20 12:40:32
Error connecting to Data or Trading service. For help with this issue, press the 'Send For Analysis' button on this window. | 2017-12-20 12:40:32
Select 'File >> Disconnect' to prevent further connection attempts. | 2017-12-20 12:40:32
DTC Client socket (216) | Closed. | 2017-12-20 12:40:32
Rithmic Trading | Disconnected. | 2017-12-20 12:40:32
Will reconnect to the server in 2.0 minutes. Select 'File >> Disconnect' to prevent further connection attempts. | 2017-12-20 12:40:32

Rithmic Trading | Port for executable: 64240 | 2017-12-20 12:42:32
Listening socket (1320). Port 64240 | Closed. | 2017-12-20 12:42:32
Rithmic Trading | Starting server: C:\SierraChart\Rim\DTCBridge.exe | 2017-12-20 12:42:32
Rithmic Trading | Bridge process is not running! | 2017-12-20 12:42:34
Rithmic Trading | Connecting to the server 127.0.0.1. Port 64240 | 2017-12-20 12:42:34
DTC Client socket (220) | Creating socket. | 2017-12-20 12:42:34
DTC Client socket (220) | Connecting to IP: 127.0.0.1. | 2017-12-20 12:42:34
DTC Client socket (220) | Connect event error. Windows error code 10061: No connection could be made because the target machine actively refused it. | 2017-12-20 12:42:35 *
DTC Client socket (220) | Initiating close of socket by core. | 2017-12-20 12:42:35
Error connecting to Data or Trading service. For help with this issue, press the 'Send For Analysis' button on this window. | 2017-12-20 12:42:35
Select 'File >> Disconnect' to prevent further connection attempts. | 2017-12-20 12:42:35
DTC Client socket (220) | Closed. | 2017-12-20 12:42:35
Rithmic Trading | Disconnected. | 2017-12-20 12:42:35
Will reconnect to the server in 2.0 minutes. Select 'File >> Disconnect' to prevent further connection attempts. | 2017-12-20 12:42:35
Date Time Of Last Edit: 2017-12-20 18:07:26
[2017-12-20 11:50:39]
wetro - Posts: 59
I may have been annoying a bit when I tried to find a bitcoin symbol on global setings-symbol setings. after that i lost my connection and can not connect
[2017-12-20 12:35:32]
wetro - Posts: 59
Now I've tried the 1669 version..and it came in for a few seconds and lost the connection again and can not connect ... rithmic is given ... and I use it for years without a problem
[2017-12-20 18:08:34]
Sierra Chart Engineering - Posts: 64895
This connection problem needs to be posted in a different thread. We are locking this thread now.

Based upon what we see below:
Rithmic Trading | Port for executable: 64130 | 2017-12-20 12:36:49
Listening socket (812). Port 64130 | Closed. | 2017-12-20 12:36:49
Rithmic Trading | Starting server: C:\SierraChart\Rim\DTCBridge.exe | 2017-12-20 12:36:49
Rithmic Trading | Bridge process is not running! | 2017-12-20 12:36:51
Rithmic Trading | Connecting to the server 127.0.0.1. Port 64130 | 2017-12-20 12:36:51
DTC Client socket (205) | Creating socket. | 2017-12-20 12:36:51
DTC Client socket (205) | Connecting to IP: 127.0.0.1. | 2017-12-20 12:36:51

It appears as though some security software on your system is preventing the Rithmic bridge program from running. The first thing we recommend you do is restart the computer.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
Date Time Of Last Edit: 2017-12-20 18:09:17
[2018-09-01 00:19:46]
Sierra Chart Engineering - Posts: 64895
Regarding the original post in this thread. We are not sure of the cause in this particular case, however there was a related issue which has been resolved. Update to version 1795.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.

To post a message in this thread, you need to login with your Sierra Chart account:

Login


Login Page - Create Account