Login Page - Create Account

Support Board


Date/Time: Sun, 24 Nov 2024 02:48:27 +0000



Post From: Spreadsheet question

[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