Opening Range Breakout (ORB) Intraday Log
An 11-column Excel log for opening range breakouts: the first 15-minute high and low, which side broke, whether volume confirmed it, and the result.
The .xlsx opens in Excel, LibreOffice or Google Sheets (upload it to Drive, then open with Sheets). Delete the sample row before you log real trades.
See a worked example →| Date | Symbol | ORB High | ORB Low | Breakout Dir | Volume OK? | Entry | Exit | Net P&L |
|---|---|---|---|---|---|---|---|---|
| 04/06/2026 | NIFTY FUT | 25040 | 24980 | Long | Yes | 25045 | 25120 | +3,905 |
| 05/06/2026 | NIFTY FUT | 25110 | 25050 | Short | No | 25045 | 25085 | −3,568 |
What is inside
ORB is simple to define, which makes it easy to test. Writing the range high and low every day also gives you the range width, and narrow and wide ranges often behave differently.
The Volume OK? column is the filter most worth checking. After twenty trades, compare average Net P&L for Yes and No. If unconfirmed breakouts lose, make volume a rule.
Trade Log · 11 columns
One row per ORB trade.
- Date
- Symbol
- ORB High
- ORB Low
- Breakout Dir
- Volume OK?
- Entry
- Exit
- Net P&L
- Setup Tag
- Notes
Worked example
A confirmed long breakout
Nifty futures range from 9:15 to 9:30 was 24,980 to 25,040. Bought 1 lot at 25,045 above the high with volume confirming, stop at the range low, exit at 25,120 (illustrative).
Futures STT took about a sixth of the gross on a 75-point move. Keep that in mind when setting ORB targets.
The numbers
Formulas to paste in
The download has headers and a sample row, not formulas. These match its column letters.
- Range width
- =C2-D2
- Average Net P&L when volume confirmed
- =AVERAGEIF(F:F,"Yes",I:I)
How to fill it
- Record the range at 9:30Write ORB High and ORB Low as soon as the first 15 minutes close.
- Decide volume before entryFill Volume OK? with your rule before you enter, not after.
- Log the trade or the skipIf the setup appeared and you skipped it, log it with a note. Skipped trades are data too.
- Compare Yes and NoAfter twenty trades, compare average Net P&L by Volume OK?.
Same review, without the typing
TradeLyser imports trades from supported Indian brokers by sync or CSV, with charges, and shows win rate, profit factor and drawdown for each strategy.
Related templates
Read next
Free calculators
Terms on this sheet
Questions traders ask
Should the opening range be 5, 15 or 30 minutes?
This sheet assumes 15 minutes. You can use another window, but keep it the same for every row or the results are not comparable.
Can I log options instead of futures?
Yes. Keep the range from the index or futures chart, and put the option premium in Entry and Exit.
Is the Opening Range Breakout (ORB) Intraday Log free?
Yes. The download link on this page needs no sign-up or email. The workbook ships with column headers and one sample row; add your own formulas or use the ones listed on this page.