Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Thu, 02 May 2024 18:39:28 +0000
Post From: question about moving spreadsheet & getting two digits
| [2013-09-05 17:22:31] |
| Sawtooth - Posts: 3990 |
|
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. |