Login Page - Create Account

Support Board


Date/Time: Thu, 25 Apr 2024 21:42:21 +0000



Post From: Spreadsheet question

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