Login Page - Create Account

Support Board


Date/Time: Fri, 19 Apr 2024 18:46:31 +0000



can't open Spreadsheet on start, 1090 nonCLR

View Count: 1259

[2014-02-10 20:53:38]
namlem - Posts: 94
Hi SC team,
I had a spreadsheet system for trading attached to the chart and it was working ok, later I added another spreadsheet study and noticed, that it didn't have values of latest added study in its spreadsheet. I restarted SC and got an error which is shown below. Additionally, it suggested to save some studies, named SS2.scss and SS3.scss (see screenshots), the thing is that I don't have any names like these (my spreadsheet name angles4)

Software version: 1090 | 2014-02-10 20:23:02
Usage end date: 2014-05-02 | 2014-02-10 20:23:02
Enabled for: Sierra Chart Historical Data Service. | 2014-02-10 20:23:02
Allow Support for Sierra Chart Data Feeds is enabled. | 2014-02-10 20:23:02
Active service: SC Forex Data (FXCM) | 2014-02-10 20:23:02
Time Zone: +00:00:00 (UTC+00) | 2014-02-10 20:23:02
2014-02-10 21:23:02 Local computer clock time | 2014-02-10 20:23:02
2014-02-10 20:23:02 GMT time | 2014-02-10 20:23:02
2014-02-10 20:23:02 Time zone adjusted time | 2014-02-10 20:23:02
Time difference to server time: 1 seconds. | 2014-02-10 20:23:02
Program path: D:\SierraChart_NONET\ | 2014-02-10 20:23:02
Data Files path: D:\SierraChart_NONET\Data\ | 2014-02-10 20:23:02
OS Version Number: 6.2 | 2014-02-10 20:23:02

Checking for new symbol settings for scfxcm | 2014-02-10 20:23:02
Symbol settings are up-to-date for scfxcm | 2014-02-10 20:23:02

SC Forex Data (FXCM): Connecting to the server ds5.sierracharts.com. Port 443 | 2014-02-10 20:23:07
Resolved address ds5.sierracharts.com to IP 204.15.192.106 | 2014-02-10 20:23:07
The network socket is connected. | 2014-02-10 20:23:07
SC Forex Data (FXCM): Connected to server. | 2014-02-10 20:23:07
SC Forex Data (FXCM): Sending logon request message. | 2014-02-10 20:23:07
SC Forex Data (FXCM) Server Info - Server Name: . Server Version: . Provider Name: . | 2014-02-10 20:23:07
SC Forex Data (FXCM) - Server protocol version: 3. Client protocol version: 3. There is a protocol match. | 2014-02-10 20:23:07
SC Forex Data (FXCM) - Successfully connected. | 2014-02-10 20:23:07
File >> Disconnect selected. | 2014-02-10 20:23:09
SC Forex Data (FXCM): Disconnected from the server. | 2014-02-10 20:23:09
No SC real-time data feed mapping found for symbol: XAUUSD | 2014-02-10 20:23:13
No SC real-time data feed mapping found for symbol: XAUUSD | 2014-02-10 20:23:13
No SC real-time data feed mapping found for symbol: XAUUSD | 2014-02-10 20:23:13
No SC real-time data feed mapping found for symbol: XAUUSD | 2014-02-10 20:23:13
No SC real-time data feed mapping found for symbol: XAUUSD | 2014-02-10 20:23:15
No SC real-time data feed mapping found for symbol: XAUUSD | 2014-02-10 20:23:15
HD Request # 2 - Downloading Intraday chart data for XAUUSD to the file XAUUSD.scid. Service: fxcm | 2014-02-10 20:23:15
HD Request # 2 - Download start Date-Time: 2014-02-10 17:33:58.0 | 2014-02-10 20:23:15
HD Request # 2 - Using server: ds3.sierracharts.com port 10149 | 2014-02-10 20:23:15
Resolved address ds3.sierracharts.com to IP 65.182.172.164 | 2014-02-10 20:23:15
The network socket is connected. | 2014-02-10 20:23:15
HD Request # 2 - Sending historical data logon request message. | 2014-02-10 20:23:15
HD Request # 2 - Requesting up to 600 days of Intraday data. Record interval: 0 | 2014-02-10 20:23:15
HD Request # 2 - Decompressing data. | 2014-02-10 20:23:16
HD Request # 2 - Receiving Intraday data for XAUUSD starting at 2014-02-10 17:33:58 | 2014-02-10 20:23:16
HD Request # 2 - Timestamp of first Intraday data file record written: 2014-02-10 17:33:58 | 2014-02-10 20:23:16
The network socket for historical data has been closed. | 2014-02-10 20:23:16
HD Request # 2 - Historical data for XAUUSD is delayed because connection to main data feed is not present. Current data will be received upon connection. | 2014-02-10 20:23:16
HD Request # 2 - Received 8524 records from 2014-02-10 17:33:58 to 2014-02-10 20:23:05 (2.8 hours) and wrote 8523 records for XAUUSD | 2014-02-10 20:23:16
HD Request # 2 - Intraday download COMPLETE for XAUUSD | 2014-02-10 20:23:16
Out of order timestamps detected. Chart tool drawings and some chart studies may not function properly. Prior Date Time: 2013-08-26 16:00:00. Next Bar Date Time: 2013-08-26 15:00:00. Filename: D:\SierraChart_NONET\Data\XAUUSD.scid | 2014-02-10 20:23:18
Out of order timestamps detected. Chart tool drawings and some chart studies may not function properly. Prior Date Time: 2013-08-26 18:00:00. Next Bar Date Time: 2013-08-26 17:00:00. Filename: D:\SierraChart_NONET\Data\XAUUSD.scid | 2014-02-10 20:23:18
Out of order timestamps detected. Chart tool drawings and some chart studies may not function properly. Prior Date Time: 2013-08-26 16:12:00. Next Bar Date Time: 2013-08-26 15:48:00. Filename: D:\SierraChart_NONET\Data\XAUUSD.scid | 2014-02-10 20:23:18
Out of order timestamps detected. Chart tool drawings and some chart studies may not function properly. Prior Date Time: 2013-08-26 18:04:00. Next Bar Date Time: 2013-08-26 17:36:00. Filename: D:\SierraChart_NONET\Data\XAUUSD.scid | 2014-02-10 20:23:18
Out of order timestamps detected. Chart tool drawings and some chart studies may not function properly. Prior Date Time: 2013-08-26 15:56:53. Next Bar Date Time: 2013-08-26 15:50:37. Filename: D:\SierraChart_NONET\Data\XAUUSD.scid | 2014-02-10 20:23:21
Out of order timestamps detected. Chart tool drawings and some chart studies may not function properly. Prior Date Time: 2013-08-26 18:04:12. Next Bar Date Time: 2013-08-26 17:39:48. Filename: D:\SierraChart_NONET\Data\XAUUSD.scid | 2014-02-10 20:23:21
Chart: XAUUSD 1.50 Range #1 | Study: angles4 | Exception occurred while calling study function. | 2014-02-10 20:23:40
Chart: XAUUSD 1.50 Range #1 | Study: angles4 | Exception occurred while calling study function. | 2014-02-10 20:23:43

ok, i removed new added spreadsheet study, saved chartbook and restarted SC. Sad, but on next load, I was not able to load original study. The error message was:
Out of order timestamps detected. Chart tool drawings and some chart studies may not function properly. Prior Date Time: 2013-08-26 18:04:12. Next Bar Date Time: 2013-08-26 17:39:48. Filename: D:\SierraChart_NONET\Data\XAUUSD.scid | 2014-02-10 20:37:24
Chart: XAUUSD 1.50 Range #1 | Study: angles4 | Exception occurred while calling study function. | 2014-02-10 20:37:42
Chart: XAUUSD 1.50 Range #1 | Study: angles4 | Exception occurred while calling study function. | 2014-02-10 20:37:45
An unhandled exception was caught in c_MainMDIWindow::WindowProc. Message: 273, wParam: 32812, lParam: 0 | 2014-02-10 20:38:11
and screenshot (3.png) shows that it tried to open weird "SS3.scss" study...

The same error if I try to open my spreadsheet study via menu File-Open Spreadsheet.
If I do any operations like save or recalculate SC suggests to save study with incremented name SC4, SC5 and so on..
Have no idea how to open original spreadsheet study now, the size seems to be ok, but it's somehow got corrupted. Also tried to remove it and add with selecting its name, but always get an error:
Chart: XAUUSD 1.50 Range #1 | Study: angles4 | Exception occurred while calling study function. | 2014-02-10 20:49:44

Out of memory issue didn't take the place.

Another minor issue, not connected to the topic:
paste operation of formula with keyboard (ctrl+v) to any formula cell doesn't work properly. Test it.

Date Time Of Last Edit: 2014-02-10 21:25:56
image1.PNG / V - Attached On 2014-02-10 20:28:42 UTC - Size: 13.91 KB - 363 views
image2.PNG / V - Attached On 2014-02-10 20:29:47 UTC - Size: 23.33 KB - 360 views
Private File
[2014-02-10 22:00:38]
Sierra Chart Engineering - Posts: 104368
Can you attach the Spreadsheet files you are encountering problems with so we can test them. Here are the instructions to attach files:

https://www.sierrachart.com/index.php?l=PostingInformation.php#AttachFile

The files 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
Date Time Of Last Edit: 2014-02-10 22:02:06
[2014-02-10 22:10:00]
namlem - Posts: 94
Please see attached. Let me know if you need chartbook file.
angles4.csss is a corrupted file - I mean I can't open it after above issue occurred. Sorry I can't make it smaller, since I can't open it.
I'm also attaching those weird files which I was suggested to save.

Attachment Deleted.
Private File
Private File
Private File
Private File
[2014-02-10 23:20:46]
Sierra Chart Engineering - Posts: 104368
Thank you for these 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

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

Login

Login Page - Create Account