papagatorga
124 posts
msg #105269
- Ignore papagatorga |
3/5/2012 6:00:26 PM
I entered the following filter
Show stocks where EMA(10) has been increasing for the last six weeks.
and stocks are ETF
The fourth and fifth ETF's reported are VXX, TZA. Neither have increasing EMA's. In fact both are in major declines.
What is wrong with my filter?
Secondly, I would like to sort my results. Other filters use phrases like "weekly roc(6,1)" and "column 5 descending".
I don't know how to phrase it.
|
frsrblch
35 posts
msg #105271
- Ignore frsrblch
modified |
3/5/2012 6:54:03 PM
If you click Edit > Check Syntax, it will show you that the first line of your filter is not being recognized.
If the ema(10) is increasing, it will be above the value from yesterday. If you make it count the number of times this has happened over the last 30 days (6 weeks), and tell it to show the stocks where this count is 30, it will show you those stocks which have had their ema(10) increasing every day for the last 30 days, or 6 weeks.
stocks are eft
count(ema(10) above ema(10) 1 day ago,30) equals 30
To sort, type "sort by column X ascending/descending" where X is the column number. SF uses the symbol as column 1, so if you made your filter as follows, it would sort by ema(10) descending, which is column 5.
stocks are eft
count(ema(10) above ema(10) 1 day ago,30) equals 30
add column ema(10)
sort by column 5 descending
|
Kevin_in_GA
4,599 posts
msg #105272
- Ignore Kevin_in_GA
modified |
3/5/2012 8:16:34 PM
frsrblch:
Excellent first post. Welcome.
|
papagatorga
124 posts
msg #105275
- Ignore papagatorga |
3/6/2012 12:59:33 PM
Thanks frsrblch, seems to be working like I wanted.
|
traderseb
36 posts
msg #105280
- Ignore traderseb |
3/7/2012 7:17:33 AM
The first line is not correct.
Did you mean "etf" instead of "eft"?
It appears to be ignoring the first line since "eft" has no apparent meaning.
|
papagatorga
124 posts
msg #105283
- Ignore papagatorga |
3/7/2012 8:35:30 AM
traderseb, I caught the mistake and changed it to ETF
|