Support Board
Date/Time: Wed, 27 Nov 2024 18:40:14 +0000
Reset Refresh Chart using Custom Spreadsheet Study
View Count: 1560
| [2014-09-24 11:55:27] |
| User16114 - Posts: 153 |
|
After changing a chart to view the evening session (Ctrl G) my custom spreadsheet study changed to different values. Is there a way to reset or refresh the custom spreadsheet study on a chart without having to close SC and then open SC again? |
| [2014-09-24 16:23:33] |
| |
|
When the Session Times change, all of the chart data is outputted to the spreadsheet and all of the formulas are updated. If there is some problem, there must be something inherently wrong with what you are doing which is causing the problem. Maybe something with calculation precedence: http://www.sierrachart.com/index.php?page=doc/doc_ChartStudies.html#StudyCalculationPrecedence You certainly do not have to close Sierra Chart and open it again. 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 |
| [2014-09-29 22:15:39] |
| User16114 - Posts: 153 |
|
is there a way to update spreadsheets before the Session Times change does it automatically?
|
| [2014-09-30 02:23:52] |
| Sawtooth - Posts: 4120 |
|
Go to Chart >> Reload and Recalculate, or Chart >> Recalculate.
|
| [2014-09-30 12:54:50] |
| User16114 - Posts: 153 |
|
thnx tomgilb - I appreciate the community answering questions much! did what post #4 suggested many times yesterday but only closing SC and restarting provided correct output for my custom spreadsheet study. I think SC post #2 may be my issue. can SC or anyone help? my spreadsheet study is using "Cumulative Sum of Study" on the "Volume" study and the "Cumulative Sum of Study" is outputted to spreadsheet column AD. Then, I am using column AD in a formula in column K which I think is causing an issue with calculation precedence. Is there a way to get "Cumulative Sum of Study" outputted in column K or to the left of L? Or is there a way to output column AD in spreadsheet 1 to column K in spreadsheet 2? Any suggestions would be appreciated from SC or others. |
To post a message in this thread, you need to log in with your Sierra Chart account: