StockFetcher Forums · General Discussion · Days Since<< >>Post Follow-up
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.

Fetcher[show stocks where days(high reached new 50-day high,50) > days(low reached new 50-day low,50)]




Any help would be greatly appreciated.

Thanks,

Jerry

TheRumpledOne
6,358 posts
msg #56037
Ignore TheRumpledOne
modified
10/26/2007 1:08:11 AM

Fetcher[
set{dsh, days(high equal high 50 day high, 51 ) }
set{dsl, days(low equal low 50 day low, 51 ) }

add column dsh
add column dsl
add column high 50 day high {50_High}
add column low 50 day low {50_LOW}

dsh above dsl

sort column 5 descending
]





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,358 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
958 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


StockFetcher Forums · General Discussion · Days Since<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2016 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus