Login Page - Create Account

Support Board


Date/Time: Sat, 10 May 2025 00:45:39 +0000



Post From: Spreadsheet question

[2013-09-04 17:53:53]
Sawtooth - Posts: 4214
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