Login Page - Create Account

Support Board


Date/Time: Mon, 16 Sep 2024 19:25:12 +0000



Post From: Spreadsheet Study Programming Disappears After Saving?

[2015-03-25 19:08:46]
GiantAvocado - Posts: 67
I am back up but must say I have been an SC user since Jan'15 and am disappointed in the stability of the spreadsheet study function of SC. For someone like me to crash a very fine platform as SC with 3 lines of code is puzzling me. I have programmed Excel in VB for years and have crashed it only enough times to count on one hand.

By renaming the old default spreadsheet SC gave me a new one that is blank. I had copies of my code so I could paste it back into the refreshed default spreadsheet without spending an hour trying to remember what I wrote and with two charts and SS studies (1 chart-book open )it works fine.

Now I have only two spreadsheet studies (two charts), a third chart (in 2nd chartbook) with a SS study of 10000 rows still crashes SC. The log entry way down at the bottom (see below) describes the issue; same code on the same two "other" spreadsheets that are working. After the log comes up with the error, I go to delete the cell with the formula and then is when SC crashes.

When I adjust the 3rd chart to 5000 rows and only its' chartbook open it works also. But there is definitely a limit be hit; can't have them all open at once. Thx...

St.


Go to bottom of log:

Software version: 1241 | 2015-03-25 14:38:59
Uses New Spreadsheets | 2015-03-25 14:38:59
Usage end date: 2015-08-20 | 2015-03-25 14:38:59
Enabled for: Advanced Features. | 2015-03-25 14:38:59
Enabled for: Advanced Features 2. | 2015-03-25 14:38:59
Enabled for: Sierra Chart Historical Data Service. | 2015-03-25 14:38:59
Allow Support for Sierra Chart Data Feeds is enabled. | 2015-03-25 14:38:59
Active service: Open E Cry FIX | 2015-03-25 14:38:59
Time Zone: -04:00:00 (EST-05EDT+01,M3.2.0/02:00,M11.1.0/02:00) | 2015-03-25 14:38:59
2015-03-25 14:38:59 Local computer clock time | 2015-03-25 14:38:59
2015-03-25 18:38:59 GMT time | 2015-03-25 14:38:59
2015-03-25 14:38:59 Time zone adjusted time | 2015-03-25 14:38:59
Time difference to server time: 6 seconds. | 2015-03-25 14:38:59
Program path: C:\SierraChart\ | 2015-03-25 14:38:59
Data Files path: C:\SierraChart\Data\ | 2015-03-25 14:38:59
OS Version Number: 6.1 | 2015-03-25 14:38:59
Locale Information: C | 2015-03-25 14:38:59

Chart: 6EM5 [CB] 15 Min #2 | Study: DefaultSpreadsheetStudy | Exception occurred while calling study function. | 2015-03-25 14:54:47 *

Date Time Of Last Edit: 2015-03-26 03:38:01