CALCULATING WEIGHTED MOVING AVERAGES The first step for calculating a weighted moving average (WMA) is to decide the lookback period (n) and the alpha (a). For our example in sidebar Figure 1, we are using n = 8 and a = 0.6 to calculate the optimized weighted moving average (OWMA) described in "Weighted moving averages." The OWMA is calculated in column E and is smoothing the put/call ratio calculated in column D. Each cell in column D is simply the ratio of the put volume in column C divided by the call volume in column B — that is, cell D2 = C2/B2. Enter the alpha in cell F2; our example has 0.6 entered. The weight counter i is listed in column G. We are using n = 8, so enter in the values 1 through 8 in cell G2 to G9. When calculating the weights, the denominator never changes, therefore, the denominator can be calculated once. This is performed in cell H2. The formula for cell H2 is: |
FOR THOSE ORDERING ARTICLES SEPARATELY: *Note: $2.95-$5.95 Articles are in PDF format only. No hard copy of the article(s) will be delivered. During checkout, click the "Download Now" button to immediately receive your article(s) purchase. STOCKS & COMMODITIES magazine is delivered via mail.
|
