does anyone know the formula for linear weighted moving averages? i need it for some work im doing in excel. i need the FORMULA not MT4 CODE. any help would be appreciated. thanks.
Linear Weighted Average This moving average indicator is the least common out of the three and is used to address the problem of the equal weighting. The linear weighted moving average is calculated by taking the sum of all the closing prices over a certain time period and multiplying them by the position of the data point and then dividing by the sum of the number of periods. For example, in a five-day linear weighted average, today's closing price is multiplied by five, yesterday's by four and so on until the first day in the period range is reached. These numbers are then added together and divided by the sum of the multipliers.
Linear Weighted Average This moving average indicator is the least common out of the three and is used to address the problem of the equal weighting. The linear weighted moving average is calculated by taking the sum of all the closing prices over a certain time period and multiplying them by the position of the data point and then dividing by the sum of the number of periods. For example, in a five-day linear weighted average, today's closing price is multiplied by five, yesterday's by four and so on until the first day in the period range...
