Replies to post #3652 on MDA - Market Direction Analysis (MDA)

[augieboo]

Warp, here is the Formula for PAVS, (Percent Advancing Volume Stochastic)

PAVS = 100 * ((PAV-(MIN(PAV-N))) / ((MAX(PAV-N))-(MIN(PAV-N))))

PAV = Percent Advancing Volume = [VADV / (VADV + VDEC + VUNC)]

Where:

VADV = Volume Advancing
VDEC = Volume Declining
VUNC = Volume Unchanged

(MIN(PAV-N)) = lowest PAV reading over the last "N" days
(MAX(PAV-N)) = highest PAV reading over the last "N" days

EXCEL NOTES:

For those who are not familiar with Excel, here are a couple explanations:

1. The expression "(MIN(X:Y))" tells Excel to find the lowest number in cells in the range X through Y.

2. The expression "(MAX(X:Y))" tells Excel to find the highest number in cells in the range X through Y.

3. "*" means multiply

4. "/" means divide

--------------

If anyone would like to play with this stuff at home, just click on this link to get the Excel file.

http://home.earthlink.net/~augiebooboo/iHub/NAZ-up-down-unchanged08.xls


MDA Thread #board-1320
Turnips Thread #board-1125
Trading Info #board-1220