Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 1/19/2006(UTC)
Posts: 33
|
I have an indicator that shows a '1' when the MACD histogram crosses up on a daily chart. Simple.
Cross(MACD()-Mov(MACD(),9,E),0)
If I place this in an exploration as column 1 and put a filter of C>9 and C<50 and V>100000, I get stocks that did not just cross the line - it could have happened 3-5 days ago. I have EOD quotes for this but am using MS Pro 10.
What am I missing?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
jer99 wrote:I have an indicator that shows a '1' when the MACD histogram crosses up on a daily chart. Simple.
Cross(MACD()-Mov(MACD(),9,E),0) If I place this in an exploration as column 1 and put a filter of
C>9 and C<50 and V>100000, I get stocks that did not just
cross the line - it could have happened 3-5 days ago. I have EOD quotes
for this but am using MS Pro 10.
What am I missing? You have forgotten to reference the MACD condition (your ColA) in the filter. The returns from you exploration are all those stocks with a closing price greater than 9 dollars and less than 50 dollars that have a volume greater than 100K, there is no mention of the MACD condition in the filter. You do not need to include conditions in all the column themselves if yuo only want to filter the stocks to return a list. You aims can be met just using the filter condition:
Code:
Cross(MACD()-Mov(MACD(),9,E),0) AND C>9 AND C<50 AND V>100000;
Hope this helps wabbit [:D]
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
