Greetings Bruce; it has been some time since my last programming request. I hope you can help.

I wish to scan for stocks that meet the following criteria based on the 1^st 15 min bar of market open (9:45AM):

Long: open of 2^nd 15 min bar is equal or higher than close of 1^st 15 min bar.

Short: open of 2^nd 15 min bar is equal or less than close of 1^st 15 min bar.

I appreciate your input.

Both of these can be done but you can't specifically refer to the first 15 min bar of the day.  Right now, at 11:49am ET, the first 15 min bar was 9 bars ago so...

Long: O8 >= C9

Short: O8 <= C9

At 12:00pm, you'll need to amend to...

With time frame on each condition set to 15-minute.

I am looking for a fixed scan after market open that I don&rsquo;t have to write daily.

Is Bruce still there by chance?

Yes, he is. But there isn't a way to define the first 15 minute bar other than the examples I gave you.  Bruce will tell you the same thing.

This formula does not work. The test values are false, not based on a 15 min bar from market open values and does not address the timing issue.

I would greatly appreciate if you can forward me to Bruce. He has helped me extensively in the past.

Many thanks

When I run your formula based on the 9:45 + 10:00 bars MANY stocks do not match the criteria of 2nd bar open is >= close of 1st bar. For example TSL shows up, etc. I want only stocks that match my criteria so why are hundreds more appearing? 

The first 15 minute bar on TSL today closed at $12.81.  The second bar opened at $12.81.  That meets your criteria of the 2nd bar open being higher or equal to the first bar's close.

If you want it to be greater, then remove the = from the formula.

Sorry I meant CHOP. Stocks like these got &lsquo;caught&rsquo; in the scan.

To help minimize this, and those stocks that retrace, can you tweak the formula:

2^nd bar opens >= 1^st bar AND close of 2^nd bar is > close of 1^st bar.

Thanks,

Separately, I am having a lot of problems posting to your forum. It repeated gives a posting error: "Oops...network admin has been notified". Adding to that, anything I write is lost and your forum does not offer a copy feature which would help a little.

The current version of the formula (until 3:00pm ET) is O20 >= C21 and CHOP is not passing.

2^nd bar opens >= 1^st bar (close?) AND close of 2^nd bar is > close of 1^st bar

O20 >= C21 and C20 > C21

Any reason why JRJC doesn't show up?

And why I'm repeatedly getting posting error messages?

Not sure about the forum errors.  Can you take a screen shot the next time it happens?

The open of the second 15-minute bar is actually $5.2999 and the first bar closed at $5.30.  The charts only show 2 decimal places but if you export the data you'll see the full price.