Discussions
»
Product and Service Development
»
MetaStock
»
Explorer- How to inspect rejected securities [RESOLVED]
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/22/2005(UTC)
Posts: 31
|
I have developed a custom exploration but am seeking some help or guidance on a problem. When I run the exploration and get the list of securities that match the filter criteria, one can "Inspect" the column data for a given security and see what the values were for the various columns for both today's date and all previous days. However, for the rejected securities, one does not have this option, at least as best I can tell. Is it possible to obtain the column data for the rejected securities? It seems to me one should be able to do so, as looking at the actual data behind a specific rejection would help to determine if the filter and/or column formulas are doing what you are wanting them to do.
Thanks much!
Jon Roberts
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/7/2005(UTC)
Posts: 1,346
|
hey jon.... one way might be to include a column with the indicator itself in it.... then add that column in the 'or' fashion in the filter..... leaving out column c below will on return a couple securities scaning the nas 100, however including it will return results for all.... the 'a' and 'b' columns still do there job, just now all rejects are listed also....h
Exploration notes
Col A: Cross(RSI(14),70)
Col B: Cross(30,RSI(14))
[color=blue:2706feb02c]Col C: RSI(14)[/color]
Filter colA OR colB [color=darkblue:2706feb02c]OR colC[/color]
Filter enabled Yes
Periodicity Daily
Records required 4000
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/22/2005(UTC)
Posts: 31
|
thanks hayseed. that seems like a good work around! I'll give it a shot!
Jon
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/13/2004(UTC)
Posts: 673
Location: Salt Lake City, UT
|
I have found there is no real reason to use the Filter at all for situations where you'd want to inspect the results. If you put a conditional statement into column A, it will report a 1.000 if true, and a 0.000 if not true. You can simply sort the results of the Explorer by the column to get all the "Trues" at the top and the "Not Trues" at the bottom.
This way, you can still inspect everything while still screening the results.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/7/2005(UTC)
Posts: 1,346
|
picky picky picky .... actually there are some reasons to include filters in explorations with conditional statements.... depending on one's definition of "a conditional statement " , conditional statements are not limited to just 1's and 0's....
its true my suggestion was somewhat sloppy...... without knowing jon's exploration or more importantly the explorations purpose, it was just a quick adaptation of my rsi exploration....... picky picky picky......:wink:.... h
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/13/2004(UTC)
Posts: 673
Location: Salt Lake City, UT
|
Actually I thought your reply was great, just wanted to give an alternate option :D
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
MetaStock
»
Explorer- How to inspect rejected securities [RESOLVED]
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.
