Login Page - Create Account

Support Board


Date/Time: Sat, 04 Jul 2020 22:14:23 +0000



spreadsheet recalc shortcut?

[2013-08-23 22:54:18]
User22396 - Posts: 188 | Ending Date: 2020-06-14 [Expired]
when working with the spreadsheet study is there a way to quick recalc while workin within the spreadsheet instead of going back to the chart and clickin apply so i can see values realtime updated
[2013-08-23 23:05:12]
tomgilb - Posts: 2582 | Ending Date: 2020-12-03
The only way to make it slightly quicker is to add the Recalculate button to the tool bar:
General Settings >> Customize Toolbars

But you still need to focus the chart first.
[2013-08-23 23:06:00]
User22396 - Posts: 188 | Ending Date: 2020-06-14 [Expired]
thanks tom will try that
[2013-08-23 23:45:59]
Sierra Chart Engineering - Posts: 87254 | Ending Date: 2021-04-05
In the latest non-CLR prerelease version, the new spreadsheets will detect a change at row 3 in the formula columns when using the Spreadsheet study and perform a full recalculate in the chart automatically.
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: 2013-08-24 05:12:24
[2013-08-24 09:54:32]
namlem - Posts: 94 | Ending Date: 2019-09-13 [Expired]
and perform a full recalculate in the chart automatically.
I like the old way, when only first 10 bars quickly recalculated.
This is not good automatically to recalculate full chart - for me this would be a killer within my development, sometimes my recalculation takes >=5 minutes, I can't let it happen automatically(!) I prefer to control a start of recalculation by myself by pressing Ctrl+Insert whenever I need. Please take this into account.

[2013-08-28 01:05:08]
Sierra Chart Engineering - Posts: 87254 | Ending Date: 2021-04-05
If there is a problem with lengthy calculations, then we will address that. We would like to know with the new Spreadsheets in the non-CLR version, how long the calculations take.
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.
[2013-08-28 08:24:19]
namlem - Posts: 94 | Ending Date: 2019-09-13 [Expired]
Also another performance remark:
when I set No of rows to calculate lets say to 70k for 2-3 spreadsheets it takes some time to do calculations - this is ok, but I noticed that when I start SC platform, then same loading/calculation takes much longer, 2-3 times longer. In the status bar on top it's written 'Reading...' Up to me, reading of 70k rows few times from the disk should be much faster than calculation itself.

Please just keep this in mind. Maybe there is place for tuning.
I hope I made myself clear.

Thanks SC team!

[2013-08-28 17:05:26]
Sierra Chart Engineering - Posts: 87254 | Ending Date: 2021-04-05
We would expect this will be much improved in the non-CLR version.
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.
[2020-06-30 20:49:20]
j4ytr4der_ - Posts: 209 | Ending Date: 2021-05-09
I realize this is an extremely old thread, but I am also looking for a way to automatically recalculate the spreadsheet, in my case at a certain time each day. Changes to things in row 3 does not trigger a recalculation. I can't get anything to trigger it other than me manually selecting the option by menu or hotkey.

Is there a way to programmatically trigger a recalculate without having to add a custom study?
[2020-06-30 21:35:12]
j4ytr4der_ - Posts: 209 | Ending Date: 2021-05-09
Also to be clear, changes in row 3 do relcalculate some things on the chart, but not everything. Any cell that "locks" a TRUE/FALSE state, does not get recalculated unless a manual recalculation is performed. A manual recalculation forces it to re-evaluate its condition and update the TRUE/FALSE status. This is the problem I'm encountering.
[2020-06-30 21:57:15]
j4ytr4der_ - Posts: 209 | Ending Date: 2021-05-09
For a moment I thought using this feature might save me by forcing a true recalculation periodically:

https://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html#PeriodicallySaveSheetAsTextInMinutes

However I see no such capability in the Spreadsheet System study. Has it been removed? I'm on version 2124.

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

Login

Login Page - Create Account