ExcelFree · no sign-upIntraday and cash equity

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 →
Trade Log
DateSymbolORB HighORB LowBreakout DirVolume OK?EntryExitNet P&L
04/06/2026NIFTY FUT2504024980LongYes2504525120+3,905
05/06/2026NIFTY FUT2511025050ShortNo2504525085−3,568
Illustrative rows for one Nifty futures lot of 65. Net P&L includes 0.05% STT on the sell side.
FormatExcel (.xlsx)
Trade Log sheet11 columns
Best forORB traders
Fill itEvery session

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).

Planned risk
₹4,225
Gross P&L
₹4,875
Net P&L
+₹3,905
R-multiple
0.92R

Futures STT took about a sixth of the gross on a 75-point move. Keep that in mind when setting ORB targets.

The numbers

Risk = (Entry − ORB Low) × 65(25,045 − 24,980) × 65 = ₹4,225
Gross = (25,120 − 25,045) × 65₹4,875
Charges, incl. ₹816 STT≈ ₹970

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

  1. Record the range at 9:30Write ORB High and ORB Low as soon as the first 15 minutes close.
  2. Decide volume before entryFill Volume OK? with your rule before you enter, not after.
  3. Log the trade or the skipIf the setup appeared and you skipped it, log it with a note. Skipped trades are data too.
  4. 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.

Try TradeLyser free

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.