bydesign 3 posts msg #77140 - Ignore bydesign |
8/1/2009 8:47:05 PM
All
The search is simply "Show stocks where Close dropped more than 10 percent over the last 1 week"
I would like to add a column that displays the total percentage change over the last week.
below is my attempt... but it does not display a column...
any ideas? Thanks!
set {change, last 1 week ago - last}
set {wkPercChg, change / last}
add column wkPerChg {1 Wk Chg%}
|
bydesign 3 posts msg #77141 - Ignore bydesign |
8/1/2009 8:57:02 PM
All
Sorry, I found several things wrong... but I still have not achieved the results I desire...
any thoughts would be appreciated...
I had used Weeks ago instead of days ago
I had used last instead of close
----------
Show stocks where Close dropped more than 10 percent over the last 1 week
set {change, close 7 days ago - close}
set {wkPercChg, change / close}
add column wkPerChg {1 Wk Chg%}
|
chetron 2,817 posts msg #77142 - Ignore chetron modified |
8/1/2009 9:02:00 PM
MAYBE....
CORRECTED SPELLING ERROR, WEEK % HAD TOO MANY "C" 'S....
CORRECTED VERBAGE ERRORS.....
|
bydesign 3 posts msg #77149 - Ignore bydesign |
8/2/2009 2:43:54 PM
Thanks!
|
chetron 2,817 posts msg #77151 - Ignore chetron |
8/2/2009 4:22:25 PM
YOU ARE VERY WELCOME
|