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!
 $$$$$$$$
 :>)
 
 
  |