Home >> Support Board

Support Board

Date/Time: Wed, 24 Apr 2024 15:10:15 +0000

How to Post a Message for Support

spreadsheet recalc shortcut?

View Count: 1876

[2013-08-23 22:54:18] #1 [Go To First Post]
User22396 - Posts: 191
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] #2 [Go To First Post]
Sawtooth - Posts: 3976
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] #3 [Go To First Post]
User22396 - Posts: 191
thanks tom will try that

[2013-08-23 23:45:59] #4 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
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. 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: 2013-08-24 05:12:24

[2013-08-24 09:54:32] #5 [Go To First Post]
namlem - Posts: 94
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] #6 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
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. 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

[2013-08-28 08:24:19] #7 [Go To First Post]
namlem - Posts: 94
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] #8 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
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. 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

[2020-06-30 20:49:20] #9 [Go To First Post]
j4ytr4der_ - Posts: 918
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] #10 [Go To First Post]
j4ytr4der_ - Posts: 918
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] #11 [Go To First Post]
j4ytr4der_ - Posts: 918
For a moment I thought using this feature might save me by forcing a true recalculation periodically: Spreadsheet Study Inputs: Periodically Save Sheet as Text in Minutes However I see no such capability in the Spreadsheet System study. Has it been removed? I'm on version 2124.

[2020-07-05 23:40:37] #12 [Go To First Post]
Sierra_Chart Engineering - Posts: 14071
Spreadsheet Study Inputs: Periodically Save Sheet as Text in Minutes However I see no such capability in the Spreadsheet System study. This will added to the next release. Although this is not going to cause any automatic recalculation. 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, use 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: