StockFetcher Forums · General Discussion · Faulty logic with close n days ago logic.<< >>Post Follow-up
genesis
2 posts
msg #115733
Ignore genesis
10/8/2013 12:20:21 AM

Can someone please tell me why the following two phrases return different results, what am I not getting here?

Show stocks where close > 4% above close 1 day ago date offset 1
/* Using either the "date offset 1" as part of the filter or
removing it and selecting [Date Offset] << Previous day
Ran today and got back 719 symbols */


Show stocks where close 1 day ago > 4% above close 2 days ago
/* Ran today and got back 599 symbols */

craze
3 posts
msg #115734
Ignore craze
10/8/2013 1:45:26 AM

Not sure why, but if you add:

avgvol(30) is above 10000 and price is above 1

then the difference is only 2 symbols, 213 vs 215. Just putting that out there. No point for me to guess why it's happening.

stockfetcher
963 posts
msg #115736
10/8/2013 8:12:51 AM

There are a couple syntax issues in your filter. Below are corrected examples that should produce the same number of matches:

Fetcher[Show stocks where close is more than 4% above close 1 day ago
and date offset is 1
]



Fetcher[Show stocks where close 1 day ago is more than 4% above close 2 day ago ]



However, please keep in mind if you have the results setting of "Automatically Remove 0 volume stocks" you will see different results.

Hope that helps!

StockFetcher Support




genesis
2 posts
msg #115758
Ignore genesis
10/8/2013 6:39:15 PM

It was the "Automatically Remove 0 volume stocks" setting that was causing the unexpected results. Thank you for pointing that out.

In my original filter I was also filtering on volume and wasn't noticing it but when I was debugging a filter by stepping through each line the difference jumped out at me and i was concerned there might be a larger issue with my logic or the filter itself.

Thank you.

StockFetcher Forums · General Discussion · Faulty logic with close n days ago logic.<< >>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