four 5,087 posts msg #104136 - Ignore four modified | 
1/1/2012 5:03:44 PM
  Request A. Calculate the number of times that there is at least a 1% drop from the open 1 day ago.
 AND
 Request B. Not include any times when the 1% drop  1 day ago is less than the day's low  1 day ago in the next part of the filter.
 
 Example
 
 Request A
 
 #1. open 1 day ago= $1, drop = 1%, low  1 day ago < 1% drop
 #2. open 1 day ago = $1, drop = 1%, low  1 day ago > 1% drop
 
 -- #1 fits request A.
 -- #2 does not fit request A.
 
 Request B
 
 Using #1, How many times is high 0 days ago > #1 result ?
 
 
 
  |