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.
Strategy Overview
| Paramter | 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 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 | 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. | |
Screenshot
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.
Excel sheet isn't getting any updates. Please share valid excel file.
ReplyDeleteGreat post but I was wondering if you could write a little more on this subject? I’d be very thankful if you could elaborate a little bit further. Thanks in advance! best-tablet-for-reading-and-annotating-pdf
ReplyDeleteWhether you’re a first-time stock investor or a seasoned veteran, you should understand what differentiates single stock investments from mutual fund investing. Picture a collection of stocks, bonds, or other securities that are purchased by a group of investors and then managed by an investment company. That’s a mutual fund. When you buy shares in a fund, you’re really buying a piece of a large, diverse portfolio. Conversely, stocks are shares of a single company.
ReplyDeleteFinance with Gerald Dewes