Support Board
Date/Time: Wed, 14 May 2025 10:08:25 +0000
Post From: counting colored bars
| [2016-04-12 17:20:19] |
| Sawtooth - Posts: 4214 |
|
1) Add the Spreadsheet Study study -Check 'Hide Study' -Give it a name in the 'Spreadsheet Name' field Use these formulas in these cells: K1: (this is the number of lookback days) 25 K3: (this counts the days the spreadsheet sees) =IF(A3>A4,K4+1,K4) L3: (this counts the colored bars in the previous K1 days, not including the current day) =IF(AND(ROW()>3,ID2.SG1@3,K3>$K$3-$K$1-1),L4+1,L4) You can minimize the spreadsheet. 2) Add the Text Display for Study study -Set the 'Value Format' to 1 -Set the 'Study And Subgraph To Display' to the spreadsheet study and L(SG2) |