V.11:12 (500-505): SIDEBAR: CALCULATING WEIGHTED MOVING AVERAGES
Product Description
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:
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. After paying for your subscription at store.traders.com users can view the S&C Digital Edition in the subscriber's section on Traders.com.
| Take Control of Your Trading. |
| Professional Traders' Starter Kit |
| All these items shown below only $299.99! |
| Click Here to Order |