[RT] Distribution

[Don Thompson <detomps@xxxxxxxxxxx>]

Does anyone know how to obtain a distribution of a set of prices that
include an adjustment for volume in Excel?
In the set of prices below the frequency distribution function can take a
set of columns. such as below, (OHLC).  but as you can see there is
dramatically higher volume at 10390 than at 10395 or 10396.
I am looking for a quick way to get a distribution of price without
resorting to a huge renumbering
of the prices, that reflects the number of shares distributed at volume

Thanks

Don Thompson


      10/2/2001 10398 10398 10394 10394 300
      10/2/2001 10394 10395 10394 10395 500
      10/2/2001 10395 10395 10390 10390 25000
      10/2/2001 10390 10396 10390 10396 5000
      10/2/2001 10396 10398 10396 10398 500
      10/2/2001 10398 10398 10390 10390 25000
      10/2/2001 10390 10390 10390 10390 100
      10/2/2001 10390 10390 10390 10390 50000
      10/2/2001 10390 10396 10390 10396 500



------------------------ Yahoo! Groups Sponsor ---------------------~-->
FREE COLLEGE MONEY
CLICK HERE to search
600,000 scholarships!
http://us.click.yahoo.com/Pv4pGD/4m7CAA/ySSFAA/zMEolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
realtraders-unsubscribe@xxxxxxxxxxxxxxx

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/