Range breakout-trading

I want to make opening range breakout scanner for 30 min candlestick in google spreadsheet, can anyone tell me the function, and how to create it.

You can check the following link, where i have already explained about the opening range breakout scanner