Note – Due to some unprecedented technical reasons, we have stopped supporting this excel sheet since Jan 2020. Alternatively, you can check the same strategy in the google sheets version here
In this post, we’ll explore a profitable Intraday Trading system. An automated excel sheet is created for the same which can be downloaded at the end of this post. This excel sheet will automatically download the data for Nifty50 stocks and indicate Buy/Sell signals. Also, it will show the profit % and stop loss value. This strategy is 80% accurate in all market conditions if applied on liquid stocks and commodities.
Check out below link for Live signals based on this strategy (would not require downloading Excel sheet)
|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 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||Column C,D,E,F,G||Symbol name and Price for the day. It’s not needed to manually enter anything.
Sheet will be updated automatically every 1 minute.
|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 few warnings. Press OK for all.
Step 3: Make sure that you are connected to the internet. The sheet will update automatically every minute as per the live market data. Click on ‘Refersh 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 ‘Price’ column in the excel sheet.
Step 5: Place stop loss as indicated in the Excel sheet.
Step 6: Book profit/loss based on your risk appetite and make sure 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 few complaints where users are not able to update the sheet in Office 2010 or 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 below link: