back start next


[start] [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12] [13] [14] [15] [16] [17] [ 18 ] [19] [20] [21] [22] [23] [24] [25] [26] [27] [28] [29] [30] [31] [32] [33] [34] [35] [36] [37] [38] [39] [40] [41] [42] [43] [44] [45] [46] [47] [48] [49] [50] [51] [52] [53] [54] [55] [56] [57] [58] [59] [60] [61] [62] [63] [64] [65] [66] [67] [68] [69] [70] [71] [72] [73] [74] [75] [76] [77] [78] [79] [80] [81] [82] [83] [84] [85] [86] [87] [88] [89] [90] [91] [92] [93] [94] [95] [96] [97] [98] [99] [100] [101] [102] [103] [104] [105] [106] [107] [108] [109] [110] [111] [112] [113] [114] [115] [116] [117] [118] [119] [120] [121] [122] [123] [124] [125] [126] [127] [128] [129] [130] [131] [132] [133] [134] [135] [136] [137] [138] [139] [140] [141] [142] [143] [144] [145] [146] [147] [148] [149] [150]


18

The value of PDF. represents the fraction of the price action between the boundaries 5. and B{. The PDF. value is assigned at the interval center at 5C, the central price, where

= {B.+B.JI2 ioii = ltoM

The values of the PDF, as defined, represent the fraction of the look-back period that the price has spent in each respective interval. For this definition, the magnitudes of the PDF values depend on the number of intervals M. To remove this dependence, simply normalize PDF. by dividing each value by the interval size AB = (H - L )IM. This normalization is not necessary for the following discussion, maybe confusing, and thus is omitted here. However, if the reader wants to make absolute comparisons between PDFs, then it would be important to include this normalization.

Figure 4.2 includes a plot of the PDF distribution to the right of the High-Low-Close plot. Note that the bar chart has been turned 90 degrees, on its side. This is a convenient way of viewing the distribution function as it combines the time history with the PDF with a shared ordinate axis and range on the same scale. For the example in Figure 4.2, the high H = 656.55 was on 5/28/96 and the low L = 637.75 on 6/7/96. This defines the price range. For M= 10, the interval AB =7656.55- 637.75)/ 10= 1.88.

The value of M should be large enough to resolve all the structure present. That is, M > (H - LmjJ I A, where A is the smallest interval that is to be resolved. Typically A values range from the minimum of the bar height (high-low) to the average of the bar height for the look-back period. These recommended M values, named MRX and MRA, are shown in Table 4.1 for comparison, assuming two bins per A. The reader may also want to adjust M and observe changes to the PDF as a basis for selection.

PDF Examples and Interpretation

Tabulation of the input data for the example given in Figure 4.2 as well as boundary values and the CPDF and the PDF are shown in Table 4.1. These are loaded onto a worksheet for viewing. Next, the T matrix is computed following methods and formulas previously outlined, and the columns are summed and normalized to give the CPDF and PDF.

Table 4.2 gives the same output as the sheet given in Table 4.1, except that the parametric variables are not shown. Only output data is shown. This is the format that is used in my practice for routine analysis and is calculated using Visual Basic macro functions in EXCEL. Accompanying the sheet in Table 4.2 is a bar chart of the PDF as shown in Figure 4.3.

For the example shown in Figure 4.4, the current close was below the peak. The subsequent price moved further lower on the several following days. The mobility



table 4.1 Spreadsheet showing calculation of price Distribution Function

(illustration version)

DATA INPUT

LAST

N(«=100)

M(<=40)

COMPUTED OUTPUT

HMAX

06/14/96

656.55

637.75

******

T(LD MATRIX VALUES ****

DATE

LLOW

CLOSE

05/28/96

656.55

648.92

649.93

0.00

0.00

0.00

0.00

0.00

0.00

0.01

0.26

0.51

0.75

1.00

05/29/96

651.97

643.84

645.83

0.00

0.00

0.00

0.00

0.18

0.41

0.64

0.87

1.00

1.00

1.00

05/30/96

651.43

642.33

649.09

0.00

0.00

0.00

0.12

0.32

0.53

0.74

0.94

1.00

1.00

1.00

05 1/96

651.06

644.25

646.02

0.00

0.00

0.00

0.00

0.15

0.43

0.70

0.98

1.00

1.00

1.00

06/03/96

646.06

642.19

645.11

0.00

0.00

0.00

0.31

0.80

1.00

1.00

1.00

1.00

1.00

1.00

06/04/96

649.82

645.11

649.06

0.00

0.00

0.00

0.00

0.03

0.43

0.83

1.00

1.00

1.00

1.00

06/05/96

654.21

648.60

654.21

0.00

0.00

0.00

0.00

0.00

0.00

0.08

0.41

0.75

1.00

1.00

06/06/96

656.24

648.37

648.40

0.00

0.00

0.00

0.00

0.00

0.00

0.08

0.32

0.56

0.80

1.00

650.01

637.75

650.01

0.00

0.15

0.31

0.46

0.61

0.77

0.92

1.00

1.00

1.00

1.00

06/1 ¹96

650.55

647.00

648.61

0.00

0.00

0.00

0.00

0.00

0.04

0.57

1.00

1.00

1.00

1.00

06/11/96

653.77

646.42

647.44

0.00

0.00

0.00

0.00

0.00

0.10

0.36

0.61

0.87

1.00

1.00

06/12/96

650.98

645.73

645.80

0.00

0.00

0.00

0.00

0.00

0.27

0.63

0.99

1.00

1.00

1.00

06/13/96

647.90

642.24

644.57

0.00

0.00

0.00

0.20

0.54

0.87

1.00

1.00

1.00

1.00

1.00

06/14/96

645.24

640.80

642.32

0.00

0.00

0.16

0.58

1.00

1.00

1.00

1.00

1.00

1.00

1.00

637.75

639.63

641.51

643.39

645.27

647.15

649.03

650.91

652.79

654.67

656.55

CPDF

0.00

0.01

0.03

0.12

0.26

0.42

0.61

0.81

0.91

0.97

1.00

638.69

640.57

642.45

644.33

646.21

648.09

649.97

651.85

653.73

655.61

: PDF

0.01

0.02

0.09

0.14

0.16

0.19

0.20

0.09

0.06

0.03

HMAXandLMIN are computed as are MRA and MRX, the estimates of the required M values based on average and minimum daily price range. The T matrix is shown here for illustration and is a parametric variable that is normally not used for working calculations of the PDF.

Table 4.2 Spreadsheet showing calculation of price Distribution Function

(working version)

INPUT DATA

LAST DAY

N (<=100)

Mfca=80)

COMPUTED DATA

Ql IN

06/14/96

nUIN

DATE

CLOSE

CPDF

05/28/96

656.55

648.92

649.93

637.75

0.0000

638.69

0.0110

05/29/96

651.97

643.84

645.83

639.63

0.0110

640.57

0.0224

05/30/96

651.43

642.33

649.09

641.51

0.0333

642.45

0.0862

05/31/96

651.06

644.25

646.02

643.39

0.1195

644.33

0.1396

06/03/96

646.06

642.19

645.11

645.27

0.2591

646.21

0.1582

06/04/96

649.82

645.11

649.06

647.15

0.4173

648.09

0.1941

06/05/96

654.21

648.60

654.21

649.03

0.6114

649.97

0.2017

06/06/96

656.24

648.37

648.40

650.91

0.8131

651.85

0.0928

06/07/96

650.01

637.75

650.01

652.79

0.9059

653.73

0.0623

06/10/96

650.55

647.00

648.61

654.67

0.9682

655.61

0.0318

06/11/96

653.77

646.42

647.44

656.55

1.0000

06/12/96

650.98

645.73

645.80

06/13/96

647.90

642.24

644.57

06/14/96

645.24

640.80

642.32

A more useful format for PDF calculations with the same input data format but a more streamlined output format than in Table 4.1. The distribution junctions are listed along columns instead of rows, as in Table 4.1.



Figure 4.3 price Distribution Function (PDF) constructed from 14 days of OEX data. The PDF versus is obtained from Table 4.2. The bin containing the last close is highlighted.

PDF CHART 06/14/96 (N = 14 m= 10)

02500

02000

0.1500

0.1000

0.0500

0.0000

analysis would suggest that it is easier to move lower than higher for these conditions and the subsequent price movement was consistent with this. To properly assess the situation, however, requires additional information and an assessment of the momentum to be discussed shortly.

Distribution function shapes can vary. They can be symmetric about the center of the range, peaked to one side or the other, skewed, and even have multiple peaks. Quite often, prices will form bottoms or tops and sometimes steps. This is quite natural before or after a large move, for example. These flat regions correspond to regions of congestion and will produce corresponding peaks in the PDF. The PDF analysis gives a precise means of observing this behavior. Figure 4.5 is an example of a distribution function with multiple peaks. This is not too common for short periods of 14 days, but happens occasionally. For this example, during the look-back period, the OEX moved from a level (flat region) of about 610 to another level of about 640. The move was quick, and little time was spent between these levels. Although this is apparent from simple examination of the time series history, the PDF provides a means of quantifying these conditions for precise comparisons and analysis.

Multiple peaks are more common for longer look-back periods than for shorter ones since it is more likely the price movement will experience cycles or steps within a



[start] [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12] [13] [14] [15] [16] [17] [ 18 ] [19] [20] [21] [22] [23] [24] [25] [26] [27] [28] [29] [30] [31] [32] [33] [34] [35] [36] [37] [38] [39] [40] [41] [42] [43] [44] [45] [46] [47] [48] [49] [50] [51] [52] [53] [54] [55] [56] [57] [58] [59] [60] [61] [62] [63] [64] [65] [66] [67] [68] [69] [70] [71] [72] [73] [74] [75] [76] [77] [78] [79] [80] [81] [82] [83] [84] [85] [86] [87] [88] [89] [90] [91] [92] [93] [94] [95] [96] [97] [98] [99] [100] [101] [102] [103] [104] [105] [106] [107] [108] [109] [110] [111] [112] [113] [114] [115] [116] [117] [118] [119] [120] [121] [122] [123] [124] [125] [126] [127] [128] [129] [130] [131] [132] [133] [134] [135] [136] [137] [138] [139] [140] [141] [142] [143] [144] [145] [146] [147] [148] [149] [150]