Envelope

An envelope is comprised of two moving averages. One moving average is shifted upward and the second moving average is shifted downward.

Envelopes define the upper and lower boundaries of a security's normal trading range. A sell signal is generated when the security reaches the upper band whereas a buy signal is generated at the lower band. The optimum percentage shift depends on the volatility of the security - the more volatile, the larger the percentage.

The logic behind envelopes is that overzealous buyers and sellers push the price to the extremes (i.e., the upper and lower bands), at which point the prices often stabilize by moving to more realistic levels. This is similar to the interpretation of Bollinger Bands.

Syntax:

Envelope
Envelope()
Envelope(“Method”)
Envelope(“Period”, “Percent”,”Method”)
Envelope(“OutPutStartCell”, ”Period”, “Percent”, ”Method”)

Inputs:

'Close' column values

Parameters:

• Period (default=14)
• Percent (default=20)
• Method (default=MvAvg)
• OutPutStartCell (default=the next blank column in the worksheet)

Examples:

Envelope
Envelope()
Envelope(“MvAvg”)
Envelope(MvAvg)
Envelope(“LinWgtMvAvg”)
Envelope(LinWgtMvAvg)
Envelope(“ExpMvAvg”)
Envelope(ExpMvAvg)
Envelope(“14”, “20”, “MvAvg”)
Envelope(14,20, MvAvg)
Envelope(“14”,“20”,“LinWgtMvAvg”)
Envelope(14, 20, LinWgtMvAvg)
Envelope(“14”, “20”, “ExpMvAvg”)
Envelope(14, 20,ExpMvAvg)
Envelope(“G2”, “14”, “20”,“MvAvg”)
Envelope(G2,14, 20, MvAvg)
Envelope(“G2”, “14”, “20”, “LinWgtMvAvg”)
Envelope(G2,14, 20, LinWgtMvAvg)
Envelope(“G2”, “14”, “20”, “ExpMvAvg”)
Envelope(G2,14, 20, ExpMvAvg)