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

Help with price acion scan Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Still_Learning
Posted : Monday, November 14, 2005 11:37:18 AM
Registered User
Joined: 5/12/2005
Posts: 49
Hi Guys

In my last project I wrote a momentum scan that was based on a stock's price action three months ago but I now need to find stocks that were out-of-favor (negative price action)3mos ago(63days)and are now in favor (ie. negative price action last QTR has changed at least 105% (negative to posive) and is now positive.) The help that Doug provided in the last scan was very appreciated and I was hoping thatI would get some more help this time the last scan revealed some interesting candidates but required extensive research. I am able to monitor the stock's past performance using my tab #3 (modified to show price action by month) and too many negative price action stocks (current week) are showing up and I want a way to stop this. Any help on this scan would be appreciated.


Still_Learning
Craig_S
Posted : Monday, November 14, 2005 11:44:02 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
I think I understand...

You want to eliminate stocks that are down for the last 5-days?

If so, just add PRICE PERCENT CHANGE 5-day to your EasyScan and set the VALUE range to 0 to MAX.

Let me know if I understood this correctly.

- Craig
Here to Help!
Still_Learning
Posted : Monday, November 14, 2005 11:54:25 AM
Registered User
Joined: 5/12/2005
Posts: 49
Craig,

That sounds correct...
second question: Is there a way to limit the scan results to stocks that have changed a specified percent from last QTR ?



Still_Learning
Craig_S
Posted : Monday, November 14, 2005 12:00:36 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
It depends... do you want it to be a change from the price three months ago OR from a specific date?

Both are doable.

Here is the 3-month percent change PCF:

(C-C63)/C63*100

Limit the values as you wish in EasyScan.

If you want it to be a specific date, use the format below and replace the "x"'s with the date (be sure it is a valid market day).

(C-C'xx/xx/xx')/C'xx/xx/xx'*100

Note those are single quotations ' not double quotations ".

- Craig
Here to Help!
Still_Learning
Posted : Monday, November 14, 2005 12:12:12 PM
Registered User
Joined: 5/12/2005
Posts: 49
Craig-

from the formula I could write:
((c-c63)/c63*100)>=105 if I want to see only stocks that have changed 105% or greater in 3mos (QTR)

Thanks Craig, more food for the program.
Craig_S
Posted : Monday, November 14, 2005 12:16:05 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Sure OR you could use is as I have it above and make the limits using the range selector.

The extra benefit being if you want to change 105 to something else you don't need to create a new PCF (you can just change the limits in your range selector).

To be clear... 105 means the stocks were up at least 105% in the last 63 days (meaning they more than doubled in price)

It does not mean is 105% of the old price.

- Craig
Here to Help!
Still_Learning
Posted : Tuesday, November 15, 2005 11:36:28 AM
Registered User
Joined: 5/12/2005
Posts: 49
Craig
Just got back to it...
If I want to compare the current price action to the action 63 trading days ago I thinK I write:
((C63-C)/C*100)>=105 IS THIS RIGHT ?
Thanks for all your help

Still_Learning
Doug_H
Posted : Tuesday, November 15, 2005 11:44:05 AM


Worden Trainer

Joined: 10/1/2004
Posts: 4,308
You had it right the first time, actually:

((C-C63)/C63)*100 >= 105

This basically says the price percent change for the last 63 days is greater than or equal to 105%.

- Doug
Teaching Online!
Craig_S
Posted : Tuesday, November 15, 2005 11:50:28 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
((C63-C)/C*100)>=105

this is a reverse percent change....

Here are some values to think of:

C=10
C63=90
C63-C=80
80/10=8
8*100=800
If the stock moved from 90 down to 10 this would return a value of 800 (true for your Boolean formula)

((c-c63)/c63*100)>=105

this is a straight 63-day percent change.
With the same values:
10-90= -80
-80/90= -.88888
-.88888*100= -88.88
If the stock moved from 90 down to 10 this would return a value of -88.88 (false for the Boolean)

You can decide which you want.

I still contend (see my post above a bit) that you are better off keeping this formula non-Boolean so it returns a value that you can adjust with the range selector in EasyScan.

- Craig
Here to Help!
Still_Learning
Posted : Tuesday, November 15, 2005 12:34:11 PM
Registered User
Joined: 5/12/2005
Posts: 49
Craig-

Again, I've made this scan much more difficult than it needs to be if I just take your advice and write (4) or (5) PCFs (i.e. last-QTR, 2mos-ago, 1mos-ago, current-mos and current week)and select the change per month the scan would be much more versitile and dynamic rather than changing my trading strategy to fit the scan I could change the scan to fit the strategy. Thanks for helping me to see my errs.

Still_Learning
Craig_S
Posted : Tuesday, November 15, 2005 12:55:42 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
I only hope to make the program work best for you. It sounds like we are getting closer to that goal everytime we work together.

- Craig
Here to Help!
AVARIA7
Posted : Sunday, November 27, 2005 6:27:06 PM
Registered User
Joined: 9/26/2005
Posts: 9
I tried this ((C-C63)/C63)*100 >=10 in my mutual fund program and result was FALSE.
Craig_S
Posted : Sunday, November 27, 2005 7:20:19 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
That only means that the ticker you tested the PCF against did not fulfill the condition (it was not up 10% in the last 3 months). The FALSE only means it was not TRUE for the condition.

The PCF is fine. If you change your test ticker to one that fulfills the condition you will see a TRUE.

Make sense?

- Craig
Here to Help!
AVARIA7
Posted : Sunday, November 27, 2005 8:16:42 PM
Registered User
Joined: 9/26/2005
Posts: 9
THANKS
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.