Detrend Price Oscillator

The Detrended Price Oscillator (DPO) is an indicator that attempts to eliminate the trend in prices. Detrended prices allow you to more easily identify cycles and overbought/oversold levels.

The calculation is quite simple; you simply center an x-period moving average by shifting it back x/2 + 1 periods. This centered moving average is then subtracted from the close. The result is an oscillator that crosses above and below zero.

Since the DPO is shifted back "x/2 + 1" periods, the last "x/2 + 1" periods will have no values.

Detrend Price Oscillator(Parameters)

Close. The cell reference for the range of Close prices.
Output range. The cell reference for the range of output data.
Period. Number of values used for calculation.

Detrend Price Oscillator(Syntax)

DPO(CLOSE;PERIOD;DIRECTION)

Example
=DPO(Sheet1!A1:A10;10;1)