Support Board
Date/Time: Fri, 27 Dec 2024 01:50:39 +0000
Spreadsheet - sheet order and SSstudy speeds in general
View Count: 813
| [2016-03-02 04:42:49] |
| User553714 - Posts: 184 |
|
Hi, 1)I have a static sheet I use to place global controls over the other SSsystemfortrading sheets and would like to put that at the top of the list of sheets. Is there any way I can re-organise the order of the sheets within a spreadsheets drop down menu? 2)For static sheets which are not linked to chart No's, is there anyway of renaming the sheet, for example to "GLOBAL settings"? 3)I noticed that if you click on a sheet in the SS dropdown menu it highlights as blue, you can then scroll through your sheets with the arrow key. Is this intentional as I don't think I read that in the documentation and is a handy shortcut. 4) I was wondering if you could offer a few comments on the speed of SSsystemfortrading study? I currently have an SS with 5-active sheets which I have written extensive logical conditions into many of the cells. I use a few I have 1000-lines active in each sheet and am noticing little if any lag, maybe a slight lag; there have been a few instances where my buy/sell triggers have had a several second delay in execution but I think this may be issues with the IB API? If I switched to 10,000-lines of data in each sheet would there be a noticeable effect on the speed? 5) FYI; when I used the following function SLOPE($AD3:$AD7,$A3:$A7)and tried reversing the references i.e. SLOPE($AD7:$AD3,$A7:$A3) it caused SC to crash instead of reporting an error of some sort; This was the first time SC has ever crashed on me in over 3-months of use now. 6) There is a reference in the documentation to (link below) "Select Spreadsheet >> Calculation. Activate Iteration." which I could not find. Locking works for me without this setting? https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetAdditionalInfo.html NB: Congratulations on the NEW spreadsheet functionality; I didn't use the old ones but I know the new ones are generally excellent. Regards |
| [2016-03-02 05:25:45] |
| |
|
3. Possibly but in any case we will document this. 5. We will fix this. 6. This is now corrected. We need time to go over the other items. 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 |
| [2016-03-04 09:07:19] |
| |
|
1. No this is not supported. 2. Yes this can be done through Spreadsheet >> Rename. 4. The more rows in the sheet, the slower the performance. How much, you have to determine this. 5. This will be fixed in the next release. 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 |
| [2016-03-04 14:09:29] |
| Sawtooth - Posts: 4143 |
|
Regarding #1: Currently the order of the sheets in the drop down menu is the inverse of when they were created: the last created is at the bottom of the list. If you save and close the chartbook/spreadsheet study, and then reopen it, the displayed sheet is the first one created. Would it be possible to retain the last sheet viewed when saving/closing? |
| [2016-03-04 18:16:39] |
| |
|
Would it be possible to retain the last sheet viewed when saving/closing? We will check on this. 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 |
| [2016-03-04 18:19:46] |
| |
|
We do not understand post #4. When reopening a Spreadsheet file, the last active sheet is the one displayed when opening the spreadsheet. This has been verified. 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 |
| [2016-03-04 18:32:31] |
| Sawtooth - Posts: 4143 |
|
When reopening a Spreadsheet file, the last active sheet is the one displayed when opening the spreadsheet.
This is true, but only if you open the spreadsheet with Open Spreadsheet.If you open a chartbook containing the same spreadsheet, the sheet displayed is not the one last viewed/saved. |
| [2016-03-04 18:45:40] |
| |
|
This is probably being affected by the Spreadsheet study referencing the different Sheets.
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 |
| [2016-03-04 19:07:26] |
| |
|
How this works is now documented in this section here: https://www.sierrachart.com/index.php?page=doc/doc_Spreadsheets.html#CreatingandOpeningSpreadsheets 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: