Support Board
Date/Time: Sun, 22 Dec 2024 05:07:00 +0000
Problem with Duplicating Chartbooks with Alert Speadsheets
View Count: 1661
| [2015-06-23 19:57:02] |
| User23815 - Posts: 210 |
|
When I updated SC from version 1235 Old Spreadsheets to the next OS version, my spreadsheet alert columns changed and my alerts no longer functioned as expected. I rolled back to 1235 and stayed there. Recently I found the change in the newer program(# of Daily Pivot columns)so I updated my Spreadsheet alerts to match the newer column configuration. I was then able to update to 1261 OS. I was attempting to Duplicate Chart to another Chartbook in order to experiment with some changes but the duplicated chart did not recognize the spreadsheet alerts correctly. What might the problem be that I cannot duplicate the chart(it has 4 spreadsheet alerts included in the studies)? I also tried just duplicating the chart in the same chartbook and again it did not print the alert studies to the chart. Help please.
|
| [2015-06-23 20:55:43] |
| Sawtooth - Posts: 4141 |
|
If you duplicate into the same chartbook, the formulas will not copy to the new sheet#. In the spreadsheet study settings, you can set the Formula Source Sheet Number to the sheet with the formulas, or you can set the Formula Source Sheet Number to match the chart#, then copy/paste the formulas to the new respective sheet#. You'll need to do the latter if you have any references to non-updating cells, e.g column H. Also, in most cases, the Chart Data Output Sheet Number should be 0. If you duplicate to another chartbook, the chart numbers might be different, so you'll probably also need to use the spreadsheet settings to line up the formula sheets with the chart#s. |
| [2015-06-23 22:19:34] |
| |
|
If you duplicate into the same chartbook, the formulas will not copy to the new sheet#. This cannot be true. And we did a test to verify that the formulas do copy. No matter what the Formula Source Sheet Number is set to, that will be where the formulas will be copied from unless it happens to be set to a Sheet that does not exist.Might be a problem with the Chart Data Output Sheet Number input. 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: 2015-06-23 22:20:15
|
| [2015-06-24 01:29:43] |
| User911705 - Posts: 89 |
|
Ah, but it is true. It would be so appreciated if Sierra support didn't just dismiss out of hand what their clients are telling them. That seems to be, often as not, how you handle support requests. It takes much convincing before you believe there is a problem. This is a case in point. I reported this very same issue some time back and nothing happened. But I promise you, if I duplicate a chart in the same chartbook, using the spreadsheet for trading study, a new sheet will appear in the spreadsheet, SANS FORMULA's. Nada. Zero. No formulas at all. I have to manually paste in all the formulas. I'm a relatively new user, and I think the first time I used the spreadsheets the formulas did actually copy. Then, I needed to install a new version (the prior version had an issue with saving the ss file correctly). After that, no formulas ever copied to new sheets, under any circumstances:( |
| [2015-06-24 01:53:29] |
| Sawtooth - Posts: 4141 |
|
If you duplicate into the same chartbook, the formulas will not copy to the new sheet#.
This cannot be true. And we did a test to verify that the formulas do copy.
If I duplicate chart #1 into the same chartbook, and no chart #2 exists, the duplicate chart will be #2, the new sheet will be #2, and the Formula Source Sheet Number will also be 2. There will be no formulas on Sheet #2. This scenario assumes the Chart Data Output Sheet Number is 0. This is not a problem for me, so no need to change it on my account. Some time back, maybe some years ago, a duplicated chart would keep the original Formula Source Sheet Number. I personally like it the way it is now. And it's not difficult to copy/paste formulas, which I have to do anyway if column H or J is involved. Date Time Of Last Edit: 2015-06-24 02:45:05
|
| [2015-06-24 02:09:15] |
| |
|
We will be producing a video showing what we see. Formula Source Sheet Number will also be 2
It should remain the same and did remain the same when we did a test. It is highly unlikely we have any code which is altering the study input of a particular study on a chart which is duplicated. Everything remains the same.
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 |
| [2015-06-26 04:56:31] |
| |
|
We apologize for the delay. Here is the video: https://www.sierrachart.com/Videos/SpreadsheetStudyTest20150626.mp4 We need to understand why you would be getting a different result than what we demonstrate in this video. Possibly there is a difference because you are using Old Spreadsheets. We did not test Old Spreadsheets but those should work the same. 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: 2015-06-26 05:10:19
|
| [2015-06-26 14:58:42] |
| Sawtooth - Posts: 4141 |
|
I did my test with New Spreadsheets, v1261. Below is a link to a two minute video replicating the steps in your video. Mine shows that the Formula Source Sheet Number has been incremented when duplicating the chart. Attached is the chartbook and scss. www.screencast.com/t/yuuSZpjM |
 FSSN test.cht - Attached On 2015-06-26 14:47:31 UTC - Size: 58.45 KB - 355 views FSSN test.scss - Attached On 2015-06-26 14:47:56 UTC - Size: 61.52 KB - 441 views |
| [2015-06-26 19:05:07] |
| |
|
Please try this on the latest prerelease. We do not think it will occur with that release. We have a better understanding of why this was occurring. 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 |
| [2015-06-26 22:40:18] |
| Sawtooth - Posts: 4141 |
|
The Formula Source Sheet Number does not increment with v1265; it retains the original value. BTW, in the Old Spreadsheets, the Formula Source Sheet Number incremented in v1261, but it does not in v1265. |
| [2015-06-27 02:08:35] |
| |
|
The particular code that has been causing the change with the Formula Source Sheet Number, and it may have been added based on a particular issue Tom raised before, but we cannot remember, now has been removed. Instead there is going to be this new input setting with the Spreadsheet study: IN_ALWAYS_SET_FORMULA_SOURCE_SHEET_NUMBER_TO_OUTPUT_SHEET_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 |
To post a message in this thread, you need to log in with your Sierra Chart account: