BuffaloBill
17 posts
msg #33885
- Ignore BuffaloBill |
11/11/2004 9:13:29 PM
I would like to find the daily-volume total for a
specified period of time.
In other words, if the specified period was for the last 5 days,
and the volume for each of those days was: 2m, 4m, 3m, 1.5m, and 7m,
then I would like to get the total for those 5 days...
2m + 4m + 3m + 1.5m + 7m = 17.5m
I tried "avgvol(1) last 5 days is above nn..." but
that didn't seem to work. Any ideas would be appreciated...
|
BuffaloBill
17 posts
msg #33886
- Ignore BuffaloBill |
11/11/2004 10:35:08 PM
Maybe there isn't a way to do this with StockFetcher???
|
TheRumpledOne
6,411 posts
msg #33887
- Ignore TheRumpledOne |
11/11/2004 11:46:57 PM
MAY ALL YOUR FILLS BE COMPLETE
|
xplorer
257 posts
msg #33891
- Ignore xplorer |
11/12/2004 7:33:41 AM
SET{V,avgvol(5)*5}
ADD COLUMN V
VOLUME ABOVE 100000
|
BuffaloBill
17 posts
msg #33893
- Ignore BuffaloBill |
11/12/2004 9:35:14 AM
Wow! Thanks TheRumpledOne and xplorer - you guys are awesome!
FedEx has nothin' on you two for speedy, same-day delivery! lol
Saved me lots of time.
Going to use that info to try and find stocks where the OS has had
a complete turnover (all shares have changed hands) within a specified
period. I would have preferred comparing your volume total to the Float
instead, but SF doesn't provide that value yet, though I can still
manually plug it in after a Yahoo lookup. (Tomb mentioned he may
add the Float at some point).
We have a little board over on Ihub where we use StockFetcher and
TraderBot. Post charts, etc - real laid back. You guys are more than
welcome to chime in anytime. I'm known as PieSky over there, along with
ddfridd_007 and Wang....
TraderBot & Fetcher:
http://www.investorshub.com/boards/board.asp?board_id=2117
Thanks again...
|
cegis
235 posts
msg #33897
- Ignore cegis |
11/12/2004 10:20:58 AM
BuffaloBill,
Use the SUM() function: SUM(volume,5)! That way, the rounding that takes place with calculating an average will not skew the results.
HTH,
C
|
BuffaloBill
17 posts
msg #33899
- Ignore BuffaloBill |
11/12/2004 1:45:49 PM
Cegis,
Excellent!
You guys came up with so many ways to skin the 'ol cat,
I'm afraid the poor little feller's runnin' around
naked by now!
Many thanks to all for the help....
Buffalo Bill
|