Deepfoobar,
Bring your data in excel, and then it is
easy.
Paul
----- Original Message -----
Sent: Tuesday, January 11, 2005 11:50
PM
Subject: [EquisMetaStock Group] Price
Volume Distribution Indicator
Folks,
I am wondering how to approach coding up
a Price Volume Distribution indicator in MS.
Not sure if everyone is
familiar with these, the gist being over the start and end dates/times of
the chart the volume at a given price range (generally a single dollar) is
plotted (not on time axis) against price.
In other words if a stock
has ranged in price from 20-25 dollars over a year it would show the amount
of volume that was traded at 20, 21, 22, 23, 24, and 25 dollars.
Given that MS has neither direct loop control and no way to (as far
as I can tell) display an indicator independent of time scale I'm kind
of stuck how to procede. Or even if it is worth trying to do it in
the formula language.
Yahoo! Groups Links
|