Support Board
Date/Time: Sun, 24 Nov 2024 03:12:03 +0000
question about moving spreadsheet & getting two digits
View Count: 1806
| [2013-09-05 16:19:44] |
| toews&kane - Posts: 209 |
|
Hi, 1) Working on two computers, would like to know how I can move a spreadsheet to another computer. I tried copying and then removing the study in the destination and then readding and pointing it to the sheet. It didn't complain out any errors but when I try to run autotrading the numbers don't update, it stopped at last when I saved the sheet on the other computer. 2)I am trying to grab data from a column. The column will be either 0,1,2,3,4. I want to continuously combine the last two nonzero values and put it in a column, say if the sequence is 0,0,0,0,1,0,0,3 The column will read 13 then if the sequence goes 0,0,0,4 then the updated value will read 34 Can you offer some assistance? |
| [2013-09-05 17:22:31] |
| Sawtooth - Posts: 4118 |
|
1) In the source computer's Sierra Chart, Save Single a study collection of only the spreadsheet study. Then copy the study collection (.StdyCollct) and the spreadsheet file (.scwbf) to the destination computer's Sierra Chart \Data folder. In the destination computer's Sierra Chart, with the destination chart focused, go to Analyis >> and choose the study collection. 2) Put this in Z3: =IF(AB3>0,1,0) where AB is the column containing the last two non-zero values Put this in Y3: =MATCH(1,Z3:Z1002,0) Put this in X3: =IF(Y3=1,Y4,X4)+1 Put this in a spare cell: =INDEX(AB3:AB1002,Y3,1)&INDEX(AB3:AB1002,X3,1) This will concatenate the previous two non-zero values. This assumes the number of rows is set to 1000. |
| [2013-09-05 22:02:22] |
| User22396 - Posts: 191 |
|
hey tom...(sorry to hijack this thread user22095) had a question about copying chartbooks with spreadsheet studys on the same machine...is there an easy way like you describe above? when i start doing the 'save as' to make a chartbook copy for say a different symbol it takes a bit of work to sort thanks |
| [2013-09-05 22:15:35] |
| toews&kane - Posts: 209 |
|
thanks for the advice! |
| [2013-09-05 22:15:45] |
| Sawtooth - Posts: 4118 |
|
I don't recommend using the same-named spreadsheet in another chartbook. IMO, each chartbook should use an unique-named spreadsheet. This is how I copy (Save As) chartbooks with a spreadsheet study: 1) Focus the spreadsheet, go to File >> Save As and give it a unique name. The existing spreadsheet will disappear. 2) Go to Analysis >> Studies >> highlight the spreadsheet study >> Settings >> Settings and Inputs tab >> Spreadsheet Name field, and change/select the new spreadsheet name. The spreadsheet will reappear with the new name. 3) Focus the chart, change the symbol, then go to File >> Save As and give it a new name. |
| [2013-09-05 22:40:38] |
| User22396 - Posts: 191 |
|
cool thanks...
|
| [2013-09-07 02:37:37] |
| |
|
1. You need to copy the spreadsheet (.scwbf) file in the Data folder of Sierra Chart over to the Data folder of other copy of Sierra Chart.
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: 2013-09-07 02:38:00
|
To post a message in this thread, you need to log in with your Sierra Chart account: