Home >> Support Board

Support Board

Date/Time: Fri, 20 Sep 2024 04:04:23 +0000

How to Post a Message for Support

Spreadsheet Losing Formulas

View Count: 1887

[2014-09-12 15:07:37] #1 [Go To First Post]
User025429 - Posts: 26
When I try to get a value from a secondary worksheet into the calculation worksheet, ie: AA3, the formulas disappear as the trade data refreshes. Previously I could this.

[2014-09-12 16:11:52] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
This problem is because the Formula Source Sheet Number input is set to a different sheet than where you are entering formulas. Refer to this section about this here: https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetStudyInputs.html#FormulaSourceSheetNumber 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-12 16:32:59] #3 [Go To First Post]
User025429 - Posts: 26
I have tested the following: If I start a new chart book and then create a spreadsheet study with "Formula Source Sheet Number" set to one - and then add an additional worksheet the formula works fine. However If I try to add a spreadsheet study to an existing chart that has 8 different charts in it, the study settings change the "Formula Source Sheet Number" from 1 to 9 and then the formula in the source sheet disappears as before.

[2014-09-12 16:36:29] #4 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
You need to make sure the Formula Source Sheet Number is set to be the same as the chart number. 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-12 17:17:28] #5 [Go To First Post]
User025429 - Posts: 26
The Formula Source Sheet Number is set to 9, which is also the chart number. I now found that if I add a 10th worksheet, and reference the formula to that the worksheet, the formula works.

[2014-09-12 17:52:36] #6 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
Another thing you need to check is that the sheet that says Sheet9 is actually the ninth sheet counting from the left. If it is not, then this can also be the problem. 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-12 18:13:42] #7 [Go To First Post]
User025429 - Posts: 26
It is the 9th sheet

[2014-09-15 19:58:48] #8 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
We see no reason why there would be this problem, but unless we can interactively work with your setup, it is hard for us to determine what the particular issue is in your case. 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-15 21:06:09] #9 [Go To First Post]
Sawtooth - Posts: 4091
If you manually add a sheet to a spreadsheet study's spreadsheet, and then you add a spreadsheet study to a chart# that corresponds to the manually added sheet#, the formulas on the manually added sheet will disappear. By default the Formula Source Sheet Number matches the Sheet# (tab position from the left) and the Chart#. If you need a calculation sheet, you can use a standalone spreadsheet: File >> New Spreadsheet Then reference the spreadsheet study's sheets. Or manually add a sheet to the spreadsheet study's spreadsheet that has a tab position beyond any potential chart# in your chartbook. I recommend the former, but it will only work in the Old Spreadsheets versions.

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