Skip to main content

Intraday Trading Strategy

Access the strategy in the Google Sheets version here.

Discover a profitable Intraday Trading Strategy in this post. We’ve created an automated Excel sheet for you to download at the end of this post. This Excel sheet will automatically fetch data for Nifty50 stocks, provide Buy/Sell signals, and display profit percentages and stop-loss values. When applied to liquid stocks and commodities, this strategy boasts an 80% accuracy rate in all market conditions.

For live signals based on this strategy that doesn’t require downloading the Excel sheet, visit the link below.

Intraday Open High Low Strategy – Live Signals

Strategy Overview

Parameter Value
Preferred Timeframe Intraday 5 minutes
Indicators Used None
Buy Condition Open=Low for the current day. Buy after half an hour of market open
Sell Condition Open=High for the current day. Sell after half an hour of the market open
Stop Loss Indicated in Excel Sheet
Targets As per one’s risk appetite or End of the day

Excel Sheet

Parameter Description
Worksheet Name Intraday Trading System
Inputs Columns C, D, E, F, G Symbol name and Price for the day. It’s not needed to manually enter anything.
Outputs Position (Column H) BUY/SELL signals for the particular stock. If this field is blank then don’t take any trade.
Price (Column I) Price above/below which Buy/Sell orders should be placed.
Stop Loss (Column J) Stop Loss Price.
Profit/Loss at EOD (Column K) Profit/Loss % at the end of the day based on the entry price.

Intraday Trading Strategy

How to use this Excel Sheet

Step 1: Download the sheet from the end of this post to your local computer.

Step 2: Open the sheet. It will throw a few warnings. Press OK for all.

Step 3: Ensure that you are connected to the internet. The sheet will update automatically every minute as per the live market data. Click on the ‘Refresh Data’ button if you want to update it forcefully.

Step 4: After half an hour of market open time, check the sheet for Buy/Sell signals. Place your order above/below the ‘Price’ column in the Excel sheet.

Step 5: Place the stop-loss as indicated in the Excel sheet.

Step 6: Book profit/loss based on your risk appetite and ensure that your entire position is squared off at the end of the day. This is an Intraday-only strategy.

Note: The sheet works perfectly fine in Microsoft Excel 2016. We have received a few complaints where users are not able to update the sheet in Office 2010 or the below versions. Please upgrade to the latest version for seamless access to the sheet and data.

Download Link

Intraday Trading System

Download Amibroker AFL for this strategy here.

Also, check out the modified version of this strategy at the link below:

Intraday NSE BSE Open High Low Strategy