V.17:10 (447): Sidebar: The MACD spreadsheet

THE MACD SPREADSHEET

This spreadsheet calculates the MACD fast line and the signal line. Column A is the date; column B is the closing price of the security. Column C calculates the 12-day EMA. The EMA is calculated as:

EMAn = • Pn + (1 - • ) * EMAn-1

where P is the price, • is the smoothing constant, 2/(n+1), in which n is the length of the period used for the moving average. In cell C13, enter the formula:

(0.154 * B13) + (0.845 * (SUM(B2:B13)/12))

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.

Take Control of Your Trading.

Professional Traders' Starter Kit

All these items shown below only $495!

5-year subscription to Technical Analysis of STOCKS & COMMODITIES, The Traders' magazine. (Shipping outside the US is extra. Washington state addresses require sales tax based on your locale.)
S&C on DVD 10.25 plus next year's upgrade FREE!
5-year subscription to Traders.com Advantage.
5-year subscription to Working Money.
Free book selection.

Save up to 54% by purchasing today. Limited time offer. By purchasing today you also receive your choice of one volume from the Professional Traders' Series (Volumes 1-17 or Charting The Stock Market) for FREE!
NOTE: Use the "comment" field during checkout to tell us which book you would like to receive.

Click Here to Order

You save $502.31 plus the value of the book you choose over the regular price of these items. Offer ends soon.