• 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 |

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 7 » pcf help

pcf help Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
kostya1
Posted : Sunday, May 6, 2007 8:59:10 AM
Registered User
Joined: 8/25/2006
Posts: 12
 Hi,
I'm trying to find stocks that have closed more than or equal to the minimum in 260 days range.

100 * (C - MINC260) / (MINC260)>=100

How can I modify this so that for stocks which don't have 260 days of available data, it still scans for stock closing >= 100% taking the minimum of all available data.

Thanks,
Siya123
Back to top
bustermu
Posted : Sunday, May 6, 2007 11:19:20 AM
Registered User
Joined: 1/1/2005
Posts: 2,645
QUOTE (siya123)
Hi,
I'm trying to find stocks that have closed more than or equal to the minimum in 260 days range.

100*(C-MINC260)/(MINC260) >= 100

How can I modify this so that for stocks which don't have 260 days of available data, it still scans for stock closing >= 100% taking the minimum of all available data.


siya123,

You must not be asking for what you really want.

Your PCF will return all stocks with at least 260 days of data. The PCF:

C >= 0.0

will return all stocks as will many others.

Your PCF is equivalent to:

C >= MINC260

Perhaps you intended:

C > MINC260

Maybe not?

Thanks,
Jim Murphy
Back to top
bustermu
Posted : Sunday, May 6, 2007 11:59:00 AM
Registered User
Joined: 1/1/2005
Posts: 2,645
 siya123,

My post is in error.

Your statement is equivalent to:

C >= MINC260

Your PCF is equivalent to:

C >= 2*MINC260

The latter cannot be modified to return all stocks for which:

C >= 2*MINC(min(260,P))

where P is the number of days of data available.

You can find all stocks for which at least one of:

C >= 2*MINCP, P= 2,3,...,260,

returns "TRUE". That would be a long process.

Thanks,
Jim Murphy
Back to top
kostya1
Posted : Monday, May 7, 2007 10:59:09 AM
Registered User
Joined: 8/25/2006
Posts: 12
 Thanks, Jim!

So I guess there is no easy way to acheive this? Anyone?

Thanks,
Siya123
Back to top
Bruce_L
Posted : Monday, May 7, 2007 11:16:51 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
 siya123,
As bustermu indicated, it is not possible to modify your formula so that for stocks which don't have 260 days of available data, it still scans for stock closing >= 100% taking the minimum of all available data.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
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.