Moving average function for dynamic arrays
With increasing use of dynamic arrays for time series data such as stock prices we need a way of doing moving averages with dynamic arrays.
I suggest something like
MOVAVG (RangeArray, N, MAMethod [, Down] [,StartExp])
where N is the number of periods in the moving average and MA-Method controls the MA calculation method method (Simple, Central, Cumulative, Weighted, Exponential, Double Exponential etc)
Wolf Forbes commented
Second this idea. AverageIfs is limited. Need different moving averages beside simple moving average. Exponential, DEMA, Wilders would be great start. They can be done with 4or5 extra columns per type or should be as easy as =EMA(Range, 3) for and ema of 3 values.
Microsoft Excel Recalc or Die commented
Hi Charles, have you tried using Averageifs function for the simple and central options and the spill arrays?