Awesome Oscillator

Awesome Oscillator (AO) is a momentum indicator that reflects changes in the market driving force. It is calculated by taking the difference between a 34-period and 5-period Simple Moving Average (SMA), which are based on the midpoints of the bars (Higher + Lower) / 2.

AO

=AO(data)

Example Usage

=AO(A2:F500)

Parameters

Parameter Type Description Status
data
Range
The input range of columns containing the Date, Open, High, Low, Close, and Volume data. The function automatically uses the High and Low values to calculate midpoints (Average Price).
 Required

Returns

A two-column array of dates and their corresponding Awesome Oscillator values.

Output Example

Awesome Oscillator Formula Result in Google Sheets