Support Board
Date/Time: Thu, 05 Feb 2026 14:02:37 +0000
spreadsheet recalc shortcut?
View Count: 2353
| [2013-08-23 22:54:18] |
| 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] |
| Sawtooth - Posts: 4312 |
|
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: 191 |
|
thanks tom will try that
|
| [2013-08-23 23:45:59] |
| |
|
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] |
| 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] |
| |
|
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] |
| 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] |
| |
|
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] |
| j4ytr4der_ - Posts: 947 |
|
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: 947 |
|
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: 947 |
|
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. |
| [2020-07-05 23:40:37] |
| Sierra_Chart Engineering - Posts: 22683 |
|
https://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html#PeriodicallySaveSheetAsTextInMinutes
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 |
| [2026-01-20 12:12:22] |
| Jethro Go - Posts: 31 |
|
Good day, Is there a way to automatically recalculate spreadsheet now? I tried Edit > Reload and recalculate, but seems like it just reloads the chart and studies not the spreadsheet. Thanks! |
| [2026-01-20 15:50:04] |
| John - SC Support - Posts: 44433 |
|
There have been no changes to how the spreadsheet calculates since this thread was ended in 2020. What exactly are you trying to accomplish, or what is not working as you need it to? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2026-01-21 04:28:58] |
| Jethro Go - Posts: 31 |
|
Whenever I load back in sierra or enter replay mode, my spreadsheets doesn't get recalculated. Is there a way to automatically recalculate every time I replay or open back up the charts?
Date Time Of Last Edit: 2026-01-21 10:39:19
|
 Screenshot 2026-01-21 122819.png / V - Attached On 2026-01-21 04:28:36 UTC - Size: 94.05 KB - 11 views |
| [2026-01-21 15:43:09] |
| John - SC Support - Posts: 44433 |
|
The spreadsheet absolutely should be recalculating with a replay and when the chart is opened. What are you seeing where this is not occurring? Are you using a Spreadsheet Study, or one of the standard spreadsheets created by selecting "File >> New Spreadsheet"? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2026-01-21 15:49:54] |
| Jethro Go - Posts: 31 |
|
I am currently using Spreadsheet system/alert study. Should I use the spreadsheet study instead? Edit: Tried using Spreadsheet study it still causes the same issue. I have to recalculate manually every replay. Date Time Of Last Edit: 2026-01-21 16:00:07
|
| [2026-01-21 16:38:05] |
| John - SC Support - Posts: 44433 |
|
Tried using Spreadsheet study it still causes the same issue. I have to recalculate manually every replay.
This should definitely not be occurring. But, keep in mind that the spreadsheets only update the first 10 rows when it calculates. So if you are looking at rows below 13, then those will not be calculating. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2026-01-21 16:41:06] |
| Jethro Go - Posts: 31 |
|
Maybe that is the case. Since my spreadsheet uses more than 10 rows. Is there a way to increase the rows of calculation?
|
| [2026-01-21 17:09:17] |
| Jethro Go - Posts: 31 |
|
There must be a setting I can change to fix this, because I tried using my reference scss from sawtooth and it works fine during replay. No manual recal needed on saw tooths chartbook. Edit: There seems to be no difference between my scss and sawtooth's scss aside from the value format. There must be something I can change within my chart settings. Date Time Of Last Edit: 2026-01-21 17:27:06
|
| Screenshot 2026-01-22 010732.png / V - Attached On 2026-01-21 17:08:32 UTC - Size: 57.09 KB - 16 views Screenshot 2026-01-21 122819.png / V - Attached On 2026-01-21 17:10:31 UTC - Size: 94.05 KB - 14 views |
| [2026-01-21 18:47:39] |
| John - SC Support - Posts: 44433 |
|
Are you trying to change a value for an older bar based on information from a recent bar? This is the only situation where the way the spreadsheet calculates would make any difference. There are no settings to change how the calculations work. The recent rows are only calculated in order to cut down on overhead from the study. Also, the way the spreadsheet calculates in replay is going to be the same as real-time. So if you are not having a problem in real-time, then there should not be an issue in replay. There must be something about your setup that is causing the issue you are stating. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2026-01-21 19:11:40] |
| Jethro Go - Posts: 31 |
|
I'm not sure. I'll explain how my spreadsheet works and maybe you can find the issue. My Spreadsheet references: - CVD Study - Swing high/low (based on CVD) - Price high/low My Spreadsheet function: - Converts CVD swing highs/lows to price swing highs/lows - Draws line on swing high/low on price levels based on CVD swings - Detects divergences of the highs/lows of both CVD and Price. I think none of these functions are trying to change previous bars but instead are only gathering data from them. The attached files are from sawtooth's free access scss. The functions I replicated is the line plotting of the swing highs/lows which shouldn't cause any issue based on previous tests. The functions I added were the conversion of current values and divergence detector. Edit: Each functions has its own spreadsheet so I remove each one to find the issue, but it seems like all of it has the same issue. Maybe it has to do with the conversion? Date Time Of Last Edit: 2026-01-21 19:16:46
|
Private File  Swing HL extended.cht - Attached On 2026-01-21 19:04:32 UTC - Size: 4.11 KB - 8 views |
| [2026-01-21 19:18:54] |
| John - SC Support - Posts: 44433 |
|
Looking at your spreadsheet is not something we can do. It is beyond the scope of our support, as this gets into Programming Help.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2026-01-22 06:50:08] |
| Jethro Go - Posts: 31 |
|
Thank you for the help John! I was able to find the issue within my formula and was able to change it. Now it works great!
Date Time Of Last Edit: 2026-01-22 06:50:17
|
To post a message in this thread, you need to log in with your Sierra Chart account: