Support Board
Date/Time: Sun, 22 Dec 2024 05:52:21 +0000
Formula disappering in spreadsheet study
View Count: 829
| [2015-07-08 22:53:32] |
| User224651 - Posts: 28 |
|
I have a chart book with 5 charts in it. Each chart has a spreadsheet study attached to it. The spreadsheets do not query each other for data. recently the formula in the spreadsheet studies has begun disappearing from cell ie. cell k3 is "=if(ap3=1,1,0)" I change it to "=if(and(cf3=0,ch3=0,ap3=1),1,0) I reload the chart attached to the spreadsheet to allow the formula to propagate down column k. I check cell k3 and it reads =if(ap3=1,1,0)" Cell M4 contains "if(aq3=1,1,0)" next I delete the formula in cell m4 I reloaded the chart attached to the spreadsheet. Cell M4 contins the original formula, "=if(ap3=1,1,0)" Is this a known behavior? Is it possible to repair the chartbook/ spreadsheets? Are there steps I can take to avoid this behavior in the Future? All the best, Alex |
| [2015-07-09 17:44:39] |
| |
|
The reason this happens is because of the Formula Source Sheet Number Input setting with the Spreadsheet study. This is documented here: http://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetStudyInputs.html#FormulaSourceSheetNumber We recommend setting it to 0 and then it will be automatically set properly. 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 |
To post a message in this thread, you need to log in with your Sierra Chart account: