| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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
|
|
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!
|
|
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
|
|
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!
|
|
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.
|
|
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!
|
|
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
|
|
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!
|
|
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!
|
|
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
|
|
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!
|
|
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.
|
|
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!
|
|
Registered User
Joined: 9/26/2005
Posts: 9
|
 THANKS
|
|
|
Guest-1 |