Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Percent formulas Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
whesse
Posted : Saturday, January 7, 2006 11:47:53 AM
Registered User
Joined: 1/14/2005
Posts: 9
Hello,

I have pre-defined price range. How would I create a forumla to view scans of stocks that have increased/decreased 5% ON THE DAY, at the close of the day? C < C * (1.05)? / C > C * (1.05)? Am I close?
Craig_S
Posted : Saturday, January 7, 2006 12:00:51 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
From the open to the close or the close of yesterday to the close of today?

Your formula above compares the close today to itself.

If you are looking for stocks that went up/down X% from the close yesterday, use this PCF:

Absolute Percent Change Today
100*ABS(C-C1)/C1

This will return the absolute (no + or -, just the change) percent change for the stock from the close yesterday to the close today. Add it to an EasyScan and limit your VALUES to 5 to MAX (to capture 5% or more)

If you are looking for stocks that went up/down X% from the open today, use this PCF:

Absolute Percent Change Open to Close
100*ABS(C-O)/O

This will return the absolute (no + or -, just the change) percent change for the stock from the o to the close today. Add it to an EasyScan and limit your VALUES to 5 to MAX (to capture 5% or more)

Here are two videos to review:

How to create a Personal Criteria Forumula (PCF)

Using EasyScan to find stocks that meet your own criteria

- Craig
Here to Help!
Craig_S
Posted : Saturday, January 7, 2006 12:01:22 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
You should also look this over:

Handy PCF example formulas to help you learn the syntax of PCFs!

- Craig
Here to Help!
vablake
Posted : Saturday, January 7, 2006 12:02:30 PM
Registered User
Joined: 12/10/2004
Posts: 10
I have been having the same shoutdown problem that was reported June 06 by Previn bungle and on june 09 by Mousefinger and again on dec. 21 by Svinson. I have been having this trouble for a number of months. I am runing EP Home edition, and have TC2005 version 6.0.0042 on my machine. Is there a fix for this problem, it seems to be showing up every once in a while. I just cancle it when I shut down. vablake
Craig_S
Posted : Saturday, January 7, 2006 12:06:58 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
We are unable to address technical issues in these forums. Please contact our Tech department.

Technical Support is available via telephone, live chat and email. Their hours are 9AM - 9PM EST through the week, and 9AM - 3PM Saturday. support@worden.com or 919.408.0542. Suport is also available via live chat. You can go to the Live Tech Support Chat during business hours for live interactive chat with one of the Tech Support Agents.

- Craig
Here to Help!
Doug_H
Posted : Saturday, January 7, 2006 12:31:41 PM


Worden Trainer

Joined: 10/1/2004
Posts: 4,308
You may also want to take a quick look at the following training video concerning the correct and effective use of these forums. You posted your question in a completely unrelated topic, and it helps to keep things organized if you either post a comment or question in a related topic, or create a new topic to post your question. Thanks!

Learn how to use the forums: post a new topic, reply, Search existing topics

- Doug
Teaching Online!
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.