VousDeux 17 posts msg #56035 - Ignore VousDeux | 
10/25/2007 9:56:22 PM
  Greetings:
 
 I'm trying to find stocks where the 50-day high occurred before the 50-day low, but I don't seem to be getting the desired result.
 
  	    
 
 
 Any help would be greatly appreciated.
 
 Thanks,
 
 Jerry 
 
  | 
TheRumpledOne 6,529 posts msg #56037 - Ignore TheRumpledOne modified | 
10/26/2007 1:08:11 AM
    	    
 
 
 
  | 
VousDeux 17 posts msg #56050 - Ignore VousDeux | 
10/26/2007 9:18:00 AM
  TRO:
 
 Thank you for the quick response. I really appreciate your time.
 
 I like the way you set yours up so that we could see the results in the columns. When I tried it without the sorting I got some results right at the top that show what I think the problem is.
 
 There are a bunch of the results that show the 50-day low as '-1.00'. These do not seem to be correct, and are causing an undesirable outcome. I have included some examples below.
 
 TYRIA 	 0.0002 	 N/A 	 132006800 	 11.00 	 0.00
 EMC 	 24.45 	 8.52 	 126032900 	 0.00 	 -1.00
 JAVA 	 5.75 	 -1.20 	 68890000 	 9.00 	 -1.00
 FNIX 	 0.0005 	 N/A 	 65671900 	 7.00 	 0.00
 AIG 	 61.79 	 -3.21 	 64325700 	 12.00 	 0.00
 INTC 	 25.89 	 -0.46 	 57683200 	 5.00 	 -1.00
 
 With EMC, for example, the 50-day high was the most recent day, but the 50-day low should have really been 50; which sould have disqualified this match.
 
 With JAVA, the 9 is correct for the 50-day high, but the 50-day low should have also been 50; which should have also disqualified this match.
 
 With INTC, however, unless I am counting the candles wrong, the 50-day low should have been 49. Since the 50-day high is 5, though, this match should still have been disqualified.
 
 I also tried changing the number of days from 51 to 52 and 100; which did change the outcome, but did not eliminate the -1.00 results.
 
 Any more ideas, or do you think that maybe this a bug that would need to be addressed by SF?
 
 Thanks again,
 
 Jerry
 
 
 
 
  | 
TheRumpledOne 6,529 posts msg #56063 - Ignore TheRumpledOne modified | 
10/26/2007 5:10:48 PM
  -1.00 means NO MATCH found.
 
 Hmmmm...........
 
 Unless I am missing or not understanding something, it looks like a bug!
 
  | 
VousDeux 17 posts msg #56141 - Ignore VousDeux | 
10/29/2007 10:25:13 AM
  There does not appear to be an obvious way for me to contact SF. I clicked the 'Home' button, then I clicked the 'Contact Us' link at the bottom, and it took me to the 'Help' page. At the bottom of the 'Help' page I clicked the 'Contact Us' link again, and it took me to a "404 - Page not found" error page. Another bug?
 
  | 
stockfetcher 980 posts msg #56143 | 
10/29/2007 10:34:55 AM
  Thank you for bringing this to our attention. The "Contact Us" link has been corrected. 
 
 You can always reach StockFetcher Support via support@stockfetcher.com
 
 StockFetcher.com Support
 
 
  |