Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 6/30/2005 Posts: 30
|
Please help,
I am looking for stocks that: 1. Bounce off of the 9 exponential MA. The open is at or near the 9EMA and the close is at or near the high of that same day. WIth the the 20EMA, being the slow average, less than the 9EMA.
Number 1 would be for bullish stocks, where I'd also like the contrary of this formulated for the bearish stocks. Hopefully I make sense and that you can help me. Thanks for your time.
OneDay
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
How near is "near" to qualify when you say the "open is at or near the 9EMA and the close is at or near the high of that same day"?
- Craig Here to Help!
|
|
Registered User Joined: 6/30/2005 Posts: 30
|
Hey Craig,
Well I assumed that it would be unrealistic for the price to open at the same price as the 9EMA. So I guess near can be less than or greater than 5% of the 9EMA price.
One Day
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
How near is near for this part: "the close is at or near the high of that same day"?
- Craig Here to Help!
|
|
Registered User Joined: 6/30/2005 Posts: 30
|
the same plus/minus 5% from the 9EMA
|
|
Registered User Joined: 6/30/2005 Posts: 30
|
So sorry,
I meant to say: closes at the high or within 5% of the high. Sorry. Thanks
OneDay
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
Try this for me:
ABS(O-XAVGC9)/XAVGC9 <=0.05 AND (C-L)/(H-L)>=0.95 AND XAVGC20<XAVGC9
I put the close at 95% of the daily range. A stock with the close's value at 5% of the high's value may still be closer to the daily low than the high (which I don't believe you wanted).
- Craig Here to Help!
|
|
Registered User Joined: 6/30/2005 Posts: 30
|
Hi Craig,
I tryed the formula above but the scan provided stocks far away from the 9EMA. Let me give you an example of what I'm looking for: CRM on 9/20/06 off the daily, candlestick chart. another would be NYX on 9/21/06 daily, candlestick chart. Here r some of the stocks that the above formula gave me: CAL, SPG, UTX, IPS. I hope you can help me. Thanks.
One Day
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
It would appear we need to get tighter than 5% and less restrictive on the close as percent of range.
Try this:
ABS(O-XAVGC9)/XAVGC9 <=0.01 AND (C-L)/(H-L)>=0.85 AND XAVGC20<XAVGC9
It is TRUE for NYX and CRM on the dates you gave.
Here are some of the stocks it found today:
BMC ORCL GT CNP CELG
- Craig Here to Help!
|
|
Registered User Joined: 1/1/2005 Posts: 2,645
|
Craig,
The portion of the PCF:
(C-L)/(H-L)>=0.85
should be changed to:
(C-L)>=0.85*(H-L)
in order to prevent a divide by zero.
An attempt to plot the PCF as a Custom Cumulative Indicator will fail in many cases without the change.
Thanks, Jim Murphy
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
OK.
- Craig Here to Help!
|
|
Registered User Joined: 6/30/2005 Posts: 30
|
The outputs r much better. Can u pls convert this on the bear side as well? Also Craig, a long time ago (8/9/06 thread) you had given me a conversion table, an easy way for me to convert daily candlestick patterns into 3-day patterns. Can you pls provide a table with 4-day and weekly conversions as well? Thanks.
One Day
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
I need you to define the "bear side" version of this. Describe it and I will write it.
Daily to 4-day:
O -> O3 H -> MAXH4 L -> MINL4 C -> C O1 -> O7 H1 -> MAXH4.4 L1 -> MINL4.4 C1 -> C4 O2 -> O11 H2 -> MAXH4.8 L2 -> MINL4.8 C2 -> C8 O3 -> O15
See the relationship between the daily and the 4-day? Review the one I gave for the 3-day as well. I bet you can make your own 5-day (or any day) version. Let me know if you have trouble.
- Craig Here to Help!
|
|
Registered User Joined: 6/30/2005 Posts: 30
|
Thank you very much for the definitions, i can see the relationships to develop further versions(5, 6, 7, 8 day charts). When i meant bearish, i just meant now the 9EMA is lower than the 20EMA and the open falls off the 9EMA. Hope i make sense.
Thanks, OneDay
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
Try this:
ABS(O-XAVGC9)/XAVGC9 <=0.01 AND (C-L)/(H-L)<=0.05 AND XAVGC20>XAVGC9
I assumed you wanted the close near the low as well.
- Craig Here to Help!
|
|
Guest-1 |