Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

NULL value and Range of Days Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Glassmoons
Posted : Wednesday, March 22, 2006 1:40:41 PM
Registered User
Joined: 12/16/2004
Posts: 9
Is there any way to enter a NULL value or Range of Days into a PCF? For example, I want to look for IPO's that do not yet have a 200-day moving average. I would like to place in the scan something like "AVGC200=NULL" to scan for them.

Additionally, I want to scan for specific criteria within the last 60 days... is there a recursive function for doing this or do I need to do something like "C.59 or C.58 or C.57 etc."?

Thanks.

~Jonathan
Craig_S
Posted : Wednesday, March 22, 2006 1:43:10 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
The best way to find stocks with less than 200 days of trading is to create a simple PCF:

C200

This returns the close 200 days ago. Sort any WatchList by the condition and scroll down to the very bottom. If any do not have a C200 they will show up as blank.

What condition do you want to search for in the last 60 days. Depending on what it is there may be an easier way.

- Craig
Here to Help!
Users browsing this topic
Guest-1

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.