Home >> Support Board

Support Board

Date/Time: Sun, 28 Apr 2024 16:02:30 +0000

How to Post a Message for Support

Reset Refresh Chart using Custom Spreadsheet Study

View Count: 1455

[2014-09-24 11:55:27] #1 [Go To First Post]
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] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
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] #3 [Go To First Post]
User16114 - Posts: 153
is there a way to update spreadsheets before the Session Times change does it automatically?

[2014-09-30 02:23:52] #4 [Go To First Post]
Sawtooth - Posts: 3980
Go to Chart >> Reload and Recalculate, or Chart >> Recalculate.

[2014-09-30 12:54:50] #5 [Go To First Post]
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: