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: Exponential Moving Average
The Exponential Moving Average (EMA) is very similar to Simple Moving Average (SMA) as it also indicates trend direction over time.
The difference is that the EMA applies more importance (weight) to more recent data points, this results in an inidicator that follows prices more closely.
The Excel formula for calculating the Exponential Moving Average is:
=EPF.TA.EMA(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 exponential moving average. |
| Date | The date that the simple moving average corresponds to. |