Support Board
Date/Time: Sat, 23 Nov 2024 23:51:40 +0000
[User Discussion] - Spreadsheet question
View Count: 1450
| [2013-09-04 17:35:05] |
| toews&kane - Posts: 209 |
|
Hi, Is there a way to count the number of bars since an event occurred? say a crossfrombelow() I have thought of marking a cell with say "START" but then in real time it pushes it down I am not sure how to keep count thanks |
| [2013-09-04 17:53:53] |
| Sawtooth - Posts: 4118 |
|
This will count the bars since a crossover: A cross from below (formula is in Y3): =IF(AND(AC4>AA4,AA3>AC3),1,Y4+1) A cross from above (formula is in Z3): =IF(AND(AC4<AA4,AA3<AC3),1,Z4+1) where AA is a fast MA and AC is a slow MA. Date Time Of Last Edit: 2013-09-04 17:55:22
|
| [2013-09-04 18:59:12] |
| toews&kane - Posts: 209 |
|
Brilliant! thanks tomgilb
|
To post a message in this thread, you need to log in with your Sierra Chart account: