V. 14:2 (55-62): Sidebars: Price Distribution Functions and Mobility Oscillator by Mel Widner, Ph.D.

V. 14:2 (55-62): Sidebars: Price Distribution Functions and Mobility Oscillator by Mel Widner, Ph.D.

PDFs are computed using a Microsoft Excel 5.0 spreadsheet. The first step is compute the price range and divide the range into intervals. The maximum high and minimum low are:

{Cell C19} = MAX(C3:C16)

{Cell D19} = MIN(D3:D16)

Interval boundaries start in cell G2 as

= $D$19 + (G1/10)*($C$19-$D$19)

then fill right through cell P2. The contributing terms Ti,j start in cell G3 as

= IF(G$2<$D3,0,IF(G$2>$C3,1,(G$2-$D3)/($C3-$D3)))

then fill right through cell P3. Next, select from cell G3 through cell P3 and fill down through row 16. The CPDF values are given in cell G17 as

= SUM(G3:G16)/14

Fill right through cell P17. The PDF values are given as

{Cell G18} = G17

{Cell H18} = H17 - G17