Sidebar  |  FEB 1996

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

by Mel Widner, Ph.D.