| karennma 8,057 posts
 msg #51617
 - Ignore karennma
 | 5/15/2007 6:07:56 PM 
 After you get your filter results, does anyone know who to say:
 (for example)
 "and add column % difference between column 1 and column 4"
 
 So, I'm adding a column that gives me the % difference between the 2 columns in my results.
 
 THANKS.
 
 
 
 | 
| bielyplafon 42 posts
 msg #51630
 - Ignore bielyplafon
 | 5/16/2007 2:58:02 AM 
 karennma
 - Ignore karennma 5/15/2007 3:07:56 PM
 
 After you get your filter results, does anyone know who to say:
 (for example)
 "and add column % difference between column 1 and column 4"
 
 So, I'm adding a column that gives me the % difference between the 2 columns in my results.
 
 THANKS.
 ------------
 
 You need to define it in the filter and add column.
 E.g.
 column1 = close
 column4 = close 1 day ago
 set{ccc1, column1 / column4}
 set{ccc2, ccc1 - 1}
 set{PercDiff, ccc2 * 100}
 add column PercDiff
 
 
 
 | 
| karennma 8,057 posts
 msg #51638
 - Ignore karennma
 | 5/16/2007 3:34:24 PM 
 Biely:
 OMG!!
 Thanks!
 :>)
 
 
 
 | 
| karennma 8,057 posts
 msg #51639
 - Ignore karennma
 | 5/16/2007 3:41:36 PM 
 Hi Biely:
 Sorry to bother you again ..
 Can you tell me what I did wrong?
 Thanks.
 k.
 
 column2 = close
 column6 = 52 week high
 set{ccc1, column2 / column6}
 set{ccc2, ccc1 - 1}
 set{PercDiff, ccc2 * 100}
 add column PercDiff
 
 
 
 | 
| conyeuchua 83 posts
 msg #51649
 - Ignore conyeuchua
 | 5/16/2007 10:51:57 PM 
 set{column2,close}
 set{column6,52 week high}
 set{ccc1, column2 / column6}
 set{ccc2, ccc1 - 1}
 set{PercDiff, ccc2 * 100}
 add column PercDiff
 
 
 
 | 
| karennma 8,057 posts
 msg #51651
 - Ignore karennma
 | 5/17/2007 8:26:11 AM 
 Cony:
 Sweet!
 Thank you, thank, you, thank you!
 May all your profits be swift and HUGE!
 $$$$$$$$
 :>)
 
 
 
 |