Login Page - Create Account

Support Board

Date/Time: Sun, 29 May 2022 01:49:52 +0000

[User Discussion] - Spreadsheet question

View Count: 1013

[2013-09-04 17:35:05]
toews&kane - Posts: 205

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

[2013-09-04 17:53:53]
tomgilb - Posts: 3277
This will count the bars since a crossover:

A cross from below (formula is in Y3):

A cross from above (formula is in Z3):

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: 205
Brilliant! thanks tomgilb

To post a message in this thread, you need to log in with your Sierra Chart account:


Login Page - Create Account