Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 19 May 2024 03:16:27 +0000
Multiple Chartbooks Using Spreadsheet System for Trading Study
View Count: 1313
| [2019-03-27 13:07:49] |
| User94606 - Posts: 327 |
|
I have the following questions/issues: 1. In one chartbook, I added the Spreadsheet System for Trading study and was able to modify the spreadsheet and saved it. However, when I reopened the chartbook, it is not listed in the Studies to Graph window. Any ideas what is causing this? 2. Since I have multiple chartbooks, I am adding the Spreadsheet System for Trading study to each chartbook. I copied the spreadsheet.scss from an existing one and renamed it and put the new spreadsheet under the data folder. I noticed that the calculations/formulas are not being copied from the original spreadsheet. Any suggestions on how to copy the spreadsheet with all the formulas included? 3. Is the behavior differently when you use the spreadsheet in multiple instances of SierraChart? |
| [2019-03-27 20:43:14] |
| |
|
1. If you really did save the Chartbook and opened the same Chartbook and you are looking at the same chart where you added that study, then the study must be there. You must not have done something right or you are looking at the wrong chart. I noticed that the calculations/formulas are not being copied from the original spreadsheet. The formulas will definitely be there but the issue is likely related to this Input setting:Spreadsheet Study Inputs: Formula Source Sheet Number 3. No, there is no different behavior. 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: 2019-03-27 20:43:28
|
| [2019-03-28 14:44:18] |
| User94606 - Posts: 327 |
|
Thanks. I got the concept of multiple sheets within the spreadsheet now that you explained it. I noticed that in one scenario, I have sheet2 and sheet7 with formula and sheet6 has no formula. I was able to delete sheet6 but I am not able to delete sheet2. have the following 2 questions: 1. If you have 2 sheets with formulas, which one is the active sheet? 2. How do I delete either sheet7 or sheet2 so only one sheet contains the formulas |
| [2019-03-28 15:42:05] |
| User94606 - Posts: 327 |
|
Please ignore my last post (#3). I managed to figure this out. I had multiple copies of the same chart and each chart had a spreadsheet associated with it. Thanks |
To post a message in this thread, you need to log in with your Sierra Chart account: