Getting Started
- Introduction
- Download
- Installation & Activation
- Troubleshooting
- Data Refresh/Updates
- Software Updates
- Manage Your Subscription
- Example Spreadsheets
General Formulas
Technical Analysis Toolkit
- Introduction
- Simple Moving Average (SMA)
- Exponential Moving Average (EMA)
- Volume Weighted Average Price (VWAP)
- Average True Range (ATR)
- Bollinger Bands
- Aroon
Federal Reserve Economic Data
(FRED)
Yahoo Finance
IG Index / IG Markets
- Account Setup
- Formula Reference
- VBA Functions Reference
- Historical Price Data Download To Excel
- Historical Price Data Download To File
- Historical Client Sentiment Data Download
- Watchlists
- Live Positions, Transactions & Activity History
EODHistoricalData.com
Nasdaq Data Link
Technical Indicators: Simple Moving Average
The Simple Moving Average (SMA) indicator is the average price over a lookback window.
The SMA is used to smooth price data and can be used to help determine the direction of a trend. If the SMA is moving up then the trend is moving up and vice-versa.
A price crossing the SMA is often used as a trading signal. For example if the price moves above the SMA then this may signal a long trade and when the price moves below the SMA this may signal a short trade.
You can also calculate more than one SMA and use the points where the SMAs cross as another entry signal.
The Excel formula for calculating the Simple Moving Average is:
=EPF.TA.SMA(prices, dates, lookbackWindow)
The input parameters required are:
| Parameter | Description |
|---|---|
| Prices | An Excel range of the prices. |
| Dates | An Excel range of the dates. |
| Lookback Window | The number of periods in the lookback window. |
The range of prices and dates must correspond and be of the same length, for example the first date in the date range must correspond to the first price in the price range.
The output columns are:
| Output Column | Description |
|---|---|
| SMA | The simple moving average. |
| Date | The date that the simple moving average corresponds to. |
Example
"Calculate the SMA with a 5 day lookback window"
In this example you can see the price/date data in columns A and B respectively. The SMA formula is in cell D2 and references the price (A2:A100) and date (B2:B100) ranges as well as the 5 period lookback:
=EPF.TA.SMA(A2:A100,B2:B100,5)
The formula calculates the SMA and returns the SMA and corresponding dates to columns D and E respectively:
