Weighted Close

The Weighted Close indicator is an average of each day's price. It gets its name from the fact that extra weight is given to the closing price. The Median Price and Typical Price Indicator are similar indicators.

When plotting and back-testing moving averages, indicators, trend lines, etc, some investors like the simplicity that a line chart offers. However, line charts that only show the closing price can be misleading since they ignore the high and low price. A Weighted Close chart combines the simplicity of the line chart with the scope of a bar chart, by plotting a single point for each day that includes the high, low, and closing price.

Syntax:

WeightedClose
WeightedClose()
WeightedClose(“OutPutStartCell”)

Inputs:

'High', 'Low', and 'Close' columns values

Parameters:

• OutPutStartCell (default=the next blank column in the worksheet)

Examples:

WeightedClose
WeightedClose()
WeightedClose(“G2”)
WeightedClose(G2)