Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 11:38:15 +0000



[User Discussion] - Spreadsheet question

View Count: 1351

[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: 3952
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:

Login

Login Page - Create Account