Support Board
Date/Time: Fri, 27 Dec 2024 18:46:17 +0000
Post From: Spreadsheet - sheet order and SSstudy speeds in general
| [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 |