Login Page - Create Account

Support Board


Date/Time: Thu, 28 Mar 2024 14:29:47 +0000



Spreadsheet - sheet order and SSstudy speeds in general

View Count: 726

[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]
Sierra Chart Engineering - Posts: 104368
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]
Sierra Chart Engineering - Posts: 104368
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: 3952
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]
Sierra Chart Engineering - Posts: 104368

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]
Sierra Chart Engineering - Posts: 104368
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: 3952
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]
Sierra Chart Engineering - Posts: 104368
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]
Sierra Chart Engineering - Posts: 104368
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:

Login

Login Page - Create Account