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.
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.
Download Amibroker AFL for this strategy here.