CHAIKIN OSCILLATOR

Chaikin Oscillator

07/31/00 05:34:52 PM

by Jason K. Hutson

Here are the Excel formulas for the Chaikin indicators using daily price data for Paramount.

Security: N/A
Position: N/A

In column F, the single day's measurement of money flow is calculated. The following formula is entered into cell F2 and copied down:
=(((D2-C2)-(B2-D2))/(B2-C2))*E2

Column E is Volume
Column D is Close
Column C is Low
Column B is High

The cumulative line is calculated in column G. Start with the first day's value of the single day's money flow by entering the following formula into cell G1:
=F2

Then start the running total in cell G3 by entering the following formula in cell G3 and copying down:
=F3+G2

The Chaikin oscillator is the difference between the three-period simple moving average and the 10-period simple moving average of the cumulative line. The three-period simple moving average is calculated in column H. The following formula is entered into cell H4 and is copied down:
=AVERAGE(G2:G4)

The 10-period simple moving average of the cumulative line is calculated in column I. Enter the following formula into cell I11 and copy down:
=AVERAGE(G2:G11)

The Chaikin oscillator is calculated in column J. The following formula is entered into cell J11 and is copied down:
=H11-I11

This article taken in part from:
Stocks & Commodities V. 12:1 (30-37): SIDEBAR: CHAIKIN INDICATORS

Jason K. Hutson

Traders.com Staff Writer. Enjoys trendlines, support and resistance, moving averages, RSI, MACD, ADX, Bollinger bands, parabolic SAR, chart formations, and volume analysis.

Title:	Industrial Engineer
Company:	Technical Analysis, Inc.
Address:	4757 California Ave SW
	Seattle, WA 98116
Phone # for sales:	206 938 0570
Website:	Traders.com
E-mail address:	JasonHutson@Traders.com
Traders' Resource Links
Charting the Stock Market: The Wyckoff Method -- Books
Working-Money.com -- Online Trading Services
Traders.com Advantage -- Online Trading Services
Technical Analysis of Stocks & Commodities -- Publications and Newsletters
Working Money, at Working-Money.com -- Publications and Newsletters
Traders.com Advantage -- Publications and Newsletters
Professional Traders Starter Kit -- Software

Click here for more information about our publications!

Comments

Date:�/ /Rank:�5Comment:�

PRINT THIS ARTICLE

Comments or Questions?	Article Usefulness
	5 (most useful) 4 3 2 1 (least useful)