StockFetcher Forums · General Discussion · Need help on summing volume over nn period...<< >>Post Follow-up
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

Fetcher[SET{V1,VOLUME + VOLUME 1 DAY AGO}
SET{V2,V1 + VOLUME 2 DAYS AGO}
SET{V3,V2 + VOLUME 3 DAYS AGO}
SET{V4,V3 + VOLUME 4 DAYS AGO}
SET{V5,V4 + VOLUME 5 DAYS AGO}
ADD COLUMN V5
VOLUME ABOVE 100000
]



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


StockFetcher Forums · General Discussion · Need help on summing volume over nn period...<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2022 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.