Probably Moving Average based trading systems are most popular among the traders across the globe. These trading systems work very well in Trending markets. We introduced one such trading system in our AFL of the week section:
AFL of the week: 14-73 EMA crossover system
Most of the beginners might not have subscription to Amibroker with continuous data feed. So we have attempted to develop a 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.
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. |
联系客服