Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 26 Apr 2024 00:59:14 +0000
Spreadsheet formulas reappear/revert
View Count: 963
| [2018-07-03 20:12:04] |
| User98657 - Posts: 304 |
|
I'm hoping you can help me understand how or why this keeps occurring: i have a spreadsheet with formulas i'm using. One chart, one Spreadsheet System for Trading in the chartbook. i duplicated the chart. On the new chart: Analysis> Studies> Spreadsheet System for Trading i changed the Chart Data Output Sheet Number to match the new chart and i changed the Formula Source Sheet Number to match the new chart. Essentially (or so i thought), this new sheet and chart would work independently from the pre-existing sheet and chart. i changed some formulas in the new sheet and ran a replay. the new formulas work initially, but then revert back to the previous formula. it almost seems as though the pre-existing sheet repopulates the cells in the new sheet. So shut down SC, copied and renamed the spreadsheet, pointed to the newly named spreadsheet from within the second chart. Surely now they are separate, but not so fast. i didn't delete the other sheets in the newly named workbook so again, the formulas are getting overwritten. So i deleted all the other sheets in this new workbook that don't pertain to anything (except sheet 1). All that remains is sheet 1 and sheet 2 (my duplicate chart is Chart #2). But.... having done that, my formulas are also gone. Why/how are these sheets linked together with respect to the formulas? |
| [2018-07-03 20:27:08] |
| |
|
You really have to make sure that there is only one Spreadsheet study referring to a particular Spreadsheet and Sheet within it. And that the Formula Source Sheet Number Input is using that Sheet. Would be best to close all other charts to be sure in order to isolate 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 Date Time Of Last Edit: 2018-07-03 20:27:58
|
To post a message in this thread, you need to log in with your Sierra Chart account: