|
PureBytes Links
Trading Reference Links
|
--- In amibroker@xxxxxxxxxxxxxxx, "Jim" <bankedout@xxxx> wrote:
> Hello,
>
> I am wondering how to do something with an exploration.
>
> If I Filter my database for Close > Zero, it will return all of my
> stocks.
>
> If I then Add a Column which displays the Rate of Change for the
> Close,102 weeks This displays mostly stocks with a number value.
> Either positive or negative, depending on how their price has
> changed over the past 2 years.
>
> But, if I sort by this ROC 2 years column, there are quite a few
> results where there is no value. I'm guessing these are issues
> which haven't been trading for 2 years.
>
> How do I screen specifically for ROC(C,120)="No Value"
>
> What do I put in place of "No Value"?
If they haven't been trading you should be able to filter on Close.
Either way, check out the IsNull function.
Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|