Probably Moving Average based trading systems are most popular among the traders across the globe. These trading systems work very well in Trending markets.
Most of the beginners might not have subscription to any broker with continuous data feed. So here we have provided semi-automated Moving Average trading system in Excel. The only manual task would be to copy closing price for the security selected in this excel.
Strategy Overview
| Paramter | Value |
| Preferred Timeframe | Daily |
| Indicators Used | 3 Days EMA, 5 Days EMA |
| Buy Condition | 3 Days EMA is above 5 Days EMA |
| Sell Condition | 3 Days EMA is below 5 Days EMA |
| Stop Loss | No fixed target, Stop and reverse when excel gives opposite signal |
| Targets | No fixed target, Stop and reverse when excel gives opposite signal |
Excel Sheet
| Parameter | Description | |
| Worksheet Name | MA Trading System | |
| Inputs | Date (Column A) | Calender Date |
| Close Price (Column B) | Closing price on specified Calender Date. | |
| Faster EMA Period (Cell C2) | Faster Exponential Moving Average. Default is 3. | |
| Slower EMA Period (Cell D2) | Slower Exponential Moving Average. Default is 5. | |
| Outputs | Faster EMA Values | Faster EMA values based on period defined at input. |
| Slower EMA Values | Faster EMA values based on period defined at input. | |
| Crossover Price | The exact price at which EMA crossover will take place. | |
| Signal | Buy/Sell signal based on conditions mentioned at strategy overview. | |
Screenshot
No comments:
Post a Comment