Reply To: Screening for Gaps

[Darren]

To scan for daily Gap Ups use the following:

OPEN() > HIGH()[1] and LOW()>HIGH()[1]

1 2 3

OPEN() > HIGH()[1] and LOW()>HIGH()[1]

Gap Downs:

OPEN() < LOW()[1] and HIGH()<LOW()[1]

1 2 3

OPEN() < LOW()[1] and HIGH()<LOW()[1]

Open the scan results as a watchlist and add columns, then every time the workbook is opened the watchlist will update.