karennma
8,057 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
8,057 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
8,057 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,599 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
8,057 posts
msg #113467
- Ignore karennma |
5/16/2013 1:33:09 PM
Fabulous!
Thanks!
|
karennma
8,057 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
8,057 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
979 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:
StockFetcher
|
karennma
8,057 posts
msg #113474
- Ignore karennma
modified |
5/16/2013 3:50:07 PM
.
|
karennma
8,057 posts
msg #113535
- Ignore karennma
modified |
5/18/2013 11:36:44 AM
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?
|