StockFetcher Forums · General Discussion · What does Volume Ascending means - for SF?<< 1 2 3 >>Post Follow-up
karennma
6,831 posts
msg #113462
Ignore karennma
5/16/2013 12:41:27 PM

THANKS guys!
One more question ....
Here's where it gets messy.
In my results, I've got four VOL columns; todays vol and 3 others.
The last part of the filter is as follows:

"add column volume 1 day ago
add column volume 2 days ago
add column volume 1 week ago"

How do I get the percentage difference between the volume 1 week ago and 1 day ago?
(Sadly, I used to know how to calculate this, but forgot.)

TIA!



karennma
6,831 posts
msg #113463
Ignore karennma
5/16/2013 12:53:07 PM

Whoops! Sorry!
"add column volume 1 week ago" does NOT work.

For anyone else testing this, you'd have to say:
"add column volume 7 days ago"



karennma
6,831 posts
msg #113465
Ignore karennma
5/16/2013 1:11:15 PM

When I get the volume for 1 day ago, 2 days ago, 7 days ago, how do I make the headings (in my results) say 1day, 2day 7day?
Right now, the columns just say "volume". I've got four "volume" columns, which is confusing.

TIA!


Kevin_in_GA
4,553 posts
msg #113466
Ignore Kevin_in_GA
5/16/2013 1:15:04 PM

"add column volume 1 day ago
add column volume 2 days ago
add column volume 1 week ago"


Just add {insert what you want to call the column here}

like this:

add column volume 1 day ago {1 day ago}
add column volume 2 days ago {2 days ago}
add column volume 7 days ago {1 week ago}


karennma
6,831 posts
msg #113467
Ignore karennma
5/16/2013 1:33:09 PM

Fabulous!
Thanks!


karennma
6,831 posts
msg #113471
Ignore karennma
5/16/2013 3:11:14 PM

Does anyone know how to figure out the diff between today's volume and volume a week ago?
I tried this, but it doesn't work properly.

"set {diff, volume 8 days ago - volume 1 day ago}"


karennma
6,831 posts
msg #113472
Ignore karennma
5/16/2013 3:35:58 PM

Stockfetcher?
Do you know how to do this?
I'd prefer the %, as opposed to the numerical difference.
TIA!


stockfetcher
963 posts
msg #113473
5/16/2013 3:48:17 PM

Hi,

First the week ago offset is 5 (i.e 5 trading days).

The following filter shows both a percent change and the actual change:

Fetcher[
set{vDiff, volume - volume 5 days ago}
set{vRatio, vDiff / volume 5 days ago}
set{vPctChg, vRatio * 100}
close > 10

and add column vPctChg {V%Chg 1 week}
and add column vDiff
]



StockFetcher

karennma
6,831 posts
msg #113474
Ignore karennma
modified
5/16/2013 3:50:07 PM

.

karennma
6,831 posts
msg #113535
Ignore karennma
modified
5/18/2013 11:36:44 AM

Fetcher[set{vDiff, volume - volume 5 days ago}
set{vRatio, vDiff / volume 5 days ago}
set{vPctChg, vRatio * 100}
close > 10
volume > 1000000
and add column vPctChg {V%Chg 1 week}
and add column vDiff
]






Can someone EXPLAIN those results to me, please 'cause I don't get it.
I added volume > 1,000,000 to make it "realistic", but it's still NOT making sense.

#1 - WHY does every number in the v%chg 1 week column have a minus sign?
Frankly, I don't see how you can do a random scan of stocks over $10, volume > a mil., and the vol. went down on ALL of them in an up market? ALL 870 of them? The ##s in that column don't look right to me.


#2- In the vdiff column ... there's a minus sign in front of every number because ... ?

Edit:
WHY would it have a minus sign if the volume did NOT go down?



StockFetcher Forums · General Discussion · What does Volume Ascending means - for SF?<< 1 2 3 >>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 2016 - 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