Exponential Moving Average (EMA)

Smooths price data to identify trends by assigning more weight to recent prices.

Function Syntax

=EMA(data, period)  

• data (array):
  Range of columns containing the date, Open, high, Low, close, volume data.
• period (number):
  Number of (periods) days over which to calculate the EMA.

Returns:
A two-column array of dates and their corresponding EMA values.

Output Example

Below is an example of the resulting array when applying the custom =EMA() function.