Underworlds
30 posts
msg #100128
- Ignore Underworlds |
4/5/2011 8:31:18 PM
The use of the operational word BETWEEN does not seem to be working properly. Please take a look at my code and let me know if it is something that I may have done wrong in the coding.
Using the following code...
The results returned included stocks where the value of currentsize was outside of the range established by shortbodysize and longbodysize.
For example, results included...
NSM
short = 0.03
long = 0.14
current = -0.04
SIRI
short = 0.01
long = 0.07
current = 0.08
MSFT
short = 0.03
long = 0.14
current = -0.04
These three incorrect returns appeared on the very first page returned. The filter returned a total of 11,319 stocks. This tells me that something is definitly wrong here.
|
stockfetcher
980 posts
msg #100130 |
4/5/2011 9:05:37 PM
The "between" phrase only works with constant values. Please see:
http://forums.stockfetcher.com/sfforums/?q=view&fid=1007&tid=24002
Thank you,
StockFetcher Support
|
Underworlds
30 posts
msg #100131
- Ignore Underworlds |
4/5/2011 9:36:10 PM
Aha!!! Thanx for the fast response stockfetcher. Guess I'm gonna have to figure a work-around for that situation then.
|
stockfetcher
980 posts
msg #100132 |
4/5/2011 10:00:28 PM
Simply break the original statement into an above and below:
show stocks where currentsize is above shortbodysize
and currentsize is below longbodysize
StockFetcher Support
|
Underworlds
30 posts
msg #100134
- Ignore Underworlds |
4/5/2011 11:33:16 PM
Once again, thanx for the great support. I found just the trick to get this filter working the way I need it to work...
I may have to adjust the upper and lower limits a bit to get a better interpretation of a candlestick with a medium body size, but at least it works.
|