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.
|Preferred Timeframe||Intraday 5 minutes|
|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|
|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.|
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 Amibroker AFL for this strategy here.
Also, check out the modified version of this strategy at the link below: